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…

0

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…

1

DQS: Create a New Knowledge Base

[View:https://www.youtube.com/watch?v=BXaXN5JHvGw] 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.

0

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,…

3

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…

0

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…

5

Data Quality in SQL Server 2012 Part 1: Introducing Master Data Management

Data quality is important and data quality mistakes can be expensive. Imagine a situation where a company has two systems, each with their own data set. One system is for CRM, the other is a financial system. Both systems have information about customers. Now an employee needs to send an invoice to a customer. What…

2

SQL Server 2012 Webcasts

Myself and colleagues (mostly Sam Solieman, but also will Thompson) have been running a series of webcasts on SQL Server 2012. The ones we’ve run so far have been recorded, so you can watch them on demand. The recordings are on the Partner Learning Center, so you’ll need a Microsoft partner login to access them. The…

0

SQL Server 2012 Customers

The SQL Server team blog has posted recently about customers using SQL Server 2012 today. This post has five case studies of big customers who are on the early adopters programs for SQL Server, putting to use the new features of SQL Server 2012.

0

SQL Server comments video

This nice video has people giving their comments on their favourite features of SQL Server 2012. [View:https://www.youtube.com/watch?v=nhrsBc6RsjA]

0