Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Archive for October 10th, 2012

PASSMN October 2012 Meeting

Posted by denglishbi on October 10, 2012

[tweetmeme source=”denglishbi” only_single=”false”]

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.

Minnesota SQL Server Users GroupThe sponsor for this month’s meeting is Magenic.

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

Date/Time: Tuesday, October 16 from 4 to 6 p.m.

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


•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

Please click here for meeting details and to RSVP for the event


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.

Posted in Training | Tagged: , , | Leave a Comment »