SSG Blog
Insights and news from the SQL Solutions Group.
Recent
Dynamic SSIS Error Logging
When building ETL processes, one of the things we always like to do is to account for every row. But setting up error data flows
SQL Saturday #120 – Orange County, CA
Looking forward to heading to Southern California this weekend for SQL Saturday #120 in Huntington Beach. They always put on a great event and you
Utah Code Camp Spring 2012
This last Saturday was the most recent iteration of Utah Code Camp and I have to say it was a resounding success. In addition to
SQL Saturday #91 – Omaha, NE
This is a bit late but wanted to post about my experience at the recent SQL Saturday held in Omaha, Nebraska. This was a fantastic
Using RoboCopy in SQL Server Agent Jobs
One of the most important tasks for the DBA is managing backup files. Often the SQL Server backups files themselves are written to a drive
Truncate Tables that have Foreign Keys
One of the issues I often run into is the need to truncate very large tables. But if there is a foreign key constraint on