Monthly Archives: December 2012

Enabling Service Broker on a database

To check the status of service broker on a database run the following (in the database)… SELECT is_broker_enabled FROM master.sys.databases WHERE database_id = DB_ID() If the broker is enabled it will return a 1, otherwise it will return 0. The … Continue reading

Posted in Service Broker | Comments Off on Enabling Service Broker on a database

Failed data collector upload job

When the MDW data collector fails the upload job,  the cached files start building up and the MDW database starts getting out of date. If you look at the SQL agent job history for the upload job you will likely … Continue reading

Posted in Troubleshooting | Comments Off on Failed data collector upload job

Working with SQL Server data compression

 Before compressing any database, a check to see whether ROW or PAGE compression will give the best result is necessary before carrying out any change. The script below will generate a set of scripts to run and the output you can use … Continue reading

Posted in Compression | Comments Off on Working with SQL Server data compression

Creating a SQL Database

Writing an article about how to create a database might seem a bit too simple to many but I was surprised when talking to people that they didn’t know why I would do it this way.  When you create a … Continue reading

Posted in Tips | Comments Off on Creating a SQL Database

Scaling MDW

SQL Server 2008 introduced the MDW – a Management Data Warehouse. The MDW is a data warehouse for storing performance data about your SQL servers. It is best configured using a centrally located database – in the environment I work … Continue reading

Posted in Performance | Comments Off on Scaling MDW