sqlsathistory

Nr: 33

Back to Main list

SQLSaturday #33 - Charlotte 2010

Start Time (24h)	Speaker	Track	Title
00:00:00	Aaron Bertrand	Track 2	Management Studio Tips Tricks
00:00:00	Aaron Nelson	Track 8	PowerShell Awesomesauce
00:00:00	Aaron Nelson	Track 8	PowerShell for Data Professionals
00:00:00	Aaron Nelson	Track 7	Virtualize This!
00:00:00	Andrew Kelly	Track 5	Practical Performance Monitoring in SQL Server
00:00:00	Andrew Kelly	Track 6	Collecting and Analyzing File Wait Statistics
00:00:00	Andrew Kelly	Track 6	Maximizing Plan Re-use in SQL 2008
00:00:00	Amy Styers	Track 5	Know Your IO: Gain Better Performance with Ease
00:00:00	Andy Leonard	Track 8	Build Your First SSIS Package
00:00:00	Andy Leonard	Track 9	Applied SSIS Design Patterns
00:00:00	Andy Warren	Track 5	Introduction to SQL Server Statistics
00:00:00	Ashton Hobbs	Track 4	Compression in SQL 2008
00:00:00	Allen White	Track 8	Automate SQL Server Administration with PowerShell
00:00:00	Allen White	Track 8	Gather SQL Server Performance Data with PowerShell
00:00:00	Brett Tomson	Track 9	What's New In SSRS 2008
00:00:00	Brett Tomson	Track 5	Growing Pains - A Cautionary Tale
00:00:00	Chris Skorlinski	Track 3	Troubleshooting Transactional Replication
00:00:00	Chris Skorlinski	Track 3	Comparison of Replication Technologies
00:00:00	Dave Turpin	Track 4	De-mystifying Query Plan Analysis
00:00:00	Evan Basalik	Track 1	SQL Azure: Data in the Cloud is a Good Thing
00:00:00	Evan Basalik	Track 3	Diagnosing Connectivity Issues with SQL Server
00:00:00	Jana Sattainathan	Track 2	Partitioning in SQL Server 2005/2008
00:00:00	Janis Griffin	Track 5	Tuna Helper for SQL Server DBA's
00:00:00	Jeffry Schwartz	Track 6	SQL Server Performance Outside the Box
00:00:00	Jessica Moss	Track 9	Incorporating Reporting Services into SharePoint
00:00:00	Jessica Moss	Track 9	Adding SSRS Report Bells and Whistles
00:00:00	Jason Hall	Track 2	Things Your Mom Never Told You About SSMS
00:00:00	John Welch	Track 8	Creating Custom Components for SSIS
00:00:00	John Welch	Track 9	Delivering BI Solutions Rapidly using Vulcan
00:00:00	Kendal Van Dyke	Track 7	The (Solid) State Of Drive Technology
00:00:00	Kendal Van Dyke	Track 4	Getting started in blogging and technical speaking
00:00:00	Kevin Kline	Track 1	Top 10 Mistakes on SQL Server
00:00:00	Kevin Kline	Track 6	SQL Server Internals Architecture
00:00:00	Alejandro Mesa	Track 5	Parameter Sniffing
00:00:00	Mike Walsh	Track 4	As a DBA, Where do I start?
00:00:00	Mike Walsh	Track 2	You Can Improve Your Own SQL Code
00:00:00	Denny Cherry	Track 1	Storage for the DBA
00:00:00	Denny Cherry	Track 7	Is Virtualization is a good choice for SQL Server?
00:00:00	Denny Cherry	Track 7	SQL Server Service Broker in the Real World
00:00:00	Patrick LeBlanc	Track 4	SQL Server Data Compression 101
00:00:00	Rafael Salas	Track 9	SSIS, You, and ETL Architecture
00:00:00	Rushabh Mehta	Track 7	Harnessing PowerPivot
00:00:00	Rushabh Mehta	Track 1	Building PowerPivot Models and Reports
00:00:00	Sergey Pustovit	Track 6	SQL Server Performance Related DMVs
00:00:00	Sergey Pustovit	Track 1	SQL Server 2008/R2 Overview
00:00:00	Steve Jones	Track 4	The Modern Resume: Building Your Brand
00:00:00	Tim Ford	Track 2	Tips For The Lazy But Driven DBA
00:00:00	Tim Ford	Track 6	Insight Into Your Indexes With DMVs
00:00:00	Geoff Hiten	Track 7	Clustering for Mere Mortals.
00:00:00	Geoff Hiten	Track 2	Bad SQL.
00:00:00	Steven Wright	Track 3	Memory Management in SQL Server Analysis Services
00:00:00	Wayne Snyder	Track 3	SSRS In the Enterprise - Surviving With a Smile!
00:00:00	Andy Warren, Steve Jones, Rushahb Mehta	Track 1	SQL Server Support Team QA
00:00:00	Andy Warren, Steve Jones, Rushahb Mehta	Track 1	KEYNOTE: SQLSaturday Past, Present and Future
00:00:00	Andy Warren, Steve Jones, Rushahb Mehta	Track 2	LUNCH!

