Why Can't I Shrink TempDB?

I know, I know....#OMGShrinkingIsBadDontEverDoThatOrElseEtcEtcEtc

We all know that there are simply times you have to shrink some files.  There are risks...

Finding Application Session Settings

One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous inside of SSMS, but run miserably inside the application.
Related...

Finding Application Session Settings

One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous...

Happy 2019!

As I’m writing this it’s actually still 2018, so this is both my last blog post of the year and the first blog post of the new year ??...

The most-read posts in 2018

Good morning #sqlfamily folks! The very first post in the new year 2019. Tell me: when this time passed??? The...

An error occurred while writing an audit trace. SQL Server is shutting down

There was this incident at one of the clients in recent past. It was a nice morning. I was enjoying the tea of the day. I just started my...

Using Microsoft Learn

I’ve just signed up on Microsoft’s new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows...

Happy New Year, Here are our Most Popular Posts of 2018

Firstly, all of us at SQL Undercover would like to wish you a very Happy New Year and all the...

Finding Installed Event Sessions

Get off that arctic island and warm up with a little XE fun. This script is quite simple but will show you what you may have out there on...

Finding Installed Event Sessions

As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying...