sqlsathistory

Nr: 9

SQLSaturday #9 - Greenville 2008

Start Time (24h)	Speaker	Track	Title
00:00:00	David Darden	SQL DBA	Resource Governor in SQL Server 2008
00:00:00	Jason Burton	SQL Development	Getting Started with SQL Express
00:00:00	John Welch	Business Intelligence	Patterns for SSIS Configurations
00:00:00	John Welch	Business Intelligence	Using Data Profiling to Improve ETL
00:00:00	Lee Johnson	SQL Development	SQL Server 2005 Auditing Using the CLR
00:00:00	Rob Schoenborn	SQL DBA	Scaling SQL Server for Large Datamarts
00:00:00	Rob Schoenborn	Business Intelligence	Performance Point 2007 Server Data Integration
00:00:00	Tejas Patel	Business Intelligence	Implementing Smart Reports with MS BI Platform
00:00:00	Whitney Weaver	SQL DBA	Dynamic Management Views Will Save Your Life

SessionID: 35091

Resource Governor in SQL Server 2008

Back to calendar

Event Date: 11-10-2008 - Session time: 00:00:00 - Track: SQL DBA

Speaker: David Darden

Title: Resource Governor in SQL Server 2008

Abstract:

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.

SessionID: 35147

Getting Started with SQL Express

Back to calendar

Event Date: 11-10-2008 - Session time: 00:00:00 - Track: SQL Development

Speaker: Jason Burton

Title: Getting Started with SQL Express

Abstract:

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.

SessionID: 35213

Patterns for SSIS Configurations

Back to calendar

Event Date: 11-10-2008 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: John Welch

Title: Patterns for SSIS Configurations

Abstract:

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.

SessionID: 35216

Using Data Profiling to Improve ETL

Back to calendar

Event Date: 11-10-2008 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: John Welch

Title: Using Data Profiling to Improve ETL

Abstract:

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.

SessionID: 35294

SQL Server 2005 Auditing Using the CLR

Back to calendar

Event Date: 11-10-2008 - Session time: 00:00:00 - Track: SQL Development

Speaker: Lee Johnson

Title: SQL Server 2005 Auditing Using the CLR

Abstract:

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.

SessionID: 35399

Scaling SQL Server for Large Datamarts

Back to calendar

Event Date: 11-10-2008 - Session time: 00:00:00 - Track: SQL DBA

Speaker: Rob Schoenborn

Title: Scaling SQL Server for Large Datamarts

Abstract:

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.

SessionID: 35400

Performance Point 2007 Server Data Integration

Back to calendar

Event Date: 11-10-2008 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Rob Schoenborn

Title: Performance Point 2007 Server Data Integration

Abstract:

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

SessionID: 35457

Implementing Smart Reports with MS BI Platform

Back to calendar

Event Date: 11-10-2008 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Tejas Patel

Title: Implementing Smart Reports with MS BI Platform

Abstract:

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]

SessionID: 35514

Dynamic Management Views Will Save Your Life

Back to calendar

Event Date: 11-10-2008 - Session time: 00:00:00 - Track: SQL DBA

Speaker: Whitney Weaver

Title: Dynamic Management Views Will Save Your Life

Abstract:

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.

This site is open source. Improve this page.