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.
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers