SQL SERVER – Error: 45207 – SQL Server Managed Backup to Microsoft Azure Cannot Configure the Database Because a Container URL was Either not Provided or Invalid
While using SQL Server on Virtual Machines in Azure, I ran into an interesting error. In this blog we would learn how to fix Msg 45207 – SQL Server Managed Backup to Microsoft Azure cannot configure the database ‘sqlauthdb’ beca …
We Need to Talk About the Warnings In Your Query Plans.
SQL Server, thanks for coming today. Have a seat. Yes, this might seem odd – there are a lot of us here. And yes, we are locking the door behind you. We all care about you – all of us care very deeply – but we need to talk about some …
SQL SERVER – SQL Server Configuration Manager Error: 0x80010108 – The Object Invoked Has Disconnected From its Clients
While writing my previous blogs about SQL Server Configuration Manager, I encountered another error. In this blog, we would learn one of the possible causes of error 0x80010108 – The object invoked has disconnected from its clients. Here is the s …
First Responder Kit Release: Fingers Crossed!
This is a small release just to make sure you don’t forget about us. We know you’re busy. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements#1755 – @MisterZeus added a new check for aler …
Unused Indexes – Are they really unused or have they just not been used YET?
During our Critical Care® sessions with clients, we often see unused indexes (reads=0) with high writes. Sometimes these unused indexes have very high writes. If an index is never being used to help with performance but SQL Server is having to main …
Modern Data Warehouse Design Pattern – Part II
Join Anoop Kumar as he discusses two modern design patterns to handle Advanced Analytics on big data, and Real time analytics.
Who’s Using the DAC?
Learn how you can determine which connection is using the Dedicated Administrator Connection.
Free 1 Hour Consulting – PASS Pre-Con 2018 – 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs
Today, I am going to talk about my the most anticipated pre-conference 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs scheduled at PASS Summit 2018. This session is going to be amazing fun and very unique. It is a ful …
Adaptive Query Processing in SQL Server 2017
SQL Server 2017 now offers adaptive query processing, a new set of features aimed at improving query performance. Adaptive query processing addresses issues related to cardinality estimates in execution plans, leading to better memory allocation, join …
The New Lightweight Query Plan Profile Hint
Recent Updates To SQL Server 2016 and 2017 introduced a new USE HINT that lets you direct an actual execution plan to a new Extended Event, called query_plan_profile. The hint by itself doesn’t do anything, and the XE by itself doesn …
Compress and Decompress in SQL Server 2016
Explore using Compress/Decompress with varying types of data and examine size/storage usage
Exhuming the GDPR Bodies
Since the GDPR has gone into effect, the focus has often been on databases. There are many other ways that personally identifiable data may be stored by an organization. In this article, David Poole shows how to use Bash and PowerShell to locate that d …
Using undocumented DBCC WRITEPAGE to instigate SQL Server database corruption
In this tip we look at the undocumented command DBCC WRITEPAGE to corrupt a SQL Server database and then use the command to undo the corruption. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony D …
SQL SERVER – Unable to Launch SQL Server Configuration Manager. Error: Cannot Connect to WMI Provider. [0x80070422]
While playing with my virtual machine, I encountered an interesting error. In this blog we would learn how to fix error cannot connect to WMI provider [0x80070422] while launching SQL Server Configuration Manager. As I have been writing in my earlier b …
How to STOP the Usage of SELECT * For Views? – Interview Question of the Week #193
Question: How to STOP the Usage of SELECT * For Views? Answer: Last week was a very interesting week, during the recent Comprehensive Database Performance Health Check, we identified a query which was running very slow for our customer. After …