mac-glasses

Session: T-SQL’s Hidden Support Feature

Today I presented one of my favorite sessions – T-SQL’s Hidden Support Feature – for the DBA Fundamentals group! They’ll put up the recording shortly, but in the meantime I thought I’d post the slide deck and header template:

Download Goodies

Also, here are the resources I point to at the end of the session:

Oh heck, here’s the session abstract, too:

The most effective T-SQL support feature comes installed with every edition of SQL Server, is enabled by default, and costs no overhead. Yet, the vast majority of database administrator underutilize or completely neglect it. That feature’s name is “comments”.

In this session, Microsoft Certified Master Jennifer McCown will demonstrate the various commenting methods that make code supportable. Attendees will learn what’s important in a header comment, use code blocking to edit code, build a comprehensive help system, and explore alternative comment methods in stored procedures, SSIS packages, SSRS reports, and beyond. These methods help prevent errors and reduce troubleshooting.

Thanks for having me, DBA Fundamentals!

Leave a Reply

Your email address will not be published. Required fields are marked *