Perspective can trick the brain into believing the eyes are seeing something they are not. My two monitors are slightly staggered. The right one is further back, only by a couple inches or so, but it causes the corner on the bottom to appear higher on the one further away, and lower on the top… Read More »
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 »
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 »
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 »
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 »
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 »
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 »
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: