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
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’ Secret Admin Panel
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
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…
Javascript Date is One Day Off
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…
Code Comments For MiniMap
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…
jQuery Toggle Firing Twice
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…
Moving FDLAUNCHERLOG in SQL Server
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…
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…