Announcing a workshop on optimizing ETL processes for SQL Server and Azure SQL at the SQLBits 2019 conference.
Analyzes if Batch Mode on Rowstore eliminates the need for Columnstore Indexes in SQL Server, comparing performance and compression.
Explains the security risks of the SQL Server 'Trustworthy' database setting and how it can lead to sysadmin privilege escalation.
Explores the new Edge Constraints feature in SQL Server 2019 and Azure SQL Database for enforcing data quality and directionality in graph database schemas.
Analysis of a SQL Server blocking scenario where a failed update with missing permissions blocks an index rebuild, exploring lock incompatibility.
Author's schedule and session highlights for the PASS Summit 2018, a major Microsoft Data Platform conference.
Explores limitations of Batch Execution Mode on Rowstore Indexes in SQL Server, including heuristics and missing operators.
Explores the heuristics and conditions under which SQL Server's Query Optimizer decides to use Batch Mode execution for query processing.
Explores SQL Server 2019's new Batch Execution Mode for Rowstore indexes, covering basics, enabling it, and analyzing performance.
SQL LocalDB Wrapper v2 released, a .NET library for programmatically managing SQL Server LocalDB instances, now with .NET Core support.
Explores SQL Server 2019's improved DBCC CLONEDATABASE command for automatically extracting Columnstore Index statistics into a cloned database.
Resolving Flyway migration errors in SQL Server due to non-empty schemas and leftover global assemblies.
Explores Microsoft's new Columnstore compression estimation in SQL Server 2019, comparing it to a custom system stored procedure.
Announcing a full-day SQL workshop on optimizing data warehouses using Columnstore Indexes, from basics to advanced tuning, at SQLSaturday Madrid 2018.
A guide to configuring Entity Framework Core for performance and reliability, covering retries, warnings, logging, and query tracking.
A personal reflection on the author's 5-year journey writing a blog series about SQL Server Columnstore Indexes, from initial posts to becoming an expert.
Explores Microsoft's Resumable Online Index Creation feature in Azure SQL DB, detailing its benefits for managing large databases without downtime.
Announcing four in-depth tech workshops on SQL Server, Git/GitHub, Cassandra, and Microsoft Azure at the Tuga IT 2018 Summer Edition conference.
Introduces a custom stored procedure for estimating compression savings for SQL Server Columnstore Indexes, filling a gap in native tooling.
Explores the new online rebuild feature for Clustered Columnstore Indexes in SQL Server, detailing its significance and testing methodology.
