Category Archives: SQL Server 2012

SQL Server 2012: Certification Upgrade Info

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

Posted in Certification, SQL Server 2012, SQLServerPedia Syndication | 8 Comments

SQL Server 2012: Installing on a Virtual Machine

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

Posted in SharePoint, SQL Server 2012, SQLServerPedia Syndication | 19 Comments

SQL Server 2012: Multidimensional vs tabular

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

Posted in Data warehouse, SQL Server 2012, SQLServerPedia Syndication, SSAS, Tabular | 18 Comments

SQL Server 2012: SSAS enhancements

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

Posted in SQL Server 2012, SQLServerPedia Syndication, SSAS | 1 Comment

SQL Server 2012: xVelocity

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

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

SQL Server 2012: New Certification Info

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

Posted in Certification, SQL Server 2012, SQLServerPedia Syndication | 3 Comments

SQL Server 2012: Tabular Models vs PowerPivot Models

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

Posted in Power Pivot, SQL Server 2012, SQLServerPedia Syndication, Tabular | 4 Comments

SQL Server 2012 (“Denali”): Power View installation and requirements

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

Posted in Power View/Project Crescent, SQL Server 2012, SQLServerPedia Syndication | 8 Comments

SQL Server 2012 (“Denali”): Reporting Services in SharePoint integrated mode

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

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

SQL Server 2012 released!

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

Posted in SQL Server 2012, SQLServerPedia Syndication | 1 Comment