Try Catch within an SSIS Script Tasks and Components
Using a Try/Catch/Finally within your Script Components and Script Tasks is just good coding practice. The thing you want to be able to do is push...
2010-01-30
2,590 reads
Blog Posts
Book Review: The Breach
The Breach by Patrick Lee ($8 at Amazon) was a gift, and wasn’t quite what I expected based on the...
2010-01-29
1,439 reads
But We Have Always Done It That Way
I recently ran across the following scenario. A SQL Server instance had been upgraded from SQL Server 2005 to SQL...
2010-01-29
1,978 reads
Columbia Code Camp 2010
We're making a final push to let everyone know about the Columbia Code Camp 2010, which happens tomorrow, January 30....
2010-01-29
1,496 reads
Introduction: Developing with SQL Server
As a developer based primarily in the Microsoft world I have over the last 10 years spent time working with...
2010-01-29
1,319 reads
Paul Randal’s Benchmarking Series
Fellow SQL MVP Paul Randal of SQLSkills, (who is also Kimberly Tripp’s husband, and a former long-time Microsoft employee) has...
2010-01-29
2,758 reads
SQLSaturday #30 Rescheduled
Got the email today, SQLSaturday #30 has been rescheduled for April 10, 2010, due to projected bad weather on the...
2010-01-29
1,368 reads
SQLSaturday #41 Announced
Stuart Ainsworth will be coordinating the second SQLSaturday in Atlanta, this time on April 24th, 2010. Registration and call for...
2010-01-29
1,884 reads
Are You Running the x86 Version of SQL Server 2005/2008?
If so why? Honestly, I am curious why people may still be running 32-bit versions of SQL Server 2005, 2008,...
2010-01-28
2,906 reads
IN and NOT IN
One of the most common mistakes made in T-SQL is thinking that these behave identically. I've personally opened up a...
2010-01-28
1,231 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I specify only the Resource Database?
See possible answers