Presenter: Brian Knight
bknight@pragmaticworks.com
Is your customer looking for drag and drop reports or capabilities inside of Excel. SQL Server Analysis Services (SSAS) is the answer for you then. You’ll be amazed how quickly you can develop sophisticated reports after watching the basics of this session. Read the rest of this entry »
Popularity: 11% [?]
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% [?]
Hey there everyone. Have I got a treat for someone out there.
Are you a SQL Server DBA, Developer, Report Writer?
Do you align with a desire to spread God’s Word?
Do you love working in an evolving/energetic environment? Read the rest of this entry »
Popularity: 11% [?]
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% [?]
