SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Andy Jones

SQLServerCentral.com 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 2018/10/12 (first published: 2016/03/28) | Source: SQLServerCentral.com | Category: trigger
Rating: |  Discuss |   Briefcase | 3,901 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 2017/11/17 (first published: 2016/02/25) | Source: SQLServerCentral.com | Category: extended property
Rating: |  Discuss |   Briefcase | 7,127 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: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 6,224 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: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 11,067 reads
   Items 1 to 4 of 4