Monthly Meeting Thursday, October 19, 2017 at 5:30pm!

Meeting in Aurora, Colorado!

Meeting Denver SQL User Group
Thursday, October 19, 2017 5:30pm – 8:30pm
Aurora Mental Health Center
791 Chambers Road,
Aurora CO 80011
https://goo.gl/maps/ZiTWLTvjzRD2

Auditorium in the Basement. Please enter by the Front Door.

Meeting Agenda
5:30 – 6:00 Food / Socializing
6:00 – 6:15 User Group Business
6:15 – 6:30 Open panel/Questions & Answers
6:30 – 7:00 Warmup presentation
7:00 – 8:30 Main presentation

30 minute session:
There’s a shortcut for that! – SSMS Tips and Tricks

Have you ever accidentally pressed the wrong combination of keys, stared at your screen in utter confusion, then spent the next ten minutes trying to figure out what you just pressed that did that really cool thing?

In this session, I will show you some of what I have learned and discovered that has made me say “Oh wow! Why did I not know this yesterday!?” – including SSMS interface tweaks, features and keyboard shortcuts.

Bio:
Cathrine Wilhemsen loves teaching and sharing knowledge. She works as a consultant, technical architect and developer, focusing on Data Warehouse and Business Intelligence projects. Her core skills are ETL, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the SQL Server and PASS communities as a Microsoft Data Platform MVP, BimlHero Certified Expert, speaker, blogger, organizer and chronic volunteer.

60 minute session:
Revenge: The SQL!

Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You’re on the edge. What do you do? WHAT DO YOU DO?

Hint: You attend Revenge: The SQL!

This session will show you how to “correct” all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT* and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!

Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.–

Bio:
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. An MCSE, he also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers “business intelligence” an oxymoron or “the cloud” as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.