Making The Query Plan Profile Hint More Useful
Way Back When I blogged about the new USE HINT that logs query plans that use it to a new XE session. The use hint and session both share the same name — query_plan_profile. There are currently some rather unfortunate limitations to the even …
In-Memory OLTP Table Checkpoint Processes Performance Comparison
The article demonstrates one of the major performance enhancements in checkpoint processes in « in memory tables »
SQL SERVER – SSIS – Package Error: “ODBC Source” Failed Validation and Returned Validation Status “VS_NEEDSNEWMETADATA”
As a part of my consulting, I see many clients who use SSIS. In this blog we would learn how to fix error “ODBC Source” failed validation and returned validation status “VS_NEEDSNEWMETADATA”. My client was using SSIS to transfor …
SQL Server Management Studio 18’s Execution Plans Will Change The Way You Look At Plan Tuning
The preview of the next version of SQL Server Management Studio is out, and it has a radical improvement to query plans that will shock and amaze you. It’s best to just show you: Estimated vs actual rows You can see the estimated and actual numbe …
Insert missing SQL Server IDENTITY column values using SET IDENTITY_INSERT command
In this tip we look at how to insert missing values for an identity column using the SET IDENTITY_INSERT command.
Introducing SQL Server SSRS in Windows Containers
Learn how to deploy Reporting Services into a container with Windocks.
Using Azure Storage Explorer
Azure Storage can store many types of data, from NoSQL tables to VHDs. In this article, Supriya Pande explains how to work with Azure Storage Explorer, a tool that makes it easy to manage storage in Azure. She also provides an example of using the Azur …
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 …