Friday
Apr172015

Free up RDP connections

"The terminal server has exceeded the maximum number of allowed connections."

Bugs me to no end.  Finally wrote a script to forcefully log off disconnected sessions.  More here.

Thursday
Jan222015

Simple Backups for Oracle on Windows

Here's a solution for automating your Oracle backups when running Oracle on Windows.

Solution provides recent recovery point and e-mail alerting on six different error conditions.  

More information here.

Friday
Jan242014

Baseline your SQL Servers - PerfMon counters

Finally got around to a daily summary report for key PerfMon counters on my SQL servers to help with establishing a baseline of their performance.  More here.



Tuesday
Apr302013

Baseline your SQL Servers - Wait Stats

I'm working on establishing a baseline of the performance metrics of my SQL Servers for information that I care about.  I'm starting with Wait Statistics and am working to get my servers to send me information based on the Waits they're incurring and when they normally incur them.

More here.

 

Wednesday
Feb272013

Reporting on SQL Agent jobs that never run

We know exactly when a job fails, but what if it doesn't run at all?

Here's a quick-and-dirty alert for jobs that hadn't ran in an acceptable amout of time.

More info to the right under SQL - Misc Tips.