You are browsing the archive for Data Quality.

Dec 15th Meeting – Douglas Johnston – SQL Server Denali (SQL Server 2012)

November 27, 2011 in Meetings

When: Thursday, Dec 15th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

This month, Douglas Johnston introduces the new version of SQL Server, codename Denali.  From T-SQL additions to the new Integration Services designer, from Master Data Services to the new Visual Studio project types, he will walk through a real-world example of each.  As Douglas is also currently implementing all of these for a client, he will also demonstrate the pitfalls and bugs of the pre-release software.  If you are considering upgrading to SQL Server 2012, this session will give you great information on what the benefits and the risks are.

Douglas Johnston is a Group Manager in the Business Intelligence & Collaboration Service Line of Avanade. With 10 years of experience with SQL Server and business intelligence tools, in industries as diverse as healthcare, financial services, defense and energy utilities, he has become one of the leading contributors to the Avanade BI community. He advises on, and develops projects with, aspects of database development, performance tuning, architecture, warehouse design and management, high availability, ETL and reporting systems. He is also a founding member of the peer-nominated Avanade Expert Network and holds several Microsoft certifications.

Before becoming a database ninja, Douglas developed with VB6, Perl, Oracle, Business Objects and J2EE, as well as some other really terrible technologies. He has particularly desiccated sense of humor to go with the British accent, owns a kilt, and likes monkeys.

Register for Memphis PASS Chapter Meeting - Douglas Johnston – SQL Server Denali in Memphis, TN  on Eventbrite

Number of View :7446

June 9th Meeting – Brian Ringley – Data Warehouse Data Quality

June 2, 2011 in Meetings

A major challenge for any BI data warehousing project is issues with data quality. Often times business users expect the IT departments to simply clean up the data without providing any other input or information. Unfortunately, IT often needs business rules in order to decide how to clean up the data. Without the proper business rules the data cleansing project can take longer to complete or even fail. A way to avoid this situation is to “empower” the business users and give them a way to manage their own data.

Brian Ringley, a Solution Architect at PointBridge Solutions, will present a simple method to allow users to manage their own data using SharePoint and SQL Server Integration Services. There are many Master Data Management tools available in the market, however, these are often expensive or difficult to use. Allowing users to manage their data within SharePoint allows them to use an environment they are comfortable with and leverage other out of the box SharePoint functionality.

Number of View :1107

Switch to our mobile site