Tech4Him – Technology with Integrity

Presenter: Matt Masson
http://blogs.msdn.com/mattm/

This talk describes the new MERGE statement and Change Data Capture (CDC) feature introduced in SQL Server 2008, and how to take advantage of them in SQL Server Integration Services. Well cover the traditional ways of doing incremental data loads, and see how these new key features make the process a whole lot easier. If you’re interested in learning best practices for this new SQL Server 2008 functionality, you won’t want to miss this session! Read the rest of this entry »

Popularity: 15% [?]

Presenter: Brian Knight
bknight@pragmaticworks.com
Owner, Pragmatic Works

In this session, you’ll learn how to load a typical data warehouse in SSIS efficiently. You’ll start by seeing some of the strengths and weaknesses of the Slowly Changing Dimension (SCD) Wizard in SSIS and how you can get around some of the weaknesses including your own home-brewed solution. You’ll then see how to load a fact table using SSIS and how to make the common components scale. Read the rest of this entry »

Popularity: 21% [?]

Presenter: Thomas LaRock
Database Administration Manager
ING Investment Management

In SQL 2008, Maintenance Plans create a workflow of tasks to ensure your database is optimized and backed up on a regular schedule. The Maintenance Plan will create an SSIS package that will be scheduled and run with SQL Agent. Attend this session and learn how Maintenance Plans will ease your administrative overhead. Read the rest of this entry »

Popularity: 5% [?]

Presenter: Erik Veerman
erik@solidq.com

In a Business Intelligence solution, the fact tables hold the core data that you are analyzing – facts (also called measures). Therefore, fact tables are a critical component to get right the first time. Poor fact table design will lead to poor performance and difficult calculations. This session dives into fact table and considers the basic column types, measure aggregation types, fact table types, and volume considerations. Read the rest of this entry »

Popularity: 4% [?]

Presenter: Erik Veerman
erik@solidq.com

Dimension Tables are one of the core components in a dimensional design and it is critical to design your dimension tables correctly in order to lay a solid foundation to a Business Intelligence system. This session dives into the dimension design techniques and considers the core components of a dimension table, surrogate keys, attributes, and hierarchies. In addition, we will consider advanced hierarchy types such as parent-child hierarchies, snowflake designs and unbalanced hierarchies. Finally, we will consider the best practices in tracking changes historically. Read the rest of this entry »

Popularity: 7% [?]

Presenter: Erik Veerman
erik@solidq.com

This session focuses on the basic design patterns for building relational database structures for Business Intelligence applications on SQL Server. By laying the foundation to dimensional modeling, this session provides an overview of dimension modeling theory and the justification of dimension modeling by reviewing the core structures involved in data marts and data warehouses and contrasting these design techniques to other types of systems. If you are new to Business Intelligence or feel you need a refresher on dimensional modeling, this session is for you. Read the rest of this entry »

Popularity: 5% [?]

Presenter: Jeremy Lull
Jeremy@datarealized.com

DMV – Dynamic Management Views (and functions)

• Returns server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.* MSFT – 2008 BOL Read the rest of this entry »

Popularity: 5% [?]

Presenter: Craig Utley
craig@solidq.com

DB –> SSIS –> Relational Data Warehouse –> SSAS (Cubes) –> SSRS

Data Sources

• SSAS Projects have one or more data sources that point to data in some physical format
• Data sources should impersonate a domain use with least privileges for the purpose of accessing data. Read the rest of this entry »

Popularity: 3% [?]