Opinion SQL Server – AD Groups vs AD Logins Writer #1, 2020-09-01 Let me state my position from the outset: Favoring AD Groups for security in SQL… Continue Reading
Moving FDLAUNCHERLOG in SQL Server Writer #1, 2018-05-16 EDIT: I had two scenarios like this. The one written about here worked. The other… Continue Reading
sp_who2 Alternative (T-SQL, SQL Server) Writer #1, 2018-05-012024-03-10 The trusty "sp_who2" is a quick way to look at what’s happening on your SQL… Continue Reading
Discover How User Is Accessing SQL Instance (PowerShell and T-SQL) Writer #1, 2018-04-302023-06-23 When your security gets unruly, it can get time consuming to figure out how a… Continue Reading
Removing SSMS Boost Writer #1, 2017-06-30 SSMS Boost is an add-on for SQL Server Management Studio. I used it for quite… Continue Reading
TempDB Reporting Incorrect File Size Writer #1, 2017-01-202024-06-13 So what happens when you run a query to check TempDB file sizes and SQL… Continue Reading
SQL Server – Disabled User Account Overrides AD Group Authorization! Writer #1, 2016-12-28 Just a quick note on a scenario I ran into, and what I did to… Continue Reading
SQL Server – Timestamp Column Writer #1, 2016-05-02 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. Continue Reading
Restore All Databases With Most Recent Backup Writer #1, 2016-04-14 This is a bit of a scary task. Someone tells you about 87 databases that… Continue Reading
SQL Server – Database Stuck In Single User Mode Writer #1, 2016-03-29 If you've painted yourself into the single_user corner, here is how you can get out. Continue Reading