Articles
Below are some of the articles that I’ve had the honor of being an author, contributor, or reviewer. Lots of good stuff here so enjoy! The articles are broken out by subject area; the ones without links and in italics are the papers coming soon!
Hadoop on Azure
PowerPivot
- PowerPivot Best Practices / Capacity Planning Guide
- Using PowerPivot to Analyze SAP data
- PowerPivot for SharePoint: Existing Farm Installation Guide
- PowerPivot for SharePoint: Single Server Installation Guide
- PowerPivot Technical Diagram: PowerPivot Security Architecture
- How often are patients coming back? A healthy PowerPivot study
- PowerPivot for SharePoint – Transitioning from a Single Server to SharePoint Farm
- How can I prepare for PowerPivot?
- PowerPivot Technical Diagram: PowerPivot Client/Server Architecture
- Microsoft SQL Server 2008 R2 PowerPivot Planning and Deployment (contributor)
SharePoint
Analysis Services
- Analysis Services 2008 R2 Performance Guide
- SQL Server 2008 R2 Analysis Services Operations Guide
- REAL PRACTICES: Performance Scaling Microsoft SQL Server 2008 Analysis Services at Microsoft adCenter
- Why the obsession with random I/O within the context of SSAS?
- What is SSAS Maestros (as co-creator of the SSAS Maestros course with Daniel Yu and Thomas Kejser)
- Analysis Services Distinct Count Optimization Using Solid State Devices
- Analysis Services ROLAP for SQL Server Data Warehouses
- Scale-Out Querying for Analysis Services with Read-Only Databases
- Accelerating Microsoft adCenter with Microsoft SQL Server 2008 Analysis Services (contributor)
- Microsoft SQL Server 2008 Analysis Services Consolidation Best Practices (technical reviewer)
- Analysis Services Load Balancing Solution (technical reviewer)
- Analysis Services Synchronization Best Practices
- Reintroducing Usage-Based Optimization in SQL Server 2008 Analysis Services
- The Analysis Services 2008 Performance Guide (contributor)
- Analysis Services Distinct Count Optimization
- The Many Benefits of Money…Data Type!
- Including Child Members Multiple Places in a Parent-Child Hierarchy (technical reviewer)
- Analysis Services: Should you use many-to-many dimensions?
- Scale-Out Querying with Analysis Services
- Scale-Out Querying with Analysis Services Using SAN Snapshots (technical reviewer)
- Precision Considerations for Analysis Services Users
- Sample Robocopy Script to customer synchronize Analysis Services databases
- Analysis Services Processing Best Practices
- Analysis Services 2005 Aggregation Design Strategy
Integration Services
- Moving Large Amounts of Data Between Oracle and SQL Server: Findings and Observations (technical reviewer)
- Top 10 SQL Server Integration Services Best Practices
Reporting Services
- SQL Server Reporting Services Disaster Recovery Case Study
- Reporting Services Performance Optimizations
- Reporting Services Scale-Out Deployment Best Practices
- Report Server Catalog Best Practices
- Reporting Services Scale-Out Architecture
SQL Server
- Disk Partition Alignment Best Practices for SQL Server
- The Data Loading Performance Guide 2008 (contributor)
- Tuning the Performance of Change Data Capture in SQL Server 2008 (technical reviewer)
- Reaching Compliance: SQL Server 2008 Compliance Guide
- Running SQL Server 2008 in a Hyper-V Environment – Best Practices and Performance Recommendations (technical reviewer)
- Bulk Loading Data into a Table with Concurrent Queries (technical reviewer)
- Scheduling Sub-Minute Log Shipping in SQL Server 2008 (technical reviewer)
- Tuning the Performance of Backup Compression in SQL Server 2008 (technical reviewer)
- Top 10 Best Practices for Building a Large Scale Relational Data Warehouse
.
Please provide the link for PowerPivot Best Practices / Capacity Planning Guide
We have yet to complete this guide – as soon as it is completed, I will definitely post it up. Sorry!
Hey Denny,
I have a question on how you handle SAN Snapshots and Load Balancing… My question is a little more technical in nature than the “Scale-Out Querying for Analysis Services with Read-Only Databases”. Can you please help?
To handle SAN snapshots and load balancing, best to work with your Systems Engineer as each SAN vendor operates SAN differently. As for Load balancing, please reference the Analysis Services 2008 R2 Operations Guide. http://sqlcat.com/sqlcat/b/whitepapers/archive/2011/06/01/sql-server-2008r2-analysis-services-operations-guide.aspx
HTH!