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 features, and never...

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: Two new Professional-level certifications will...

Career advice for the IT professional...

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). Th...

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 ...

Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at HASSUG. Here is the PowerPoint presentation: Scaling SQL Server to HUNDREDS of Terabytes As a followup to a question from the pre...

Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at HASSUG. Here is the PowerPoint presentation: Scaling SQL Server to HUNDREDS of Terabytes As a followup to a question from the presentation about clusterin...

What is the best methodology to use when creating a data warehouse?  Well, first off, let’s discuss some of the reasons why you would want to use a data warehouse and not just use your operational system: You need to in...

What is the best methodology to use when creating a data warehouse?  Well, first off, let’s discuss some of the reasons why you would want to use a data warehouse and not just use your operational system: You need to integrate many different so...

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 ...