Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Ken Simmons

SQLServerCentral.com profile

   Items 1 to 7 of 7   
 

SQL Server Preproduction Tasks

What are some of the things that you need to do before you sign off and hand it over to production? What do you need to do to keep the server running smoothly?  Read more...
By Ken Simmons 2008/11/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,924 reads

SQL Profanities

Do you avoid certain SQL functionality because you have been told you should NEVER use it?   Read more...
By Ken Simmons 2008/08/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 354 reads

Return Query Text Along With sp_who2 Using SQL 2000

This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".  Read more...
By Ken Simmons 2008/07/18 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 7,690 reads

Include Column Headers From SSMS

Save time when copying data from SSMS to Excel by configuring the options to Include Column Headers.  Read more...
By Ken Simmons 2008/06/13 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 3,056 reads

Dynamically Generate Folders for File Output using Variables in SSIS

This article describes how to use variables in SSIS to dynamically generate folders and file placement.  Read more...
Rating: |  Discuss |   Briefcase | 10,444 reads

Return Query Text Along With sp_who2 Using Dynamic Management Views

This article describes how to generate the sp_who2 results including the query text for the spid.  Read more...
By Ken Simmons 2008/06/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,811 reads

Sync All Logins on a Server in a single click using SP_MSForEachDB

Reduce your recovery time and minimize the chance for error by resolving all logins in one script.  Read more...
By Ken Simmons 2008/06/03 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 13,434 reads
   Items 1 to 7 of 7