Facebook Twitter LinkedIn YouTube E-mail
Home Microsoft Archive for category "SQL Server 2012" (Page 5)
formats

Introduction to SQL Server 2012 “ColumnStore” Index (Part I)

Share

Overview Is “ColumnStore” a new idea? No, it has been around for years, and even dates back to the 1970s. Is this new for SQL Server Database? Yes, it was newly introduced into the SQL Server database engine in SQL Server 2012. This new idea combining with other enhancements in algorithm and execution plan can

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
2 Comments  comments 
formats

Using Data Quality Services to Cleanse Source Data in Integration Services

Share

So far we’ve seen various methods of cleansing source data using Data Quality Services. One of the main applications of DQS is in SQL Server Integration Services. This is where source data can be cleansed using the knowledge bases maintained in the DQS client by launching the DQS cleansing transform available in Integration Services. This blog gives

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Using Data Quality Services to Cleanse Source Data in Integration Services  comments 
formats

Cleansing Source Data in Data Quality Services Using Cloud Based Knowledge Base

Share

In my previous post, I showed how Data Quality Services can be utilized to cleanse and build high quality data by creating a Knowledge Base. For this post I will show you how to utilize a cloud based Azure Data Market subscription to build a Knowledge Base domain in Data Quality Services and utilize it for cleansing

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Cleansing Source Data in Data Quality Services Using Cloud Based Knowledge Base  comments 
formats

Healthcare BI Summit Presentation Links

Share

This post is a follow-up to today’s presentation at the Healthcare BI Summit in Minnesota.  The following links provide additional details and reference materials for both the demonstrations and methodologies discussed during the presentation, and for the GNet Group SightN2 for Healthcare: GNet Group Links and References GNet Group’s Agile BI On-Demand Webinar Video Preview

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Healthcare BI Summit Presentation Links  comments 
formats

Generating High Quality Source Data Using Microsoft Data Quality Services Knowledge Base

Share

In the previous post on DQS, you can see how to setup the DQS server client application for starting a data quality activity. Now that the configuration is done, the next step is to create and maintain a knowledge base within the DQS client application for providing a reference dataset for the data cleansing activity.

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Generating High Quality Source Data Using Microsoft Data Quality Services Knowledge Base  comments