Monthly Archives: March 2012

DQS – Using the Changes History Panel

DQS – Using the Changes History Panel

The DQS client will automatically sort the list of Domain Values, which can make adding new values to a big list tricky. Once you enter the new value at the bottom of the list, it gets automatically sorted, and you need to scroll up the list to find it again. However, there is a better … Continued

Microsoft SQL Server 2012 Integration Services

Microsoft SQL Server 2012 Integration Services

I’m happy to see that my second SSIS book for the SQL Server 2012 release has been announced! SQL Server 2012 Integration Services  is published by Microsoft Press (and O’Reilly), and gives you a real insiders view of the product. My co-authors are all members of the SSIS product team, and we’ve really dug deep … Continued

Training Scholarships for SQL Saturday #111 in Atlanta

Training Scholarships for SQL Saturday #111 in Atlanta

Julie Smith announced that Idera is offering full training scholarships for each of the three Pre-Con training events at SQL Saturday #111 (Atlanta). One of those sessions – A Day of SSIS – is one I’ll be doing along with Andy Leonard. This is a great opportunity for someone who might not have gotten to … Continued

Getting Started with DQS and MDS

If you’re looking to get started with Data Quality Services (DQS) and Master Data Services (MDS), there are some fantastic resources available on Technet. The site includes videos and slides for full day training sessions on both products. Data Quality Services for SQL Server 2012 Data Quality Basics and Introducing DQS: Video | Slides Knowledge … Continued

AlwaysOn Multi-Subnet Failover and SSIS

Updated 2012-05-11: Updated the .NET Framework update link to point to 4.0.3, as it has some additional updates for AlwaysOn. If you plan on using Multi-Subnet Failover Clustering, note that the SQL Native Client 11.0 OLEDB provider does not support the new connection string key words (MultiSubnetFailover=True). Instead you should use the ADO.NET or ODBC … Continued

Data Quality Services Performance Best Practices Guide – now available!

The Data Quality Services (DQS) Performance Best Practices Guide (or DQSPDPG for short) is now available on the Microsoft Download Center. It covers hardware and setup considerations, how matching policies will impact your performance, and some best practices when using the DQS Cleansing transform in SSIS. I was also happy to see a section in … Continued