MOAR sp_DatabaseRestore

Testing…Someone’s gotta do it

people are talking about me again… o_o

However instead of plots to overthrow my kingdom, or curses that would cause me to eat pie and lose weight, or saying my name three times in a mirror so that I become summoned and forced to bust a cap…instead of stuff like THAT…they are props for working on some code!

I made some new changes and fixed an embarrassing bug in my previous contribution for the sp_DatabaseRestore.  In an ideal world I would just skip the part of this post where I point out my mistakes and explain what they were, however Github does a great job at keeping history so…

Continue reading “MOAR sp_DatabaseRestore”

Automated Restore Fun (ARF)

Script it…then walk away…

Over the last a couple of weeks I started reviewing an automated restore solution I had been playing around with for a couple years.  RedGate SQL Backup had thrown some errors and since we couldn’t go without backups while waiting on RedGate support we decided to move ALL backup operations to Ola Hallengren’s scripts.  We also decided to ditch RedGate because they sent us back a list of reported bugs we had submitted and told us they aren’t going to fix it. So in other words “despite the fact that you have multiple licenses of multiple softwares across many servers, we feel your issues as a customer aren’t important to us as a software company.” With that we decided to roll our own solutions that we can customize for our environment…

Continue reading “Automated Restore Fun (ARF)”

Process Count Automation

Script it…then walk away

Reviewing my most recent posts, I realized that I begin my posts with “So…”.

So…, I’d like to try and stop that.

Where have I been since August 11th 2015? Apparently not being active in the SQL community where clearly I wasn’t missed :D. Really though, I ended up taking on quite a bit of side work. When I wasn’t moonlighting or spending time with my family, I devoted whatever free time that I had towards creating music and learning synthesis.

Continue reading “Process Count Automation”

Using sp_whoIsActive with DELL Spotlight on SQL Server

Script it…then walk away…

So…I missed a February post, but to be fair, I had an article published on Simple-Talk.

In an attempt to not miss March (although I’m working on part 2 of that article), I thought I’d throw a little something out there for anyone using Spotlight and sp_whoIsActive
Continue reading “Using sp_whoIsActive with DELL Spotlight on SQL Server”

I’m the O-D-B-c as you can see

The beast hath been slain!!!

So I’ve been working on a project to bring monitoring awesomeness to various SQL servers, without purchasing more RedGate SQL Monitor licenses and hopefully, without purchasing anything at all. Part of this project requires ODBC connections (at least it has in the testing so far), and during the testing I ran into a snag with the ODBC driver so I thought I would throw up a post in case anyone else runs into the same problem.

Continue reading “I’m the O-D-B-c as you can see”

Replay the oplog in MongoDB

“only a braindead can’t find x”

We had what I thought was a completely grueling homework question in M202. One person finished it very quickly and labeled the rest of us “a braindead” for not being able to do so (great encouragement right…and yes that was the grammar he used). The majority of the students seemed to have a problem with it, as I did. To be fair to the assignment, they did throw us a link to the following StackOverflow link. This is probably where those of us who are braindead failed the test.

Continue reading “Replay the oplog in MongoDB”