Category: SQL Server
Opinion
Continue Reading
SQL Server – AD Groups vs AD Logins
Let me state my position from the outset: Favoring AD Groups for security in SQL…
SQL Server
Continue Reading
T-SQL Temp Table Check
What’s better than dropping your temp tables at the end of every script? Checking for…
C#
Continue Reading
Script Storage Update
This is an update to a previous post. In another post on this site, it…
Moving FDLAUNCHERLOG in SQL Server
EDIT: I had two scenarios like this. The one written about here worked. The other…
Script Storage
Update here: Script Storage Update Throughout my career, my scripts have been a vital piece…
sp_who2 Alternative (T-SQL, SQL Server)
The trusty “sp_who2” is a quick way to look at what’s happening on your SQL…
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…
Removing SSMS Boost
SSMS Boost is an add-on for SQL Server Management Studio. I used it for quite…
TempDB Reporting Incorrect File Size
So what happens when you run a query to check TempDB file sizes and SQL…