Database administrators tend to perform a lot of routine checks, referred to as sanity checks, on a daily, weekly, and monthly basis. Rob Gravelle shows you how to write some PowerShell scripts to automate a couple of fairly common sanity checks.  Read more...

Using Powershell to create color coded backup reports for all servers in your environment.  Read more...

Report to keep you abreast of various details of an instance, including: general properties, uptime, drive space, db size allocation, growth stats, backups, jobs, unused indexes, & more...  Read more...

This scripts helps to power you with the disk space monitoring for the Mount points. Hope this helps  Read more...

This article describes a utility that allows you to identify what SQL statements are currently executing.  Read more...

An article from new author Lokesh Gunjugnur that shows how you can set up tracking for database growth on multiple servers and creating custom reports in Excel.  Read more...

This scripts helps to power you with the disk space monitoring for the Mount points. Hope this helps  Read more...

This article introduces Profiler presenting what it is, how to use it, and why you might want to use it.  Read more...

This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.  Read more...

This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.  Read more...

This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.  Read more...

This article describes a utility that allows you to identify what SQL statements are currently executing.  Read more...

An interesting tale of David Bird's fight with tempdb.  Read more...

Every extra byte of space you waste in your database causes a performance hit to your application. This article looks at disk space usage and how it affects performance.  Read more...

Monitoring in the real world. Roy Carlson concludes his series on space monitoring for your SQL Servers with a real world example of how he found a problem and fixed it.   Read more...

Trending the size data for your databases can be crucial when ordering new hardware or just ensuring that you can handle the load. In Part 3, Roy Carlson looks at how you get the sizes needed for your instances into Excel and generate a chart for trending of this important piece of performance data.   Read more...

Continuing with his series on monitoring space, Roy Carlson looks at checking the space in a folder to be sure your SQL Server databases never run out of storage.   Read more...

Joe has a bunch of small, easy to use scripts that can definitely be the beginning of a great set of monitoring tool. Amazing how much info you can gather with a little bit of code!   Read more...

One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.   Read more...

Knowing which databases are being backed up is a critical thing for all DBAs to know. After reading an article on this subject, new author Santveer Singh decided to share his own techniques for checking SQL Server databases and their backup status. He shows us how to look for failed backups as well as find those databases which have not been backed up.   Read more...