SQL SERVER – Limitation of ENABLE_PARALLEL_PLAN_PREFERENCE Hint
Earlier this week, I had written a blog post about SQL SERVER – Using Query Hint ENABLE_PARALLEL_PLAN_PREFERENCE and I received quite a few interesting emails. One of the emails was about the Limitation of ENABLE_PARALLEL_PLAN_PREFERENCE Hint. Le …
SQL in the City Streamed- the birthday edition
The post SQL in the City Streamed- the birthday edition appeared first on SQLServerCentral.
Key Rotation in TDE
Transparent Data Encryption (TDE) has been around for a long time. It first appeared in SQL Server 2008, and after a rocky start with some bugs, it has become a regularly used feature for many organizations. While not perfect, it does provide some prot …
DBA Training Plan 14: POP QUIZ!
AH-HA! You didn’t know there would be one of these, did you, hotshot? You’ve been reading along in the series, just smiling and nodding, pretending you’re keeping up, but not really doing the homework. BUSTED! Put your books away and …
SQLskills at 24 Hours of PASS: Summit Preview 2019
On September 10, 2019, SQLskills will have three slots in the free 24 Hours of PASS: Summit Preview 2019 event. I’ll be leading off with “Dr. DMV’s Troubleshooting Toolkit” at 12:00 UTC. Erin Stellato will present “Why You …
SQL SERVER – Security Risk of Public Role – Very Little
I like to do consulting for SQL Server Performance Tuning area because that is my favorite thing to do and I spend over 16 hours a day tuning my system. However, once in a while, during the Comprehensive Database Performance Health Check, I do receive …
Proactively monitor your SQL Server estate with SQL Monitor 9
The post Proactively monitor your SQL Server estate with SQL Monitor 9 appeared first on SQLServerCentral.
SQL Server Database Activity Based on Transaction Log Backup Size
The post SQL Server Database Activity Based on Transaction Log Backup Size appeared first on SQLServerCentral.
Updated First Responder Kit and Consultant Toolkit for August 2019
sp_DatabaseRestore can now restore to Azure blobs and change the database owner after a restore, and everything else gets bug fixes. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit …
SQL SERVER – Using Query Hint ENABLE_PARALLEL_PLAN_PREFERENCE
I am not a big fan of using SQL Server query hints. The matter of facts, during the Comprehensive Database Performance Health Check, I always advise against using any query hints at all. Trust me there are so many different options you should experimen …
Graphical Tools for Accessing Azure Cosmos DB
The post Graphical Tools for Accessing Azure Cosmos DB appeared first on SQLServerCentral.
Fast and Reliable Development with Redgate Solutions for SQL Server
The post Fast and Reliable Development with Redgate Solutions for SQL Server appeared first on SQLServerCentral.
A Self-Tuning Fill Factor Technique for SQL Server – Part 2
Introduction Fill Factor is a parameter most of us have ignored because there is no definitive way to calculate what the correct value should be. Part 1 of this series describes a new technique to dynamically determine index fill factors for all indexe …
SQLintersection Fall 2019
As we head towards our SQLintersection Fall 2019 in November (our 14th show), I’m excited to say that it’s once again our most diverse, complete, and information-packed show yet! One of the pieces of feedback we hear over and over is t …
DBA Training Plan 13: Why Do Cached Plans Go Bad?
It’s a little bit of a trick question: what could make a good query plan turn bad? In the last episode, we used sp_BlitzCache to spot the most resource-intensive, longest-running query plans in your server’s cache. Go run those queries agai …