SessionID: 28372

Management Studio Tips Tricks

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Aaron Bertrand

Title: Management Studio Tips Tricks

Abstract:

A collection of tips, tricks and gotchas revolving around the use of Management Studio for database development, administration and maintenance. Will also outline a few alternative tools.

SessionID: 28386

PowerShell Awesomesauce

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 8

Speaker: Aaron Nelson

Title: PowerShell Awesomesauce

Abstract:

In this session we will begin exploring the amazing world of the PowerShell language. We will compare cmdlets/operations to similar syntax/patterns in the T-SQL language.  We'll also step through one of the most talked about topics (the foreach-object command).  PowerShell has been bragged about since the beginning because of how much you can accomplish in just one line of code. When you leave this session YOU will be bragging about what YOU can do in just ONE line of code!

SessionID: 28400

PowerShell for Data Professionals

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 8

Speaker: Aaron Nelson

Title: PowerShell for Data Professionals

Abstract:

In this session we will learn to perform several everyday DBA tasks like backing up user databases, scripting table objects and evaluating disk space usage with PowerShell. For each tasks we will explore the benefits is using PowerShell over the standard method. Only a basic understanding of PowerShell or DOS is needed. This session should serve as a good introduction to PowerShell for database users. The goal is to get data professionals feet wet about PowerShell.

SessionID: 28401

Virtualize This!

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 7

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: 28561

Practical Performance Monitoring in SQL Server

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Andrew Kelly

Title: Practical Performance Monitoring in SQL Server

Abstract:

Do you know what counters, statistics, events and other information you should be collecting on a regular basis to properly monitor your SQL Server instances? Do you know where your current bottlenecks really are or how to even look for them. In this session we will cover the basics when it comes to monitoring the database, server and hardware that give us the biggest bang for the buck. See how a little bit of effort upfront can lead to a much better understanding of your database environment and put you in a position to spot potential issues before they become real trouble.

SessionID: 28562

Collecting and Analyzing File Wait Statistics

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Andrew Kelly

Title: Collecting and Analyzing File Wait Statistics

Abstract:

Since SQL Server 2000 we have had the ability to collect statistics on two key areas in terms of performance directly from within SQL Server. More specifically these are the File Wait statistics and the information that can be gleaned from these has increased dramatically with each new release. SQL 2008 currently has over 480 events so far. This session will show you how to efficiently capture and analyze the information provided by a set of DMV’s in SQL Server 2005 SQL Server 2008. This knowledge will dramatically decrease the amount of time spent looking for bottlenecks in your system.

SessionID: 28563

Maximizing Plan Re-use in SQL 2008

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Andrew Kelly

Title: Maximizing Plan Re-use in SQL 2008

Abstract:

Lack of plan reuse is one of the biggest performance killers in SQL Server and almost everyone has experienced problems in this area before. We will explore exactly how to determine if this is an issue for you and more importantly, how to address it. See what factors determine if a plan gets reused or not and why. We will cover how to issue calls to the database that guarantee reuse and peak performance. Understanding this aspect of SQL Server is something every good DBA should be fully aware of and attending this session will get you the insight to get started immediately.

SessionID: 28643

Know Your IO: Gain Better Performance with Ease

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Amy Styers

Title: Know Your IO: Gain Better Performance with Ease

Abstract:

Understanding a SQL application's data and storage needs is often overlooked - yet it can yield GREAT RETURNS when performance tuning. I will discuss and demonstrate how to plan for better performance with IO tuning.

SessionID: 28654

Build Your First SSIS Package

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 8

Speaker: Andy Leonard

Title: Build Your First SSIS Package

Abstract:

This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.

SessionID: 28657

Applied SSIS Design Patterns

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 9

Speaker: Andy Leonard

Title: Applied SSIS Design Patterns

Abstract:

