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

Guest Columnist: James Greaves

SQLServerCentral.com profile

   Items 1 to 4 of 4   

SSIS object search using T-SQL

Easily determining what objects are located in all your SSIS packages can be a challenging endeavor. James Greaves brings us a technique that can help you determine which packages might need to be changed based on objects you alter in your database.  Read more...
Rating: |  Discuss |   Briefcase | 8,842 reads

Clustered SQL Server 2005/2008 Installation Using Mount Points

If you are in a clustered environment, check out this article from James Greaves. Here we learn how to deal with the clustered disk space and mount points.  Read more...
By James Greaves 2009/03/19 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 6,130 reads

Monitoring and Recording DDL changes on SQL 2005 (NARC)

Auditing activities on your database servers becomes more important all the time. But ensuring that schema changes do not occur without your knowledge may be more important for a stable system. James Greaves brings us a great technique using DDL triggers for doing this.  Read more...
By James Greaves 2008/02/29 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 7,198 reads

Handling Zero Byte Files in DTS

SQL Server 2005 has substantially enhanced its ETL capabilities, but many people will still be working with DTS in SQL Server 2000 for many years. New author James Greaves brings us a technique for working with imports and handling files that might not have any data.   Read more...
By James Greaves 2006/03/27 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 6,771 reads
   Items 1 to 4 of 4