Category Archives: Sys Admin

Process Count Automation

Script it, then walk away...

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. I started a project called artistcalled6 and then it morphed into a band with my wife called Signals for Starships

Continue reading

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

Fixed it real good...

Fixed it real good…

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, then walk away...

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

Automation for DBAs – PerfMon Presage

I”m a pretty big fan of PerfMon. Most seasoned DBAs are adept with ready it and scheduling out collector sets in order to grab graphically aesthetic globs (GAGs) of information. I’m also a pretty big fan of Alerts. Most of you (if not all) should be familiar with how and when to setup alerts on SQL Server, if not then review this article from Brent Ozar and get alerting!

Continue reading