Part 2 of a tutorial on setting up Change Event Streaming in SQL Server 2025, focusing on Azure Event Hub configuration and database setup.
Explores SQL Server 2025's Change Event Streaming (CES), a feature for real-time data change streaming to Azure Event Hubs.
Explains the new Optimized Locking feature in SQL Server 2025, detailing how it reduces lock memory and improves concurrency.
Explores the new ABORT_QUERY_EXECUTION query hint in SQL Server 2025 for blocking problematic queries via Query Store.
A technical checklist for database application vendors to ensure SQL Server security, high availability, and best practices in deployment and operations.
Explains the Optional Parameter Plan Optimization (OPPO) feature in SQL Server 2025, part of Intelligent Query Processing to mitigate parameter sniffing issues.
Analyzes the lack of data replication support for Clustered Columnstore Indexes in SQL Server, covering features from 2012 to 2025.
Analyzes the pros and cons of renaming the built-in SQL Server 'sa' account as a security measure against brute-force attacks.
A technical analysis of missing features and wishlist for SQL Server Columnstore Indexes as of 2026, focusing on performance and functionality gaps.
Fixing a misleading Azure AD group permission error during DACPAC deployment in Azure DevOps, related to schema creation.
A data professional shares her schedule and projects for PASS Data Community Summit, including keynotes, sessions, and a fun AI-powered PowerShell script.
Updated SQL Server diagnostic queries for November 2025, including new columns and query hints for performance analysis.
EF Core 10.0 introduces partial updates for JSON columns using ExecuteUpdate/ExecuteUpdateAsync, with examples for SQL Server.
Provides slides and scripts for the 'Indexing for Dummies' presentation from the dataMinds Connect 2025 tech conference.
Explores advanced techniques attackers use to bypass SQL Server data access auditing and provides mitigation strategies to close security gaps.
Updated T-SQL diagnostic queries for SQL Server (2005-2025) and Azure SQL to analyze instance configuration and performance.
EF Core 10.0 adds support for the new JSON data type in Microsoft SQL Server 2025, enabling querying and storage of JSON documents.
Provides slides and SQL scripts from a 'Indexing for Dummies' session, focusing on SQL Server database performance.
Updated T-SQL diagnostic queries for SQL Server (2005-2025) and Azure SQL to analyze instance configuration and performance.
A security researcher details a SQL Server auditing bug that allows low-privilege users to exfiltrate sensitive data without detection.
