Adaptive Query Processing – Batch Mode Adaptive Join
Let's explore how SQL Server 2017 automatically adapts between nested loop and hash join operators
Effectiveness
Today Steve Jones notes that your software should handle the load and work, but it needs to get done as well.
Azure DWH part 24: Elastic queries
This article will explain what is an elastic query and show an example.
Automatic Database Seeding
Set up and use the automatic databases seeding feature for Availability Groups.
Innovation Needs Information
We need data to innovate more. Steve Jones reminds us this means opportunity for many of us.
It's an Exciting Time
I read a lot of history (as you no doubt notice from my other editorials). I’m currently reading an excellent book on the air war in World War One, Marked for Death: The First War in the Air. One of the fascinating aspects of the war is just how fast the technology shifted. At the […]
Formatted ASCII Results from a SELECT
Generate aligned output from SELECT statement for code comments using a simple stored procedure.
The GDPR Sky is Falling
GDPR is coming and many are concerned. Steve Jones has a few thoughts today.
Customize Software or Process
The build v buy decision isn't the final one. We also need to decide if we'll use software as is or customize it.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
We Are Eating Our Own Seed Corn
Comments posted to this topic are about the item We Are Eating Our Own...
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers