Opinions, tips, and news orbiting Microsoft
First published on MSDN on Mar 14, 2013
Data Quality Services (DQS) internally stores the domain values in a knowledge base in the Unicode format, and uses the trigram algorithm, which is language agnostic, to compare the domain va… Continue reading Languages supported by DQS for Cleansing and Matching
First published on MSDN on Mar 06, 2013
Today we are releasing SQL Server Data Tools – Business Intelligence for Visual Studio 2012 (SSDT BI) templates. With SSDT BI for Visual Studio 2012 you can develop and deploy SQL Server Busi… Continue reading SQL Server Data Tools – Business Intelligence for Visual Studio 2012 released online
First published on MSDN on Dec 18, 2012
There is now a SSIS 2012 version of the “Creating a Simple ETL Package Tutorial”. The tutorial and lesson packages work with the AdventureWorksDW2012 database. And, the tutorial includes… Continue reading SSIS 2012: Creating a Simple ETL Package Tutorial
First published on MSDN on Dec 06, 2012
In SQL Server 2012, you can use the catalog.deploy_project stored procedure to deploy an SSIS project to the SSIS server. You need to provide the binary contents of the project deployment fil… Continue reading Deploy SSIS 2012 projects using catalog.deploy_project Stored Procedure
First published on MSDN on Nov 29, 2012
This post provides information about the Data Quality Services (DQS) improvements in the SQL Server 2012 Service Pack 1 (SP1) release, and step-by-step instructions to upgrade your curre… Continue reading Upgrading DQS to SQL Server 2012 Service Pack 1 (SP1) Release
First published on MSDN on Oct 16, 2012
I’ve recently updated the SSIS documentation in Books Online (BOL), to add some details around setting SQL Agent job options for packages stored in the SSIS catalog, as well as in MSDB and th… Continue reading Scheduling SSIS Packages and SSIS Catalog Reports — Doc Updates
First published on MSDN on Oct 08, 2012
This post provides you information on how to use the pattern matching rules in DQS while creating domain rules. These are the four pattern matching rules in DQS:
First published on MSDN on Sep 20, 2012
When you upgrade to SQL Server 2012 Integration Services (SSIS) on a machine that has SSIS 2005 or 2008 installed, SSIS 2012 is installed side-by-side with the earlier version. Unlike upgrade… Continue reading Important Note about Upgrading to SSIS 2012