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
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
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
Databases and DevOps, It’s Not Just Me
Anyone who subscribes to my blog or my YouTube channel as well as anyone following me on social media knows...
2018-09-19
309 reads
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
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
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
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
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
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
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
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