Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Using BIDS 2008 to validate Analysis Services 2005 cubes

    If you have experimented with cube design in SQL Server 2008, you will probably have run into the new AMO design warnings in Business Intelligence Development Studio 2008 (BIDS). We find that these warnings help customers a lot: they allow them to quickly analyze your cube for classic design mistakes...
Page 1 of 1 (11 items)