Meeting Archive

2023

• September
  • Tame Your Unruly Data…With Constraints! – Rob Volk
  • Here’s the Execution Plan… Now What? – Hugo Kornelis
• August
  • Handle Azure SQL Auditing with Ease – Josephine Bush
• July
  • Divide and conquer Partitioning – Stuart Moore
  • What is Azure Arc-enabled data services – Nikita Takru
• June
  • Parallelism in Microsoft SQL Server – Torsten Strauß
  • Hybrid Disaster Recovery with SQL Server 2022 – Armando Lacerda
• May
  • The magnificent seven and beyond – Intelligent Query Processing in SQL Server – Taiob Ali
  • Execution Plans … Where do I start? – Hugo Kornelis
• April
  • Uncovering Duplicate, Redundant, and Missing Indexes – Andy Yun
• March
  • Development Lifecycle Basics for DBAs – Eitan Blumin
• February
  • Getting Started: SQL Server Data Security – John Deardurff
• January
  • Modern Data Warehouse Using Azure Synapse Analytics – Pawel Potasinski

2022

• December
  • Introduction to Spark for SQL Server Pros – Warner Chaves
• November
  • Protect your data with Microsoft Azure Backup – Tomislav Bronzin
  • SQL Server Backup Strategies in Azure – Armando Lacerda
  • Data Warehouse or Data Lake: Which do I choose? – Rachel Pedreschi
• October
  • Crushing a Cloud Migration: Moving Mountains While Migrating Data – Matt Gordon
  • Scaling Clustered Column Store – Thomas Grohser
• September
  • Achieving Wonders with Query Store – Dennes Torres
• August
  • Data Virtualization with Polybase and SQL Server 2022 – Kevin Feasel
• July
  • Memory Optimized TempDB – Torsten Strauss
• June
  • SQL Assessment – Microsoft’s Best Practices Checker – Taiob Ali
  • Performance Tuning Azure SQL Database – Monica Rathbun
• May
  • GIT For DBAs – Justin Dearing
• April
  • Storing and Searching Files in SQL Server FileTables – Sam Nasr
  • Advanced Insides into System Versioned Temporal Tables – Uwe Ricken
• March
  • Introduction to Azure Synapse Serverless Pool – Warner Chaves
  • Python for SQL Server DBA and Developers – Jean Joseph
• February
  • Azure SQL Server And DevOps – Alpa Buddhabhatti
  • Infrastructure DBA In the Cloud – Kellyn Pot’Vin-Gorman
• January
  • Azure SQL: Year In Review – Anna Hoffman and Bob Ward
  • Query Store on-Prem and In the Cloud – Deepthi Goguri
  • The Encryption Primer – Steve Jones

2021

• December
  • Introducing SQL Server 2022 – Bob Ward
  • Backup Basics with Powershell and dbatools – Andy Levy
• November
  • Advanced Data Types – JSON – Damir Matesic
• October
  • How to Audit SQL Server for Free – Josephine Bush
  • How to Conduct a Database Design Review – Kevin Kline
• September
  • Introduction to Data Engineering with Azure Synapse Analytics – Warner Chaves
  • Creating Azure SQL Database Users Programmatically with a Service Principal using Azure DevOps – Rob Sewell
• August
  • Azure Logic apps for Azure Database DBAs – Ronen Ariely
  • PostgreSQL for the SQL Server DBA: What to Know When You’re Called in to Help! – Ryan Booz
  • Azure SQL Database for DBAs – Ameena Lalani
• July
  • Turn Runbooks into Notebooks: Azure Data Studio for the On-Call DBA – Matt Gordon
  • Need to Monitor Any Azure Resource? Must Learn Kusto Query Language – Taiob Ali
• June
  • NoSQL for the DBA – Jean Joseph
  • Streamline Database Deployments – Elizabeth Noble
• May
  • Azure SQL Database and Managed Instance vs OnPremise – Jose Manuel Jurado Diaz
  • Become a Contributor to Microsoft Docs – Microsoft SQL Docs Team
