The Great Conjunction

just me baby…

I’ve spent a lot of time over the past few years blogging and trying to keep up on different platforms, across what could be seen as multiple identities.  One was for public consumption which included employers, another for music, another for amusement, etc., etc.

Aside from it being a huge PITA to keep content updated and active across so many places, it also started to seem like less of me, and just little compartmentalized tidbits that never really represented who I am.  Everything started to feel impersonal.  I can’t really explain it, but the Database Engineer was starting to feel like a completely different person from the Artist, the Husband, the Father, the…Tim.

Continue reading

Automated Restore Fun (ARF)

script it…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

Process Count Automation

script it…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

Automated restore using Ola Hallengren’s SQL Server Backup

script it…walk away.

Greetings humans. This is the second time I’m writing this post because of some wordpress trickery, so pardon me if I make it short. I’m still finishing up part 2 of my first Simple Talk article, while making sure I’m ready for two more presentations, all while making sure I’m ready for a musical performance May 1st. So things are a little busy 🙂

Continue reading

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

win by decapitation…

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

Cassandra Install Helper Script

script it…walk away.

So while I’ve been doing research into the use of NoSQL platforms to augment or improve our infrastructure, I’ve had to create many…MANY Cassandra clusters. These are all testing and dev level clusters but regardless of their deployment level, the act can become very tedious. Because I’m a firm believer in repeatable builds I put together this helper script.

Continue reading