Here I show you how to automatically compress BCP operations with Hyperbac. It’s just a cool bonus you get when you do you database backups with this utility. Here’s the Vid.
Author: KenpoDBA
Windows Performance Monitoring: Part 2
This is the continuation of the live presentation I did a couple weeks ago. This one covers disk counters, memory architecture, and counters. Find the video here.
Find LogSpace Used
Find out how to query the log space usage for all DBs on the server with a single statement. This is a quick way to get the % of log space used and even program against the results. Find video here.