Introduction This article contains information about the things we have learned while working with Federated Databases. Before beginning it is necessary to define the terms being used. Included in this article is one solution in production that is...

Author: Denny Lee Contributors: John Desch, Kevin Cox Reviewers: Robert Zare DRILLTHROUGH MDX Overview DRILLTHROUGH MDX is a very powerful way to drillthrough to your original data source of detail data that make up the aggregations...

Four new best practices articles are available at the SQL Server Best Practices site on Technet ( http://technet.microsoft.com/en-us/sqlserver/bb331794.aspx ). Two of the articles are on Analysis Services Processing and Querying best practices: ...

You can check out the three new Best Practices Articles Predeployment I/O Best Practices http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx by Mike Ruthruff Partial Database Availability http://www.microsoft.com/technet...

Authors: Sanjay Mishra, Michael Thomassy, Peter Byrne Database Snapshots ( http://msdn2.microsoft.com/en-us/library/ms175158.aspx ) in SQL Server 2005 Enterprise Edition allow a read-only point-in-time view of data. Recently we encountered an interesting...