Sessions

Getting Better Query Plans by Improving SQL’s Estimates

15 Comments
Target Audience: You want faster queries, and you’re starting to read execution plans to figure out what to do. Abstract: You’ve been writing T-SQL queries for a few years now, and when you have performance issues, you’ve been updating stats and using OPTION (RECOMPILE). It’s served you well, but every now and then, you hit…
Read More

SQL Injection Attacks: Is Your Data Secure?

4 Comments
Target Audience: Developers, DBAs, and anyone else responsible for writing or maintaining dynamic SQL queries. Abstract: SQL injection is one of the most common ways that hackers gain access to your SQL server. Do you know how to harden your queries and protect your data from malicious users? This session will provide an overview of…
Read More

Architecting Availability Groups

5 Comments
Target Audience: A DBA new to Availability Groups. Familiar with basic clustering and database mirroring concepts. Abstract: This session will cover the pros and cons of four typical configurations of AlwaysOn Availability Groups; stand-alone instances, fail-over cluster instances, multi-subnet, and a hybrid approach that I call disaster-recovery-on-the-cheap. It will also include their exclusive features such…
Read More

SQL Server Containers and Clones

1 Comment
Target Audience: SQL Server DBAs and Developers. Abstract: Microsoft emphasizes use of containers for development and test on SQL Server 2017, and new solutions from Red Gate and Windocks add support for containers and SQL Server database cloning  for the full range of the SQL Server family. We’ll explore use of containers for delivery of…
Read More

Be My Azure DBA (DSA)

5 Comments
Target Audience: Any DBA that wants to start using/looking after Azure data services. Abstract: There seems to be a common misconception that once you move from on premises SQL Server to Azure PaaS offerings a DBA is no longer required. This perception is wrong and in the session I’ll show you why. As a business…
Read More

SQL Server 2017 Community Driven Enhancements

4 Comments
Target Audience: Targeted to DBAs and Developers who want to get familiar with new features in SQL 2017. Abstract: Will cover all new SQL 2017 features that the Data Platform Community has requested and Microsoft has included in the next major version of SQL Server. 200 level Why I Want to Present This Session: I…
Read More

The Junior SQL Developer’s Kick-Start

Target Audience: Entry-level and junior SQL Server developers seeking “Now what?” guidance beyond introductory T-SQL. Abstract: Congratulations on your recent move into the world of SQL Server development! You’ve got a handle on the basics — SELECT, INSERT, UPDATE, and DELETE — but now what? How do you know what’s important to learn next, and…
Read More
Menu