SQLBits 2019
2019-02-27..2019-03-02
Manchester, United Kingdom
SQLBits ·
[SQLBits 2019, SQLBits 2020, SQLBits 2022, SQLBits 2023, SQLBits 2024]
who it's for
SQL Server DBAs, database developers, database architects, DevOps engineers, cloud migration engineers, data engineers, security engineers
topics
Always On Availability Groups; Azure SQL Managed Instance; SQL Server 2022 migrations; dbatools automation; Flyway and GitHub Actions CI/CD; test data management masked clones; intelligent query processing; index maintenance and defragmentation; disaster recovery and backup strategies; Cosmos DB partitioning and consistency; query plan fixes and implicit conversions; monitoring with Redgate SQL Monitor
| title | author | length |
|---|---|---|
| Relational or Non-Relational? Choosing the Best Database for the Task | Bob Pusateri | 19m |
Compares relational rules (normal forms, ACID) against NoSQL tradeoffs with concrete guidance: avoid storing logs, images or huge free text in RDBMS; avoid… | ||
| Writing T-SQL code for the engine, not for you "more demos" by popular demand | CLÁUDIO SILVA | 52m |
Demos run on a SQL Server 2022 Docker container (Developer Edition) and SSMS 19 against a ~10GB Stack Overflow DB, showing concrete fixes: implicit conversions… | ||
| DevOps Discovery: Navigating the Database Landscape | David Ong, Huxley Kendell | 48m |
Redgate demos a concrete DevOps stack: TDM: masked clones from 5TB to ~100MB per developer that provision in seconds for SQL Server, Postgres, MySQL and… | ||
| Effortless Low-Code Data Testing | Petr Pařík, Tomas Tucek | 20m |
Claims a one-line install of a PowerShell module called cat that runs SQL/DAX checks and integrates into CI/CD (Azure DevOps) to give immediate failure alerts… | ||
| Challenge to Triumph: Exploring Real-World High Availability in SQL Server Environments | Harry Aujla | 20m |
A large Canadian media/tax arm migrates about 300 SQL clusters into AWS and replaces SQL Enterprise Always On with SIOS DataKeeper replication plus Windows… | ||
| Effortless Low-Code Data Testing | Petr Pařík, Tomas Tucek | 19m |
Claims a low-code test harness that installs with one-line Install-Module cat, runs tests defined as SQL selects compared across sources, and plugs into CI/CD… | ||
| Flying High with Highly Available SQL Server Deployments | Aaron West | 20m |
Defines HA options for SQL Server with specifics: shared SAN, Block‑level mirroring, log shipping, Always On Availability Groups, and DataKeeper block-level… | ||
| The New Database Landscape - Revealing Shifts and Charting the Next Horizon | Danielle Summers, Grant Fritchey | 49m |
Annual survey shows 21% single-database while 30% use six or more platforms and 70% run hybrid deployments; top platforms remain Oracle, MySQL, SQL Server and… | ||
| SQL Horror Stories | Kevin Kline | 21m |
Guided tour of real failures: backups often succeed but restores fail, forcing recovery from 10+ day-old copies; DBCC CHECKDB is cited as mandatory before a… | ||
| Getting Started Quickly with DB DevOps | Huxley Kendell | 20m |
Sets up a working DB DevOps pipeline in under 30 minutes using Flyway and a free Fly Autopilot sandbox that clones a GitHub repo, installs a runner, and… | ||
| Shift-Left: A DevOps and Database Story | Kevin Kline | 23m |
Argues that performance testing must be shifted left by embedding SolarWinds SQL Sentry and Plan Explorer into a CI pipeline (Visual Studio/TFS) so deployments… | ||
| Managing the Challenge of Monitoring Growing, Multi-platform Database Estates | Grant Fritchey, Laura Copeland | 20m |
Redgate Monitor claims to unify multi-platform estates by giving a single pane of glass that shows 80% cloud/hybrid adoption, 72% of DBAs managing multiple… | ||
| Return ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR | Dani Ljepava, Djordje Jeremic | 23m |
Live demos show one‑click reverse migration and DR using the Mi link feature, creating links from SQL Server to SQL Managed Instance and back by running an… | ||
| Stabilizing Performance with Query Store | Erin Stellato | 19m |
Demonstrates using plan forcing and Query Store hints to stabilize a procedure that shows plan sensitivity: the same proc returns 26,000 rows for customer 401… | ||
| Assessing and Optimize Enterprise SQL Server Environments | Ben DeBow, Angela Henry | 49m |
Claims that the top 1% equals 50% of database cost guide a concrete plan: identify the same expensive statement running across hundreds of databases, quantify… | ||
| Indexing Internals for Developers & DBAs | Bradley Ball | 53m |
Deep dive into SQL Server index behavior with live DBCC demos showing how DBCC IND/DBCC PAGE reveal IAM pages, RID lookups and forwarding pointers; heap scans… | ||
| Empowering SQL: Mastering Intelligent Query Processing in 20 Minutes | Manish Kumar, Haider Raza | 22m |
Covers concrete IQP changes across SQL Server 2017, 2019 and 2022: Query Store is now default and persists runtime metadata so memory grant feedback survives… | ||
| Maximizing Database Performance With Isolation Levels | Bob Pusateri | 47m |
Walks through concrete tests on SQL Server and Azure SQL Database using a 41,437-row US ZIP table, extended events, sys.dm_tran_locks and ALTER DATABASE… | ||
| Dealing with Very Large Tables in SQL Server | Milos Radivojevic | 51m |
Very large tables (10M–20B rows, multi‑TB) turn small mistakes into huge costs: an unindexed 20B‑row, 4.6TB table returns 3 rows with a 28‑minute, 72M… | ||
| When to stop tuning a query | Milos Radivojevic | 53m |
A single T‑SQL query against two tables — 100 million rows in orders and 335 million rows in order_details — starts with a hash join, ~11s and 5 million… | ||
| Unlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights | Anthony Nocentino | 50m |
Shows concrete dbatools PowerShell commands: standing up two SQL Server containers in seconds, creating persistent SMO connections, taking morning full plus… | ||
| An introduction to Extended Events | Peter Kruis | 51m |
Intro to on‑prem SQL Server Extended Events showing concrete setup in SSMS, how to script sessions, and how to read .xel output into a temp table for analysis… | ||
| Flight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud Cockpit | Ben Weissman | 22m |
Azure Arc registers non‑Azure servers and then enables SQL Server management by running one PowerShell script (or bash) to install an agent that sends metadata… | ||
| ACID in SQL Server: what it is, how it works, and how to live more adventurously. | Daniel Hutmacher | 52m |
A concise primer on ACID for SQL Server that focuses on Isolation levels: read uncommitted, read committed, repeatable, serializable, snapshot and RCSI with… | ||
| Disaster Recovery Strategies for SQL Server | Andrew Pruski | 47m |
Covers concrete DR choices: standard backup/restore baseline with offsite copies, log shipping since 2000 for delayed recoveries, and when scale exceeds… | ||
| Managing replication with dbatools | Jess Pomfret | 48m |
dbatools now includes replication commands that use RMO to enable-distributor and enable-publisher, create or remove publications, add/remove articles… | ||
| Unraveling the Web of Relationships: Understanding Graph Data | Mala Mahadevan | 19m |
Covers graph basics from Euler’s 1736 Seven Bridges origin to practical use cases: social recommendations, GPS routing, fraud detection, MDM, and RCA; compares… | ||
| Azure Infrastructure - What Not to Do | John Morehouse | 22m |
Lists concrete failures seen in Azure: leaving anonymous blob access enabled, poorly planned networks causing overlapping IP spaces, and barely any penetration… | ||
| Relational or Non-Relational? Choosing the Best Database for the Task | Bob Pusateri | 19m |
Compares relational vs non-relational with concrete rules: a redirect service is implemented in Azure Cosmos DB using the document model and userId partition… | ||
| Here’s the execution plan … now what? | Hugo Kornelis | 51m |
Hands-on diagnostics for real plans: shows a dashboard proc causing resource semaphore waits where a 47 MB memory grant 47MB → 14MB drops by splitting the… | ||
| Let me show you why data types still matter | CLÁUDIO SILVA | 19m |
Shows concrete bugs and fixes: a float rounding/precision case breaks a ceiling check and turns a cursor-to-set refactor from 2 minutes into 1 second but… | ||
| Soaring to New Heights with Accelerated Database Recovery | John Morehouse | 54m |
Claim: enabling Accelerated Database Recovery (ADR) on SQL Server 2019+ can roll back a 197‑minute transaction in under a second and bring a database online… | ||
| Understanding Alert Fatigue | Owen Murphy | 16m |
Explains why 50–100 alerts per day desensitizes responders and produces missed incidents, slow responses, employee burnout and even failed IT projects… | ||
| Efficiency up, failed releases down; compliant production data for your test and dev environments | Grant Fritchey, Chris Hawkins | 47m |
A real pipeline for usable, compliant test data: classify sensitive columns with Redgate Data Catalog, export a mapping file, apply rules and static masking… | ||
| Should We Defragment Indexes? | Rob Mandeville | 19m |
Argues that defragmenting indexes for external fragmentation can hurt throughput on VM/hypervisor storage that uses an SSD cache fronting capacity devices… | ||
| Building an Open Data Lakehouse using Apache Spark, Apache Iceberg and Dremio | Mike Flower | 45m |
Shows an Open Data Lakehouse built with Apache Spark to create Apache Iceberg tables and Dremio to query and manipulate them in place; demonstrates… | ||
| Stop Indexing the Query | Rob Mandeville | 41m |
Methodology scores queries by an inefficiency score = (logical + physical reads) / rows × execution count, then groups statements by table and ranks them… | ||
| Where should I be encrypting my data | Denny Cherry | 51m |
Compares one-way hashing versus two-way encryption, recommends SHA3 for hashes and AES-256 for data, warns salted encryption breaks indexing and increases… | ||
| What you can do to protect your SQL Server and why it matters | Gethyn Ellis, David Postlethwaite | 21m |
CIS Benchmark for SQL Server (about 103 pages) maps each recommendation to T‑SQL checks and remediation, and emphasizes concrete steps: disable ad hoc… | ||
| What the heck is a checkpoint, and why should I care? | Taiob Ali | 51m |
Explains exactly what a checkpoint writes and why: it flushes dirty pages to disk, records a begin/end checkpoint LSN in the boot page, and relies on write… | ||
| Unveiling the magic of CI/CD for SQL Server using GitHub Actions | SANDER STAD, Kevin Chant | 49m |
Shows a working GitHub Actions CI/CD pipeline that builds a DACPAC from a database project (including the new SDK-style project), runs workflows defined in… | ||
| Unlocking the Power of WhoIsActive | Jeff Iannucci | 20m |
WhoIsActive is shown with exact commands and repo links and the scripts are ready to download for immediate use. Examples use output_column_list (bracket… | ||
| The Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance | Dani Ljepava | 44m |
Mi link creates a distributed availability‑group bridge between SQL Server (2016–2022) and Azure SQL Managed Instance to replicate user databases… | ||
| The Power of Polybase with SQL - True data Virtualisation | Manish Kumar, Haider Raza | 21m |
PolyBase lets SQL Server query remote stores (Oracle, MongoDB, Teradata, another SQL, S3, Azure Blob, ADLS Gen2) using T-SQL without copying data by creating… | ||
| The Most Important Performance Factor in SQL Server and Azure SQL | Guy Glantser | 53m |
Claim: table column statistics drive nearly every optimizer decision and bad stats cause wrong plans. Live demos on a 41 million‑row library show SQL Server… | ||
| The Metadata Driven Data Warehouse | Barney Lawrence, Emma Dolling, Ruth Pearson | 45m |
Shows how to turn SQL Server metadata and DMVs into executable pipelines: uses STRING_AGG and information_schema to auto-generate SELECTs that produce column… | ||
| SQL Server 2022 migrations with dbatools | Jess Pomfret | 20m |
Shows a hands‑on migration to SQL Server 2022 using dbatools with runnable demos and a GitHub devcontainer, proving the process works. Uses backup‑restore with… | ||
| Spell of Transmutation - Using Debezium to Transfer Realtime Data Changes to Event Hub | Alexander Arvidsson | 46m |
Shows how Debezium running in an Azure container reads SQL Server CDC and posts change events into Event Hub (using the Kafka endpoint), then downstreams to… | ||
| Security is not a feature | Robert Hartskeerl | 50m |
Demonstrates Dynamic Data Masking, Row Level Security and Always Encrypted against a Northwind demo: masks a phone column, limits rows so Andrew sees 648 rows… | ||
| Query Store Best Practices | Erin Stellato | 50m |
Explains concrete rules and knobs: Query Store cost depends on SQL version and CU (many fixes backported), default max size 1 GB (recommend 2–4 GB), Azure caps… | ||
| Migrating data solutions to the cloud - a checklist. | Kristina Mishra | 50m |
Step-by-step checklist for migrating databases with concrete actions: run Azure Migrate and the Azure SQL migration extension, use Data Migration Assistant and… | ||
| Managed Instance Link - Seamless migration to Azure | Haider Raza, Manish Kumar | 50m |
Managed Instance Link migrates on‑prem SQL Server (2016, 2019, 2022) to Azure SQL Managed Instance by creating a certificate‑based trust, seeding a full backup… | ||
| Lessons learned from refactoring multi terabyte databases for the last 10 years | Sergey Olontsev | 54m |
Ten years of refactors on SQL Server and other engines hit limits and teach concrete patterns: use IDEs and tests (for example DataGrip finds dynamic‑SQL… | ||
| Keeping historical data in tables forever – mission (im)possible! | Margarita Naumova | 50m |
Tests on SQL Server use a real emergency-incident schema partitioned by incident_date_created and load 3–4 million rows in demo and anticipate 1–20M… | ||
| Hear me out - Don't go offline because of your index deployment strategy | CLÁUDIO SILVA | 20m |
A production table goes slow and CPU spikes after a deployment that drops an index then recreates it offline; the mistake is non-atomic drop/create and table… | ||
| Columnstore Index Compression in a Nutshell | Edward Pollack | 20m |
Columnstore storage breaks data into ~2^20-row rowgroups and compresses each column segment separately, using dictionary encoding, value encoding and… | ||
| Chaos Engineering for SQL Server | Andrew Pruski | 44m |
Shows concrete experiments: use PowerShell and T‑SQL to stop the SQL Server service on a primary VM in Azure and observe availability group behavior; initial… | ||
| Business Continuity for Hybrid and Cloud Native SQL Server Deployments | Allan Hirt | 52m |
Covers concrete designs and gotchas for SQL Server on VMs: always test native backups and plan restores because copying a multi‑terabyte seed can take a week… | ||
| Break five common myths about SQL Server backup | Taiob Ali | 18m |
80 people are interviewed and 70–75% get these wrong; demos show concrete results: a full backup doesn't break log chain so restoring a later log after an… | ||
| Beware of nondeterministic T-SQL code | Itzik Ben-Gan | 51m |
Shows concrete nondeterminism bugs and fixes: pagination with OFFSET/FETCH returns duplicate rows unless ordering is a strict total order (add a unique… | ||
| Banishing Slow Queries with Intelligent Query Processing | John Morehouse | 53m |
Overview of SQL Server features that fix slow queries by changing nothing in app code: engine-side table variable deferred compilation shifts estimate from one… | ||
| Architecting for High Performance SQL Server on Virtual Machines | Anthony Nocentino | 47m |
Checklist of actionable fixes and measurable effects: disable energy saving power plans (one case yields a 30% IO drop), avoid oversizing vCPUs for tier‑1… | ||
| Applying effective Source Control to your Database System | Karim Ourtani | 48m |
Demonstrates using SSDT (Visual Studio) to keep schema in source control, build a dacpac and deploy it through an Azure DevOps pipeline that creates the… | ||
| A Practical Starter Guide to SQL Notebooks | Deborah Melkin | 50m |
Shows how to set up and use Azure Data Studio SQL notebooks: install the Jupyter extension, choose a SQL or PowerShell kernel, and run cells where each cell is… | ||
| Dave & James’ Excellent Database Adventure: From Code Errors to Reliable Releases | James Hemson, David Ong | 20m |
A runnable workflow shows how bad local scripts become reliable releases by enforcing versioning, formatting, testing and docs: code moves from SQL Source… | ||
| nothing matches | ||