Let me state my position from the outset: Favoring AD Groups for security in SQL Server over individual AD Logins is a mistake. I don’t care what the “best [...]

There is a handy and free tool to check your system’s uptime called “Uptime”.  (Clever, no?)  It can be downloaded at http://uptimeexe.codeplex.com. [...]

This is an update to a previous post. In another post on this site, it was said that Dropbox Paper is the code storage of choice. This has changed. As of today, I much prefer [...]

Update here: Script Storage Update Throughout my career, my scripts have been a vital piece of my work. Where I store them has changed over the years. The challenge has been [...]

When your security gets unruly, it can get time consuming to figure out how a user is accessing a SQL instance. Sometimes you may know that a user is getting access via one [...]

There is a handy and free tool to check your system's uptime called "Uptime".  (Clever, no?)  It can be downloaded at [...]

[...]

PowerShell script to quickly change all Recovery Options to “Restart the Service”. <# Not all "name"s include SQL, such as Integration Services, [...]

Creating and writing to output file in PowerShell. [...]

This is a PowerShell script that puts out the XML required to update your Red Gate MultiScript servers.  Manually entering the SQL instances from within the application [...]