2023 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