SQL Server – AD Groups vs AD Logins

September 1, 2020 benf101 0

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

October 18, 2019 benf101 0

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 give much of an option for formatting the output to […]

background-code-coder-177598

Script Storage Update

October 17, 2019 benf101 1

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 known as: devops.azure.com. The benefits are numerous. Ability to revert […]

No Image

Script Storage

May 2, 2018 benf101 0

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 from where I work, and that looks good with color-coding. Additionally, […]

agenda-black-calendar-273011

PowerShell With Uptime – Getting Days Only

December 16, 2017 benf101 0

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 give much of an option for formatting the output to […]

mmc_2016-08-04_11-35-28

PowerShell – Update All SQL Services To Restart On Failure

August 4, 2016 benf101 0

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 Unicode characters. Learn more about bidirectional Unicode characters Show hidden […]