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.

T-SQL Temp Table Check

October 21, 2019 benf101 0

What’s better than dropping your temp tables at the end of every script? Checking for their existence at the beginning of the script and dropping them.

wordpress blog pic

WordPress’ Secret Admin Panel

October 19, 2019 benf101 0

As I was attempting to update my email address in a WordPress blog, it was stuck. A notification said: There is a pending change of the admin email to xoxoxo@xoxoxo.com

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 […]

bright-codes-coding-614117

Javascript Date is One Day Off

May 14, 2019 benf101 0

In JavaScript, dates are based on the UTC time, the starting timezone which all others are based on. You may have a date in JavaScript that should be one particular date but for some reason changes itself to the previous day. The way to fix it is to add the […]

Code Comments For MiniMap

December 4, 2018 benf101 0

There is a great way to mark sections of your code with a highly visible indicator that requires less effort to identify. It’s preference, for sure. I would imagine that certain people might find this a gaudy way to comment their code, while others would appreciate the practicality of it […]

burning-chili-chilli-peppers-70842

jQuery Toggle Firing Twice

November 13, 2018 benf101 0

When trying to toggle an element on a page using jQuery, you might have the toggle happen multiple times. In other words, you click the event listening element (such as a link) and the element you want to toggle expands and collapses, then once more expands and collapses. Obviously, this […]

No Image

Moving FDLAUNCHERLOG in SQL Server

May 16, 2018 benf101 0

EDIT: I had two scenarios like this. The one written about here worked. The other one failed. The actual solution came from sql-ution.com. The solution is to fix the registry with the new value. And just in case his website comes offline before mine does, I'll post the code: Since […]