SSG Blog
Insights and news from the SQL Solutions Group.
Recent
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
Debugging SQL Server CLR Objects
Just a quick shout out to a great article on how to Debug CLR Projects. https://www.mssqltips.com/tip.asp?tip=1624
SQL Saturday #67 (Chicago)
Headed to Chicago tomorrow for SQL Saturday #67. Heading out a day early to attend a pre-conference seminar on Friday on troubleshooting and performance tuning.
Utah Code Camp
I’ve been doing a lot of traveling lately speakng at SQL Saturday events. This last weekend it was my great pleasure to speak at Utah
This discussion came up on Twitter so I …
This discussion came up on Twitter so I thought I’d blog about it. UPDATE FROM (sometimes called an UPDATE JOIN) is an language construct that