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!
Continue reading →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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
As a follow-up to my SQL Server 2012: New Certification Info, Microsoft Learning has announced the certification tracks for the SQL Server 2012 exams. There are new names for the certifications: Your first step is to achieve Microsoft Certified Solutions Associate (MCSA). If … Continue reading →
Now that SQL Server 2012 RTM is out, I have an update to my blog post SQL Server 2012 (“Denali”): Installing on a Virtual Machine, which was for CTP3. Here is the version for the RTM: The steps below are what … Continue reading →
To expand on what I talked about in SQL Server 2012 (“Denali”): Details on the next version of SSAS, there is a new data model called Tabular. So when you are creating a new project, which model should you use, Multidimensional … Continue reading →
My previous blog, SQL Server 2012 (“Denali”): Details on the next version of SSAS, talked about the major new feature in SSAS, which is BISM. But what other changes are there? Well, not much. Here are details on the few changes … Continue reading →
After SQL Server 2012 was released this past week, I saw a few mentions from Microsoft about a new feature in SQL Server 2012 called “xVelocity”. I have been using SQL Server 2012 for months now, playing with all the new … Continue reading →
As a follow-up to my posts SQL Server “Denali”: New Certifications and SQL Server 2012: New Certifications, there are now final details coming out about the SQL Server 2012 certifications. The major news: UPDATE: Anyone can take the beta exams for free. Just … Continue reading →
In SQL Server 2012, there is a new data model, called tabular, that is part of the new feature called the Business Intelligence Semantic Model (BISM). BISM also includes the multidimensional model (formally called the UDM). The Tabular model is based on … Continue reading →
Power View is installed when you run the SQL Server 2012 install and on the Feature Selection page choose “Reporting Services Add-in for SharePoint Products”. This is a newer version of the add-in that is installed with SharePoint 2010, with … Continue reading →
In SQL Server 2008, if you wanted to run Reporting Services in SharePoint integrated mode, these where the steps you took (see How to: Install and Configure SharePoint Integration on a Stand-alone Server): Install SQL Server 2008 and on the on the Feature … Continue reading →
Exciting news! Microsoft announced today that SQL Server 2012 has released to manufacturing (RTM). Customers and partners can download an evaluation (or here) of the product today and can expect general availability to begin on April 1 (see Microsoft SQL Server … Continue reading →