Wednesday, January 18, 2012

New SQL Server and SharePoint Sessions Added

We’re going to be adding more sessions to the schedule this week, and we’re kicking it off with the three below:

Mike Diehl will be presenting two SQL Server based talks:

SQL Server 2012 Data Quality Services

Data Quality represents the degree to which the data is suitable for usage in the required business processes. The quality of data can be defined, measured and managed through various data quality metrics such as completeness, conformity, consistency, accuracy, and duplication. Improved data quality is achieved through people, technology and processes. Learn how SQL Server Data Quality Services (DQS) provides approachable data quality capabilities for organizations of all sizes to help improve the quality of their data. DQS is designed to help ensure data quality through the profiling, cleansing, and matching of critical data.

Patterns and Practices for developing SQL Server 2008 Integration Packages to Populate Data Warehouses

Integration packages perform extract, transform, and load (ETL) operations to bring data from an operational database to a data warehouse. I will show the patterns and practices I use to develop these packages:

  • Naming Conventions
  • When to use the Slowly-changing-dimension task
  • Using stored procedures and views in the source and target databases for integration purposes
  • Using the Lookup task.
  • Incremental extractions
  • Snapshot extractions
  • Change tracking in source, and extraction tracking in target
  • Making packages idempotent
  • Package configurations
  • Deployment and execution
  • Custom SSIS task development

And Kanwal Khipple will be presenting on SharePoint:

Optimizing SharePoint 2010 for Internet Sites.

This session is for you whether you have an existing public facing site that you want to replace or you are new to the world of .com. We’ll also discuss how to configure public facing sites, what security needs to be place and what features to leverage. We will also focus on the needs of your visitors and how to ensure a consistent experience. After this session, you'll have the knowledge to tackle the following key areas: Performance optimization, SEO, Branding Guidelines, Technical Architecture

Don’t forgot our January discounted price ends in less than two weeks, so register today!

www.prairiedevcon.com

No comments:

Post a Comment