sqlsathistory

Nr: 31

Back to Main list

SQLSaturday #31 - Chicago 2010

Start Time (24h) Speaker Track Title
00:00:00 Aaron Nelson Track 3 PowerShell for Data Professionals
00:00:00 Aaron Lowe Track 1 Vendor Session A
00:00:00 Aaron Lowe Track 1 Vendor Session B
00:00:00 Aaron Lowe Track 1 Ask the Experts QA
00:00:00 Aaron Lowe Track 1 Welcome and Keynote
00:00:00 Aaron Lowe Track 1 After Party
00:00:00 Adam Jorgensen Track 2 Zero to Cube in 60 Minutes
00:00:00 Andrew Karcher Track 2 One Developers Journey into MDX
00:00:00 Arie Jones Track 4 Working with Spatial Data in SQL Server 2008
00:00:00 Arie Jones Track 3 Reporting Services 2008 Unleashed!
00:00:00 Brad McGehee Track 1 Introduction to Graphical Execution Plans
00:00:00 Brad McGehee Track 1 How and When to Use Indexed Views
00:00:00 Brent Ozar Track 1 BLITZ! 60 Minute Server Takeovers
00:00:00 Brent Ozar Track 3 Perfmon Profiler 101
00:00:00 David Levy Track 4 Getting Out from Behind the Curtain - The New DBA
00:00:00 Chuck Heinzelman Michael Steineke Track 1 Oh Cluster, My Cluster!
00:00:00 Derek Comingore Track 3 Delivering Rapid Business Value with Microsoft BI
00:00:00 Dean Richards Track 3 Wait-Time Based Performance Management
00:00:00 Jeremiah Peschka Track 1 A Dynamic World Demands Dynamic SQL
00:00:00 Jeremiah Peschka Track 4 Fundamentals of SQL Server Internals
00:00:00 Jorge Segarra Track 4 SQL University 201: More DBA Fun
00:00:00 Jorge Segarra Track 4 Policy Based Management 101
00:00:00 Jason Strate Track 3 Using XML to Query Execution Plans
00:00:00 Jason Strate Track 3 Extended Events, Work Smarter Not Harder
00:00:00 Kevin Kline Track 1 Stored Procedure Best Practices
00:00:00 Devin Knight Track 2 Analysis Services Partitions and Aggregations
00:00:00 Alex Kuznetsov Track 1 Defensive programming with Transact SQL
00:00:00 Ross LoForte Track 4 Proactive DBA: Manage SQL Server Better
00:00:00 Tim Ford Track 3 SQL DMVs, DMFs, DMOs. WTH?
00:00:00 Tim Ford Track 4 Tools for The Driven, But Lazy DBA
00:00:00 Aaron King Track 4 The Benefits of SQL Azure
00:00:00 Wes Dumey Track 2 Building a Data Warehouse using SQL Server 2008

SessionID: 28395

PowerShell for Data Professionals

Back to calendar

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

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

Vendor Session A

Back to calendar

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

Speaker: Aaron Lowe

Title: Vendor Session A

Abstract:

Vendor Presentation

SessionID: 28426

Vendor Session B

Back to calendar

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

Speaker: Aaron Lowe

Title: Vendor Session B

Abstract:

Vendor Presentation

SessionID: 28427

Ask the Experts QA

Back to calendar

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

Speaker: Aaron Lowe

Title: Ask the Experts QA

Abstract:

Ask the Experts QA

SessionID: 28428

Welcome and Keynote

Back to calendar

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

Speaker: Aaron Lowe

Title: Welcome and Keynote

Abstract:

Welcome and Keynote

SessionID: 28429

After Party

Back to calendar

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

Speaker: Aaron Lowe

Title: After Party

Abstract:

After Party

SessionID: 28511

Zero to Cube in 60 Minutes

Back to calendar

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

Speaker: Adam Jorgensen

Title: Zero to Cube in 60 Minutes

Abstract:

Overcome the barriers of traditional training and seminars with this Quick Start to building a cube. This all demo session will get you started and answer many questions you have about building cubes the right way, the first time.

SessionID: 28545

One Developers Journey into MDX

Back to calendar

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

Speaker: Andrew Karcher

Title: One Developers Journey into MDX

Abstract:

"You are a database guy, how do I write a query in MDX?" This is a question that many of you are probably hearing right now as your companies' database experts. As the amount of data access being delivered cubes in increasing every day your company is looking to you to help unlock that stored potential. You have used the query designers and profiler to build some really simple stuff, but now you need to really understand the language and figure how to do some more complex stuff. This session will help you take that journey from not understanding MDX to being an MDX Developer. This session will give you the core concepts of MDX and how to utilize them with clear concrete examples, along with the tools to get you there.

SessionID: 28807

Working with Spatial Data in SQL Server 2008

Back to calendar

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

Speaker: Arie Jones

Title: Working with Spatial Data in SQL Server 2008

Abstract:

Spatial data is being pushed more and more into the forefront of our application universe. With the advent of MapPoint and Google Maps companies are consistantly pushing the boundaries of what traditional databases can do. Now with SQL Server 2008 we have built in spatial data types that will make your life a little easier in the days to come. This session will focus on utilizing these native types to store, analyze, and retrieve spatial data so that you can become the spatial data pro in your organization.

SessionID: 28809

Reporting Services 2008 Unleashed!

Back to calendar

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

Speaker: Arie Jones

Title: Reporting Services 2008 Unleashed!

Abstract:

SQL Server Reporting Services has been around for a number of years now and the 2008 release provided DBAs and Developers with a truly enterprise class reporting platform. If your company had not embraced Reporting Services fully yet then now is the time! Come see not only some of the new features that are available but also how to programmatically interface with the Reporting Services web services in order to extend your own custom applications!

SessionID: 29176

Introduction to Graphical Execution Plans

Back to calendar

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

Speaker: Brad McGehee

Title: Introduction to Graphical Execution Plans

Abstract:

In this introductory level session, which is designed for DBAs with little or no knowledge of query execution plans, you will learn why execution plans are important, how they are created, learn about the different execution plan formats, discover different ways to produce them, find out about the difference between estimated and actual execution plans, and most importantly, learn the basics of how to read and interpret graphical execution plans. This includes taking a look at ten of the most commonly used execution plan operators, and finding out exactly what they mean.

SessionID: 29182

How and When to Use Indexed Views

Back to calendar

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

Speaker: Brad McGehee

Title: How and When to Use Indexed Views

Abstract:

Indexed views are an often misunderstood and underused feature of SQL Server that more DBAs should learn to master. Essentially, an indexed view is a standard view that has been materialized (made physical) by adding a unique clustered index to it. When used appropriately, they can greatly speed query performance. In this session, you will learn the features and benefits of using indexed views, learn where indexed views work best, learn how to create indexed views, and review indexed view best practices.

SessionID: 29227

BLITZ! 60 Minute Server Takeovers

Back to calendar

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

Speaker: Brent Ozar

Title: BLITZ! 60 Minute Server Takeovers

Abstract:

You're minding your own business in your corner office - well, no, you're a DBA, so it's just your cubicle - when somebody says, "Did you know about this SQL Server over here?" Suddenly, you have to find out what the server's doing, how it was set up, and whether things are working correctly. In this real-time session, Brent will show you how he tackles unknown servers in 60 minutes to find problems, take an inventory, and set the server up for easier management down the road.

SessionID: 29228

Perfmon Profiler 101

Back to calendar

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

Speaker: Brent Ozar

Title: Perfmon Profiler 101

Abstract:

SessionID: 29702

Getting Out from Behind the Curtain - The New DBA

Back to calendar

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

Speaker: David Levy

Title: Getting Out from Behind the Curtain - The New DBA

Abstract:

The days of hiding amongst rows of servers, focusing purely on operational tasks are quickly coming to an end. This presentation will provide a high level overview of how to boost your value to your organization by automating the mundane operational tasks and focusing on supporting new development. Topics covered will include tools and techniques available for automation, integration with development teams and relationship management.

SessionID: 29810

Oh Cluster, My Cluster!

Back to calendar

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

Speaker: Chuck Heinzelman Michael Steineke

Title: Oh Cluster, My Cluster!

Abstract:

Clustering is a black box to many DBAs. Often, the IT dept configures installs the SQL cluster then turns it over to DBAs to deploy databases and set up backup maintenance plans. The problem is when things go wrong the DBAs are reliant on the IT dept when their time is better spent working on other things. The goal of this session is to discuss underlying aspects of SQL Server clustering. We will touch on OS and SQL Server issues as well as how it reacts differently being clustered vs non-clustered. We will also discuss the pitfalls of upgrading clustered databases and installing clusters from scratch including lessons learned from a real-world upgrade of a SQL Server cluster where the active and passive nodes are 1,200 miles apart!

SessionID: 29845

Delivering Rapid Business Value with Microsoft BI

Back to calendar

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

Speaker: Derek Comingore

Title: Delivering Rapid Business Value with Microsoft BI

Abstract:

The days of long, inefficient Business Intelligence (BI) and data warehousing projects are coming to an end. Customers need to ability to reap quick business value for their investments. In this session we will take a tour of methodologies, techniques, and technologies that enable a quick return on investment for the Microsoft BI platform.

SessionID: 29871

Wait-Time Based Performance Management

Back to calendar

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

Speaker: Dean Richards

Title: Wait-Time Based Performance Management

Abstract:

SessionID: 30755

A Dynamic World Demands Dynamic SQL

Back to calendar

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

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

Fundamentals of SQL Server Internals

Back to calendar

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

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

SQL University 201: More DBA Fun

Back to calendar

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

Speaker: Jorge Segarra

Title: SQL University 201: More DBA Fun

Abstract:

In our 101 session we covered general basics and walk throughs of some of the ground-level skillsets for a DBA. In this second class we dive into more advanced topics such as indexes, DMVs and advanced troubleshooting.

SessionID: 31018