• Apr
  • Packaging Permissions in Stored Procedures – Erland Sommarskog
  • Going to Azure SQL: Admin differences no one told you before – Dennes Torres
• Mar
  • From Service Level Agreement to HA/DR solution – Thomas Grohser
  • 5 ways to reduce database size and improve performance – Dmitri Korotkevitch
• Feb
  • Full Text Indexing Basics – John Miner
  • SQL Full Text Search – Hilary Cotter
  • SQL Admin Best Practices with DMVs – William Assaf
• Jan
  • Storage 101 for the DBAs – Argenis Fernandez
  • Big Data Clusters for the Absolute Beginner – Mohammad Darab

2020

• Dec
  • SQL Notebooks in Azure Data Studio for the DBA – Rob Sewell
• Nov
  • Monitoring and managing your enterprise Sql Server database farm – DBWatch
  • My Romantic Relation with Powershell Generally (and with dbatools especially) – Magnus Ahlkvist
  • Relational Database in Azure – David Alzamendi
• Oct
  • The Function of Windowing Functions – Kevin Wilkie
  • Controlling Chaos with Resource Governor – John Miner
  • SQL Server farm management vs single instance management
• Sep
  • Stored Procedure Optimization Techniques – Kimberly Tripp
  • SQL Server 2019 is not your dad’s DBMS – Armando Lacerda
• Aug
  • A Beginner’s Guide to Becoming a Performance Tuner
  • Getting Started with SQL Containers on Docker & Kubernetes – Carlos Robles
  • SQL Server to Azure SQL: Performance and Availability – Bob Ward and Anna Hoffman
• Jul
  • Beyond the Basic SELECT
  • You should use Column Store but Avoid the Mistakes I made… – Thomas Grohser
• Jun
  • JSON for the SQL Server Professional – Martin Catherall
• May
  • Replacing Profiler with Extended Events – Erin Stellato
  • Understanding character data types in SQL Server, including UTF-8 – Greg Low
• Apr
  • DBA Tools for Microsoft Azure- Radu Vunvulea
• Mar
  • Habits of Highly Successful DBA Teams – Kevin Kline
  • The Evolution of the DBA in the Age of Cloud – Warner Chaves
• Feb
  • Deadlocking for Mere Mortals – Jonathan Kehayias
  • Azure SQL Database Unleashed: Managed Instance, Hyperscale, And More Horsepower! – Matt Gordon
  • Azure Data Security – Tim Radney
• Jan
  • SQL Server Memory Internals & Troubleshooting – Amit Bansal

2019

• Dec
  • SQL Server & Kubernetes
  • Scalable data pipelines with managed Delta Lake on Databricks & Azure Data Lake Store Gen2
  • SQL Server 2019: Your Next Modern Data Platform
• Nov
  • Basic Database Programming – John Miner
• Oct
  • Managing SQL server farms vs managing SQL Server Instances.
  • Introduction to Query Store – Erin Stellato
• Sep
  • Networking 101: Getting Ready for a SQL Event
  • Refactoring Queries for Improved Performance
  • Eyes On The Prize: Simple and Effective Dashboard Visualization Techniques – Kevin Feasel
• Aug
  • Go, go, QueryStore! (Upgraded) – Gail Shaw
  • Container – You Better Get on Board! – Anthony Nocentino
• Jul
  • What Else Can Indexes Do?
  • Help! SQL Server 2008 is Still Here! – Brent Ozar
  • Introduction to SQL Server Temporal Tables – Tim Mitchell
• Jun
  • Modernizing on SQL Server 2019
  • 14 Habits of Great SQL Developers – Ike Ellis
  • Journey to the Cloud with Azure Database Migration Service – Warner Chaves
• May
  • DevOps Fundamentals: What, who, why and how? – Kendra Little
  • Using Open Source Products for Collecting Performance Metrics – Tracy Boggiano
  • Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance – Glenn Berry
• Apr
  • 3 Performance Tuning Tricks you Always Wanted to Know – Pinal Dave
• Mar
  • Administering Beyond the Speed of Light : Managing SQL Server with Ansible
  • Where Should My Data Live (and Why)?
  • Stored Procedure Optimization Techniques – Kimberly Tripp
