I talk about a couple of subtleties of THROW, and how to avoid frustrating bouts of troubleshooting.
12 Search results
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.
For this month's T-SQL Tuesday, I share some of my favorite best practices.
See why you should always use alias or column names in your ORDER BY clauses, rather than ordinal position.
I explain several reasons I was eager to upgrade to SQL Server 2008 as soon as it was released.
I present a laundry list of things I always do in stored procedures (and why).
I react to some sensationalism that blamed SQL Server for vulnerabilities caused by issues with Windows and application configuration.