Checking jobs for failure, owners, and if they’re stuck running until someone notices. … More Take Those Jobs and Check ‘Em
It’s a wrap! SQL Saturday #66 was a huge success! Thank you everyone! … More Did You Get Your Assist at SQL Sat 66?
Where oh where did all my disk space go? Ya might want to keep an eye on thoes pesky data and transaction log files before they suck up all your disk space and you end up feeling a tad silly when your users wonder why they can’t add anymore data. … More Growing, Growing, Gone!
A percolating what? Yeah, I know. It’s the best title I could come up with. My cat tried to give me ideas but the universal translator was offline. … More I Distinctly Detect a Percolating Process
When I started blogging, my goal was to put up a new post at least once a week, and I feel I’ve pretty much kept to it. These last few weeks have been an exception with the SQL Cruise (ah, fun times) followed immediately by family visiting from out of state (do not stop at … More Peek-a-Who? Ha! I See You!
Have you ever had a database or two or ten show up mysteriously one day? Or perhaps you’ve had some disappear for no apparent reason? For me, I dubbed it the “Bermuda Cluster”… … More The Bermuda Cluster…
This week my boss asked who wanted to install SQL Server on a new server. Seeing as it had been awhile since I did one, or at least it seemed like it, I happily volunteered. I needed some time away from my desk anyway so I was pretty excited. Much to my dismay, it turned … More Failure? What Failure?
What is a system level trigger and why you should care. The second post in a blog series about checking one’s database servers for malicious code and other fun stuff. … More Ready, Aim, Fire that Trigger!
Check that server on the double! Stat! Now! Go! … More Is It Me or Is That an Error in Your Log?