This session is for experienced SSIS developers. Attend and learn the Parent-Child SSIS design pattern, how to leverage less-than-well-documented characteristics of SSIS to centralize logging, and how to pass variable values between parent and child packages by value and by reference.

SessionID: 28726

Introduction to SQL Server Statistics

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 5

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: 28881

Compression in SQL 2008

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 4

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: 28896

Automate SQL Server Administration with PowerShell

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 8

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: 28898

Gather SQL Server Performance Data with PowerShell

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 8

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: 29252

What's New In SSRS 2008

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 9

Speaker: Brett Tomson

Title: What's New In SSRS 2008

Abstract:

Microsoft SQL Server 2008 was released to much fanfare, excitement and anticipation in the IT community. 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: 29253

Growing Pains - A Cautionary Tale

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 5

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 reporting databases that grow to become much larger than expected. We will examine a real-world scenario and discuss the strategies and techniques implemented in order to get the database back on track.

SessionID: 29503

Troubleshooting Transactional Replication

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Chris Skorlinski

Title: Troubleshooting Transactional Replication

Abstract:

This presentation will provide an overview of the techniques used by Microsoft SQL Server Replication Support team for troubleshoot Transactional Replication performance. Topics covered include: Overview of Agent Reader/Writer threads, Monitoring Replication Performance, Common causes of Latency, tools for identifying Replication latency, and best practices for improving Transactional Replication Performance.

SessionID: 29504

Comparison of Replication Technologies

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Chris Skorlinski

Title: Comparison of Replication Technologies

Abstract:

This sessions provides a high level overview and comparison of various Microsoft SQL Server Replication technologies including 1) Snapshot, 2) Change Tracking, 3) Change Data Capture, 4) Transactional, 5) Peer-2-Peer, 6) Merge Replication, 7) Web Sync, 8) Sync Services.

SessionID: 29707

De-mystifying Query Plan Analysis

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Dave Turpin

Title: De-mystifying Query Plan Analysis

Abstract:

If you never click on the estimated/actual query plan icons because it looks like a foreign language to you AND you want your queries to really run fast... This session is for you. Starting from the beginning, we'll go through the key things to look for when reviewing your queries' estimated and actual plans.

SessionID: 30095

SQL Azure: Data in the Cloud is a Good Thing

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Evan Basalik

Title: SQL Azure: Data in the Cloud is a Good Thing

Abstract:

Evan will talk about how SQL Azure works behind the scenes, plus demonstrate how to use the cloud-based sibling of SQL Server. He will also discuss how to best design your applications to take advantage of the power of SQL Azure.

SessionID: 30096

Diagnosing Connectivity Issues with SQL Server

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Evan Basalik

Title: Diagnosing Connectivity Issues with SQL Server

Abstract:

Evan will show you how to diagnose and solve common connectivity issues. This will include covering GNEs, Kerberos, and completely inaccessible SQL Servers. He will demonstrate how to use UDLs and network traces to easily identify the problem, plus provide tips that often solve the problem in seconds.

SessionID: 30419

Partitioning in SQL Server 2005/2008

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Jana Sattainathan

Title: Partitioning in SQL Server 2005/2008

Abstract:

• What is partitioning?

• Why and when to partition your data? • History of Partitioning in SQL Server • How does partitioning in SQL Server compare to partitioning in Oracle? • Understanding partitioning in SQL Server and types of partitioning • Benefits of partitioning • Organizing partitions: File groups, files, partitions, indexes and constraints • Partition operations - merge/split partitions, exchange partitions to tables and vice versa (switch in and switch out) • Partitioning and archiving • System tables related to partitioning • Demoes • How to build a generic framework to manage partitioning? • How to convert non-partitioned tables into patitioned tables and vice versa? • Best practices • Downloads/References

SessionID: 30432

Tuna Helper for SQL Server DBA's

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Janis Griffin

Title: Tuna Helper for SQL Server DBA's

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: 30674

SQL Server Performance Outside the Box

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Jeffry Schwartz

Title: SQL Server Performance Outside the Box

Abstract:

This session will delve into a variety of unique and not-so-obvious correlation and analysis techniques using Windows performance metrics and SQL Server DMV's to uncover previously hidden performance bottlenecks in your SQL Server systems.

SessionID: 30802

Incorporating Reporting Services into SharePoint

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 9

Speaker: Jessica Moss

Title: Incorporating Reporting Services into SharePoint

Abstract:

