Speaker – Louis Davidson (view bio)
Session – Implementing Row Level Security in SQL Server
Since the early days of SQL Server, it has been possible to use basic security measures to allow (and disallow) user access to any object in a database, and even limit access to a given column. A more difficult task has been to limit access to the individual rows in a table. This has made application development more complex because whereas most every user may have access to a table like HR.Employee, not every employee will have access to every employee’s data. In this session I will cover several techniques to limit access to rows, from methods that have existed since early versions of SQL Server, to the new Row Level Security feature in SQL Server 2016. If time permits, an overview of Dynamic Data Masking will be included, since it is a related technology.
Speaker – Cameron Snapp (view bio)
Session – Choosing Sides in the ETL vs ELT Debate
NOTICE — This meeting has been postponed until 1/24 6pm because of expected inclement weather.
The debate regarding the relative merits of extract transform load (ETL) and extract load transform (ELT) data migration strategies isn’t new, but it remains relevant. Making the right choice is critical, because the wrong solution will slow development cycles and execution times, and increase the cost and complexity of code maintenance. In this presentation, I’ll cover some best practices for implementing an ELT solution for a variety of data migration scenarios. Data enthusiasts of any level will benefit from a detailed discussion of methodologies, strategic benefits, and code examples.
Speaker – Rodney Landrum (view bio)
Session – The DBA Script Thumb (10 year anniversary)
Over time and through many different roles I have collected a wide array of T-SQL scripts and techniques that I use many times per week. These vary from basic troubleshooting, to health checks and best practice configuration settings to custom alerting and trending. In this session, I will walk through several of these scripts and ultimately show how you can automate the delivery of the output into useful reports and visualizations that will wow your boss (or customers) but more importantly, help you find and address potential problems fast and for free.
Download the The DBA Script Thumb (10 year anniversary) script
Speaker – Wayne Sheffield
Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne
Session Title – More Fundamentals for Your SQL Server Toolbox [DBA]
SQL Server has evolved many times over the years. This evolution has brought a need for every DBA to enhance or at least revisit their fundamental methods for tuning and troubleshooting. In this session you will explore how SQL Server has made the data professional’s job easier through the addition of new features and enhancements to some of the well-established features. This session will expose you to some of the new toys now available to you (such as execution plan changes and new Dynamic Management Objects) that will help improve your efficiency at troubleshooting and tuning SQL Server. Coming away from this session, you will have more tools to help showcase your rock-star skills back on the job.
Thank you to our Sponsors!