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,581 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,429 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,976 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,487 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,318 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,749 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,367 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,877 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,900 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,226 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers