The next Minnesota SQL Server User Group meeting is next Tuesday on October 16. This month there will be two presentations, one on a SQL database maintenance plans and the other on a new feature that was added in SQL Server 2012, Data Quality Services (DQS). Be sure to register so that your name badge will be available for you at the Microsoft Technology Center when you arrive.
Date/Time: Tuesday, October 16 from 4 to 6 p.m.
•Meeting ID: H8JST2
•Entry Code: rz&R*ZSN9
•4:00-4:15 : Registration / hospitality / networking
•4:15-4:45 : Ola Hallengren’s SQL Server Maintenance Solution
•4:45-5:45 : Data Quality Services
•5:45-6:00 : Announcements and prize giveaways
Ola Hallengren’s SQL Server Maintenance Solution (Rizwan Hassan, DBA at Kroll Ontrack)
DBAs are inconstantly using SQL Server standard maintenance and custom maintenance plans to maintain SQL environments. Ola Hallengren has been generous enough to contribute his maintenance plans which are not only effective, but also can be customized to meet small to large SQL environments. These plans have won SQL Server Magazine 2011 Gold Community Choice and Silver Editors’ Best awards. The Ola’s maintenance plans cover:
- SQL Server Backups
- SQL Server Integrity Checks
- SQL Server index and Statistics Maintenance
Data Quality Services (Jeff Prom, Senior Consultant at Magenic) – As the old adage goes, ‘Garbage in, garbage out.’ Stop spending hours manually cleansing your data, and start using Data Quality Services! DQS is the new data quality tool provided with SQL Server 2012. In this session we will cover topics such as creating a knowledge base, data cleansing, data matching, and using 3rd party knowledge bases (Reference Data). We will talk about installation, show how to use the DQS tool, the Excel Add-in, and how to integrate DQS into your SSIS packages.