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.
Announcing a 2018 Asia & Australia tour featuring a full-day SQL Server performance analysis workshop in Melbourne and tech talks on Azure SQL and Availability Groups.
Author shares excitement about being selected to speak at PASS Summit 2018 on SQL Server Columnstore index selection.
The author praises Joe Obbish's blog for its original, critical analysis of the SQL Server Query Optimizer, declaring it the Data Platform blog of 2017.
A deep dive into SQL Server Columnstore Index wait types, explaining their groups and providing setup for analysis.
Columnstore Indexes are now available on the Standard Tier of Azure SQL Database, enabling better compression and performance for data warehousing.
Part 3 of a series on deploying Azure Stack on Azure, focusing on installing SQL and MySQL Resource Providers using PowerShell scripts.
Explains how oversized VARCHAR columns in SQL Server can negatively impact query performance by inflating memory grant requests.
Guide to finding the SQL Server 2017 Reporting Services license key from the main installer.
Guide to exiting SINGLE_USER mode in SQL Server by killing connections and switching to MULTI_USER.
Steps to exit SINGLE_USER mode in SQL Server by killing connections and switching back to MULTI_USER.
Analysis of the Meltdown/Spectre processor flaws and their critical impact on SQL Server deployments, security, and performance.
