sqlsathistory

Nr: 30

Back to Main list

SQLSaturday #30 - Richmond 2010

Start Time (24h)	Speaker	Track	Title
00:00:00	Aaron Nelson	Track 2	Virtualize This!
00:00:00	Ashton Hobbs	Track 3	Compression in SQL 2008
00:00:00	Allen White	Track 3	Automate SQL Server Administration with PowerShell
00:00:00	Allen White	Track 3	Gather SQL Server Performance Data with PowerShell
00:00:00	Bob Lambert	Track 2	Normalize Metadata for Data Integration Analysis
00:00:00	Bob Lambert	Track 2	The Business End of Data Modeling
00:00:00	Brett Tomson	Track 1	Introduction to SSRS 2008
00:00:00	Brett Tomson	Track 2	Growing Pains - A Cautionary Tale
00:00:00	Brock Beatty	Track 1	SQL 2008 Change Data Capture Tips and Tricks
00:00:00	Dan Crawford	Track 3	SQL Service Brokers
00:00:00	Dan Crawford	Track 4	SQL Server Spatial Data
00:00:00	Louis Davidson	Track 2	Database Design
00:00:00	Louis Davidson	Track 2	Database Design Patterns
00:00:00	Janis Griffin	Track 4	Tuner Helper - A Proven Process In Tuning For DBAs
00:00:00	Jeremiah Peschka	Track 4	A Dynamic World Demands Dynamic SQL
00:00:00	Jeremiah Peschka	Track 3	Fundamentals of SQL Server Internals
00:00:00	Jason Hall	Track 4	Things Your Mom Never Told You About SSMS
00:00:00	Michael Femenella	Track 3	Loading Data In Real Time
00:00:00	Michael Femenella	Track 4	Introduction to Performance Tuning
00:00:00	Susan Lennon	Track 4	Using SSRS to report on IIS Web Logs
00:00:00	Steven Wright	Track 1	Memory Management in SQL Server Analysis Services
00:00:00	Brian Garraty	Track 1	Integration Services in the Real World
00:00:00	Tom Robinson	Track 1	Building SSRS Reports from SSAS Cubes
00:00:00	Tom Robinson	Track 1	SSAS Basic Cube and dimension design

SessionID: 28396

Virtualize This!

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Aaron Nelson

Title: Virtualize This!

Abstract:

With the list of features of SQL Server growing constantly the need to sandbox and test drive features in a separate environment that can communicate with but not interfere with your existing environment has become vital. With virtualization, setting up consistent test, dev, and even sandbox environments can happen minutes instead of hours AND be consistent with previous/ existing environments. In this session we will focus on Microsoft Virtualization solutions that you can leverage starting with your desktop/laptop and extending to your server environments. Even if you aren’t going to be doing the virtualization yourself it’s good to know what your options are.

SessionID: 28882

Compression in SQL 2008

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Ashton Hobbs

Title: Compression in SQL 2008

Abstract:

This session will cover the different forms of compression in SQL 2008, Backup and Data compression. The session will also explore best practices and how to overcome some of the limitations within the different compression technologies.

SessionID: 28903

Automate SQL Server Administration with PowerShell

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Allen White

Title: Automate SQL Server Administration with PowerShell

Abstract:

Most administrative functions consist of repetitive sequences of tasks which just take time. PowerShell is a powerful scripting environment which allows an administrator to automate those repetitive tasks, providing better results to the organization while saving the administrator time, and ensuring that the tasks get done properly every time. This session will give an introduction to PowerShell and demonstrate a number of scripts which help SQL Server administrators effectively manage their environments.

SessionID: 28904

Gather SQL Server Performance Data with PowerShell

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Allen White

Title: Gather SQL Server Performance Data with PowerShell

Abstract:

We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

SessionID: 29111

Normalize Metadata for Data Integration Analysis

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Bob Lambert

Title: Normalize Metadata for Data Integration Analysis

Abstract:

Many of today’s business applications feature dozens of interfaces feeding a central database. Interface source-to-target mapping is now common practice, but if there are many interfaces how do you make sure the work of separate teams on tight timelines dovetails smoothly and avoids the all too common death march of correction and rework?

