Most Recent Blog Posts

Jun 09, 2012

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
May 18, 2012

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
Apr 27, 2012

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
Apr 05, 2012

Dive into SQL Server 2012 EIM Tools (DQS)

Prior to SQL Server 2012, Microsoft DW....More
Mar 06, 2012

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
Mar 06, 2012

Taking PowerPivot to the Enterprise

SQL Server 2012 adds even more enterprise capabilities to this PowerPivot model of Microsoft BI solutions....More
Dec 27, 2011

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
Oct 06, 2011

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
Sep 13, 2011

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
Aug 20, 2011

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
Aug 03, 2011

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
Jul 21, 2011

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
Jul 01, 2011

All the Pieces: Microsoft Cloud BI Pieces, Part 5 (FINAL 5 of 5)

A look into the future of Microsoft Cloud BI: SQL Server Data Mining in the Cloud, BI 3.0: Social BI and Cloud BI in SQL Server 2012....More
Jun 01, 2011

All the Pieces: Microsoft Cloud BI Pieces, Part 4

Learn to to deploy Microsoft Cloud business intelligence (BI) dashboards solely in the cloud, via Microsoft’s Azure platform....More
SQL Server Open Report screenshot
May 12, 2011

All the Pieces: Microsoft Cloud BI Pieces, Part 3

An examination of the new Azure Reporting Services CTP (beta) that enables SSRS-like reporting services in the cloud with Windows Azure and SQL Azure....More
Contributors

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) ×