Microsoft re-released SQL Server 2022 Cumulative Update 23 (CU23) with fixes, including a security update, and discusses patching strategies.
A comprehensive checklist for securing and ensuring high availability of SQL Server database applications, covering deployment, operations, and resilience.
Updated SQL Server diagnostic queries for January 2026, covering multiple versions and Azure services for performance and configuration analysis.
Explores the new JSON data type and JSON Index in SQL Server 2025, focusing on their compatibility and limitations with Columnstore Indexes and Batch Execution Mode.
A tutorial on building an ASP.NET Core API with Azure Functions, Durable Functions, and SQL Server, using GitHub Copilot to generate the project architecture.
Explores the integration of new Vector data types and Vector Indexes with Columnstore Indexes in SQL Server 2025 for similarity search and RAG.
Overview of official documentation, learning resources, and training materials for Microsoft SQL Server 2025.
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.
