Category Archives: Production DBA

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

Replay the oplog in MongoDB

Only a braindead can't find x

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

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