SQL Server 2008 introduced a new feature, Management Data Warehouse (MDW), which allows users to collect metrics on their servers over time to aid in performance troubleshooting. A lot of people try this feature out, because it is easy to set up, and then find that it is not so easy to remove. In fact, removing MDW is not supported; in SQL Server 2012, though, a new system stored procedure was added to make this process easier. The problem is that this stored procedure (as well as several of the workarounds I've seen published) can leave several objects behind.

Wiggle Room

by Steve Jones

SQLServerCentral.com

Editorial

Consultants sometimes don't live up to their hype. To what extent should we expect them to know exactly what they're doing? This editorial was originally published on Nov 9, 2007. It is being republished as Steve is on vacation.

SQL Saturday #164 - Cleveland

by Press Release

SQLServerCentral.com

SQL Saturday

A free day of training in Cleveland, OH. Come see MVPs Allen White and others talking about all aspects of SQL Server. For free.

Working with SSIS Data Types

by Additional Articles

SimpleTalk

Integration Services (SSIS)

In order to be able to take data from a variety of sources, manipulate it, and then export it to one of several destinations, SSIS has to use its own data types. If you hit problems, then you may need to intervene to ensure an appropriate conversion.

Display data by fiscal year instead of calendar year

by Sanjay Kumar

SQLServerCentral.com

Fiscal Year

This article provides a simple solution to display any data by fiscal year instead of calendar year.

Stupid Interviewer Tricks

by Steve Jones

SQLServerCentral.com

Editorial

Today's editorial was originally published on Feb 7, 2008. It is being re-published as Steve is on vacation.
What do you do when the interviewer is obviously wrong? Steve Jones offers a perspective.

Optimizing tempdb configuration with SQL Server 2012 Extended Events

by Additional Articles

SimpleTalk

tempdb

One of the most obvious bottlenecks in the performance of tempdb is caused by PAGELATCH, in-memory latch contention on the allocation bitmap of each data file used. We can use one of the rules-of-thumb to choose what should be roughly the best number of files, but how then do you check to see whether you've got it right for your data and workload?

Code Reviews Must Be Brutally Honest

by Hakim Ali

SQLServerCentral.com

Code Review

Today we have a guest editorial from Hakim Ali. Today Akim talks about why holding back out of politeness in code reviews may be a self-defeating practice.

Pushing SQL Alerts to Remote Server using PowerShell 2 and T-SQL

by Simon Richards

SQLServerCentral.com

SQL Alerts

Managing log files in a large enterprise environment can be an overwhelming task. In this article I will show you how to automate some of the work using SQL Alerts and Powershell 2.0

Windows Server 2012, ReFS and No SQL Server

by Phil Factor

SQLServerCentral.com

Database Weekly

ReFS, the new file system with Windows Server 2012, should be good news, but its apparent lack of support for SQL Server is a serious concerned for Phil Factor.

Removing the SQL Server Management Data Warehouse

Wiggle Room

SQL Saturday #164 - Cleveland

Working with SSIS Data Types

Display data by fiscal year instead of calendar year

Stupid Interviewer Tricks

Optimizing tempdb configuration with SQL Server 2012 Extended Events

Code Reviews Must Be Brutally Honest

Pushing SQL Alerts to Remote Server using PowerShell 2 and T-SQL

Windows Server 2012, ReFS and No SQL Server

Blogs

ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)

A Fabric solution can be very cost effective

Track SQL Server Configuration Changes Using the Error Log

Forums

We Are Eating Our Own Seed Corn

Before Using AI with Business Data, Read This

Designing SQL Server ETL Pipelines That Don't Break at Scale

Question of the Day

Detecting Deadlocks Quickly