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...
sql server
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-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...
2016-12-28
SQL Server – Disabled User Account Overrides AD Group Authorization!
Just a quick note on a scenario I ran into, and what I did to fix...
2016-05-02
SQL Server – Timestamp Column
While this seems like a simple thing to do, I recently discovered so many ways not to do it (also known as failing) that I just had to document this one.
2016-04-14
Restore All Databases With Most Recent Backup
This is a bit of a scary task. Someone tells you about 87 databases that all...
2016-03-29
SQL Server – Database Stuck In Single User Mode
If you've painted yourself into the single_user corner, here is how you can get out.