• Feb
  • Architectural Choices That Affect Performance – Kevin Kline
  • Understanding SQL Server Backup and Restore – Tim Radney
• Jan
  • Free Downloads for Powerful SQL Server Management – Brent Ozar
  • Plan Stability through Plan Forcing – Erin Stellato

2018

• Dec
  • Cross querying multiple SQL sources using Xpath based queries
  • Introduction and Use cases for working with Azure Databricks
  • Data Compression 101
• Nov
  • An Introduction to Partitioning
  • Indexing from the Ground Up
• Oct
  • 5 Shifts to Becoming a Rockstar Data Professional (Without the Stress and Burnout Caused by Being in
• Sep
  • Linux Fundamentals for SQL Server DBAs
  • Data Types Do Matter
• Aug
  • BEGINNING ADMIN: THE CARE AND FEEDING OF SQL SERVER
  • SQL Server 2017 Database Engine Enhancements: Why You Should Upgrade to it
  • Bad Designs have Consequences
• Jul
  • Top 7 Thing’s a New DBA Should Know
  • What is this Temporal Table thing anyway? Come and see!
• Jun
  • CHOOSING THE RIGHT AZURE SQL SERVICE FOR YOU
  • Tips and Tricks for Using SQL Server Management Studio Effectively
  • Not So Secret: Get To Know SQL Server Agent – Jes Borland
• May
  • Advanced Indexing for Beginners
  • Index Design Patterns for Beginners – Kendra Little
• Apr
  • Execution Plans 101 – Thomas LeBlanc
  • Test Driven Development in SQL Server – it will make your database deployments better
  • Index Fragmentation: Internals, Analysis, and Solutions – Paul Randal
• Mar
  • What To Do When SQL Server is Slow – Brent Ozar
  • Common SQL Server Mistakes and How to Avoid Them – Tim Radney
• Feb
  • High Availability/Disaster Recovery 101 – Glenn Berry
  • Migrating to In-Memory OLTP – Erin Stellato
• Jan
  • The Jr. DBA Workout Plan – Erik Darling
  • Statement Execution and the Plan Cache – Kimberly Tripp

2017

• Dec
  • SQL Operations Studio – SQL Tiger Team Introduction
  • Ten Surprising Performance Killers on Microsoft SQL Server
  • SSIS 2016 – Intermediate
• Nov
  • SQL Server 2017 – Deep Dive – Bob Ward
  • Strategies to get maximum concurrency for your workload in SQL Server
  • T-SQL’s Hidden Support Feature – Jennifer McCown
  • Optimizing your SQL Server for Azure VMs
• Oct
  • Upgrade Strategies for Highly Available SQL Server Environments- Edwin Sarmiento
• Sep
  • Shortcuts From an Impatient DBA – Andy Mallon
  • From DBA to Data Scientist – Mike West
  • T-SQL’s Hidden Support Feature – Jennifer McCown
  • SSMS Shortcuts & Secrets – Kendra Little
• Aug
  • Linux for the SQL Administrator – David Klee
  • Azure SQL Data Warehouse for the SQL Server DBA – Warner Chaves
  • SQL Server 2017 – What’s New
• Jul
  • Extending DevOps to SQL Server
  • SQL Server Performance Tuning Made Easy
  • DevOPs and the DBA
• Jun
  • SQL Server 2016 SP1: All the Enterprise Features You Ever Wanted—In Standard Edition
  • Plan, Design and Implement a HADR Solution – a Journey
  • All about Indexing with Gail Shaw
• May
  • SSIS Fundamentals and Beyond. 2016 Features
  • Survey of the Azure Data Landscape
  • How to Assess Technical Quality of Apps Running on Microsoft SQL Server
• Apr
  • How to Triage SQL Server Emergencies
  • Analyzing I/O Subsystem Performance
  • Dr. DMV’s Troubleshooting Toolkit
• Mar
  • Deadlocking for Mere Mortals
  • In-Memory OLTP – What it can do for me
  • Performance Troubleshooting Using Wait Statistics
• Feb
  • Stored Procedure Optimization Techniques
  • Partitioning Basics: Treating your tables like Lego
  • “Answering the Question, “What Happened?” with QUERY STORE”
• Jan
  • FIRE! A FULLPROOF CHECKLIST FOR TUNING AND TROUBLESHOOTING
  • What Smart SQL Server DBAs Ought to Know about Windows Server Failover Clustering
  • How SQL Server 2016 SP1 Changes the Game

2016

• Dec
  • VLDBs: Lessons Learned
  • The Server is Down – What will you do?
• Nov
  • SQL Server 2016 Always On Availability Groups Perf Enhancements & Internals
  • Watch Brent Tune Queries
• Oct
  • Statistics and Query Plans
• Sep
  • Performance Tuning as Pinal Dave Sees It
  • Understanding Backups
• Aug
  • Securing SQL Server, Recommended Practices
  • High Availability/Disaster Recovery 101
• Jul
  • SQL Server Performance Monitoring & Baselining
  • 3 Skills Every Junior DBA Must Know
  • Azure SQL Database for the Production DBA
• Jun
  • 2016 Enhancements That Will Make your SQL Server Roar
  • SQL Server Database Administration for the non-DBA
  • Securing a SQL Server Checklist – Visit to the Dentist
• May
  • SQL Server Encryption
  • Beyond CXPACKET: Understanding Wait Statistics
• Apr
  • Understanding SQL Server Backup and Restore
  • Kicking and Screaming: Replacing Profiler with Extended Events
• Mar
  • The Transaction Log and How It Affects HA/DR
  • How to Use Parameters like a Pro and Boost Performance
• Feb
  • Performance Tuning Methodology as Gail Sees It
• Jan
  • Top 10 Clustering Dos and Don’ts
  • Silent Killers Lurking in Your Schema

2015

• Dec
  • End to End Troubleshooting for SQL Server
  • Index Fragmentation: Internals, Analysis, and Solutions
• Nov
  • Know Your Roles(s)!
  • Big Data and Hadoop
• Oct
  • SQL Server on Flash – Re-Thinking Best Practices
  • Common SQL Server Mistakes and How to Avoid Them
• Sep
  • SQL Server Performance Tuning: Controlling Parallelism
  • Going Asynchronous with Service Broker
• Aug
  • Moving from Profiler to Extended Events
  • What Execution Plans can tell you about Query Performance
• Jul
  • SSRS 101
• Jun
  • Identifying Long Running Queries
• May
  • XML without XANAX: How to handle XML in SQL Server
• Apr
  • Getting started with Azure’s SQL Database
• Mar
  • Building the Right Backup Strategy
  • I’ve Got a SQL Database, Now What?
• Feb
  • Dr. DMV’s Troubleshooting Toolkit
  • Virtualization 101 for SQL Servers
• Jan
  • Statement Execution and the Plan Cache
  • Performance Tuning Pit Stop for DBAs

2014

• Dec
  • Solving the Accidental DBA Problem
• Nov
  • In-memory OLTP – the ultimate performance frontier
• Oct
  • Changing Your Habits to Improve the Performance of Your T-SQL
• Sep
  • The Roadmap to Better Performance: Reading Query Plans
  • Treating Tables Like Legos, Partitioning Basics
• Aug
  • Rolling Upgrades, The Easy Way!
• Jul
  • Table Indexing 101
• May
  • SQL Server Internals Party: Storage, Memory and the Query Life-cycle
• Apr
  • Building Perfect SQL Servers, Every Time
• Mar
  • Microsoft SQL Server 2014 Countdown: SQL Server 2014 In-Memory OLTP Overview”
  • Manage Your Shop with CMS and Policy Based Management
• Feb
  • SQL Server 2014- Features Drilldown
• Jan
  • Statistics Starters
  • DBA 911 – Database Corruption

2013

• Dec
  • The Minimalist Guide to Database Administration
• Nov
  • Statistics Starter
• Oct
  • K. Brian Kelley What You Must Know About Security
• Aug
  • SQL2012 Whats New Breakthrough
• Jan
  • Louis Davidson – What Counts For a DBA