Category Archives: SQL Server 2012

SQL Server 2012 Business Intelligence Enhancements

My first article in SQL Server Pro magazine has been published, in the April 2013 issue.  It is entitled “SQL Server 2012 Business Intelligence Enhancements” and can be found here (web) or here (mag).  I hope you enjoy it!

Posted in Business Intelligence, SQL Server 2012, SQLServerPedia Syndication | 4 Comments

Top BI Enhancements for SQL Server 2012 Presentation Slides

Thanks to everyone who attended my session “Top BI Enhancements for SQL Server 2012” at the Houston Area SQL Server User Group Monthly Meeting. Here is the PowerPoint presentation: Top BI Enhancements for SQL Server 2012 Top BI Enhancements for SQL Server 2012 What are … Continue reading

Posted in Business Intelligence, Presentation, Session, SQL Server 2012, SQLServerPedia Syndication | Leave a comment

Top BI Enhancements for SQL Server 2012 Presentation

Next Tuesday, March 12th at 1:15pm CST, I will be presenting the session “Top BI Enhancements for SQL Server 2012” at the Houston Area SQL Server User Group Monthly Meeting.  Below is the abstract.  I will be presenting in person but you … Continue reading

Posted in Business Intelligence, Presentation, Session, SQL Server 2012, SQLServerPedia Syndication | Leave a comment

SQL Server 2012 SP1 Causes MsiInstaller Application Log Entries

After installing SP1 to SQL Server 2012 (11.0.3000) on one of our servers, I noticed higher than normal CPU loads due to msiexec.exe running non-stop.  The cpu percentage would bounce from 0% to 13%, and the application log would have five new … Continue reading

Posted in SQL Server 2012, SQLServerPedia Syndication | 1 Comment

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

Jumping from SSIS 2008 to SSIS 2012

Being a long-time SSIS 2008 developer, I have been working with SSIS 2012 for the past few months, and I wanted to jot down a quick guide for those of you also making the jump from SSIS 2008 to SSIS … Continue reading

Posted in SQL Server 2012, SQLServerPedia Syndication, SSIS | 2 Comments

SQL Server 2012: New Business Intelligence features

SQL Server 2012 has many new Business Intelligence (BI) features and enhancements.  Here are my top 12, in order of importance: Power View.  A fun, visual, and powerful drag-and-drop ad-hoc reporting tool.  It is a web-based end-user BI tool based … Continue reading

Posted in Business Intelligence, SQL Server 2012, SQLServerPedia Syndication | 5 Comments

SQL Server 2012 and SharePoint 2013: Installing on a Virtual Machine

With SharePoint 2013 now available, I have updated my post SQL Server 2012: Installing on a Virtual Machine to use SharePoint 2013 instead of SharePoint 2010.  If you would like to get a head start on learning what is new with SharePoint … Continue reading

Posted in SharePoint 2013, SQL Server 2012, SQLServerPedia Syndication | 11 Comments

Microsoft Data Quality Services in SQL Server 2012

SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product that is new to SQL Server 2012.  The technology was from Microsoft’s acquisition of Zoomix in 2008.  DQS enables you to build a knowledge base and use it to perform … Continue reading

Posted in DQS, SQL Server 2012, SQLServerPedia Syndication | 4 Comments

Microsoft Master Data Services in SQL Server 2012

Microsoft SQL Server Master Data Services (MDS) is a Master Data Management (MDM) product from Microsoft.  Master Data Services is the rebranding of the Stratature MDM product titled +EDM, which Microsoft acquired in June 2007.  Master Data Services is architecturally … Continue reading

Posted in DQS, MDS/MDM, SQL Server 2012, SQLServerPedia Syndication | 7 Comments