Build Schedule

Advanced Filters:
  • Track

    clear all




  • Speaker


  • Level


  • Session Type

Sessions Found: 10
At the heart of Kimball’s method, business dimensional modeling has been the dominant technique for data warehouse presentation for years; moreover, with the last two releases of SQL Server, ties between some of SQL Server products and features and Kimball’s dimensional model have grown stronger. This session is an introduction to business dimensional modeling, and provides the attendee a foundation of what dimensional models are and how they fit in the data warehouse lifecycle. Key concepts are illustrated through real world scenarios while some SQL Server 2008 data warehouse relevant features are identified.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you ever wish you could get an X-Ray view of your sluggish SQL Server?
Take the guesswork out of troubleshooting database issues by utilizing the
data collected in Dynamic Management Views. In this session, Whitney
Weaver will show you the tools implemented in SQL Server 2005 that give you
extraordinary view into the health and well being of your database instance.
Code samples will be presented around query performance, I/O utilization,
index usage, and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SQL DBA

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

New to SQL?  Check out Microsoft's free versions of SQL Server Express.  We will discuss the differences between 2005 and 2005 SQL Express versions and walk through the installation process.  We'll also learn some basic SQL commands and how you can use SQL Express at home and in your next web project.
Speaker:

Session Type:
Regular Session

Track:
SQL Development

Level: Beginner

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Intent of this session is to demostrate use of smart reports to present datamining results. Reports can be used to analyze historical patterns, review trends and present predictions.These reports use analysis services, CLR stored procedure and reporting services. [Note: Concept of this article comes from the book, Applied Microsoft Analysis Services, by Teo Lachev]
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the common issues encountered with SSIS is deploying configurations for multiple environments. During this session, 3 patterns for handling configurations in SSIS will be covered. from a simple pattern that handles most cases, to a very flexible pattern that covers most complex scenarios. Learning and using these patterns will allow SSIS developers to more easily deploy packages between environments, and leverage a single point of configuration in each environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Performance Point 2007 Server is a powerful tool that allows the Business Analyst to define and create the relational and analysis data structures, forms, reports and dashboards with simple wizard driven tools.  The Information Technology folks still need to integrate these solutions into existing databases.  Based on real world experience building large enterprise Performance Point Planning and Monitoring solutions, this guides through the pitfalls and key issues involved with integrating Performance Point 2007 Server into your current Data Warehouse environment.  Key topics include The Business Model, Data Staging, Data Loading, Data Validation, PPS Command Line (PPSCMD), and Key Tips and Tricks for tying these all together using SQL Serv
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the new features in SQL Server 2008 is the resource governor.  With increasingly consolidated SQL Server environments, and particularly with applications with complex performance requirements, this new feature will provide more fine grained control over how your solutions work.  During this session we will review the functionality included in this feature, identify scenarios where it can be used, and show how to implement it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SQL DBA

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the roles of Business Intelligence for Retailers is to determine buying patterns based on customer demographics.  This type of analysis though can quickly create very large cubes above 600 Gigabytes and often between 1 to 4 Terabytes.   Based on real world experience with two major retailers, this talk will discuss key design tips and best practices for building these large cubes so the data can be accessed in a timely manner.  Key topics covered include vertical and horizontal partitioning, necessary key parameters, and custom aggregations.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SQL DBA

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Database auditing is something everyone would like their databases to do, but implementing it without slowing data access down can be difficult.  In this session I will show you how to use the CLR to create triggers that do not have a big performance hit and do not have to be rewritten if the tables change.
Speaker:

Session Type:
Regular Session

Track:
SQL Development

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Data quality is one of the most challenging aspects of constructing a reliable data warehouse / business intelligence solution. SQL Server Integration Services 2008 introduces the Data Profiling Task, which can be used to help improve the data quality in the ETL process itself. This session will cover the use of the Data Profiling Task to gather initial quality metrics from both source systems and the warehouse. It will also cover how to incorporate data profiling into the ongoing ETL process to continue gathering quality metrics on new data, and to build dynamic data quality rules that adjust themselves based on the current quality measures.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Advanced

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 10
Back to Top cage-aids
cage-aids
cage-aids
cage-aids