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 practice” is. It’s a headache with no discernible advantage.
PowerShell With Uptime – Getting Days Only
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. While it is very easy to use (just navigate to it in a command window and type “uptime”), it doesn’t…
Script Storage Update
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 using Microsoft’s GIT code repository…
Script Storage
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 in finding a repository that is reliable, searchable, accessible…
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 is accessing a SQL instance. Sometimes you may know that a user is getting access via one certain AD group but you aren’t sure…
PowerShell With Uptime – Getting Days Only
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. While it is very easy to use (just navigate to it in a command window and type "uptime"), it doesn't…
PowerShell – Update All SQL Services To Restart On Failure
PowerShell script to quickly change all Recovery Options to “Restart the Service”. This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden…
PowerShell – Create And Write Out To Log File
Creating and writing to output file in PowerShell. https://gist.github.com/benf101/379e8040393a24771af81360ee0111ab
Generate Red Gate MultiScript .dat File
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 can be a daunting task if you have a large number to do. …