A technical guide exploring workarounds to update SQL Server statistics on secondary replicas in Availability Groups, including scripts and methods.
Covers best practices for migrating Microsoft SQL Server databases to AWS, including hybrid architecture and migration methods like AWS DMS.
Explains the index INCLUDE clause in SQL databases, covering its purpose, how it works with B-tree indexes, and when to use it for performance.
A guide to running ASP.NET Core integration tests with SQL Server in Docker containers within Azure Pipelines, solving container readiness issues.
Explores a new feature in SQL Server 2019's SET STATISTICS IO output, revealing detailed I/O metrics for INSERT operations into target tables.
A proposal for a new "Optimize for Analytics" database configuration option in SQL Server and Azure SQL Database to enhance performance for data warehousing workloads.
A detailed overview of the new Database Scoped Configuration options introduced for SQL Server and Azure SQL Database in 2018, leading into 2019.
Explores MERGE DML statement support for Graph tables in SQL Server and Azure SQL Database, focusing on UPSERT operations for node and edge tables.
Author offers 12 free hours of expert consultation on Columnstore Indexes and Batch Execution Mode in SQL Server throughout 2019.
Explores new SQL Server 2019 & Azure SQL Database preview features for derived tables and views in Graph databases, focusing on heterogeneous nodes and edges.
A guide to managing database changes in .NET using Database Projects for state versioning and DbUp for migration scripting.
Announcing a new YouTube channel focused on SQL Server Columnstore Indexes and Batch Execution Mode, featuring technical videos and interviews.
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.
