There are some controversial beliefs that I hold, of which I am solidly in the minority. Perhaps, less than 10% of the population would agree with me on certain beliefs. Thanks to the wonders of the internet, I am able to find like minds who espouse to some of my weird beliefs and they give… Read More »
This is a photograph of where most Christians think hell is. This is the legendary valley of Hinnom, more recently called Gehenna.
Just in fun. I like Linux, for the most part.
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 »