Most Recent Blog Posts

11/11/2012 - 2:25pm

Big Data Analytics with Hive, Windows & SQL Server

Big Data has become one of the most over-used and over-loaded terms in IT and data management in recent years. Since we focus on business....More
07/11/2012 - 10:57pm

SQL Server 2012 BI with SQL System Center Data Warehouse

A great way to monitor and manage large SQL Server enterprise environments is with the Microsoft System Center Suite, particularly monitoring the....More
06/22/2012 - 11:10pm

Add a Power View Web Report to Your PPS Dashboards

One of the most exciting and talked-about updates to SQL Server 2012 is SSRS 2012 and the new Power View reporting tool. If you’ve built existing BI....More
06/09/2012 - 4:57pm

Microsoft Cloud BI Update 2012

It’s been a little while here on the SQL Server Pro Mag BI Blog since I’ve provided any updates on the state of Cloud BI in the world of Microsoft BI....More
05/18/2012 - 9:34am

Publishing Tabular Models to SSAS

This is a follow-up from my blog post last month here on SQL Server Pro about utilizing common traditional reporting tools like Excel and Report....More
04/27/2012 - 12:59pm

Report Builder and Tabular Model Databases

Here is an easy way to leverage your existing skills in traditional SQL Server reporting tools with the new Tabular Mode of SQL Server Analysis....More
04/05/2012 - 9:30pm

Dive into SQL Server 2012 EIM Tools (DQS)

Prior to SQL Server 2012, Microsoft DW....More
03/06/2012 - 9:07am

Updated SQL Azure Reporting Services CTP

One thing that I really liked in this CTP is that I am able to manage users so that I was able to make demo users who can access my reports from my....More
03/06/2012 - 9:04am

Taking PowerPivot to the Enterprise

SQL Server 2012 adds even more enterprise capabilities to this PowerPivot model of Microsoft BI solutions....More
12/27/2011 - 4:39pm

An Introduction to Power View in SQL Server 2012 RC0

What is Power View? Power View is a brand new Silverlight browser-based reporting tool that is currently scheduled to ship with SQL Server 2012....More
10/06/2011 - 3:47pm

SSIS Version Control Made Easy in Denali

For those SQL Server and development shops that have built a lot of SQL Server Integration Services (SSIS) packages out there and have utilized....More
09/13/2011 - 3:38pm

SQL Server Denali Dependencies & Lineage

I’ve been a long-time advocate and big proponent of having a mechanism in my end-to-end BI solution that can show me what has changed and what will....More
08/20/2011 (All day)

How Can SQL Server Denali Columnstore Indexes Help Your BI Solution?

In the world of data warehouse specific databases, column-oriented databases (as opposed to the classic row-based databases) are becoming very....More
08/03/2011 - 3:39pm

Master Data Services in SQL Server Denali - Preview in CTP3

Here is a quick peek at some of the enhancements to Master Data Services (MDS) in SQL Server Denali as of CTP3....More
07/21/2011 - 3:07pm

Shortening Load Times in SQL Server DWs

The struggle to separate operational reporting against an ODS or a reporting schema from BI reporting against a data warehouse continues to confound....More

Mark Kromer

Mark Kromer has been a technical product manager & solution architect in business intelligence, data warheouse and Big Data world for over 20 years for Microsoft, Oracle and AT&T, currently...

Jen Underwood

Jen Underwood, Founder and Principal Consultant at Impact Analytix, has almost 20 years of experience in data warehousing, business intelligence, and predictive analytics. She is a former Global...
What's SQL Server BI Blog?

Derek Comingore’s, Mark Kromer's, and Jen Underwood's candid look at SQL Server’s Business Intelligence features.

Blog Archive

Sponsored Introduction Continue on to (or wait seconds) ×