Monthly Archives: November 2012

Power View for Multidimensional Models – Preview Available

Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012.  Power View can only consume data from tabular models.  At the PASS Summit (see PASS 2012 Announcements) it was revealed that you would soon be able to … Continue reading

Posted in Power View/Project Crescent, SQLServerPedia Syndication | 3 Comments

Reasons not to upgrade to SQL Server 2012

As exciting as SQL Server 2012 is, with its multitude of new features, it’s not always possible to upgrade right away.  Here are some reasons that may cause you to delay your upgrade: Training – Your developers and dba’s will … Continue reading

Posted in SQL Server 2012, SQLServerPedia Syndication | 5 Comments

Billing rates – other side of the fence

The following is a guest post by Tim Morgan from Sullexis in response to a resent blog of mine: Thanks for letting me reply to your last post, “Should a placement firm tell you what they are billing the client?“.  This … Continue reading

Posted in Career, Consulting, SQLServerPedia Syndication | 6 Comments

Master Data Services Web Services API Error

In Master Data Services (MDS), I received an error when using C# code in the script task in SSIS 2012 to call the MDS web services API: To fix this, I had to edit the web.config in C:\Program Files\Microsoft SQL … Continue reading

Posted in MDS/MDM, SQLServerPedia Syndication, SSIS | Leave a comment

PASS 2012 Announcements

Some announcements and notes from the SQL PASS Summit 2012 last week (If you don’t know what PASS is, check out What is SQL PASS?): PASS Summit 2012 had 3,894 delegates – up 13% from last year’s previous record attendance – and 1,717 pre-conference … Continue reading

Posted in PASS, PDW/APS, Power View/Project Crescent, SQLServerPedia Syndication | 2 Comments

Data Warehouse Architecture Presentation Slides

Thanks to everyone who attended my “Data Warehouse Architecture” presentation to the South Florida PASS chapter. Here is the PowerPoint presentation: Data Warehouse Architecture Data Warehouse Architecture – comparing Kimball and Inmon methodologies You’re a DBA and your boss asks you to … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | 2 Comments

Dell Quickstart Data Warehouse Appliance 2000

As a follow-up to my blog Dell Quickstart Data Warehouse Appliance for SQL Server 2012, Dell announced the availability of the second appliance in the Quickstart family: the Quickstart Data Warehouse Appliance 2000 (QSDW2000).  This is a pre-built appliance for data warehouses … Continue reading

Posted in Appliance, SQLServerPedia Syndication | Leave a comment

Data Warehouse Architecture Presentation

I will be presenting the session “Data Warehouse Architecture” to the South Florida PASS chapter on Wednesday, Nov 14th, at 5:30PM CST.  Below is the abstract.  It will be a remote presentation that you can join online.  Details at South … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | Leave a comment

SSIS: Execute SQL task vs Execute T-SQL Statement task

In SSIS there are two tasks than can be used to execute SQL statements: Execute T-SQL Statement and Execute SQL.  What is the difference between the two? The Execute T-SQL Statement task tasks less memory, parse time, and CPU time … Continue reading

Posted in SQLServerPedia Syndication, SSIS | 7 Comments

Problem copying large files to a USB flash drive?

I thought I would write a quick blog on a problem I see frequently: You try to copy a large file, such as the iso image of SQL Server, to a USB flash drive, and get the error message “There … Continue reading

Posted in SQLServerPedia Syndication | Leave a comment