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 …
SQL SERVER – Stop Using DBCC DBREINDEX and Use ALTER INDEX
It has been over a decade since the comment DBCC DBREINDEX has been deprecated, however, once in a while I still encounter them while working with clients on Comprehensive Database Performance Health Check. The other week, while going over the maintena …
Glenn’s Tech Insights For August 25, 2019
(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …
4 Pillars of SQL Server Monitoring
The post 4 Pillars of SQL Server Monitoring appeared first on SQLServerCentral.
Azure Stretch Database, Part I: Getting Going
Whenever you see Microsoft demonstrate any of its nifty new technologies, you would think they are so easy that a lightly-trained hamster could fire them all up in five minutes. It never turns out this way in real life. Microsoft purposefully builds de …
How to Use a CASE Statement in the WHERE Clause? – Interview Question of the Week #239
Question: How to Use a CASE statement in the WHERE Clause?Answer: First of all – CASE is not a statement but rather an expression so the right question should be How to Use a CASE expression in the WHERE Clause? In any case, let us see the answer …
SQL SERVER – Identify Read Heavy Workload or Write Heavy Workload Type by Counters
The other day I had a very interesting experience with one of my client of Comprehensive Database Performance Health Check. It is a standard process of the health check to identify the workload of the server before making the necessary changes. Let us …
Scaling SQL Monitor with your growing estate
The post Scaling SQL Monitor with your growing estate appeared first on SQLServerCentral.
Research Paper Week: Constant Time Recovery in Azure SQL DB
Let’s finish up Research Paper Week with something we’re all going to need to read over the next year or two. I know, it says Azure SQL DB, but you boxed-product folks will be interested in this one too: Constant Time Recovery in Azure …