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…
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…
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.
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.
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.