Do you already have a SharePoint implementation and now you need reporting capabilities? Attend this session to learn about incorporating SQL Server Reporting Services into your existing SharePoint installation. We will discuss the reasons why you would want to do this, and how to install, use, and access SSRS reports from SharePoint.

SessionID: 30803

Adding SSRS Report Bells and Whistles

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 9

Speaker: Jessica Moss

Title: Adding SSRS Report Bells and Whistles

Abstract:

Producing a good looking report will wow your business users even if your data isn't all that impressive. If you've ever had trouble finding the best way to display that data or how to show trends appropriately, this is the session for you. We will review grouping logic, graphs, gauges, and more in Reporting Services 2008. With the knowledge in this session, you won't ever need to show a plain, boring report again!

SessionID: 30826

Things Your Mom Never Told You About SSMS

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 2

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: 30923

Creating Custom Components for SSIS

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 8

Speaker: John Welch

Title: Creating Custom Components for SSIS

Abstract:

SSIS data flows are great tools for moving data. But what if you need to go beyond the out-of-the-box components provided with SSIS? Custom components are a great way to encapsulate and reuse functionality for the data flow in SSIS. We will discuss what it takes to create and deploy custom components in SSIS, review the pros and cons of using custom components instead of scripts, and discuss some of the common challenges and issues with creating them.

SessionID: 30926

Delivering BI Solutions Rapidly using Vulcan

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 9

Speaker: John Welch

Title: Delivering BI Solutions Rapidly using Vulcan

Abstract:

SQL Server, Integration Services, and Analysis Services are used together to deliver BI solutions but development efforts are carried out separately, without sharing of metadata between the products. This creates duplicate effort and compromises the ability to develop agile, iterative solutions. Vulcan is an open source project from Microsoft (http://vulcan.codeplex.code) that helps bridge this gap, while also providing many of the benefits of code focused approaches used in application development. It allows you to define the relational data marts, ETL, and OLAP cube portions of your BI solution in a common language, and seamlessly uses that information to generate the appropriate database schemas, SSIS packages, and SSAS cubes.

SessionID: 31262

The (Solid) State Of Drive Technology

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 7

Speaker: Kendal Van Dyke

Title: The (Solid) State Of Drive Technology

Abstract:

Solid State Drives are being heralded as game changers in the world of SQL IO. What was once was a costly technology only available to those with deep pockets is now becoming affordable for mainstream use. This session look into the how SSDs work, how they perform compared to traditional hard drives, and highlight the things you need to consider when implementing SSDs on your SQL Servers. Be sure not to miss a live demonstration of solid state technology in action!

SessionID: 31263

Getting started in blogging and technical speaking

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Kendal Van Dyke

Title: Getting started in blogging and technical speaking

Abstract:

Are you thinking of starting a blog? Or are you interested in presenting at events like SQL Saturday but not sure what to do to get started? This panel style session with established SQL bloggers will give you tips on blogging platforms, choosing topics, techniques for giving presentations, and sage advice from years of experience.

SessionID: 31304

Top 10 Mistakes on SQL Server

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Kevin Kline

Title: Top 10 Mistakes on SQL Server

Abstract:

SQL Server encompasses a wide variety of domains – administrative, development, and design. But despite years of experience with relational databases, SQL Server practitioners frequently make the same mistakes over and over again. Wouldn’t you like to learn about those mistakes before they ever happen? This session will answer questions like:

• What’s the most common Transact-SQL programming mistake and how do I fix it?
• How do database designers cause problems for future generations of application developers and database administrators?
• Why do inexperienced database administrators make their own job more difficult and less efficient?

SessionID: 31305

SQL Server Internals Architecture

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Kevin Kline

Title: SQL Server Internals Architecture

Abstract:

Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:

• What’s different about 32- and 64-bit systems?
• What are the various areas of memory inside of SQL Server?
• How are queries handled behind the scenes?
• What does SQL Server do with procedural code, like functions, procedures, and triggers?
• ...and much more.

SessionID: 31704

Parameter Sniffing

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Alejandro Mesa

Title: Parameter Sniffing

Abstract:

In this session we will learn about:- What is parameter sniffing?- What can we do when it doesn't help?- Statistics used by Sql Server- The OPTION clause- Plan Guides

SessionID: 31883

As a DBA, Where do I start?

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Mike Walsh

Title: As a DBA, Where do I start?

Abstract:

Whether you are new to the role of DBA, being "forced" to take on the responsibility of one or are starting at a new role as a DBA, knowing where to start can often mean the difference between success or failure. In this chat, Mike will help us wade through the noise that attacks a DBA and figure out just what our priorities should be. By focusing on the "itties" of Database Administration (Recoverability, Availability - Health Performance - , Security and Reliability) we can see a natural priority build. Throughout this interactive discussion we will also have a look at some of the available tools and scripts to help us see where our environments rate with the "itties" of Database Administration.

SessionID: 31884

You Can Improve Your Own SQL Code

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Mike Walsh

Title: You Can Improve Your Own SQL Code

Abstract:

In this talk, Mike will show us some of the tools that come with SQL Server and how they can be used to analyze the performance of our database code. We will take a quick walk through indexing, best practices, some quick tips and then have a more in depth look at Execution Plans, IO Statistics and Profiler. Plus as a DBA, Mike can give a few pointers in working with your organization's own "Dr. No" along the way. Rough Agenda: • Review of Best Practices • Indexing/Table Structure High Level Overview • Will your queries use the index? • Query Plans don’t have to be scary • IO Statistics, Profiler • Put Them Together (Use the tools before you say, "Done!" • Interaction with the DBA (How to be a partner in performance with the DB

SessionID: 31979

Storage for the DBA

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Denny Cherry

Title: Storage for the DBA

Abstract:

One of the biggest issues in database performance centers around storage. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as RAID Groups. In addition to theory, we’ll be looking at an actual EMC SAN so that we can translate what we see in the Storage Array with what we see on the actual server.

SessionID: 31980

Is Virtualization is a good choice for SQL Server?

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 7

Speaker: Denny Cherry

Title: Is Virtualization is a good choice for SQL Server?

Abstract:

We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like all problems in the database world there are no hard set answers as to if virtualization is a good idea, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money. There are some other times when you will be shooting yourself in the foot and shouldn’t. We’ll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision.

SessionID: 31981

SQL Server Service Broker in the Real World

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 7

Speaker: Denny Cherry

Title: SQL Server Service Broker in the Real World

Abstract:

Microsoft SQL Server 2005 and 2008 include a fantastic feature that few people understand or use. That feature is the Microsoft SQL Server Service Broker. The SQL Service Broker is one of the least used features within the database engine, and that lack of use is simply from last of knowledge about the feature.

In this session we’ll dig into how to configure the service broker for not only intra-database message queuing, but database to database queuing as well as server to server database queuing. We will also dig into a real life scenario where the SQL Server Service Broker was used to do ETL from an OLTP database to an OLAP database in near real time for near real time reporting.

SessionID: 32276

SQL Server Data Compression 101

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Patrick LeBlanc

Title: SQL Server Data Compression 101

Abstract:

In this session I will explain SQL Server Data compression (Page and Row), provide scripts and tips that will help you identity the compression state that should be configured in your Warehouse environment and also provide demo scripts showing you how to configure compression at the Table and Index level.

SessionID: 32360

SSIS, You, and ETL Architecture

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 9

Speaker: Rafael Salas

Title: SSIS, You, and ETL Architecture

Abstract:

BOS30-200: SSIS, You , and Better ETLDid you already learned SSIS, and now want to get serious about ETL? Did you become an SSIS developer by accident, but wonder what makes a good ETL solution? Is your current SSIS solution falling apart and you need to revamp it? The Complexity and importance of Extract, Transform and Load (ETL) projects are often underestimated, and the consequences of a poor crafted solution would inevitable lead to maintenance nightmares, or worse yet to the failure of the whole project. In this session we will try to bridge SSIS and a ETL architecture based on good practices while looking to some lessons learned from real world implementations.

SessionID: 32533

Harnessing PowerPivot

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 7

Speaker: Rushabh Mehta

Title: Harnessing PowerPivot

Abstract:

PowerPivot (project Gemini) introduces an innovative platform for self-service analysis. In this session, we will very briefly look at the user-facing features and functionality of PowerPivot before we dive deep into a behind-the-scenes look at PowerPivot, understand limitations and finally drill into some best practices and lessons learnt from actual customer implementations.

SessionID: 32534

Building PowerPivot Models and Reports

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Rushabh Mehta

Title: Building PowerPivot Models and Reports

Abstract:

In this session, we will use the features of the PowerPivot add-in for Excel to import data from various sources, cleanse and prepare the data for analysis and finally use the data to build complex reports and publish. We will also take a look at Data Analysis Expressions (DAX) and how to use them to extend the functionality of the model and the reports.

SessionID: 32884

SQL Server Performance Related DMVs

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Sergey Pustovit

Title: SQL Server Performance Related DMVs

Abstract:

There are number of tools available on the market for the SQL Server performance troubleshooting. But do we use the full power of the internal SQL Server Data Management Views (DMVs)? Some very challenging issues can be solved using DMVs. What the Dynamic Management Views are? How diagnostics data is getting populated? Using the examples we are going to talk about diagnostic data analysis using T-SQL queries against SQL Server DMVs.

SessionID: 32888

SQL Server 2008/R2 Overview

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Sergey Pustovit

Title: SQL Server 2008/R2 Overview

Abstract:

During this session we will go over the features been introduced in SQL Server 2008 and upcoming SQL Server 2008 R2.

SessionID: 32933

The Modern Resume: Building Your Brand

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Steve Jones

Title: The Modern Resume: Building Your Brand

Abstract:

Learn how to better set yourself apart from the pack in this presentation on building a modern resume and brand using social networking, volunteerism, blogging, and more. Presented by Steve Jones, founder of SQLServerCentral.

SessionID: 33021

Tips For The Lazy But Driven DBA

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Tim Ford

Title: Tips For The Lazy But Driven DBA

Abstract:

Having had to support a large number of SQL Server instances as a solo DBA for many years I’ve developed a toolbox of scripts and arsenal of processes that I rely upon to give insight into disk space, file growth, backup status, Agent job outcomes, and login management. Some of these I’ve shared on various websites and blogs; others see the light of day for the first time in this session. Attendees leave the session with processes and code they can begin to use immediately.

SessionID: 33022

Insight Into Your Indexes With DMVs

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Tim Ford

Title: Insight Into Your Indexes With DMVs

Abstract:

Use the right tool from your SQL toolbox to maintain those indexes, determine which indexes are being used (and more importantly which ones are NOT being used), and get recommendations on indexes to create all from Dynamic Management Views. Walk away with scripts you can use in your environment IMMEDIATELY.

SessionID: 33032

Clustering for Mere Mortals.

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 7

Speaker: Geoff Hiten

Title: Clustering for Mere Mortals.

Abstract:

Learn about the major changes in clustering in recent SQL and Windows releases and how clustering is something you can implement that will actually make your work life easier.

SessionID: 33033

Bad SQL.

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Geoff Hiten

Title: Bad SQL.

Abstract:

Learn to write (or at least recognize) T-SQL code that consumes hundreds of times more I/O and CPU Resources than optimal code. More importantly, see what the optimal counterpart looks like.

SessionID: 33307

Memory Management in SQL Server Analysis Services

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 3

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: 34513

SSRS In the Enterprise - Surviving With a Smile!

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Wayne Snyder

Title: SSRS In the Enterprise - Surviving With a Smile!

Abstract:

If you plan to use SSRS in a large enterprise there are many things you should do be successful - things that do not seem to have much prescriptive guidance for. The purpose of this session is to provide you with guidance around those administrative things you should do to have a successful, maintainable SSRS Site in a large Enterprise. We wll discuss

How should folder structure and security be set up? Are there best practices around data sources? Are SSRS 2008 Report Models Models ready for the enterprise? How should projects be organized?
Is Report Builder 2.0 good enough yet? What works well and what will cause you pain?

We will spend our time in a very practical discussion to help you get SSRS deployed and working.

SessionID: 34645

SQL Server Support Team QA

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Andy Warren, Steve Jones, Rushahb Mehta

Title: SQL Server Support Team QA

Abstract:

Here's your chance to speak directly with members of the SQL Server Support Team based in Charlotte.

SessionID: 34646

KEYNOTE: SQLSaturday Past, Present and Future

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Andy Warren, Steve Jones, Rushahb Mehta

Title: KEYNOTE: SQLSaturday Past, Present and Future

Abstract:

SQLSaturday founders Andy Warren and Steve Jones, and current PASS President Rushabh Mehta, will conduct an open forum discussion on SQLSaturday -- where it has been, and where it will be heading under PASS management. Microsoft's Bill Walker will also be covering venue logistics, and CSSUG's Peter Shire will be going over prize drawings and after-party details. PLEASE DO NOT MISS!

SessionID: 34647

LUNCH!

Back to calendar

Event Date: 06-03-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Andy Warren, Steve Jones, Rushahb Mehta

Title: LUNCH!

Abstract:

Meet for lunch in the Microsoft cafeteria!

This site is open source. Improve this page.