Policy Based Management 101

Back to calendar

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

Speaker: Jorge Segarra

Title: Policy Based Management 101

Abstract:

We will be learning an overview of this powerful new feature in SQL 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Servers!

SessionID: 31153

Using XML to Query Execution Plans

Back to calendar

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

Speaker: Jason Strate

Title: Using XML to Query Execution Plans

Abstract:

SQL Server stores its execution plans as XML in dynamic management views. The execution plans are a gold mine of information. From the whether or not the execution plan will rely on parallelism to what columns are requiring a key lookup after a non-clustered index seek. Through a the use of XML this information can be available at your finger tips to help determine the value and impact of an index and guide you in improving the performance of your SQL Server databases.

Goals:

  1. Discuss information available in an execution plan
  2. Demonstrate use of XQuery to query execution cache
  3. Demonstrate methods to performance tune

SessionID: 31155

Extended Events, Work Smarter Not Harder

Back to calendar

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

Speaker: Jason Strate

Title: Extended Events, Work Smarter Not Harder

Abstract:

There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.

Goals:

  1. Define the architecture for Extended Events
  2. Identify scenarios where Extended Event can be used to troubleshoot performance
  3. Demonstrate solutions to real-world performance scenarios

SessionID: 31303

Stored Procedure Best Practices

Back to calendar

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

Speaker: Kevin Kline

Title: Stored Procedure Best Practices

Abstract:

Find out the tricks and techniques needed to make SQL Server stored procedures achieve top performance. Numerous tips will show you how to make your stored procedures run faster, with fewer errors, and with better reliability. This class assumes a basic understanding of Transact-SQL. The session covers both SQL Server 2005 and 2008.

SessionID: 31417

Analysis Services Partitions and Aggregations

Back to calendar

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

Speaker: Devin Knight

Title: Analysis Services Partitions and Aggregations

Abstract:

In this session, you will learn how to split your measure group data in to more manageable pieces using partitions to speed up cube processing time. Then designing aggregations on your partitions will be discussed including how to create aggregations using Usage Based Optimization (UBO) to speed up query time.

SessionID: 32483

Defensive programming with Transact SQL

Back to calendar

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

Speaker: Alex Kuznetsov

Title: Defensive programming with Transact SQL

Abstract:

I will explain what is defensive programming, what are its advantages, and provide several simple real life examples that show how to use it. I will demonstrate how to develop robust Transact SQL code that correctly works in high concurrency environments, gracefully handles cases of unintended use, and is easy to maintain in changing environments.

SessionID: 32655

Proactive DBA: Manage SQL Server Better

Back to calendar

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

Speaker: Ross LoForte

Title: Proactive DBA: Manage SQL Server Better

Abstract:

At Microsoft we understand that in the current economic climate you are being asked to better manage your database environment and reduce costs; in essence, keep the lights on. We have pulled together best practices for not only keeping the lights on but helping you manage more SQL Servers with less time and expense. The focus of this presentation is around:

o o Management best practice: SQL Server Discovery o Microsoft Assessment and Planning Toolkit (MAP) o MAP query and report analysis o SQL Server 2008 management enhancements o Policy Based Management o Performance Data Warehouse o Configure Resource Governor o Management best practice: Cross Platforms

SessionID: 33018

SQL DMVs, DMFs, DMOs. WTH?

Back to calendar

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

Speaker: Tim Ford

Title: SQL DMVs, DMFs, DMOs. WTH?

Abstract:

Dynamic Management Views and Functions first made their appearance in SQL 2005. With almost five years of exposure they are still forbidden fruit for many DBAs. Find out how to tap into the power of these objects. To tune indexes, examine file I/O and wait stats, maintain healthy indexes, and see just who is doing what and when on your SQL Servers.

SessionID: 33019

Tools for The Driven, But Lazy DBA

Back to calendar

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

Speaker: Tim Ford

Title: Tools for The Driven, But Lazy DBA

Abstract:

We all know how difficult it is being a DBA. Everyone assumes they are your top priority, and time is in short supply to get everything accomplished daily. Heck, we all like to sleep at night too! This session will demonstrate the tools out of the box, as well as developed by the presenter, that allow you to automate tasks and make it possible for you to be a great DBA AND have a personal life.

SessionID: 33777

The Benefits of SQL Azure

Back to calendar

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

Speaker: Aaron King

Title: The Benefits of SQL Azure

Abstract:

This talk will focus on the benefits, features, object model and ease of use of SQL Server Data Services. Learn how your projects can benefit from a hosted data storage and query processing service. See by example how to design your program to use SQL Server Data Services.

SessionID: 34483

Building a Data Warehouse using SQL Server 2008

Back to calendar

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

Speaker: Wes Dumey

Title: Building a Data Warehouse using SQL Server 2008

Abstract:

In this session we will talk about building a data warehouse using the SQL Server 2008 database and SQL Server Integration Services ETL product. We will cover the basics of data warehousing, how to start the project, and look at how we can use the tools to solve a business problem using a real-world example.