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:
Also, here are the resources I point to at the end of the session:
- Minion Backup: MinionWare.net/Backup
- Video – Commenting SSIS: midnightdba.com/Video/Watch?VideoId=52
- Video – Commenting SSRS: www.midnightdba.com/Jen/2010/07/commenting-ssrs/
- Me on Twitter: www.Twitter.com/MidnightDBA
- Other session recordings: http://midnightdba.itbookworm.com/Events
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!