Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Andy Jones profile

Andy is a SQL Server DBA specialising in getting the maximum performance out of your SQL Servers.

   Items 1 to 4 of 4   

Trigger Happy

This article looks at using triggers to audit and to prevent the performing of unintended actions.  Read more...
By Andy Jones 2016/03/28 | Source: | Category: trigger
Rating: |  Discuss |   Briefcase | 2,847 reads

Auto Generate Your Database Documentation

Script provided to create missing extended properties allowing you to auto generate your database documentation.  Read more...
By Andy Jones 2016/02/25 | Source: | Category: extended property
Rating: |  Discuss |   Briefcase | 5,330 reads

Initial Installation of the Production Database

Your software has passed all testing phase(s) and it is time to install your database into production. Andy Jones will outline below how he accomplished this task. This article is concerned with an evolving system and how to migrate it to production.   Read more...
By Andy Jones 2003/02/04 | Source: | Category: installation
Rating: |  Discuss |   Briefcase | 6,223 reads

Loading a Series of Flat Files

Andy Jones recently faced a requirement to load several flat files on a nightly basis. In this article, Andy Jones shows you how he accomplished this and shows plenty of code!   Read more...
By Andy Jones 2002/10/31 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 11,058 reads
   Items 1 to 4 of 4