sp_who2 Alternative (T-SQL, SQL Server)

May 1, 2018 | 0 Comments

The trusty “sp_who2” is a quick way to look at what’s happening on your SQL instance, but completely lacks the ability to filter using a WHERE clause. You [...]

Removing SSMS Boost

June 30, 2017 | 0 Comments

SSMS Boost is an add-on for SQL Server Management Studio.  I used it for quite some time but I got tired of using it as freeware.  The reason SSMSBoost as freeware [...]

TempDB Reporting Incorrect File Size

January 20, 2017 | 0 Comments

So what happens when you run a query to check TempDB file sizes and SQL tells you that each file is 101 MB, but when you look in the file system, they're actually a 45 GB [...]

TSQL – Make Excel Link In Output

August 4, 2016 | 0 Comments

Here is a situation I just came across (boiled down and simplified).  An end user was having to manually find a user id, navigate to an image folder, and [...]
1 2 3 4 11