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.
2010-05-13
12,232 reads
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.
2009-03-19
6,160 reads
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.
2008-02-29
7,475 reads
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.
2006-03-27
6,803 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers