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...
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,...
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...
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...
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...
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...
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.
While enjoying my free month of Google Play music, I tried to play something on YouTube, which has now become “YouTube Red” because of my free music trial. The song played for three seconds and then I get this:
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...