Running Entire Folder of Scripts With PowerShell
Handy time-saving PowerShell script to run a batch of scripts easily.
Programming
SQL Server – AD Groups vs AD Logins
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 give much of an option for formatting the output to […]
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 known as: devops.azure.com. The benefits are numerous. Ability to revert […]
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 day. The way to fix it is to add the […]
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 their code, while others would appreciate the practicality of it […]
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 and collapses, then once more expands and collapses. Obviously, this […]
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 comes offline before mine does, I'll post the code: Since […]