Category Archives: Technology
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… Read More »
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… Read More »
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… Read More »
Discover How User Is Accessing SQL Instance (PowerShell and T-SQL)
When your security gets unruly, it can get time consuming to figure out how a user is accessing a SQL instance. Sometimes you may know that a user is getting access via one certain AD group but you aren’t sure if any other groups are granting access. Furthermore, a user might be in a group… Read More »
MySQL – Move Data Files To New Location (Windows)
After setting up MySQL, I realized that I put my data files on the C drive. Since I don't want database growth to end up taking down the entire OS, I had to move them. My struggles consumed a couple of hours, so I wanted to clear up and document the process. Default Database Files MySQL… Read More »
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… Read More »
Hurricanes Irma, Jose, and Maria, Might Be Military Attacks
The world is crazier than you may realize. Man-made Climate Change has nothing to do with coal mining and your car’s exhaust pipe. It has to do with militaries using the weather as a weapon against other countries. Yes, I’m serious.
YouTube Error Because of Free Trial of Google Play Music
Android – Wi-Fi Battery Usage When Wi-Fi is Disabled
How could it be? Wi-Fi is showing up as consuming 10% of your Android battery when wifi is turned off! What gives? Android is sneaky, that’s what. The Wi-Fi setting is more like a “use Wi-Fi for internet” setting. In other words, your selection of that setting has nothing to do with the phone actually stopping the use… Read More »