5 Ways to Bypass SQL Security
@Microsoft Pass Summit
In this class, we will walk through 5 not so obvious ways to bypass SQL Server security and how to close these loopholes. You will be surprised with how familiar some of these scenarios sound, and inevitably, some of you will need to make a quick phone call after this session to close some of these loopholes now. This session will frame scenarios from the mindset of a business user interacting with a DBA and show you how a casual conversation about getting permissions to one item can lead to a world of hurt and security issues.
Optimization, Optimization: Make your Queries Faster
@SQL Saturday Atlanta 2017
In this class, we will take some real world examples of very complex queries that have over a dozen joins (inner, left, and cross) and break them down to their foundational parts, restructure and rebuild, and improve performance dramatically. We will touch on techniques such as leveraging temp tables, creating indexes, and looking at execution plans to know when you’ve gone far enough on the optimization. Time is money right?...time to save a ton!