April 16, 2020 – Jen McCown presenting SQL’s Hidden Support Feature
6:00 – 6:15 User Group Business
6:15 – 7:15 Main Presentation
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.
By Jen McCown
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, the North Texas SQL Server User Group, and the PASS Women in Technology virtual chapter.
Please join the meeting from your computer, tablet or smartphone.
You can also dial in using your phone.
United States: +1 (408) 650-3123
Access Code: 539-646-717
New to GoToMeeting? Get the app now and be ready when your first meeting starts: