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”. <# Not all "name"s include SQL, such as Integration Services, which are called MsDtsServer110 # Therefore use "displayname" when filtering to capture every SQL service # All seem…
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. …