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,495 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,757 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,230 reads
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Secure Communications
Comments posted to this topic are about the item Secure Communications
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers