By Eli Leiba, 06/17/2011
Manually monitor SQL Server instances for problems daily using this automated solution that checks CPU utilization, database status, available disk space, and more.
By Eli Leiba, 09/17/2010
Stored procedures are typically executed with an EXEC statement. However, you can execute a stored procedure implicitly from within a SELECT statement, provided that the stored ...
By Eli Leiba, 10/12/2009
In SQL Server 2008 and SQL Server 2005, one of the easiest ways to encrypt and decrypt strings is to use T-SQL's ENCRYPTBYPASSPHRASE and DECRYPTBYPASSPHRASE functions.
By Eli Leiba, 12/23/2008
You can change many configuration options in SQL Server 2005 and SQL Server 2000 simultaneously by using a.config file and a T-SQL stored procedure that automates the use of the ...
By Eli Leiba, 09/29/2008
Use this password-cracking tool to check the complexity of the passwords being used for SQL Server database logins.
By Eli Leiba, 07/30/2008
Here's a T-SQL stored procedure that finds and moves the clustered-indexes user tables you specify from old file groups to new file groups.
By Eli Leiba, 11/20/2007
LoadTraceFileToTable loads the data from a trace file into a trace table so that you can easily sort and analyze that data.
By Eli Leiba, 10/25/2007
To determine the number of occurrences of a substring within a string, a user-defined function (UDF) performs a simple arithmetic calculation.
By Eli Leiba, 05/23/2007
The sp_markAllMasterDBasSystem stored procedure can help protect the T-SQL objects you've created by marking them as system objects.
By Eli Leiba, 03/22/2007
Here's a stored procedure that displays all the T-SQL statements currently being executed along with the IDs of the processes running those statements.
By Eli Leiba, 02/23/2007
The showViolatingRows procedure automates the tedious task of finding rows that violate check and foreign-key constraints.
By Eli Leiba, 10/26/2006
The sp_showConstraints stored procedure is an alternative to using sp_helpconstraint when you need to find all the constraints for a table.
By Eli Leiba, 04/10/2006
Together, the suggestIntType and scanIntIndex procedures search for indexed integer columns in a database and determine whether the optimal data type is used for those columns.
By Eli Leiba, 02/13/2006
Here’s a simple yet generic solution for exporting or importing data. This solution consists of two stored procedures: BCPObject and ExpOrImpDB.
By Eli Leiba, 01/31/2006
The sp_GetAllSQLMediaTypes stored procedure lists the names of all the available media and their types on a SQL Server machine.
By Eli Leiba, 01/31/2006
By compiling sp_LogSpace in a master database and calling it from an updated version of sp_SpaceUsed, you can extend the ability of sp_SpaceUsed to obtain transaction log ...
By Eli Leiba, 12/12/2005
The getMaxResourceConsumeSessions stored procedure lets you quickly identify the sessions that are consuming most of a SQL Server machine's resources.
By Eli Leiba, 10/31/2005
The getSQL_IPaddr.sql procedure uses the Ipconfig utility to dynamically find the IP address of a server running Microsoft SQL Server.