SQLCAT.Com – eBook Downloads

As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication.  MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated with more SQLCAT learnings.  You can also… Read more

Self-Service BI Works!

When I talk to people about adding self-service BI to their company’s environment I generally get a list of reasons why it won’t work. Some things I commonly hear: I can’t get anyone in IT or on the business side to even try it. The business side doesn’t know how to use the technology. This… Read more

Review a working option to setup a SQL Server 2012 BI solution using Azure’s IaaS VMs

By: Nicholas Dritsas Reviewers: James Podgorski, Olivier Matrat, Sanjay Mishra Overview Azure’s Iaas VMs plus Virtual Networks can be used to configure easily a set of servers/VMs to host the main components of a BI solution. This process assumes you already have an Azure subscription plus access to add new VMs and Virtual Networks. Setting… Read more

What’s so BIG about “Big Data”?

As announced during the PASS Summit 2011 Day One Keynote, we are diving deeper into the world of Big Data by embracing and contributing to the open source community and Hadoop. We’ve had a lot of good coverage on this topic with some examples below. Microsoft Expands Data Platform With SQL Server 2012, New Investments… Read more

Why the obsession with random I/O within the context of SSAS?

by Denny Lee 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 not already familiar with this topic, definitely reference Mike Ruthruff’s whitepaper Predeployment I/O Best Practices. But as could be seen from the… Read more

What is the SSAS Maestros?

by Denny Lee (SQL Customer Advisory Team), Daniel Yu (SQL Marketing) Over the last few weeks, there has been a lot of questions, tweets, and rumors about the SSAS Maestros program – some notable blogs include Kasper de Jonge’s Do you have what it takes to become SSAS Maestro and Vidas Matelis’ SSAS White Paper… Read more

Optimizing CREATE SET in Cube Calculation Scripts

Author: Thomas Kejser Reviewers: Peter Adshead, Nicholas Dritsas, Sanjay Nayyar, John Desch, Kevin Cox, Akshai Mirchandani, Anne Zorner In this blog we will describe an important optimization that you should apply to cubes that are processed often and have CREATE SET commands in the calculation script. We will describe the measurements you can make to… Read more

Gemini – Self Service BI!

Gemini is the code name for the new breakthrough Self-Service Business Intelligence (BI) capabilities being delivered in the SQL Server 2008 R2 release. Gemini enables end users to build BI applications by integrating data from a variety of sources, modeling, refining and analyzing the data, adding business logic, building reports and visualizations and ultimately sharing… Read more

Assigning surrogate keys to early arriving facts using Integration Services

In data warehouses, it is quite common that fact records arrive with a source system key that has not yet been loaded in the dimension tables. This phenomena is known as “late arriving dimensions” or “early arriving facts” in Kimball terminology. When you see a fact record that cannot be resolved to a dimension surrogate… Read more

Remember to move DTS2000 packages when upgrading msdb from 2005 to 2008

Some customers prefer to upgrade to SQL Server 2008 by detaching all databases from their SQL Server 2005 instance and then reattaching them to a completely new SQL Server 2008 instance.   If you choose this upgrade strategy, you should be aware that you cannot detach an msdb database from a SQL Server 2005 instance… Read more