Monthly Archives: March 2013

SQL Server 2012 Business Intelligence Enhancements

Posted on March 28, 2013 by

My first article in SQL Server Pro magazine has been published.  It is entitled “SQL Server 2012 Business Intelligence Enhancements” and can be found here.  I hope you enjoy it!

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

TFS vs SSIS project versioning

Posted on March 26, 2013 by

I had someone ask me the other day if they are using SSIS 2012 Project Versions, is there any benefit to using TFS?  The answer is Yes!  While Project Versions is a new feature that keeps prior versions of SSIS … Continue reading →

Posted in SQLServerPedia Syndication, SSIS, Team Foundation Server | Leave a comment

Benefits of using views in a BI solution

Posted on March 19, 2013 by

Using SQL Server views throughout a Business Intelligence (BI) solution can provide a tremendous amount of benefits.  Here is a list of such benefits, taken in large part from the excellent video SQLBI Methodology by Marco Russo and Alberto Ferrari: Benefit … Continue reading →

Posted in Business Intelligence, SQLServerPedia Syndication | Leave a comment

Why you need Business Intelligence

Posted on March 14, 2013 by

First lets define what Business Intelligence (BI) is.  My favorite definitions: Forrester Research: “Business Intelligence is a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information used to enable more effective strategic, tactical, … Continue reading →

Posted in Business Intelligence, SQLServerPedia Syndication | Leave a comment

Top BI Enhancements for SQL Server 2012 Presentation Slides

Posted on March 12, 2013 by

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

Parallel Data Warehouse (PDW) Version 2

Posted on March 12, 2013 by

Version 2 of Parallel Data Warehouse (PDW) is apparently due this month (and can be ordered as of March 1st).  The official name is Microsoft SQL Server 2012 Parallel Data Warehouse. Info on HP’s version: HP AppSystem for Microsoft SQL Server 2012 Parallel … Continue reading →

Posted in PDW, SQLServerPedia Syndication | Leave a comment

Top BI Enhancements for SQL Server 2012 Presentation

Posted on March 8, 2013 by

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

Profisee Master Data Maestro

Posted on March 7, 2013 by

I have been using Microsoft’s Master Data Services (MDS) on a daily basis for the last 8 months.  I also have been using Microsoft’s Data Quality Services (DQS) for the last couple of months.  While both products are very good and … Continue reading →

Posted in DQS, MDS/MDM, SQLServerPedia Syndication | 2 Comments

Visual Studio 2012 now supports BI!

Posted on March 6, 2013 by

My most popular blog has been Visual Studio 2012 does not support BI.  In short, this means VS 2012 does not support SSAS, SSIS, or SSRS.  Well, not anymore!  Just released is Microsoft SQL Server Data Tools – Business Intelligence for … Continue reading →

Posted in Business Intelligence, SQL Server, SQLServerPedia Syndication, SSAS, SSDT/Juneau, SSIS, SSRS, Visual Studio 2012 | 8 Comments

Microsoft Data Explorer

Posted on March 5, 2013 by

Data Explorer (download), which I first mentioned in my blog about PASS Summit 2011 (SQL Server 2012 and other PASS announcements), has finally taken the next step and is now a public preview. Think of Data Explorer as a self-service ETL … Continue reading →

Posted in Excel, SQLServerPedia Syndication | 1 Comment