June 2007 - Posts
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 using
Read More...
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 that you are looking
Read More...
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: Analysis
Read More...
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/prodtechnol/sql/bestpractice/pdbavail.mspx
Read More...
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
Read More...
