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