Explains limitations of ONLINE rebuild for Rowstore indexes on tables with Columnstore Indexes in older SQL Server versions (2016, 2017).
A technical guide on setting up and using a Linked Server in SQL Server to query data from a MySQL database.
Announcement of a pre-conference workshop on SQL Server Columnstore Indexes at SQLSaturday Cincinnati, covering versions, batch mode, and Azure Synapse features.
Overview of new Database Scoped Configurations in SQL Server 2019, including VERBOSE_TRUNCATION_WARNINGS and LAST_QUERY_PLAN_STATS.
Announcing a SQLBits 2020 workshop on migrating, optimizing, and running SQL Server workloads on Azure Virtual Machines.
Announcement for a full-day workshop on SQL Server Columnstore Indexes at SQLSaturday Vienna 2020, covering practical techniques across multiple versions.
A technical tutorial on streaming data from SQL Server to Snowflake using Kafka and Kafka Connect with Debezium for CDC.
Analyzes the current state and future of SQL Server's In-Memory OLTP technology, highlighting new features in SQL Server 2019 and persistent limitations.
Explores SQL Server's Memory-Optimized TempDB Metadata feature, which reduces contention by moving system tables into memory, with a performance test demonstration.
Explains SQL Server 2019's new support for creating database snapshots that include in-memory (Hekaton) filegroups, a previously unsupported feature.
Explains the new Resumable TDE Scan feature in SQL Server 2019 and Azure SQL Database, detailing its commands and benefits for system availability.
Summary of key new features in SQL Server 2019 Standard Edition, including Transparent Data Encryption (TDE) and performance enhancements.
Explores compatibility of Columnstore Indexes with new features in SQL Server 2019, including Approximate Distinct Count and Scalar UDF Inlining.
Explores the preview feature of ordered Clustered Columnstore Indexes in Azure SQL Data Warehouse, testing syntax and performance benefits.
Explains Accelerated Database Recovery (ADR) in SQL Server 2019/Azure SQL, a feature designed to drastically reduce transaction rollback and database recovery times.
Announcing a SQLSaturday Lisbon 2019 workshop on deploying and managing SQL Server on Kubernetes, covering containers, orchestration, and high availability.
Performance analysis of SQL Server 2019's Batch Execution Mode on TPC-H queries using rowstore indexes and compressed data.
Explains Closeness Centrality, a key graph analysis metric, and demonstrates its calculation using SQL Server 2019's graph database features.
Explores the new Shortest Path algorithm support in SQL Server 2019's Graph Engine, a key feature for graph database functionality.
Overview of the new Learning Pathways concept at PASS Summit 2019, featuring structured educational tracks on AI, cloud, SQL performance, and Azure data engineering.
