SQLBits 2022
2022-03-08..2022-03-12
-- online --
SQLBits ·
[SQLBits 2019, SQLBits 2020, SQLBits 2022, SQLBits 2023, SQLBits 2024]
who it's for
database administrators, sql developers, data engineers, devops engineers, cloud architects, site reliability engineers
topics
Query Store configuration; SQL Server 2022 features; dbatools migrations and automation; GitHub Actions CI/CD for databases; PolyBase data virtualization; columnstore compression techniques; accelerated database recovery; parameter sensitive plan optimization; Azure SQL Managed Instance migrations; Azure networking for DBAs
| title | author | length |
|---|---|---|
| Query Store Best Practices | Erin Stellato | 50m |
Query Store works but only with specific configuration and versioning: apply recent CUs (2019+ adds custom capture mode), keep the max size modest (default 1… | ||
| Architecting for High Performance SQL Server on Virtual Machines | Anthony Nocentino | 47m |
Default VM and OS settings often throttle SQL Server: the default balanced power plan can cut I/O throughput by about 30% IO drop, and over‑allocating vCPUs… | ||
| SQL Server 2022 migrations with dbatools | Jess Pomfret | 20m |
Dbatools migrates three demo databases to SQL Server 2022 using commands like copy DBA login (preserves SIDs and SQL password hashes) and copy DBA database… | ||
| Dealing with Very Large Tables in SQL Server | Milos Radivojevic | 51m |
Practical runbook for tables >1TB with concrete numbers and fixes: an unindexed filter on 20 billion rows, 4.6 TB, 28 minutes, 72M logical reads shows why… | ||
| Unveiling the magic of CI/CD for SQL Server using GitHub Actions | SANDER STAD, Kevin Chant | 49m |
Follows a concrete CI/CD recipe: build SQL Server database projects in Azure Data Studio, create SDK-style database project (globbing), run YAML workflows on… | ||
| SQL Server 2022 Performance Enhancements | Ola Hallengren | 50m |
Covers concrete SQL Server 2022 changes: a global redo thread pool turns per-database redo into a server-wide dynamic pool (observed up to 17 threads on a… | ||
| A Beginners guide to Query Store | Kevin Kline | 22m |
Query Store captures execution plans, estimated plans, runtime stats and wait statistics, storing them per database so you can find plan regressions and top… | ||
| Maximizing Database Performance With Isolation Levels | Bob Pusateri | 47m |
Covers SQL Server and Azure SQL isolation levels with concrete demos: a 41,437-row ZIP code table, 5,000 updates repeatedly moving rows while another session… | ||
| The Power of Polybase with SQL - True data Virtualisation | Manish Kumar, Haider Raza | 21m |
PolyBase lets SQL Server query external stores without moving data: uses external tables and OPENROWSET, requires installing PolyBase, and SQL Server 2022 adds… | ||
| The Kingdom of AdventureWorks Calls for Aid | Bob Ward, Sanjay Mishra, Buck Woody, Asad Khan | 48m |
Live demos show Azure Arc giving free inventory and Defender surfacing a SQL injection, Intelligent Query Processing using DOP feedback to drop parallelism… | ||
| Unlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights | Anthony Nocentino | 50m |
Demo shows dbatools managing real tasks: persistent SMO connections via Connect-DbaInstance, scanning backup headers with Get-DbaBackupInformation and piping… | ||
| Advanced Power BI refresh with ADF/Synapse | Mathias Halkjaer | 50m |
Shows how to trigger Power BI dataset refreshes from ADF/Synapse using the Power BI REST API and a pipeline that uses the factory’s managed identity to call… | ||
| Columnstore Index Compression in a Nutshell | Edward Pollack | 20m |
Explains how SQL Server columnstore compresses by treating each column as a segment per row group (up to 2^20 ≈ 1M rows), then applying three steps… | ||
| A Practical Starter Guide to SQL Notebooks | Deborah Melkin | 50m |
Shows how to use Azure Data Studio with the Jupyter extension to make runnable SQL notebooks, demonstrating that cells are either text or code, that variables… | ||
| Applying effective Source Control to your Database System | Karim Ourtani | 48m |
Demonstrates using SSDT + Visual Studio to source-control database objects, produce a dacpac, and run an Azure DevOps pipeline that builds the dacpac artifact… | ||
| Time Series with SQL Server 2022 | Gianluca Sartori | 50m |
SQL Server 2022 can store and query time series but needs manual work: a 15‑day, 82M‑row performance dataset compresses from ~28GB (clustered index) to ~400MB… | ||
| Disaster Recovery Strategies for SQL Server | Andrew Pruski | 47m |
Claims that every environment needs a tested DR plan and clear RTO/RPOs, then shows how to hit them: baseline backup and restore with offsite copies, log… | ||
| Keeping historical data in tables forever – mission (im)possible! | Margarita Naumova | 50m |
Emergency-control-room data must stay in same tables forever, be editable historically, and remain fast; operational tables grow 1–20M rows/year and logging… | ||
| Synapse Link to SQL, bring your on-prem data alive | José Barbosa | 23m |
Shows how Synapse Link to SQL moves on‑prem SQL Server 2022 or Azure SQL Database into an Azure Synapse dedicated SQL pool using ADLS as the landing zone and a… | ||
| Microsoft Defender for SQL: Advanced Threat Protection | Rie Merritt | 19m |
Microsoft Defender for SQL claims it detects SQL injection payloads and other anomalous access patterns by continuously analyzing logs, and it raises alerts… | ||
| Stabilizing Performance with Query Store | Erin Stellato | 19m |
Shows how Query Store lets DBAs stop regressions without code changes by using plan forcing, automatic plan correction and Query Store Hints. Demo on… | ||
| Relational or Non-Relational? Choosing the Best Database for the Task | Bob Pusateri | 19m |
Compares relational ACID tradeoffs with NoSQL BASE and shows concrete choices: uses Azure Cosmos DB document model to build a URL redirection service (zombocom… | ||
| Chaos Engineering for SQL Server | Andrew Pruski | 44m |
Shows concrete experiments: uses PowerShell and T‑SQL to stop-service on a primary to force an AG failover, discovers default clustered role failover threshold… | ||
| What the heck is a checkpoint, and why should I care? | Taiob Ali | 51m |
Explains exactly what a SQL Server checkpoint does: writes dirty pages after flushing log records so crash recovery can redo/undo from the LSN/boot page… | ||
| Should We Defragment Indexes? | Rob Mandeville | 19m |
Argues that defragmenting indexes can harm throughput on VM/cloud storage because forcing pages into sequential order concentrates them on a single capacity… | ||
| Managed Instance Link - Seamless migration to Azure | Haider Raza, Manish Kumar | 50m |
Azure SQL Managed Instance Link replicates individual databases from SQL Server (2016, 2019 and 2022; 2017 coming) to Managed Instance using distributed… | ||
| What you can do to protect your SQL Server and why it matters | Gethyn Ellis, David Postlethwaite | 21m |
Summarizes the CIS Benchmarks for SQL Server 2019 (~103 pages) with concrete controls: set TRUSTWORTHY off, disable ad hoc distributed queries, avoid Database… | ||
| Where should I be encrypting my data | Denny Cherry | 51m |
Explains when to use one-way hashing versus two-way encryption, recommends AES-256 for strong encryption and modern hashing (SHA3), warns that encrypted… | ||
| Azure Networking Fundamentals for DBAs – Everything you need to know in 20 minutes! | Christian Bowman, Marc Dunbar | 16m |
Quick, practical rundown of Azure VNet basics with a live demo that builds a VNet, two subnets and an attached Network Security Group (NSG), adds inbound RDP… | ||
| There and back again: SQL Server 2022 - Managed Instance | Dani Ljepava | 19m |
Demo shows a working Mi Link that establishes near real-time replication from SQL Server (2016–2022) to Azure SQL Managed Instance, seeding a full DB, creating… | ||
| Here’s the execution plan … now what? | Hugo Kornelis | 51m |
Diagnoses a dashboard causing resource semaphore waits by reading actual execution plans and estimated operator input, finds a 120,000-row sort feeding a temp… | ||
| Keep the Integrity of your Database with Azure SQL Ledger | Rui Carvalho | 48m |
SQL Ledger in SQL Server 2022 and Azure SQL adds updatable Ledger table and append-only table types plus a history table and ledger view, emits encrypted… | ||
| Parameter Sensitive Plan Optimization in SQL 2022 ... As Cool as it Sounds? | Hugo Kornelis, Erin Stellato | 51m |
SQL Server 2022 adds Parameter Sensitive Plan Optimization (PSPO) which, at compat level 160, creates a dispatcher plan plus up to three variants per skewed… | ||
| SQL Server 2022 – Time to Rethink your Backup and Recovery Strategy | Stephen McMaster, Robert Sonders | 21m |
SQL Server 2022 adds a T-SQL snapshot backup that coordinates hardware snapshots (PowerStore and other SANs) via CLI or PowerShell, produces a small BKM… | ||
| Break five common myths about SQL Server backup | Taiob Ali | 18m |
Five concrete myths get busted with live T-SQL demos and numbers: repeated full backup does not break log chain — restoring the last log after a later full… | ||
| Elevating SQL Server Performance with Query Store Hints | Rui Carvalho | 20m |
SQL Server 2022 lets Query Store attach hints to a captured query so execution changes without touching application code; demo shows using built-in procedures… | ||
| Let me show you why data types still matter | CLÁUDIO SILVA | 19m |
Demonstrates concrete failures from mismatched types: float rounding causes comparisons to evaluate false even though SSMS prints 0.3, and NVARCHAR uses two… | ||
| Beware of nondeterministic T-SQL code | Itzik Ben-Gan | 51m |
Shows concrete failures and fixes: pagination with OFFSET ... FETCH or TOP returns nonrepeatable rows when ORDER BY isn’t a strict total order, because the… | ||
| More for less: Cost optimizing your Azure SQL databases | Arvind Shyamsundar, Aditya Badramraju | 52m |
Compares service tiers with concrete limits and costs: Business Critical and General Purpose cap at 4 TB and tie compute to storage, Hyperscale separates them… | ||
| SQL Server Containers & Kubernetes - Going to Production! | Amit Khandelwal, OJ Ngo, Tejas Shah | 57m |
Claims that the exact same SQL Server binary runs on Linux and in containers via same SQL engine, demonstrates an Always On availability group failing over… | ||
| Lessons learned from refactoring multi terabyte databases for the last 10 years | Sergey Olontsev | 54m |
Ten years of refactoring multi‑terabyte databases yields concrete rules and examples: use IDEs (Visual Studio, DataGrip finds dynamic SQL references), keep… | ||
| Stop Indexing the Query | Rob Mandeville | 41m |
Methodology identifies low‑ROI queries by computing logical and physical reads divided by rows desired and reads to rows > 8 filters the worst candidates, then… | ||
| Indexing Internals for Developers & DBAs | Bradley Ball | 53m |
Shows exact internals and demos: heaps always scan (example query costs 7,504 logical reads) vs a clustered seek (4 logical reads), loading a staging table… | ||
| Understanding Alert Fatigue | Owen Murphy | 16m |
Explains why hundreds of daily notifications become ignored and links that to real harms: missed incidents, slower response times, burnout and failed projects… | ||
| Fundamentals of Git | Grant Fritchey | 20m |
Git is presented as a distributed VCS that runs locally and on hosted services (GitHub, GitLab, Bitbucket, Azure DevOps, AWS CodeCommit) with branching built… | ||
| Managing replication with dbatools | Jess Pomfret | 48m |
dbatools now includes dbatools replication commands that create a distributor and three publications (transactional, merge, snapshot), add articles… | ||
| When to stop tuning a query | Milos Radivojevic | 53m |
Single T‑SQL query against Orders (100M) and OrderDetails (335M) returns 248 rows but starts as a hash join with a cluster scan, cold cache costing 5 million… | ||
| Welcome to the world of SQL Copilots | Bob Ward, Joe Sack | 45m |
Azure adds a Copilot for Azure SQL that demos about 40 skills (team cites ~55 total) and uses Azure OpenAI without fine‑tuning on customer data. It queries… | ||
| Relational or Non-Relational? Choosing the Best Database for the Task | Bob Pusateri | 19m |
Clear rule set: use relational when you need strict ACID transactions and normalized data; avoid relational for logs, images, large text or BLOBs and instead… | ||
| Banishing Slow Queries with Intelligent Query Processing | John Morehouse | 53m |
Overview of SQL Server Intelligent Query Processing features and live demos showing concrete effects and requirements. Demonstrations use WideWorldImporters… | ||
| The Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance | Dani Ljepava | 44m |
Mi Link provides bidirectional, database-scoped replication between SQL Server and Azure SQL Managed Instance using distributed availability groups and… | ||
| Hidden Gems in SQL Server 2022 Database Engine | Ajay Jagannathan, Dimitri Furman | 49m |
Demo-heavy session that shows concrete fixes and numbers: handsfree tempdb removes most latch contention so a 25-thread stress test falls from 19–28s down to… | ||
| Soaring to New Heights with Accelerated Database Recovery | John Morehouse | 54m |
Explains how SQL Server 2019+ redesigns recovery with an in-memory slog, a persisted version store inside the user database, logical revert and an… | ||
| ACID in SQL Server: what it is, how it works, and how to live more adventurously. | Daniel Hutmacher | 52m |
Covers how SQL Server implements ACID with concrete demos: isolation levels from read uncommitted to serializable, a banking transfer demo showing dirty reads… | ||
| Building Your Data Analytics Team - live RunAs Radio episode | Anupama Natarajan, FALEK MIAH, Maria Zakourdaev, Richard Campbell | 50m |
Panelists map concrete roles — data modeler, data engineer, analyst and architect — to specific tasks: modeling, ingestion (Power Query/SSIS/Data Factory)… | ||
| Never ETL again, thanks to Synapse Link. Really? | Ben Weissman | 19m |
Synapse Link claims a near-real-time push of selected OLTP tables into Azure Synapse by using a self-hosted integration runtime and landing data into ADLS Gen2… | ||
| Effortless Low-Code Data Testing | Tomas Tucek, Petr Pařík | 20m |
A low‑code PowerShell module called Cat PowerShell module claims one‑line install (about 15 seconds, 30 MB) and lets teams turn SQL, Postgres, Power BI and… | ||
| SQL 2022 and S3 – Dell’s overview of consuming object data via Microsoft SQL | Stephen McMaster, Robert Sonders | 50m |
Demo uses SQL Server 2022 with PolyBase against Dell ECS object storage and an S3 browser, creating database-scoped credentials and external data sources to… | ||
| Unraveling the Web of Relationships: Understanding Graph Data | Mala Mahadevan | 19m |
Starts from the 1736 Seven Bridges problem and claims graph databases excel when relationships—not entities—drive value, especially for pattern matching… | ||
| Assessing and Optimize Enterprise SQL Server Environments | Angela Henry, Ben DeBow | 49m |
Enterprise-level audit shows most waste lives in a few places: top 1% of SQL code generates more than half the cost, and cost of code is measurable in dollars… | ||
| SQL Horror Stories | Kevin Kline | 21m |
A run of cautionary tales shows concrete failures and fixes: a manager blocks preventative scripts to speed deployments and the team pays with repeated… | ||
| Come see your SQL Perfmon in the cloud | Dimitri Furman, Bob Ward | 49m |
Database Watcher is a managed monitoring pipeline that pulls query store, >200 perf counters and 70+ views from databases, managed instances, elastic pools and… | ||
| An introduction to Extended Events | Peter Kruis | 51m |
Introduction to Extended Events with demos in SSMS showing how to create sessions, script them, and read live and historical .xel files; key events used are… | ||
| Getting Started Quickly with DB DevOps | Huxley Kendell | 20m |
A live demo shows Flyway wiring into GitHub with a runner, creating sandbox Dev/Test/Staging databases, and using a free Fly Autopilot tutorial repo to go from… | ||
| DevOps Discovery: Navigating the Database Landscape | Huxley Kendell, David Ong | 48m |
Redgate demonstrates a pipeline: Test Data Manager creates masked, containerized clones in ~30s and claims it can reduce a 5TB production dataset to ~100MB per… | ||
| Writing T-SQL code for the engine, not for you "more demos" by popular demand | CLÁUDIO SILVA | 52m |
Live demos run on a SQL Server 2022 container with SSMS 19 and a 10GB StackOverflow DB; concrete fixes include eliminating implicit conversions (Unicode vs… | ||
| Data Modernization in a Hybrid World | Kenny Lowe, Stephen McMaster, Robert Sonders | 18m |
Claims that SQL Server runs faster on Linux and that true hybrid means using the same tools across public Azure, on‑prem and edge; shows Azure Arc hooking… | ||
| Excellent Database Adventure: From Code Errors to Reliable Releases | Dave, James Hemson | 20m |
Demonstrates turning messy, hand‑edited databases into a repeatable release pipeline: check schema into SQL Source Control, apply team formatting and snippets… | ||
| Flying High with Highly Available SQL Server Deployments | Aaron West | 20m |
Defines HA for SQL Server as surviving node and storage failures using clustering plus local disk replication instead of costly SAN, and shows a working setup… | ||
| Azure Infrastructure - What Not to Do | John Morehouse | 22m |
Covers concrete failures seen in Azure deployments and fixes: misconfigured blob storage or anonymous access, overlapping IP blocks from poor network planning… | ||
| Business Continuity for Hybrid and Cloud Native SQL Server Deployments | Allan Hirt | 52m |
Defines recovery targets like restore timing (RTO) and data currency (RPO), insists native backups are mandatory and tested, and warns a multi‑TB seed to the… | ||
| Fly at Mach-speed with Azure SQL Managed Instance | Niko Neugebauer, Nevena Nikolic, Uros Milanovic | 51m |
Azure SQL Managed Instance upgrades its storage from premium page blobs to premium managed disks, cuts average latency to about 3–4 ms, and exposes an IOPS… | ||
| Making the SQL Query Processor Work for you | Ajay Jagannathan, Joe Sack, Derek Wilson | 51m |
Upgrade to compatibility level 160 to get automatic QP innovations; SQL 2022 turns Query Store on by default for new databases and persists feedback there. Use… | ||
| Shift-Left: A DevOps and Database Story | Kevin Kline | 23m |
Claims that shifting database performance testing left into development prevents production slowdowns, and shows it using SQL Sentry and the free Plan Explorer… | ||
| Empowering SQL: Mastering Intelligent Query Processing in 20 Minutes | Haider Raza, Manish Kumar | 22m |
Intelligent Query Processing is traced from 2017 to 2022: it learns from runtime plans and actually changes execution on the fly. Key concrete features are… | ||
| Hear me out - Don't go offline because of your index deployment strategy | CLÁUDIO SILVA | 20m |
A deployment drops an index then creates a new offline one and the system’s CPU and wait times spike while the table locks; backups every 15 minutes stop… | ||
| SQL Server and Windows Server Better together on Azure | Dilip Ramachandran, Bob Ward | 49m |
Demonstrations show Windows Server Azure Edition hot patching that applies two real updates in seconds with no reboot versus minutes and downtime for… | ||
| Azure Stack HCI and Microsoft Hybrid Data Services | Kenny Lowe, Stephen McMaster, Dilip Ramachandran, Robert Sonders | 48m |
Dell Azure Stack HCI validated with 3rd‑gen AMD Milan‑X / EPYC (3D V‑Cache) runs Azure Arc enabled data services and AKS to host 20 SQL Managed Instances that… | ||
| Data tiering using data Virtualization in SQL | Ajay Jagannathan | 51m |
SQL Server uses PolyBase to query external files and databases without copying data, now shipping a native PolyBase V3 REST architecture in SQL Server 2022 and… | ||
| Managing the Challenge of Monitoring Growing, Multi-platform Database Estates | Laura Copeland, Grant Fritchey | 20m |
Survey finds 80% of estates cloud or hybrid and 72% run multiple database platforms, with 50% using Postgres; monitoring pain is cross-platform visibility and… | ||
| The New Database Landscape - Revealing Shifts and Charting the Next Horizon | Grant Fritchey, Danielle Summers | 49m |
Survey finds 21% single-database adoption and a startling 30% using six-or-more platforms, with Oracle/MySQL/SQL Server/Postgres as the top four and Postgres… | ||
| The Microsoft Intelligent Data Platform and | Kenny Lowe, Stephen McMaster, Dilip Ramachandran, Robert Sonders | 17m |
Dell and AMD show validated stacks for Azure Stack HCI, VxRail, PowerStore and APEX and claim Kubernetes as the required foundation for Azure Arc enabled data… | ||
| Efficiency up, failed releases down; compliant production data for your test and dev environments | Grant Fritchey, Chris Hawkins | 47m |
Claim: realistic, compliant copies of production cut failed releases and speed development by giving developers usable data without exposing secrets. Workflow… | ||
| Achieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi | Ajay Jagannathan | 50m |
Shows concrete engine features: metadata versioning (allows DDL and snapshot reads to run concurrently, currently in Azure preview for ALTER TABLE), optimized… | ||
| Return ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR | Djordje Jeremic, Dani Ljepava | 23m |
Live demos show a new Mi link that sets up near real-time replication between SQL Server (2016+) and Azure SQL Managed Instance using distributed availability… | ||
| Challenge to Triumph: Exploring Real-World High Availability in SQL Server Environments | Harry Aujla | 20m |
Large Canadian multimedia conglomerate moves roughly 3–400 SQL servers into AWS and deploys about 300 clusters built from SIOS DataKeeper plus Windows Failover… | ||
| Flight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud Cockpit | Ben Weissman | 22m |
Azure Arc enables Azure features for on‑prem and multi‑cloud SQL by running one PowerShell script that installs an agent, sends metadata to a chosen Azure… | ||
| Tidy Space, Tidy Mind; How to Better Manage SQL Environments Across Cloud Providers | Lior Asta | 44m |
Explains how a single monitoring pipeline across Azure, AWS and GCP surfaces the actual money drains: collects query telemetry from SQL Server, Oracle, MySQL… | ||
| Effortless Low-Code Data Testing | Tomas Tucek, Petr Pařík | 19m |
Tool demo of cat shows low-code data tests implemented as plain SELECTs that get compared across sources (Postgres, SQL Server, Power BI/Fabric, Databricks… | ||
| nothing matches | ||