I'm in a situation where I have configured the new data collector functionality for three instances. And there's no way to undo the config performed by the wizard! It cannot be undone by the wizard, and BOL doesn't have information on how to do this. In fact, I suspect that you in the end need to use some of the undocumented data collector ...

I'm very excited about the new Management Data Warehouse coming in SQL Server 2008 (which was called Performance Studio at one point), but keep in mind there are lots of available tools in the current versions. One of the students in my class last week put together this list of his favorites. Note that some of the tools can be used together. For ...

(See my part 1 article about non-trusted constraints in general: http://sqlblog.com/blogs/tibor_karaszi/archive/2008/01/12/non-trusted-constraints.aspx) The optimizer is a pretty smart little animal. It can even use constraints to eliminate some data access or part of a query. That assumes however that the constraint is trusted. For example, for ...

I rarely just make a post that is a link to someone else's blog post, but this one is too good to allow anyone to miss. So if you haven't seen any other announcements about this one, you'll see it here. Two of the incredible guys in Product Support Services for SQL Server at Microsoft have released a set of tools that could change your ...