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.
Category: Programming
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 include only the days. So, a […]
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 back to previous versions Ability […]
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 timezone offset to the date. […]
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 – because, boy, is 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 is not the effect we […]
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 I'm nostalgic for my wasted […]
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 from where I work, and that looks good with color-coding. Additionally, I don’t want to pay […]
sp_who2 Alternative (T-SQL, SQL Server)
The trusty “sp_who2” is a quick way to look at what’s happening on your SQL instance, but completely lacks the ability to filter using a WHERE clause. You may have to manually sift through hundreds of results to find what you need. Never fear. This quick script gives you the same basic output that sp_who2 […]