Category: sqlserverpedia-syndication

TRY, CATCH, and Transactions

The T-SQL TRY/CATCH structure (“new” in SQL 2005!) is, as the professionals say, da bomb. It’s also underused and under-understood, so let’s talk about the basics. (Or, you can skip to the summary at the end.) A group of Transact-SQL statements can be enclosed in a TRY block. If an error occurs in the TRY […]

Why should we upgrade off of SQL Server 2000?

A good many companies still have servers chugging along on SQL Server 2000 (or even, as some of us noted on Twitter, SQL Server 7.0 and 6.5) . If you’re one of those companies, and you’ve never had a problem with it, why should you upgrade?1, stability: It’s completely out of support. Microsoft won’t release […]

We’re speaking at PASS Summit 2013!

PASS liked our “Mouth Wide Shut” interviewing session from last year so much that they’ve decided to have us back for part two: Mouth Wide Shut: Interviews from the Other Side of the Table. This is our brand-spanking-new session for the interviewERs…those who question, vet, and rant about it afterward. Check out all the details […]