Tag Archives: Performance
#PASSBAC – Yahoo!, Big Data, and Microsoft BI: Bigger and Better Together
About three and a half years ago, I had virtually joined the Yahoo! Targeting, Analytics, and Optimization (TAO) Engineering team where we embarked on an incredible journey to create the … Continue reading
Enterprise Reporting Services Jump Start Guide
While there is a lot of deserved and great interest with Power View, almost forgotten is the IT workhorse SQL Server 2012 Reporting Services for your corporate / managed reporting … Continue reading
Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide
A while back, Thomas Kejser (@thomaskejser | http://blog.kejser.org/) and I had written a couple cool guides on Analysis Services Multidimensional: SQL Server 2008R2 Analysis Services Operations Guide Analysis Services 2008 … Continue reading
Announcing SSAS Maestros v1.2
In homage to the maestro, the Battlestar Galactica image links to Bear McCreary’s All Along The Watch Tower. Note, This is a re-post of Announcing SSAS Maestros v1.2 on the … Continue reading
Why the obsession with random I/O within the context of SSAS?
As many of you know from the various blogs, whitepapers, and conferences from SQLCAT, there is a big obsession or compulsion toward I/O by various members of SQLCAT. If you’re … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
ExecutionLog2 View – Analyzing and Optimizing Reports
An excellent blog explaining the ExecutionLog2 view within Reporting Services has been written by Robert Bruckner at: http://blogs.msdn.com/robertbruckner/archive/2009/01/05/executionlog2-view.aspx Quoted from Robert: Before you can optimize particular reports or your entire … Continue reading
