Presentations from SQL Bits XII : T-SQL Bad Habits & Best Practices
This week I've been in Telford, UK at SQL Bits XII. These guys outdo themselves every time, putting on yet another fantastic event (my 6th in a row). If you haven't made it to one of these conferences, you really should make an effort for the next one.
Yesterday I presented my session on T-SQL Bad Habits and Best Practices. You will be able to download the presentation, sample files and view the video at the following URL:
Bertrand_SQLBits_TSQL.zip (165 KB)
Kevin Kline (blog | @kekline) and I also did a joint vendor session together, entitled Top Tools for Tuning SQL Server. We talked about SQL Sentry Plan Explorer (including the demo kit I wrote earlier this year), cloning stats-only databases, and
DBCC OPTMIZER_WHATIF(). The video will be available here soon:
Aaron (@AaronBertrand) is a Data Platform MVP with industry experience dating back to Classic ASP and SQL Server 6.5. He is editor-in-chief of the performance-related blog, SQLPerformance.com, and serves as a community moderator for the Database Administrators Stack Exchange. Aaron's blog focuses on T-SQL bad habits and best practices, as well as coverage of updates and new features in Plan Explorer, SentryOne, and SQL Server.