http://www.windowsitpro.com/authors/author/author/5296126/rss/5296126en-USSun, 27 May 2012 06:11:57 GMTSun, 27 May 2012 06:11:57 GMThttp://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521
By Eli Leiba
Manually monitor SQL Server instances for problems daily using this automated solution that checks CPU utilization, database status, available disk space, and more.]]>Eli LeibaFri, 17 Jun 2011 17:06:23 GMThttp://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521http://www.windowsitpro.com/article/scripting/execute-a-stored-procedure-within-a-query
By Eli Leiba
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 procedure returns a result set. The OPENROWSET function is key to this technique.]]>Eli LeibaFri, 17 Sep 2010 00:01:00 GMThttp://www.windowsitpro.com/article/scripting/execute-a-stored-procedure-within-a-queryhttp://www.windowsitpro.com/article/tsql3/simple-string-encryption-and-decryption
By Eli Leiba
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.]]>Eli LeibaMon, 12 Oct 2009 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/simple-string-encryption-and-decryptionhttp://www.windowsitpro.com/article/tsql3/change-many-server-configuration-options-in-one-fell-swoop
By Eli Leiba
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 sp_configure system stored procedure.]]>Eli LeibaTue, 23 Dec 2008 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/change-many-server-configuration-options-in-one-fell-swoophttp://www.windowsitpro.com/article/tsql3/find-weak-database-passwords
By Eli Leiba
Use this password-cracking tool to check the complexity of the passwords being used for SQL Server database logins.]]>Eli LeibaMon, 29 Sep 2008 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/find-weak-database-passwordshttp://www.windowsitpro.com/article/tsql3/use-a-stored-procedure-to-move-user-tables-between-file-groups
By Eli Leiba
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.]]>Eli LeibaWed, 30 Jul 2008 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/use-a-stored-procedure-to-move-user-tables-between-file-groupshttp://www.windowsitpro.com/article/tsql3/t-sql-stored-procedure-creates-trace-tables-from-trace-files
By Eli Leiba
LoadTraceFileToTable loads the data from a trace file into a trace table so that you can easily sort and analyze that data.]]>Eli LeibaTue, 20 Nov 2007 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/t-sql-stored-procedure-creates-trace-tables-from-trace-fileshttp://www.windowsitpro.com/article/tsql3/t-sql-udf-quickly-determines-how-often-a-substring-appears
By Eli Leiba
To determine the number of occurrences of a substring within a string, a user-defined function (UDF) performs a simple arithmetic calculation.]]>Eli LeibaThu, 25 Oct 2007 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/t-sql-udf-quickly-determines-how-often-a-substring-appearshttp://www.windowsitpro.com/article/tsql3/protect-your-t-sql-objects-from-deletion
By Eli Leiba
The sp_markAllMasterDBasSystem stored procedure can help protect the T-SQL objects you’ve created by marking them as system objects.]]>Eli LeibaWed, 23 May 2007 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/protect-your-t-sql-objects-from-deletionhttp://www.windowsitpro.com/article/tsql3/procedure-helps-pinpoint-problematic-processes
By Eli Leiba
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.]]>Eli LeibaThu, 22 Mar 2007 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/procedure-helps-pinpoint-problematic-processeshttp://www.windowsitpro.com/article/tsql3/easily-find-rows-that-violate-constraints
By Eli Leiba
The showViolatingRows procedure automates the tedious task of finding rows that violate check and foreign-key constraints.]]>Eli LeibaFri, 23 Feb 2007 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/easily-find-rows-that-violate-constraintshttp://www.windowsitpro.com/article/tsql3/summarize-all-the-constraints-for-a-table
By Eli Leiba
The sp_showConstraints stored procedure is an alternative to using sp_helpconstraint when you need to find all the constraints for a table.]]>Eli LeibaThu, 26 Oct 2006 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/summarize-all-the-constraints-for-a-tablehttp://www.windowsitpro.com/article/tsql3/optimize-the-size-of-your-indexed-integer-columns
By Eli Leiba
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.]]>Eli LeibaMon, 10 Apr 2006 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/optimize-the-size-of-your-indexed-integer-columnshttp://www.windowsitpro.com/article/tsql3/rename-files-or-directories-on-the-fly-in-t-sql-scripts
By Eli Leiba
Rename Files or Directories On the Fly in T-SQL Scripts]]>Eli LeibaThu, 02 Mar 2006 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/rename-files-or-directories-on-the-fly-in-t-sql-scriptshttp://www.windowsitpro.com/article/tsql3/stored-procedures-work-in-concert-to-import-and-export-data
By Eli Leiba
Here’s a simple yet generic solution for exporting or importing data. This solution consists of two stored procedures: BCPObject and ExpOrImpDB.]]>Eli LeibaMon, 13 Feb 2006 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/stored-procedures-work-in-concert-to-import-and-export-datahttp://www.windowsitpro.com/article/tsql3/quickly-retrieve-a-list-of-available-media-resources
By Eli Leiba
The sp_GetAllSQLMediaTypes stored procedure lists the names of all the available media and their types on a SQL Server machine.]]>Eli LeibaTue, 31 Jan 2006 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/quickly-retrieve-a-list-of-available-media-resourceshttp://www.windowsitpro.com/article/tsql3/extend-the-sp_spaceused-procedure-s-usefulness-in-obtaining-transaction-log-statistics
By Eli Leiba
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 statistics.]]>Eli LeibaTue, 31 Jan 2006 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/extend-the-sp_spaceused-procedure-s-usefulness-in-obtaining-transaction-log-statisticshttp://www.windowsitpro.com/article/tsql3/don-t-let-resource-intensive-sessions-consume-all-your-resources-and-time
By Eli Leiba
The getMaxResourceConsumeSessions stored procedure lets you quickly identify the sessions that are consuming most of a SQL Server machine’s resources.]]>Eli LeibaMon, 12 Dec 2005 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/don-t-let-resource-intensive-sessions-consume-all-your-resources-and-timehttp://www.windowsitpro.com/article/tsql3/dynamically-obtain-a-sql-server-s-ip-address-in-t-sql-code
By Eli Leiba
The getSQL_IPaddr.sql procedure uses the Ipconfig utility to dynamically find the IP address of a server running Microsoft SQL Server.]]>Eli LeibaMon, 31 Oct 2005 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/dynamically-obtain-a-sql-server-s-ip-address-in-t-sql-code