5 T-SQL features that should already exist (2026 SQL Server wish list)
2026 T-SQL wish list covering native Parquet imports, arrays, OVERLAPS, simpler licensing, and cloud storage
2026-07-27
Articles
SQL Agent Job Automated Change Capture Process
Build a process that captures your SQL Agent job history and changes across time.
2026-07-24
1,744 reads
SQL Server Data Warehouse Concepts, Schema Design, and Implementation
A Data Warehouse acts as a centralized repository, is subject oriented, time variant and non-volatile repository. This article covers some concepts that will help you better design these structures.
2026-07-24
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
A real world story of how someone moved from Enterprise Edition to Standard for not only the SQL Server database engine, but also with SSRS, SSIS, and SSAS.
2026-07-22
3,568 reads
Exposing a SQL injection vulnerability you’ve never heard of
This article documents a SQL injection vulnerability I discovered in sys.sp_dbmmonitorupdate, a Microsoft-signed system stored procedure. For other SQL Server security vulnerabilities I’ve discovered, see the full series here.
2026-07-22
Connect an Azure Function to Azure SQL database Using a Managed Identity
In this article, you’ll learn step-by-step setup, Python code implementation, troubleshooting, and best practices to ensure your solution is secure and scalable.
2026-07-20
1,667 reads
Pros and Cons of Database Sharding for Performance and Maintenance
Large databases usually have a negative impact on maintenance time, scalability and query performance. For maintenance, these large single databases have to be backed up daily while the amount of actual changing data might be small. For performance, tables without correct indexes result in full table or clustered index scans. As the data grows the total query time increase linearly. How can we decrease downtime for the maintenance window for large databases and optimize the performance of daily queries?
2026-07-20
Implicit Conversions Cripple SQL Server
Learn about implicit conversions, which can dramatically affect the performance of your workload.
2026-07-17
3,536 reads
Vector search in SQL Server: VECTOR_DISTANCE, VECTOR_SEARCH, and index trade-offs
Learn how to use VECTOR_DISTANCE and VECTOR_SEARCH in SQL Server to find semantically similar data.
2026-07-17
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Learn about using classification as a technique to prepare your data for additional machine learning analysis.
2026-07-15
1,027 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers