Announcing the 5th Edition of SQL Server 2017 Query Performance Tuning
I am quite excited to announce that the latest, most up to date, and by far the largest, copy of...
2018-09-18
328 reads
The Scary DBA
Query Store and Log Backups
A question that came up recently around Query Store is what happens when there are log backups in use on...
2018-09-17
220 reads
3rd Edition, SQL Server Execution Plans, a Story
Four years ago, after a bunch of dithering and some negotiations with Tony Davis, my editor, I started to update...
2018-09-21 (first published: 2018-09-12)
1,892 reads
Estimated Plans and Forced Plans from Query Store
While all plans are estimated plans, there is still a difference between capturing an estimated plan and looking at a...
2018-09-20 (first published: 2018-09-10)
1,764 reads
Back to University, Redgate University
Let’s be really clear, Redgate makes ingeniously simple tools. That’s a fact. Nothing has changed. However, if you really want...
2018-09-03
281 reads
Why I Love Extended Events, Reason 394: Customize Live Data
There are so many reasons to love Extended Events that it can really be overwhelming, but, one more reason that...
2018-08-27
359 reads
SQL in the City Summit
This fall, in October, Redgate Software will be hosting three, live, in-person events. These events will take place in New...
2018-09-03 (first published: 2018-08-21)
1,465 reads
Actual Execution Plan Costs
Why don’t “actual execution plans” have “actual execution plan costs”? This is a question and a myth I have to...
2018-08-20
306 reads
Rant: There Is No NoSQL Data Storage Engine
Do I need relational or NoSQL? How does NoSQL help me scale? Will I get paid better with NoSQL or...
2018-09-07 (first published: 2018-08-15)
2,862 reads
Measuring Query Execution Time: What Is Most Accurate
Probably the single most important factor when deciding which query to tune, or actively tuning a query, is how you...
2018-08-28 (first published: 2018-08-13)
2,720 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
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...
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