This presentation shows how normalized metadata can help coordinate team efforts, recording data requirements, the target data model, interface sources, source to target mappings, and relationships among analysis components, and enable an effective division of labor that promotes team efficiency, improves planning, and provides the best possible product for developers and testers.

SessionID: 29112

The Business End of Data Modeling

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Bob Lambert

Title: The Business End of Data Modeling

Abstract:

This presentation is about what to expect before you start database design and what to do if you don't get it. We, as SQL Server Database professionals, apply technology solutions to meet business needs. The problem is that sometimes we're expected to meet business needs that aren't well defined, or not defined at all. Attendees will learn about the requirements side of data modeling and how it prepares a database developer to design and build the right solution. Then, the presentation will cover typical scenarios where critical business definition elements are missing and what the database professional can do make up for the missing requirements pieces and produce a successful result.

SessionID: 29250

Introduction to SSRS 2008

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Brett Tomson

Title: Introduction to SSRS 2008

Abstract:

Microsoft SQL Server 2008 was released to much fanfare, excitement and anticipation. The bevy of enhancements made to the various components coupled with sweeping performance gains made SQL Server 2008 one of the most competitive and feature-rich database platforms on the market. In this session, we will examine the enhancements made to Reporting Services in SQL Server 2008 as well as what changes to expect in R2 slated for release in early 2010.

SessionID: 29251

Growing Pains - A Cautionary Tale

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Brett Tomson

Title: Growing Pains - A Cautionary Tale

Abstract:

It happens to everyone. One day your database is humming along quietly serving up choice nuggets of information quickly and efficiently while growing at a slow, steady rate. Then next day, your database has quadrupled in size and performance has ground to a halt as the system strains under the load. Management is screaming for answers and you're coworkers are running in circles screaming for their lives. In this session, we will examine best practices to apply to databases that grow to become very large databases (VLDB). From hardware configurations (IO, CPU, RAM) to database and index design and partitioning strategies, we will examine which solutions and strategies help and which ones hinder our database on its road to recovery.

SessionID: 29292

SQL 2008 Change Data Capture Tips and Tricks

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Brock Beatty

Title: SQL 2008 Change Data Capture Tips and Tricks

Abstract:

Change Data Capture (CDC) is one of the very best features of SQL Server 2008. It's is easy to set up and it essentially makes the transaction logs for your databases both persistent and queryable. Versioning your data has never been easier. But there are dozens of tools for tuning and reporting on CDC that are either undocumented or "loosely" documented by Microsoft. During this session, Brock will show you 20 tips and tricks for making your CDC implementations much richer and easier to maintain.

SessionID: 29847

SQL Service Brokers

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Dan Crawford

Title: SQL Service Brokers

Abstract:

This session will provide an overview of Service Brokers, which provides asynchronous messaging capabilities in the SQL Server environment. We will discuss when it is appropriate to use service brokers as well as how to create and manage them. During the session we will build a simple service broker implementation so we can see brokers in action.

SessionID: 29848

SQL Server Spatial Data

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Dan Crawford

Title: SQL Server Spatial Data

Abstract:

This presentation will provide an introduction to the spatial data capabilities that were introduced in SQL Server 2008. We will examine the spatial data types and indexes. Then we will look at how to work with these data types, including loading data, querying spatial data, and generating reports with spatial data. We will also discuss interacting with spatial data types from a .Net application.

SessionID: 30001

Database Design

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Louis Davidson

Title: Database Design

Abstract:

In this session I will give an overview of how to design a database, including the common normal forms and 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).

SessionID: 30002

Database Design Patterns

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Louis Davidson

Title: Database Design Patterns

Abstract:

Beyond database design fundamentals (for example, Normalization) lies the area where you have to create "real" solutions. In this session, I will cover a good number of patterns that we commonly find useful to try to apply to the problem of building a database solution. Ideas like generalization, subclassing, single table domain tables, optional data, and more will be discussed, some of them good, some not so good (don't assume which will be which), but all that are common and/or useful for your database implementations.

SessionID: 30444

Tuner Helper - A Proven Process In Tuning For DBAs

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Janis Griffin

Title: Tuner Helper - A Proven Process In Tuning For DBAs

Abstract:

Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait type data, column selectivity, and several more that will help you succeed on future tuning projects.

SessionID: 30760

A Dynamic World Demands Dynamic SQL

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Jeremiah Peschka

Title: A Dynamic World Demands Dynamic SQL

Abstract:

Dynamic SQL is a misunderstood and much maligned part of a DBA’s tool kit – it can be used to solve difficult business problems, respond to diverse data needs, and alleviate performance problems. Many DBAs reject dynamic SQL outright as a potential source of SQL injections, being poorly performing, or just for being a hacky solution in general. Not so! Jeremiah Peschka has been making extensive use of dynamic SQL throughout his career to solve a variety of problems. He’ll set about dispelling these misconceptions and demonstrate how dynamic SQL can become a part of every DBA’s tool kit.

SessionID: 30762

Fundamentals of SQL Server Internals

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Jeremiah Peschka

Title: Fundamentals of SQL Server Internals

Abstract:

Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can't promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server.

SessionID: 30825

Things Your Mom Never Told You About SSMS

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Jason Hall

Title: Things Your Mom Never Told You About SSMS

Abstract:

This is a beginning to intermediate level presentation that aims to enlighten users of some of the more useful yet underutilized features of SQL Server Management Studio 2008. There will be explanations of the features and techniques as well as simple demonstrations throughout. This session provides something for both DBAs and developers of TSQL alike.

SessionID: 31896

Loading Data In Real Time

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Michael Femenella

Title: Loading Data In Real Time

Abstract:

After an overview of partitioning and how to set up partition functions schemes we'll take a look at how to load data and instantly switch it into production without significant impact to your database availability.

Topics covered: Partition Functions Schemes Creating partitioned tables The $partition function Switch Statement and system tables for viewing partition information

SessionID: 31897

Introduction to Performance Tuning

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Michael Femenella

Title: Introduction to Performance Tuning

Abstract:

Everything I wish someone had told me when I started with SQL Server years ago. An overview of using profiler to capture events Clustered, non clustered, covering indexes, looking at query plans (rid lookup, key lookup, scans vs seeks) When to use a table variable vs temp table

SessionID: 33275

Using SSRS to report on IIS Web Logs

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Susan Lennon

Title: Using SSRS to report on IIS Web Logs

Abstract:

Join us to find out how you can use tools that have no cost (either free or part of SQL Server) to build web site usage analysis reports. We'll use Microsoft's free tool, LogParser to load the data into SQL Server, then we'll use SQL Server Reporting Services to build reports of that data. Finally, we'll deliver those reports inside SharePoint, using SQL Server Reporting Services running in SharePoint Integrated Mode.

SessionID: 33306

Memory Management in SQL Server Analysis Services

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Steven Wright

Title: Memory Management in SQL Server Analysis Services

Abstract:

In this presentation Steve Wright will discuss methods used to manage memory in SQL Server Analysis Services, focusing primarily on memory limits and preallocation. He will also present some examples from the field of performance issues due to mis-configuration, how they were identified, and ultimately resolved.

SessionID: 33374

Integration Services in the Real World

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Brian Garraty

Title: Integration Services in the Real World

Abstract:

This session will walk through several real life examples of how SQL Server Integration Services (SSIS) was used to meet some interesting requirements quite easily that might have otherwise been difficult for a DBA to accomplish. Along the way, we will offer up some tips, tricks, and best practices found to be useful by a DBA that has worked extensively with SSIS for over four years.

SessionID: 33784

Building SSRS Reports from SSAS Cubes

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Tom Robinson

Title: Building SSRS Reports from SSAS Cubes

Abstract:

Learn how to create reports by retrieving data from SQL Server Analysis Services cubes. This session will cover setup and layout fundamentals, but will primarily focus on using the Analysis Services MDX Query Designer in both Design and Query modes to meet common reporting requirements.

SessionID: 33785

SSAS Basic Cube and dimension design

Back to calendar

Event Date: 10-04-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Tom Robinson

Title: SSAS Basic Cube and dimension design

Abstract:

This session will present the basic design of a data warehouse cube from the Data Source View, through Dimensional Design, Fact Table design and the use of Time Intelligence and basic Calculated measures.

This site is open source. Improve this page.