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
SQL Server T-SQL Temp Table Check Writer #1, 2019-10-212024-07-05 What’s better than dropping your temp tables at the end of every script? Checking for… Continue Reading
C# Script Storage Update Writer #1, 2019-10-17 This is an update to a previous post. In another post on this site, it… 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
Script Storage Writer #1, 2018-05-02 Update here: Script Storage Update Throughout my career, my scripts have been a vital piece… 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