Business Intelligence Practice Accelerator

Starting on the 3rd September, Microsoft are running a Business Intelligence Practice Accelerator. This is an online training offering for partners around building a BI practice and delivering our BI technologies. This is a new structure of Practice Accelerator, consisting of 3 online workshops, each 2 hours long, as well as an array of on-demand…


PASS SQLRally Nordic 2012

Kamal Hathi, Microsoft Director of SQL Server Business Intelligence, will be delivering the keynote at the SQLRally event in Copenhagen from 1st to 3rd October 2012. The agenda is available on the SQL PASS website, including the pre-conference activities. This conference will involve several prominent Microsoft speakers, local MVPs and a range of content across capabilities…


Data Quality in SQL Server 2012 Part 5: Master Data Services Excel Add-In

In the previous post in this series (sorry for the delay), I talked about the Client for DQS. It seems appropriate then that I introduce the desktop client for MDS. In this case, the client is Excel, through a freely-downloadable add-in that runs in Excel 2007 or 2010. You can download the add-in from the…


SharePoint Conference 2012 Giveaway

A company called Share Squared are running a competition to win a full conference pass to the Microsoft SharePoint Conference 2012 in Las Vegas this November. There are other prizes, including SharePoint Composer, an Xbox 360 and Starbucks gift cards. You can enter the competition here: If you don’t win the competition, you can…


SharePoint on Azure

The PointBeyond blog recently posted an interesting piece on running SharePoint on Azure. This piece covers setting up a virtual machine environment on Azure for running a Multi-Server SharePoint Farm. The post can be found here and is useful reading if you’re thinking about putting SharePoint onto the Azure platform.


PowerPivot: Sort by column

Sometimes there are measures which have an intrinsic order to them, such as days of the week or month of the year. However, this order is not always known by the technology being used to represent data by those values. For example, if I was to create a pivot table plotting some value against month…


DQS: Create a New Knowledge Base

[View:] This is the first video I’ve done on Data Quality Services. It shows how to get started with DQS by creating a new knowledge base and running knowledge discovery on a sample data set.


Data Quality in SQL Server 2012 Part 4: Data Quality Services Client

Data Quality Services, introduced in the previous blog post, includes two main components: DQS Server and DQS Client. There’s also a DQS Cleansing transformation included in SSIS in SQL Server 2012, but I won’t be going into that in this post. In this post, I’ll be talking about these two, core components. At its simplest,…


Data Quality in SQL Server 2012 Part 3: Introducing Data Quality Services

The previous two blog posts have been focusing on Master Data Services. Given the title of this series, it would be remiss of me to forget Data Quality Services, the second piece of the data quality story in SQL Server 2012. Data Quality Services is a new set of functionality in SQL Server 2012, based…


Data Quality in SQL Server 2012 Part 2: Introducing Master Data Services

In the previous blog post, I introduced the concept of Master Data Management as a methodology to improve data quality by creating a “master” version of important information. Master Data Services is Microsoft’s technology for implementing Master Data Management. It is included in SQL Server 2008 R2 Enterprise and SQL Server 2012 Enterprise and Business…