Audio podcast: Enjoy the Podcast? Don’t miss an episode, subscribe via iTunes, Stitcher or RSS Leave us a review in iTunes Target Audience: You’re responsible for the care and feeding of production SQL Servers, including index maintenance. Abstract: For years, you’ve heard that you’re supposed to reorganize your indexes to make SQL Server go faster….
Here’s the lineup you voted in for March 16th:
- 8AM Eastern: Making Your Emergency Toolkit by Rich Benner
- 9AM: SQL Injection Attacks: Is Your Data Secure? by Bert Wagner
- 10AM: Architecting Availability Groups by Derik Hammer
- 11AM: SQL Server 2017 Community Driven Enhancements by Javier Villegas
- Noon: SQL Server Containers and Clones by Paul Stanton
Recent Session Recordings
Let’s face it, using SQL PowerShell prior to SQL Server 2016 was like installing training wheels on a Ducati. But things have massively changed.
I’m going to explain what DevOps is, where it came from, and its implications for SQL Server. We’ll cover the human and technical basics of database DevOps – and I’m going to discuss some changes that data folk need to make.
In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance.