Monthly Archives: August 2011

Receive error #13119 in toolbox instead of tools in Visual Studio 2008

Posted on August 31, 2011 by

A couple of times over the past few months, while in Visual Studio 2008 working on an SSIS package, I went to the toolbox and saw this message: There we no tools at all showing up.  Apparently the toolbox became corrupted, but … Continue reading →

Posted in SQLServerPedia Syndication, Visual Studio 2008 | 1 Comment

When to use T-SQL or SSIS for ETL

Posted on August 29, 2011 by

When doing ETL, you have the choice of using T-SQL or SSIS.  What things should you consider when deciding which one to use?  Here are some of the major design considerations to think about.  These points were derived from Tim … Continue reading →

Posted in ETL, SQLServerPedia Syndication, SSIS | 3 Comments

Microsoft SQL Server Parallel Data Warehouse (PDW) Explained

Posted on August 26, 2011 by

Microsoft SQL Server Parallel Data Warehouse (PDW), formally called by its code name “Project Madison”, is an edition of Microsoft’s SQL Server 2008 R2 that was released in December 2010.  PDW is Microsoft’s reworking of the DatAllegro Inc. massive parallel processing (MPP) product … Continue reading →

Posted in Appliance, PDW, SQL Server, SQLServerPedia Syndication | 6 Comments

Microsoft Small Basic

Posted on August 24, 2011 by

This is a bit off-topic, but I wanted to mention a great tool for beginners to learn how to program.  This tool is especially ideal for those of us who have high schoolers who are interested in programming (this blog … Continue reading →

Posted in SQLServerPedia Syndication | Leave a comment

Tracking down KPI error in PerformancePoint

Posted on August 22, 2011 by

On a few occasions, I have opened up my PerformancePoint scorecard on SharePoint to see an error staring at me: So two of my KPI’s, which have been working fine for months, suddenly don’t work.  Follow along and I will … Continue reading →

Posted in KPI, PerformancePoint, SQLServerPedia Syndication | Leave a comment

Methods for populating a data warehouse

Posted on August 19, 2011 by

Source tables change over time. A data mart or data warehouse that is based on those tables needs to reflect these changes.  This blog post will explain different solutions for solving this problem. When moving data into a data warehouse, taking … Continue reading →

Posted in Data warehouse, SQLServerPedia Syndication | 3 Comments

Microsoft SharePoint Online

Posted on August 17, 2011 by

Microsoft SharePoint Online is a cloud-based service that is part of the recently released Microsoft Office 365.  For those of us who have installed SharePoint and maintained it, we know there is a lot of cost and overhead.  Setting it all … Continue reading →

Posted in SharePoint, SQLServerPedia Syndication | Leave a comment

Using SSIS lookup transformation editor with millions of rows

Posted on August 15, 2011 by

If you are using a SSIS lookup transformation editor to determine whether to update/delete/insert records and the reference dataset is large (millions of rows) and you are using “Full cache” on the lookup transformation (the default), you might run into … Continue reading →

Posted in SQLServerPedia Syndication, SSIS | 2 Comments

SSAS Maestro Program (or SQL BI MCM)

Posted on August 12, 2011 by

There is a very interesting new Microsoft program that started back in January, called the SSAS Maestro Program.  It is a five-day, deep-dive course on Analysis Services 2008 R2 that gives architects and consultants the education and hands-on experience needed to deliver the … Continue reading →

Posted in Business Intelligence, Certification, SQLServerPedia Syndication, SSAS | 1 Comment

Product Guide for SQL Server 2012 (“Denali”) released

Posted on August 11, 2011 by

Released today, the SQL Server 2012, code name ‘Denali’, Community Technical Preview 3 (CTP3) Product Guide download contains the latest datasheets, white papers, click-through and auto-running demonstrations, hands-on lab previews, technical presentations, and other useful links to help you evaluate the SQL … Continue reading →

Posted in SQL Server 2012, SQLServerPedia Syndication | Leave a comment