Getting ready for enterprise SSAS and PowerPivot at PASS with SQLCAT!

If you’re online this week, and admittedly the last few weeks I have been extremely dormant, you may know that next week is the 2010 SQL Server PASS Summit!   It’s one of the most important SQL Server conferences and my team, SQLCAT,  will be out in force.  Heck, we’ll be in our green SQLCAT shirts so we’ll be noticeable from across the Washington State Convention Center.   Just in case you do not already know, SQLCAT is a SQL Server product group team that works with some of the largest implementations of SQL Server.  By doing this, we help improve…

Rate this:

Analysis Services ROLAP for SQL Server Data Warehouses

You’re sh*&ting me. No way. Man, that sucks. rocks! – Toby Lee Shavers, from XXX (2002), altered of course! And before you start, yes, I’m starting to follow the schtick of quotes from fellow PowerPivot bloggers Rob Collie (@PowerPivotPro) and Kasper de Jonge (@Kjonge).  For more memorable movie quotes, check out http://www.powerpivotpro.com/  . After about 14 months of testing, validation, analysis, and all sorts of hardware headaches and dancing, I am proud to say that I have finally published the Analysis Services ROLAP for SQL Server Data Warehouses whitepaper with my trusted partners-in-crime Thomas Kejser and Kay Unkroth.  Thomas for…

Rate this:

Scale-Out Querying with Analysis Services…does it apply to SQL Server 2008 or 2008 R2?

I recently received a great question concerning the whitepaper Scale-Out Querying with Analysis Services: Question, does this also apply for SQL Server 2008? What are you experiences with the scale out? I’m in the process of recommending using this technology to a large customer of mine and want to make sure we are actually able to deploy such a setup. So let’s tackle these issues one-by-one. Does the whitepaper Scale-Out Querying with Analysis Services apply for SQL Server 2008? Yes! Okay, now a more verbose answer here :).  The paper is applicable to both SQL Server 2008 and SQL Server…

Rate this:

Pros/Cons of deploying #SSIS with the SQL engine server

I was asked a pretty good question recently on what are the pros and cons of deploying SQL Server Integration Services packages on the same server that has your SQL Engine Server as well.  While we covered a lot in Top 10 SQL Server Integration Services Best Practices, we never really addressed this issue specifically – so let’s do it: Advantages of placing SSIS and SQL on the same server: You can use the SQL Server Destination instead of OLE DB which allows you to load data into SQL faster. You remove network as a bottleneck for insertion of data…

Rate this:

Accelerating Microsoft adCenter with Microsoft SQL Server 2008 Analysis Services

How Microsoft adCenter takes advantage of groundbreaking performance and scalability enhancements and innovative design tools available with Microsoft SQL Server 2008 Analysis Services   For more information, please refer to the whitepaper Accelerating Microsoft adCenter with Microsoft SQL Server 2008 Analysis Services.   Executive Summary As an Internet platform for online advertising campaigns on Microsoft® Bing™, Microsoft adCenter offers customers a wide range of intelligence and analytics tools to target, reach, and engage the right audience with the right ad at the right time. A complex, multi-faceted Online Analytical Processing (OLAP) environment based on SQL Server® 2008 Analysis Services drives the…

Rate this:

Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series)

For all of those whom are interested in SSIS performance, we have posted a new SQL video series about how to design and tune your SSIS packages for performance. Measuring and Understanding the Performance of Your SSIS Packages in the Enterprise (SQL Server Video) Link | Watch this video Author: Denny Lee, Microsoft Corporation This video demonstrates how to measure and understand the performance of packages, based on lessons learned from enterprise customers. In this video, you will learn the following guidelines for improving performance: How the limits of the source system affect performance. Why disk I/O is important. Why…

Rate this:

The Ultimate SQL Data Loading Performance Guide

For all of you whom wanted to know about how to load data within SQL Server, please refer to the "Ultimate" SQL Data Loading Performance Guide at: http://sqlcat.com/whitepapers/archive/2009/02/15/the-data-loading-performance-guide-2008.aspx   This document described techniques for bulk loading large data sets into SQL Server. It covers both the available techniques as well as methodologies to performance tune and optimize the bulk loading process.   Enjoy!  

Rate this:

Reporting Services Performance Optimization

The final technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments technical note series on Reporting Services Performance Optimization has just been published at Reporting Services Performance Optimization.   This technical note provides guidance on the reasons to use 64-bit, how to handle large workloads, Monitoring Reporting Services (which includes a link to a sample SSRS project to view the ExecutionLog2 view), and Memory Configurations.   Enjoy!    

Rate this: