sqlsathistory

Nr: 13

Back to Main list

SQLSaturday #13 - Atlanta 2009

Start Time (24h) Speaker Track Title
00:00:00 Andy Warren DBA Introduction to SQL Server Statistics
00:00:00 Robert Cain Development Introduction to Data Warehouse Concepts
00:00:00 Robert Cain Development 2 Introduction to SQL Server Full Text Searching
00:00:00 Robert Cain BI Introduction to SQL Server Integration Services
00:00:00 Curtis Smith BI 2 SSRS Working with Images and Subreports
00:00:00 Louis Davidson Development Why Normalization Matters
00:00:00 Erik Veerman BI 2 SSIS Internals and Optimization
00:00:00 Janis Griffin DBA 2 Wait-Time SQL Server Performance Management
00:00:00 Joe Celko Development Nested Sets Model - Trees Hierarchies in SQL
00:00:00 Jen Underwood BI How to Build Analysis Services Cubes (2005/2008)
00:00:00 Jen Underwood BI Building Reporting Services and Excel Reports
00:00:00 Brian Kelley BI Fortress SQL Server
00:00:00 Kendal Van Dyke Development XML Features in SQL 2005
00:00:00 Kendal Van Dyke DBA Disk Performance Hands On
00:00:00 Kevin Kline DBA End-to-End Troubleshooting
00:00:00 Kevin Kline BI Surviving the Data Avalanche
00:00:00 Mark Tabladillo BI 2 Data Mining Beyond Adventure Works
00:00:00 Lee Johnson BI 2 SQL Server Auditing Using the CLR
00:00:00 Michael Mollenhour DBA Smokin' Mirrors - SQL Mirroring Technology
00:00:00 Michael Mollenhour BI 2 Mining for Data the SQL 2008 way
00:00:00 Noah Subrin Development Effective T-SQL Solutions
00:00:00 Sergey Barskiy Development CLR integration
00:00:00 Shawn Wildermuth Development 2 Using MSchema in Project Lifecycles
00:00:00 Shawn Wildermuth DBA 2 ADO.NET Data Services for DBAs
00:00:00 Geoff Hiten DBA An Introduction to SQL Server 2008 Features
00:00:00 Geoff Hiten DBA 2 SQL Clustering Essentials
00:00:00 Stuart Ainsworth Development 2 SQL Saturday Super Short Session I
00:00:00 Stuart Ainsworth Development 2 SQL Saturday Super Short Session II
00:00:00 Scott Russell Development 2 SQL Server 2008 Date / Time Data Types
00:00:00 Tejas Patel BI Data Mining ASP.Net Controls Library
00:00:00 Kevin Boles DBA Disk Partition Alignment
00:00:00 Kevin Boles DBA 2 SANs and SQL Server
00:00:00 Tom Mills DBA 2 Consolidating Your Database Infrastructure
00:00:00 Whitney Weaver Development Solving real world problems with meta data
00:00:00 Whitney Weaver DBA 2 A Lap Around Partitioning

SessionID: 34926

Introduction to SQL Server Statistics

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Andy Warren

Title: Introduction to SQL Server Statistics

Abstract:

This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you're a DBA or trying to get by without one, this session will give you the information you need to know.

SessionID: 34954

Introduction to Data Warehouse Concepts

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: Development

Speaker: Robert Cain

Title: Introduction to Data Warehouse Concepts

Abstract:

Business Intelligence is one of the top five skillsets for 2009. In this introductory course you can learn the basics of data warehousing, including design, population, analysis and reporting with a focus on the SQL Server toolset.

SessionID: 34955

Introduction to SQL Server Full Text Searching

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: Development 2

Speaker: Robert Cain

Title: Introduction to SQL Server Full Text Searching

Abstract:

Users have become familiar with the simple search capabilities of tools like Microsoft Live Search and Google. Did you know you can give your users the same ability to search their data with SQL Server? And it's as easy as 1-2-3! Come and learn the how to setup and use full text searching with SQL Server.

SessionID: 34956

Introduction to SQL Server Integration Services

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: BI

Speaker: Robert Cain

Title: Introduction to SQL Server Integration Services

Abstract:

SQL Server Integration Services is Microsoft's powerful tool for doing ETL (Extract, Transform, and Load) in the Business Intelligence arena. In this introductory course you can get up to speed on the basic tools of ETL and learn how to leverage SSIS not just for BI but for data conversion as well.

SessionID: 35068

SSRS Working with Images and Subreports

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: BI 2

Speaker: Curtis Smith

Title: SSRS Working with Images and Subreports

Abstract:

Session will cover working with images and subreports. I will cover real world examples of issues encountered when working with images and subreports. Examples will include "conditional subreports".

SessionID: 35107

Why Normalization Matters

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: Development

Speaker: Louis Davidson

Title: Why Normalization Matters

Abstract:

In this session I will give an overview of the common normal forms and show why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently). Properly structured data structures make it easier to work wit

SessionID: 35109

SSIS Internals and Optimization

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: BI 2

Speaker: Erik Veerman

Title: SSIS Internals and Optimization

Abstract:

This session dives deep into the underlying structure of the SSIS data flow pipeline in order understand how the SSIS engine is handling your data and how to monitor and optimize your data flow design. This review includes a drill-down into the data buffer architecture, execution trees, engine threads, column lineage, synchronous and asynchronous transformation outputs, data flow buffer tuning, pipeline monitoring, pipeline optimization, error identification and troubleshooting. Understanding the pipeline internals will lead to better package designs with more efficient and scalable data flow architectures for your SSIS environment.

SessionID: 35145

Wait-Time SQL Server Performance Management

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: DBA 2

Speaker: Janis Griffin

Title: Wait-Time SQL Server Performance Management

Abstract:

SessionID: 35158

Nested Sets Model - Trees Hierarchies in SQL

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: Development

Speaker: Joe Celko

Title: Nested Sets Model - Trees Hierarchies in SQL

Abstract:

A look at the programing techniques for Trees Hierarchies using the nested sets model. The stress will be on avoidance of recursive CTE and cursor programming.

SessionID: 35181

How to Build Analysis Services Cubes (2005/2008)

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: BI

Speaker: Jen Underwood

Title: How to Build Analysis Services Cubes (2005/2008)

Abstract:

This session will walk through building an Analysis Services Cube in SQL Server 2005 and 2008. It will also cover real world project roadmaps, common mistakes and basic dimensional modeling concepts.

SessionID: 35182

Building Reporting Services and Excel Reports

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: BI

Speaker: Jen Underwood

Title: Building Reporting Services and Excel Reports

Abstract:

This session will walk through building reports in Reporting Services 2008 and Excel 2007 that query data from Analysis Services Cubes. It will also explain a variety of reporting solution architecture options using Microsoft's Business Intelligence technologies.

SessionID: 35253

Fortress SQL Server

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: BI

Speaker: Brian Kelley

Title: Fortress SQL Server

Abstract:

We'll look at best practices for securing SQL Server and the data contained within from both a DBA and developer perspective. Starting with the basics of how to relate security to business personnel, we'll then dive in to the technical aspects of locking down SQL Server. SQL Server 2000 through 2008 will be covered.

SessionID: 35260

XML Features in SQL 2005

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: Development

Speaker: Kendal Van Dyke

Title: XML Features in SQL 2005

Abstract:

XML in SQL 2000 wasn't very exciting and it was easy to dismiss it altogether by just relying on developers to handle any XML needed within the application. SQL 2005 changes the game and this session will show you how to use the new XML data type, do basic XML operations on XML data, and showcase the changes to FOR XML that make it so much more useful. This isn't a session to convince you to use XML, but to show you what you can do with XML if you do need to use it!

SessionID: 35261

Disk Performance Hands On

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Kendal Van Dyke

Title: Disk Performance Hands On

Abstract:

Would you buy a million dollar race car then show up to the track on a clear day with rain tires that aren’t properly inflated and wonder why you’re only doing 180 when the manufacturer says it can do 220?

Your answer was probably close to something like “Of course not!”. Now let’s suppose that your “million dollar race car” is really your DB server and your “tires” are your hard drives. Do you know the right configuration to use to get the best performance out of them? Sure, there’s RAID 1, RAID 10, and RAID 5…but do you know which combination of partition offset, RAID stripe size, and allocation unit size to use?

SessionID: 35273

End-to-End Troubleshooting

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Kevin Kline

Title: End-to-End Troubleshooting

Abstract:

Learning how to detect, diagnose and resolve performance problems in SQL Server can be very difficult. It often takes years of on-the-job experience to learn how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. This hands-on session will take you from the very start of a problem situation on SQL Server, showing you how to use the native tools that help you keep SQL Server at top performance. This session will detail and demonstrate:

SessionID: 35274

Surviving the Data Avalanche

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: BI

Speaker: Kevin Kline

Title: Surviving the Data Avalanche

Abstract:

The SQL Server database platform is hosting larger and larger databases. But the industry term “Very Large Database” (VLDB) is more difficult to define than ever with multi-terabyte database becoming very common. This session will answer questions like:

Administrating and protecting very large databases is extremely difficult and very hard to learn except through direct experience. This session helps you learn from the experiences of others so that you can apply their lessons learned and mitigate your risks before you ever experience them.

SessionID: 35292

Data Mining Beyond Adventure Works

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: BI 2

Speaker: Mark Tabladillo

Title: Data Mining Beyond Adventure Works

Abstract:

Microsoft provides excellent tutorials and information about data mining through the fictional Adventure Works demos. However, what happens when you stray off that neat-and-tidy path? Data miners should be concerned about data preparation, proper algorithm selection, and correct interpretation. This interactive experience will consist of succinct audience participation demos to introduce some practical issues in real-world data mining.

SessionID: 35293

SQL Server Auditing Using the CLR

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: BI 2

Speaker: Lee Johnson

Title: SQL Server 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: 35331

Smokin' Mirrors - SQL Mirroring Technology

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Michael Mollenhour

Title: Smokin' Mirrors - SQL Mirroring Technology

Abstract:

In this session I will demonstrate how to configure Mirroring for both high availability and offloading reporting stress via database snapshots. I will also cover the different modes of mirroring and how they may affect performance.

SessionID: 35332

Mining for Data the SQL 2008 way

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: BI 2

Speaker: Michael Mollenhour

Title: Mining for Data the SQL 2008 way

Abstract:

In this session I will demonstrate datamining with SQL Analysis Services. This session will demonstrate the analytic powers incorporated into the SQL AS Engine, and show how these can be integrated with Reporting Services and Excel.

SessionID: 35339

Effective T-SQL Solutions

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: Development

Speaker: Noah Subrin

Title: Effective T-SQL Solutions

Abstract:

This session will present five short examples of solutions to real business world problems based on T-SQL or Visual Studio.

SessionID: 35427

CLR integration

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: Development

Speaker: Sergey Barskiy

Title: CLR integration

Abstract:

Integrating CLR assemblies to support custom image creation and encompassing complex business logic in SQL server/SSRS.

SessionID: 35432

Using MSchema in Project Lifecycles

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: Development 2

Speaker: Shawn Wildermuth

Title: Using MSchema in Project Lifecycles

Abstract:

While tools like Visual Studio's Database projects can help build and version databases, Oslo's new MSchema language can provide a powerful abstraction from the minutea of data models. In this talk I will show you how to use MSchema for build/deployment scenarios and using it to version your schemas.

SessionID: 35433

ADO.NET Data Services for DBAs

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: DBA 2

Speaker: Shawn Wildermuth

Title: ADO.NET Data Services for DBAs

Abstract:

The idea of exposing data across the Internet is a scary thought for most DBAs, but ADO.NET Data Services provides the security to allow you to feel better about how its handled. Since so many applications now require the Internet, ADO.NET Data Services represents a sensible way to provide that data. Come to this talk to be talked down from the ledge of fear about the technology.

SessionID: 35445

An Introduction to SQL Server 2008 Features

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Geoff Hiten

Title: An Introduction to SQL Server 2008 Features

Abstract:

Both developers and Administrators will learn new features of SQL 2008 designed to improve productivity and manageability. Focusing on breadth rather than depth, this session will give data professionals just enough information to decide whether a specific feature is worth their time to investigate more fully.

SessionID: 35446

SQL Clustering Essentials

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: DBA 2

Speaker: Geoff Hiten

Title: SQL Clustering Essentials

Abstract:

Come learn how to take some of the mystique out of SQL Clustering. Learn how to build, migrate, and operate SQL Server Clustering using the newest Windows Server 2008 Operating system.

SessionID: 35449

SQL Saturday Super Short Session I

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: Development 2

Speaker: Stuart Ainsworth

Title: SQL Saturday Super Short Session I

Abstract:

This session is actually 4 sessions in one. Speakers will each take 15 minutes to demonstrate something in SQL Server; it could be shortcuts in Management Studio, setting up and using a particular 3rd-party tool, or a code snippet. Slide decks are discouraged; the focus is on demonstrating "how-to" do something.

SessionID: 35450

SQL Saturday Super Short Session II

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: Development 2

Speaker: Stuart Ainsworth

Title: SQL Saturday Super Short Session II

Abstract:

This session is actually 4 sessions in one. Speakers will each take 15 minutes to demonstrate something in SQL Server; it could be shortcuts in Management Studio, setting up and using a particular 3rd-party tool, or a code snippet. Slide decks are discouraged; the focus is on demonstrating "how-to" do something.

SessionID: 35456

SQL Server 2008 Date / Time Data Types

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: Development 2

Speaker: Scott Russell

Title: SQL Server 2008 Date / Time Data Types

Abstract:

This session provides an overview of date / time data types, comparing capabilities and benefits of the new types in SQL Server 2008 with those from prior versions. A process will be presented on how to profile date / time data content in current tables, to better understand the implications (data preservation or loss) in migrating existing date / time data types to the newer types. Tools to simplify the data profiling process will be demonstrated.

SessionID: 35460

Data Mining ASP.Net Controls Library

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: BI

Speaker: Tejas Patel

Title: Data Mining ASP.Net Controls Library

Abstract:

Intent of this session is to demonstrate use of Data Mining Web Controls Library with web applications. Data Mining Web Controls Library is a library intended to extend the data mining user experience in Microsoft SQL Server Analysis Services to the Web. This library provides a lightweight version of the data mining model viewers. Using Data Mining Web Controls, you can browse complex mining models from any computer that has Microsoft Internet Explorer installed.

SessionID: 35474

Disk Partition Alignment

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Kevin Boles

Title: Disk Partition Alignment

Abstract:

EVERYONE can benefit from this presentation!! Improper disk alignment will rob the server of 15-50% IO throughput capability. We will cover what disk partition alignment really is, how it affects performance and how you can get it done correctly.

SessionID: 35475

SANs and SQL Server

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: DBA 2

Speaker: Kevin Boles

Title: SANs and SQL Server

Abstract:

Lets dig into both the fundamentals and details of how SANs work and how we can best utilize them to improve SQL Server's IO performance and reliability.

SessionID: 35490

Consolidating Your Database Infrastructure

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: DBA 2

Speaker: Tom Mills

Title: Consolidating Your Database Infrastructure

Abstract:

Suffering from server sprawl? Licensing fees killing your budget? Too many databases, not enough DBAs? These are all issues driving organizations to start consolidating their SQL Server infrastructure to reduce costs, improve administrative efficiencies, and increase performance. This session will present a methodology that can be applied to your database environment to consolidate and save big! Whether you are a database architect, DBA or manager, you'll be able to apply what you learn in this session to get results.

SessionID: 35512

Solving real world problems with meta data

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: Development

Speaker: Whitney Weaver

Title: Solving real world problems with meta data

Abstract:

SQL Server makes available a tremendous amount of meta data about the internal workings of the product. Join Whitney Weaver to see how many common DBA and developer tasks can be accomplished via the meta data in system views and DMVS.

SessionID: 35513

A Lap Around Partitioning

Back to calendar

Event Date: 25-04-2009 - Session time: 00:00:00 - Track: DBA 2

Speaker: Whitney Weaver

Title: A Lap Around Partitioning

Abstract:

Data volumes continue to grow and it is extremely important to know the features available to manage that growth. Whitney Weaver will discuss the partitioning functionality implemented in SQL 2005 and 2008 that will help you take your data applications to the next level.

This site is open source. Improve this page.