Fun with THROW: Avoid % and use semi-colons!
I talk about a couple of subtleties of THROW, and how to avoid frustrating bouts of troubleshooting.
I talk about a couple of subtleties of THROW, and how to avoid frustrating bouts of troubleshooting.
I repeat "Bad habits" advice from the past about using statement terminators and schema references to avoid debugging troubles.
Read about why you want to use statement terminators throughout all of your T-SQL code.
I talk about why every CTE I write starts with a semi-colon, and why you won't change my mind about it.
I show one way to run arbitrary SQL against objects in an arbitrary database – using nested dynamic SQL.
An index of over a decade's worth of posts and videos involving bad habits and best practices in SQL Server.
T-SQL Tuesday, the invention of Adam Machanic, is what he calls a recurring, revolving blog party. Each month, a new host picks a topic, invites bloggers of all levels to join in, and then...
Today I was in Chicago for SQLSaturday #67 to present my "What's New in SQL Server Denali" deck. You can download the deck and samples below. I mentioned during the talk that THROW is...
Earlier, I documented the system objects that have changed in Denali. One that caught my eye was a slew of new columns made available through sys.databases, mostly to support a feature I also blogged...
Sadly, THROW is not mentioned in the Programmability Enhancements (Database Engine) topic of Denali's "What's New" section. So, unless you were at PASS Summit, have been reading the various blogs from the keynotes and...
See why you should always use alias or column names in your ORDER BY clauses, rather than ordinal position.
I gave a presentation this morning to my bosses and co-workers explaining some of the benefits of upgrading to SQL Server 2008. I thought it might be useful to some of you if I...
When developing stored procedures, there seems to be a lot of emphasis on "get it done fast." Which means type all lower case, pay little attention to formatting, and sometimes throw best practices out...
In a recent blog post, Dancho Danchev mis-labeled a recent IIS vulnerability as a "massive SQL injection attack." Let's be honest here. Yes, this alert needs attention. But this is not a new SQL...