Learn how you can get alerts when you centralize the Event log. This is part 2 of the previous article "How to centralize your SQL Server Event Logs."  Read more...

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...

The sp_spaceused procedure does not provide schema name in return. Here is sp_spaceused2 that does.  Read more...

Loads temporary stored procs that assist in running and monitoring server-side tracing.  Read more...

This select will show the last sql statement for every open session plus many helpfull information.  Read more...

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005  Read more...

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

This script lists the name, running and success status, last executed/currently executing step name, Average and Last duration, next run time and other related information about Jobs.  Read more...

At some point you are going to need a notification system for a range of events that occur in your servers. Laerte Junior shows how you can even set up temporary or permanent alerts for any WMI events to give you a system that fits your server environment perfectly.  Read more...

In SQL Server, replication is a widely adopted technology for the purpose of real-time data replication between SQL servers. It serves the purpose of keeping data consistent between multiple end points. So the last thing we want to hear from clients is that data is no longer in synch, and as DBA, we don't want to be the last person to realize replication is out of order or broken. Here are some steps you can take to monitor SQL Server replication.  Read more...

Sean Duffy recently had an unwelcome encounter with Exchange Server Back Pressure, which cut off his message flow due to a lack of space on the server. To make sure it didn’t happen again, he found a way to automatically monitor all his servers from afar, with a little PowerShell magic.  Read more...

It is never a good idea to let your users be the ones to tell you of database server outages. It is far better to be able to spot potential problems by being alerted for the most relevant conditions on your servers at the best threshold. This will take time and patience, but the reward will be an alerting system which allows you to deal more effectively with issues before they involve system down-time.  Read more...

This script quick tip for those who will accurately monitor sessions on SQL Server.  Read more...

Continuing with his series on monitoring your SQL Servers, David Bird now looks a a way to fin those long running, active jobs.  Read more...

In the sixth part of his series on monitoring your SQL Server, David Bird looks at process locks.  Read more...

Continuing on with his series on reporting for your SQL Server, David Bird brings together the series with the full package used for building the report.s  Read more...

The Replication infrastructure in SQL Server is implemented using SQL Server Agent to execute the various components involved in the form of a job (e.g. LogReader agent job, Distribution agent job, Merge agent job) SQL Server jobs execute a binary executable file which is basically C++ code.  Read more...

In Part II of his series on monitoring SQL Servers, David Bird takes a look at importing data from your error logs.  Read more...

This script will email info about the longest running SPID in an HTML formatted table  Read more...

Monitoring your SQL Server instances and figuring out what's going on is important to keep an eye on your environment. David Bird brings us a new series that looks at how you might start setting this up with Integration Services.   Read more...