Showing posts with label Articles Best Practices and White Papers. Show all posts
Showing posts with label Articles Best Practices and White Papers. Show all posts
Thursday, July 19, 2012
Thursday, June 21, 2012
Saturday, November 26, 2011
Monday, October 24, 2011
SQL Server Technical Articles
If you work with Microsoft's BI stack, these articles can be very useful.
SQL Server Best Practices
SQLCAT Articles
Analysis Services 2008 R2 Performance Guide
SQL Server Best Practices
SQLCAT Articles
Analysis Services 2008 R2 Performance Guide
Saturday, September 10, 2011
Microsoft SQL Server Large Data Warehouses
Here are some links to the articles about the performance of SQL Server large data warehouses:
MSDN: The Data Loading Performance Guide
MSDN: We Loaded 1TB in 30 Minutes with SSIS, and So Can You
MSDN: Introduction to New Data Warehouse Scalability Features in SQL Server 2008
and many more Microsoft SQL Server 2008 White Papers and Microsoft SQL Server 2008 R2 White Papers
MSDN: The Data Loading Performance Guide
MSDN: We Loaded 1TB in 30 Minutes with SSIS, and So Can You
MSDN: Introduction to New Data Warehouse Scalability Features in SQL Server 2008
and many more Microsoft SQL Server 2008 White Papers and Microsoft SQL Server 2008 R2 White Papers
Tuesday, August 17, 2010
Monday, January 21, 2008
Improving Performance with SQL Server 2005 Indexed Views
The document Improving Performance with SQL Server 2005 Indexed Views describes the improved indexed views capability of SQL Server 2005 Enterprise Edition. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed.
Implementing Row- and Cell-Level Security Using SQL Server 2005
The paper Implementing Row- and Cell-Level Security in Classified Databases Using SQL Server 2005 describes how SQL Server 2005 can be used to support row- and cell-level security (RLS/CLS). The examples provided in this white paper show how RLS and CLS can be used to meet classified database security requirements.
Saturday, January 19, 2008
Some Interesting SQL Server Articles
Wednesday, July 18, 2007
Best Practices and White Papers
Analysis Services
SQL Server 2005 Analysis Services Performance Guide
OLAP Design Best Practices for Analysis Services 2005
Analysis Services Processing Best Practices
Real-time Business Intelligence Using Analysis Services
Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services
Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
SQL Server Data Warehousing
SQL Server 2005 Data Warehousing
Business Intelligence and Data Warehousing in SQL Server 2005
SQL Server 2005 Data Warehousing White Papers
Strategies for Partitioning Ralational Data Warehouses in Microsoft SQL Server
Choosing Microsoft SQL Server 2005 for Data Warehousing
High Performance Data Warehouse with SQL Server 2005
Manage Large Data Warehouses with SQL Server 2005
SQL Server 2005 Analysis Services Performance Guide
OLAP Design Best Practices for Analysis Services 2005
Analysis Services Processing Best Practices
Real-time Business Intelligence Using Analysis Services
Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services
Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
SQL Server Data Warehousing
SQL Server 2005 Data Warehousing
Business Intelligence and Data Warehousing in SQL Server 2005
SQL Server 2005 Data Warehousing White Papers
Strategies for Partitioning Ralational Data Warehouses in Microsoft SQL Server
Choosing Microsoft SQL Server 2005 for Data Warehousing
High Performance Data Warehouse with SQL Server 2005
Manage Large Data Warehouses with SQL Server 2005
Subscribe to:
Posts (Atom)
