2023-06-03
SQL Server
2020-09-01
SQL Server – AD Groups vs AD Logins
Let me state my position from the outset: Favoring AD Groups for security in SQL Server...
2019-10-21
T-SQL Temp Table Check
What’s better than dropping your temp tables at the end of every script? Checking for their...
2019-10-17
Script Storage Update
This is an update to a previous post. In another post on this site, it was...
2018-05-16
Moving FDLAUNCHERLOG in SQL Server
EDIT: I had two scenarios like this. The one written about here worked. The other one...
2018-05-02
Script Storage
Update here: Script Storage Update Throughout my career, my scripts have been a vital piece of...
2018-05-01
sp_who2 Alternative (T-SQL, SQL Server)
The trusty "sp_who2" is a quick way to look at what’s happening on your SQL instance,...
2018-04-30
Discover How User Is Accessing SQL Instance (PowerShell and T-SQL)
When your security gets unruly, it can get time consuming to figure out how a user...
2017-06-30
Removing SSMS Boost
SSMS Boost is an add-on for SQL Server Management Studio. I used it for quite some...
2017-01-20
TempDB Reporting Incorrect File Size
So what happens when you run a query to check TempDB file sizes and SQL tells...