Here is something that will save you lots of time and headaches when trying to connect to Azure SQL Managed Instances, especially from onprem servers or from …
Troubleshooting
- Home /
- Categories /
- Troubleshooting
For when something is broken and someone is waiting: unresponsive instances, a query that deadlocks with itself, identity values that jump by a thousand, and timeouts on Azure SQL Managed Instance.
With the end of the IE support for Power Bi (and in general tbh), companies are scrambling finally to move their users from the legacy browser to modern ones; …
Ahh, functions, the greatest tool at a programmer’s disposal, they make code reusable and easy to read, they’ve been essential since the first …
Just a quick note, the SQL Diagnostic Book has been updated, here is the changelog: Updated FirstResponder’s Kit and Glen Berry’s Scripts Added SQL …
Even if I use Extended Events almost every day, I always forget the unit of measure of each duration counter, since they’re basically arbitrary; Seconds, …
What it is and how to get it When working with SQL Instances that have lots of databases, sensitive data and equally lots of users/applications that accesses …
It must have happened you at least once to find identity columns with values that from one row to the next one jump by 1000’s rows, of course without …
SQL Server: How to Find a safe restore point (and who messed up) by reading from the Transaction Log
Panic: Someone has messed up and deleted a super important piece of information in a table! Who did it? Nobody knows. When did it happen? “The data was …
Counters and Waitstats are good boys and useful for understanding what’s going on in your SQL instance, but often are pretty useless by themselves if you …
In this previous post I detailed the structure of the objects to be created to create a live report in PowerBI to analyze Perfmon and Filestats data (which in …
Do you remember this post from not long ago? Apparently, other than still being an issue, with the latest SQL Server 2017 CU there are additional tools to see …
Imagine that you’re in a SQL data warehouse in the middle of the night, a single stored procedure is running, is nothing else, and it’s simply doing …
If you work for a big company, you may have a bunch of instances/databases under your control, you ran whatever monitoring tool has been provided and everybody …
The other day I was reading about spinlocks and troubleshooting and it mentioned to get the callstack for a certain xevent and to decode it using the windows …
It’s a late Friday afternoon, this means that somebody is going to tell you that the server is unresponsive, users are blocked and there is a imperative …