SQL Server Virtual Conference 2021
2021-01-29
-- online --
who it's for
database administrators, cloud database engineers, sql developers, devops engineers, database architects, data platform engineers, automation engineers
topics
Azure SQL business continuity; automated backups and retention; Active geo-replication; Azure DevOps pipelines for databases; tSQLt unit tests; Accelerated Database Recovery; in-memory tempdb metadata; Query Store and automatic tuning; memory grant feedback; scalar UDF inlining; dbatools and dbachecks automation; Extended Events workload capture
| title | author | length |
|---|---|---|
| Azure SQL Database Business Continuity During Disaster | Taiob Ali | 46m |
Real procedures and numbers: automated backups give point-in-time: 7→35 days by SKU, long‑term retention can store backups up to 10 years, and built‑in HADR… | ||
| Bringing DevOps to the Database | Steve Jones | 50m |
Claims that databases can be builds tests and releases like app code by putting DDL/DML into Git, running Azure DevOps pipelines for CI, using tSQLt unit tests… | ||
| Performance Improvements in SQL Server 2019 | Frank Gill | 49m |
SQL Server 2019 introduces Accelerated Database Recovery and a persistent version store that cut rollback time dramatically — a 100k-row delete goes from ~31… | ||
| How to use Geospatial Data in SQL Server | Hasan Savran | 44m |
Shows how to store and query spatial types in SQL Server 2016/2017, demonstrating geometry vs geography with SRID choices and why SRID 4326 matters for correct… | ||
| A Rocket Scientist Perspective on Index Column Selection | Mike Byrd | 46m |
Walks through hands-on demos against AdventureWorks2017 big using provided scripts and execution plans to prove index column order matters: a 26 MB… | ||
| SQL Server Configuration with dbatools & dbachecks | Tracy Boggiano | 36m |
Shows how to automate SQL Server configuration using PowerShell with the dbatools module and validate settings with dbachecks to PowerBI. Demonstrates… | ||
| Improving Performance with Intelligent Query Processing | John Morehouse | 44m |
Demonstrates specific toggles and metrics: enable lightweight profiling (trace flag 7412 on 2017 or DB scoped configs on 2019 compat level 150) and see real… | ||
| Modern T SQL for Better Performance | Kathi Kellenberger | 49m |
Shows specific replacements for common slow patterns: use LAG/LEAD window functions instead of self-joins or APPLY to compare adjacent rows (700k rows runs in… | ||
| Performance Features in SQL Server and Azure SQL | Javier Villegas | 49m |
Covers concrete features and demos: Query Store captures plans and execution stats inside the user database so regressions can be identified, a stored… | ||
| Benchmarking in the cloud | Gianluca Sartori | 44m |
Shows how to capture a production workload despite PaaS limits (no traces on local disk) using Extended Events and WorkloadTools to analyze and replay against… | ||
| Data Replication Options for Azure SQL PaaS Services | Mara Steiu | 26m |
Overview of concrete replication options and limits: SQL Data Sync uses DML triggers and a hub-and-member model to provide bi-directional synchronization with… | ||
| Developer Best Practices for Azure SQL : Avoiding common pitfalls when using the Cloud Database | Davide Mauri | 50m |
Covers concrete fixes and demos: implement retry logic and microsoft.data.sqlclient auto-reconnect for transient disconnects, prefer opening connections only… | ||
| SQL Projects for Database Development | Drew Skwiers-Koballa | 45m |
Extension added September 2020 brings Azure Data Studio SQL Database Projects to Windows Mac and Linux and uses the .NET Core SDK to build a dacpac that… | ||
| Executable Troubleshooting Guides with Notebooks for SQL People | Julie Koesmarno, Aaron Nelson | 45m |
Executable troubleshooting guides use Azure Data Studio notebooks to run real diagnostics and capture results: a ready bp_check notebook contains ~30 queries… | ||
| SQL Server Containers | Bob Ward | 46m |
Explains running SQL Server Linux images with Docker and Dockerfile custom images, shows copying a .bak into /var/opt/mssql, restoring inside the container and… | ||
| Understanding Statistics in SQL Server | Erin Stellato | 47m |
Explains how SQL Server uses column and index statistics to drive cardinality estimates, shows DBCC SHOW_STATISTICS output (header, density vector, histogram)… | ||
| SQL Server 2019 Big Data Clusters Architecture | Buck Woody | 43m |
Explains how SQL Server 2019 Big Data Clusters actually run as containerized SQL Server instances and Spark pods on Kubernetes, with a control plane, config… | ||
| Performance Tuning, Getting the Biggest Bang for Your Buck | Monica Rathbun | 43m |
Checklist of concrete fixes and measured wins: set Windows to High Performance power plan (avoids ~30% CPU loss), remove unused SQL services, apply CUs (e.g… | ||
| Using WSL2 for the Database Development Platform | Carlos Lopez | 50m |
Shows how to run Docker on WSL2 with SQL Server Linux containers (2017/2019), mounting persistent volumes and using bash scripts to copy backups, then restore… | ||
| Keynote | Asad Khan | 22m |
Announces concrete results and road map: Azure SQL Edge runs SQL with built‑in time‑series and AI on tiny devices and enables 3M to do predictive maintenance… | ||
| Learn Azure SQL Database through Demos | Anna Hoffman | 43m |
Live demos show Azure SQL deployed from the portal with choices: general purpose, business critical or hyperscale (supports up to 100 terabytes and up to 4… | ||
| How to implement GDPR with SQL Server &Azure SQL Database | Jasmin Azemović | 49m |
Maps five GDPR articles Article 25, 30, 32, 23, 35 to concrete SQL Server and Azure SQL Database controls and shows live configurations: enables Always… | ||
| MS SQL New functions, syntaxes, tips & tricks | Damir Matešić | 48m |
Lists actual new T-SQL features: STRING_SPLIT single-char only (preserves empty fragments, beats XML splitter in tests: ~31ms vs ~60ms and far fewer logical… | ||
| My romantic relation with Powershell generally and DBATools especially | Magnus Ahlkvist | 44m |
Live demo shows using the DBATools module and PowerShell to provision two Docker SQL Server 2019 instances (sql1, sql2), create a dba database, install Ola… | ||
| nothing matches | ||