Meeting Sponsor:  Magenic

Click here to RSVP

Location: 3601 West 76th Street, Suite 600 Edina, MN  55437

Live Meeting: 

• URL: https://www.livemeeting.com/cc/usergroups/join?id=H8JST2&role=attend&pw=rz%26R*ZSN9
• Meeting ID: H8JST2
• Entry Code: rz&R*ZSN9

 Agenda:

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

Presentation:

Data Quality Services

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.

Jeff Prom is a Senior Consultant with Magenic Technologies in Minneapolis. He holds a bachelor’s degree, three SQL Server certifications, and is an active PASS member. Jeff has been working in the IT industry for over 14 years and currently specializes in data and business intelligence.

Presentation:                                                

Ola Hallengren's SQL Server Maintenance Solution

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

Rizwan Hassan is a Database Administrator with Kroll Ontrack in Eden Prarie. He has been working with SQL Server since 2010.  Rizwan was introduced to SQL Server and mentored by, PASSMN's Director of Program Development, Tim Plas.