sqlsathistory

Nr: 67

Back to Main list

SQLSaturday #67 - Chicago 2011

Start Time (24h)	Speaker	Track	Title
00:00:00	Aaron Lowe	Room 218	Raise the Bar by Writing Professional Database Cod
00:00:00	Aaron Bertrand	Room 216	What's new in SQL Server 2011 ("Denali")?
00:00:00	Allan Hirt	Room 214	Windows Failover Clustering Basics for the DBA
00:00:00	Arie Jones	Room 214	Monitoring Data Changes with Change Data Capture
00:00:00	Allen White	Room 214	Automate Policy-Based Management using PowerShell
00:00:00	Bob Pusateri	Room 216	Backups Recovery In Depth
00:00:00	Brent Ozar	Room 116	SQL Server Storage: Filegroups, Files, Partitions
00:00:00	Christina Leo	Room 218	SQL Server Internals: It's What's for Dinner!
00:00:00	Craig Purnell	Room 118	Database Mirroring in the Real World
00:00:00	Dave Paulson	Room 118	Running Mission Critical Apps on SQL Server
00:00:00	David Stein	Room 217	Data Warehousing - How to Convince "The Bobs"
00:00:00	David Levy	Room 118	What To Do When It All Goes So Wrong
00:00:00	Doug Lane	Room 117	Data-Driven Report Subscriptions with SSIS
00:00:00	Erin Stellato	Room 116	Baselines First, Troubleshooting Second
00:00:00	Eddie Wuerch	Room 216	Find Performance Problems by Reading the Waits
00:00:00	Grant Fritchey	Room 217	The Optimizer, Statistics, and Indexes
00:00:00	Haidong Ji	Room 117	Minimize fragmentation during data loading
00:00:00	Hope Foley	Room 216	Self Service BI in SQL Server 2008 R2 (PowerPivot)
00:00:00	Herve Roggero	Room 116	SQL Azure Performance Considerations
00:00:00	Jason Strate	Room 215	Index Black Ops
00:00:00	Jose Chinchilla	Room 215	Custom hierachies with Analysis Services (SSAS)
00:00:00	Jeff Mlakar	Room 116	Introduction to Developing with SQL Azure
00:00:00	Jeremiah Peschka	Room 216	Refactoring SQL
00:00:00	Jes Schultz	Room 218	Make Your Voice Heard!
00:00:00	John Welch	Room 117	Do More (ETL) with Less (Effort) - Automating SSIS
00:00:00	James Volkmann	Room 118	Using Report Builder 3.0
00:00:00	Karen Lopez	Room 215	Database Design Contentious Issues
00:00:00	Mark Vaillancourt	Room 118	Intro To Reporting Services Report Models
00:00:00	Michelle Ufford	Room 117	Index Internals for Mere Mortals
00:00:00	Nicholas Cain	Room 214	Powershell: Are you checking out my profile?
00:00:00	Norman Kelm	Room 117	The Script Task, powerhouse of SSIS
00:00:00	Randy Knight	Room 215	Understanding SQL Server XML Features
00:00:00	Brian Davis	Room 214	Service Broker...What's That How Do I Use It?
00:00:00	Ross LoForte	Room 217	SQL 2008 High Availability and Disaster Recovery
00:00:00	Tim Ford	Room 217	Who Needs DMVs? You Do!
00:00:00	Thomas LaRock	Room 215	Performance Tuning Made Easy
00:00:00	Ted Krueger	Room 218	SSIS: The DBA multiplier
00:00:00	Ted Krueger	Room 116	Ask the Experts - Prize Giveaway
00:00:00	Ted Krueger	Room 216	WIT Panel
00:00:00	Kevin Boles	Room 217	Advanced TSQL Solutions

SessionID: 28424

Raise the Bar by Writing Professional Database Cod

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 218

Speaker: Aaron Lowe

Title: Raise the Bar by Writing Professional Database Cod

Abstract:

As protectors of arguably, the most important asset companies’ have we are tasked with ensuring quality, security and performance. However the ways in which we utilize and obtain those assets are often not formalized and therefore suffer from degraded quality. Let's discuss some strategies that can be implemented to not only raise the bar of quality, but also make you sleep easier at night.

SessionID: 28438

What's new in SQL Server 2011 ("Denali")?

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 216

Speaker: Aaron Bertrand

Title: What's new in SQL Server 2011 ("Denali")?

Abstract:

This presentation will cover all of the new features coming our way in the next major version of SQL Server. From contained databases to high availability to T-SQL enhancements, we will cover the good, the bad, the missing and the ugly. Several demos and no marketing.

SessionID: 28601

Windows Failover Clustering Basics for the DBA

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 214

Speaker: Allan Hirt

Title: Windows Failover Clustering Basics for the DBA

Abstract:

While you can see how to deploy a failover cluster in 60 minutes, what a DBA really needs is a solid foundation of Windows to truly be able to understand that implementation and its subsequent administration. This session will demystify the Windows layer of clustering and present it from a DBA focus. Using Windows Server 2008 R2, some of the topics that will be shown are: failover cluster validation and its impact on installing SQL Server, a tour of the new Failover Cluster Manager and how it can be used for administration, using the new cluster logs for troubleshooting, and more.

SessionID: 28835

Monitoring Data Changes with Change Data Capture

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 214

Speaker: Arie Jones

Title: Monitoring Data Changes with Change Data Capture

Abstract:

Most modern enterprise database environments require some measure of auditing their data. Previously, the DBA would need to put together a complicated web of triggers and history tables in order to properly track data changes. Now in SQL Server 2008, Change Data Capture allows the DBA to readily enact a very straight-forward method for tracking the changes and understanding easily how they took place. In this session, we will examine how to set-up, configure, use, and administer the Change Data Capture process in your environment.

SessionID: 28947

Automate Policy-Based Management using PowerShell

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 214

Speaker: Allen White

Title: Automate Policy-Based Management using PowerShell

Abstract:

The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment. PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems. This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action.

SessionID: 29126

Backups Recovery In Depth

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 216

Speaker: Bob Pusateri

Title: Backups Recovery In Depth

Abstract:

What does the Bulk Logged recovery model really mean anyway? Backup and Recovery are two of the most crucial functions a DBA can perform, however they’re also some of the least understood. We’ll bust some myths and take a good look at how backups restores really work including a comparison of recovery models, important facts about the transaction log, and tips tricks for enhancing performance.

SessionID: 29236

SQL Server Storage: Filegroups, Files, Partitions

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 116

Speaker: Brent Ozar

Title: SQL Server Storage: Filegroups, Files, Partitions

Abstract:

It’s hard to find good information about SQL Server storage. Should you put data and log files on different drives when they’re on a SAN? How do you know when to add more data files? Is there an advantage to using multiple filegroups? Brent’s a former SAN administrator and wrote the storage chapter of Professional SQL Server 2008 Internals and Troubleshooting. He’s got the answers you’re looking for, and he’ll help demystify what SQL Server’s doing inside the black box. Attendees will learn why you shouldn’t add files to an existing filegroup, how to get faster performance from TempDB, and how to check your file performance using DMVs.

SessionID: 29534

SQL Server Internals: It's What's for Dinner!

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 218

Speaker: Christina Leo

Title: SQL Server Internals: It's What's for Dinner!

Abstract:

Ever wondered what happens under the hood when you query your SQL Server database? Well, it’s somewhat like asking for a special meal for dinner. During this session, I will use a chef analogy to describe the life cycle of a query and the journey it takes through SQL Server’s working parts. By comparing the concepts of SQL Internals to a familiar idea, you will have a clear understanding of the underlying processes involved in returning data from a SELECT query. Once we’ve established a frame of reference for a simple read operation, we’ll look at an UPDATE statement and consider the additional factors associated with a write operation. By session's end you should have a clear overview of what happens when a query hits your server.

SessionID: 29640

Database Mirroring in the Real World

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 118

Speaker: Craig Purnell

Title: Database Mirroring in the Real World

Abstract:

A review of Database Mirroring in the context of operations at Baker Hostetler, where mirroring has been a cornerstone H.A. tool for over 5 years. A high level review of the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a rolling upgrades or to move large databases to a different location.

SessionID: 29704

Running Mission Critical Apps on SQL Server

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 118

Speaker: Dave Paulson

Title: Running Mission Critical Apps on SQL Server

Abstract:

This presentation will highlight case studies about some of the largest SQL Server customers who are pushing the envelope with SQL Server in various ways. This includes scalability in Database size, Transaction throughput and Replication, etc. This presentation has been given in the past by a member of the SQL Customer Advisory Team (SQLCAT.com), Kevin Cox, who has worked with some of these large customers. This session will effectively illustrate the capabilities of SQL Server, maybe beyond the limits you thought possible. This will give you confidence in recommending the use of SQL Server for your most demanding workloads within your organization.

SessionID: 29761

Data Warehousing - How to Convince "The Bobs"

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 217

Speaker: David Stein

Title: Data Warehousing - How to Convince "The Bobs"

Abstract:

Building your first Data Warehouse is a long, and often difficult process. How can you get your boss to approve a Data Warehouse project? What’s the best way to explain dimensional modeling and the benefits of a Data Warehouse to a business person? What are the best/most cost effective ways of learning it? What kind of materials, hardware, software, etc do you need? What’s the best way to build a proof of concept that will impress your boss, as rapidly as possible?

Come to this presentation, and I’ll answer all of these questions plus the most important question of all.

“Is this good for the company?” Absolutely.

SessionID: 29809

What To Do When It All Goes So Wrong

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 118

Speaker: David Levy

Title: What To Do When It All Goes So Wrong

Abstract:

As IT Professionals we inevitably will see situations where everything goes wrong. At times we are somewhat lucky and this just means diminished functionality or a slow system. Other times our organization is temporarily out of business. Regardless of the scope of the issue, how we react can have a direct impact on how quickly things are returned to normal. This session will cover how to communicate issues, including what to say, who to say it to and when to say it. Part of managing communication is to get everyone into a room, forcing them to talk, so time will be spent on designing an effective war room. The session will also cover how by setting out to prove that an issue is ours we are able to more quickly get at a root cause.

SessionID: 29967

Data-Driven Report Subscriptions with SSIS

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 117

Speaker: Doug Lane

Title: Data-Driven Report Subscriptions with SSIS

Abstract:

Do you have the need for data-driven subscriptions, but no room in the budget to buy Enterprise Edition? If so, this session is for you. We'll cover how you can deliver reports, by both file share and e-mail, on a limitless number of schedules, all using one simple package.

SessionID: 30083

Baselines First, Troubleshooting Second

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 116

Speaker: Erin Stellato

Title: Baselines First, Troubleshooting Second

Abstract:

“The system is slow. It was much faster last week! This is taking forever.” Statements like these from users can be frustrating for any DBA, unless you have the data to prove how the system regularly performs. In this session we will cover some of the tools and techniques freely available to SQL Server DBAs for capturing baselines that can be used for measuring performance, capacity planning and understanding usage patterns. We also discuss how these utilities and their data can be used to identify warning signs and troubleshoot performance issues. Tools covered include: PerfMon, PAL, Profiler, ClearTrace, RMLUtils, who_is_active and SQL Server DMVs

SessionID: 30150

Find Performance Problems by Reading the Waits

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 216

Speaker: Eddie Wuerch

Title: Find Performance Problems by Reading the Waits

Abstract:

Start with a simple proposition: a process is either working or waiting. You can tune the working part, but are you seeing the whole picture? There are many different resources on which your process could be waiting – a lock, memory, disk, CPU, and much more. When a process must wait, SQL Server will log it. There are hundreds of different wait types, and they are a gold mine of data for finding and solving performance problems – and proving the changes worked. After attending this session, you will be able to gather wait stats and use them to zero in on performance issues affecting your databases. Stop guessing, start knowing!

SessionID: 30259

The Optimizer, Statistics, and Indexes

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 217

Speaker: Grant Fritchey

Title: The Optimizer, Statistics, and Indexes

Abstract:

This session, part of a full-day session which will be presented at SQL Rally, will introduce the query optimizer. Discussion will center around how the optimizer works. We'll explore the importance of statistics to the optimizer and how indexes affect the choices the optimizer makes.

SessionID: 30291

Minimize fragmentation during data loading

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 117

Speaker: Haidong Ji

Title: Minimize fragmentation during data loading

Abstract:

BI data store mostly serves scan-centric operations. As such, it is important to minimize fragmentation during data loading process.

I will demonstrate ways to look at fragmentation and how to best avoid them while achieving fast data loading process. BCP, partitions, partition switch, and verifications will be discussed and demonstrated in having data tightly packed with 0 to minimal fragmentation.

SessionID: 30323

Self Service BI in SQL Server 2008 R2 (PowerPivot)

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 216

Speaker: Hope Foley

Title: Self Service BI in SQL Server 2008 R2 (PowerPivot)

Abstract:

There are many IT pros who know all the snazzy tools to create fantastic reports. The users who know the data inside and

out may not know those tools, but odds are that they know Excel. Microsoft has released PowerPivot which seems to bridge the gap between the two worlds. These power users can now create their own fantastic reports within PowerPivot. We will explore what PowerPivot is and how can use it to create a self-service business intelligence solution.

SessionID: 30329

SQL Azure Performance Considerations

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 116

Speaker: Herve Roggero

Title: SQL Azure Performance Considerations

Abstract:

In this session we will dive in the world of Azure, the Cloud Computing offering from Microsoft. We will take a look at SQL Azure from an application design perspective including design options, scalability and performance. If you are wondering what SQL Azure can do for you, how to best leverage it from a performance and scalability standpoint, and it compares to SQL Server, then this session is for you!

SessionID: 30550

Index Black Ops

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 215

Speaker: Jason Strate

Title: Index Black Ops

Abstract:

There's a lot that goes on under the covers of SQL Server with your indexes. But it's not as secretive as you might think. Most of this information is made available to you through DMVs. While this information is useful - you need a clear understanding of what is in the DMVs in order to understand what is going on. In this session we'll take a dive into sys.dm_index_operational_stats to find out what it does and what you can do with this information.

SessionID: 30630

Custom hierachies with Analysis Services (SSAS)

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 215

Speaker: Jose Chinchilla

Title: Custom hierachies with Analysis Services (SSAS)

Abstract:

In this session I will showcase how to create custom hierarchies in SSAS by defining attribute relationships and key columns the right way. Attendees will also learn how to optimize SSAS hierarchies by specifying the right cardinality option, relationship type, and member uniquenes properties.

SessionID: 30660

Introduction to Developing with SQL Azure

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 116

Speaker: Jeff Mlakar

Title: Introduction to Developing with SQL Azure

Abstract:

The Cloud is fast becoming the latest hot topic in the technology arena. We need to understand how we as SQL Developers and Administrators can utilize SQL Azure, Microsoft’s platform for relational data storage in the Cloud, to meet our needs. This talk will be a step-by-step demo of how to obtain an Azure subscription, create and administer a SQL Azure database, and work with it from your own SQL Server Management Studio AddIn. You’ll find that Azure is so easy to work with, you’ll get two for the price of one in this talk: you’ll learn Azure and learn how to create a Management Studio AddIn!

SessionID: 30733

Refactoring SQL

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 216

Speaker: Jeremiah Peschka

Title: Refactoring SQL

Abstract:

Refactoring SQL is not like refactoring application code. This talk will demonstrate proven SQL refactoring techniques that will help you identify where performance gains can be made, apply quick fixes, improve readability, and help you quickly locate places to make sweeping performance improvements. Jeremiah Peschka has years of hands on experience tuning SQL applications for performance, throughput, and concurrency.

SessionID: 30780

Make Your Voice Heard!

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 218

Speaker: Jes Schultz

Title: Make Your Voice Heard!

Abstract:

SQL Server professionals like to talk - a lot. We blog, we tweet, we answer forum questions, and more. Add your voice! Learn about the different ways you can share your experience and knowledge. Once you start teaching others, you'll realize how much knowledge you have!

SessionID: 30959

Do More (ETL) with Less (Effort) - Automating SSIS

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 117

Speaker: John Welch

Title: Do More (ETL) with Less (Effort) - Automating SSIS

Abstract:

SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you'll learn how to automate package creation in SSIS, including the dynamic generation of data flows. We’ll cover some of the free and open source tools available for this, and discuss “roll your own” options.

SessionID: 31168

Using Report Builder 3.0

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 118

Speaker: James Volkmann

Title: Using Report Builder 3.0

Abstract:

Creating Matrix Reports, Bar Charts and Maps with Report Builder 3.0.

SessionID: 31193

Database Design Contentious Issues

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 215

Speaker: Karen Lopez

Title: Database Design Contentious Issues

Abstract:

A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.

SessionID: 31595

Intro To Reporting Services Report Models

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 118

Speaker: Mark Vaillancourt

Title: Intro To Reporting Services Report Models

Abstract:

Report Models can be a great way to empower your end users to create their own reports through a drag and drop tool. This presentation will discuss how to create, maintain and secure SSRS Report Models. Although the focus is on implementation, we will use Report Builder 3.0 to demonstrate report model consumption. We will also cover some tips and tricks learned through real-world experience implementing and supporting report models for clients.

SessionID: 31781

Index Internals for Mere Mortals

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 117

Speaker: Michelle Ufford

Title: Index Internals for Mere Mortals

Abstract:

Most DBA's have heard of indexes, but not everyone understands how they work. In this in-depth session, Michelle will cover the internals of indexes, including index filtering and partitioning. She'll compare the B-trees of different index types, explain fragmentation, and use undocumented commands to show you what an actual index page looks like. Attendees will walk away with a much better understanding of indexes, which is helpful when designing and tuning databases. If you've ever wondered just what goes on in an index, this is the session for you!

SessionID: 32073

Powershell: Are you checking out my profile?

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 214

Speaker: Nicholas Cain

Title: Powershell: Are you checking out my profile?

Abstract:

Powershell is a very powerful management tool and you can spend hours writing magical scripts to do all the things you want. Frequently forgotten is the Powershell profile, a place you can add your own functions which can provide you lightening fast access to information. We'll talk about the power a profile puts at your fingertips. I will also demo (and share) a bunch of short functions that I use frequently for common tasks. I'll show you my Powershell profile if you show me yours.

SessionID: 32105

The Script Task, powerhouse of SSIS

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 117

Speaker: Norman Kelm

Title: The Script Task, powerhouse of SSIS

Abstract:

Everyday more DBAs and SQL developers are given responsibility for ETL development. They have a strong SQL background with little or no .Net language programming experience. As they progress with SSIS, they can come up against perceived limitations in the capabilities of SSIS using only the built-in tasks. What they may not realize is the extensibility available to SSIS via the Script Task. This presentation will provide them with the tools they need to move beyond that perceived limitation.

SessionID: 32406

Understanding SQL Server XML Features

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 215

Speaker: Randy Knight

Title: Understanding SQL Server XML Features

Abstract:

The XML Functionality embedded into SQL Server 2005 and 2008 is one of its most powerful yet least understood features. This seems to be primarily because DBA's shy away from it and developers prefer to work with XML in their code. In this session we will explore the XML features of SQL Server and how we can bridge these two worlds. Topics covered will include retrieving relational data as XML, storing XML in the database using the XML Datatype, XML indexes, and the XQuery functions included in SQL Server. We will also look at using XML as stored procedure parameters as a way to pass large amounts of complex data between client and server.

SessionID: 32449

Service Broker...What's That How Do I Use It?

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 214

Speaker: Brian Davis

Title: Service Broker...What's That How Do I Use It?

Abstract:

Have you heard of Service Broker? Do you know what it is? How about how to use it? This session will answer these questions and more. Service Broker is arguably one of the least known and used features of SQL Server. We'll explore Service Broker and learn what it is and how it works. We'll walk through the setup and configuration along with demonstrating its use. You'll leave this session with a better understanding of Service Broker, its use and implementation, along with ideas of how you can implement it in your own environments.

SessionID: 32653

SQL 2008 High Availability and Disaster Recovery

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 217

Speaker: Ross LoForte

Title: SQL 2008 High Availability and Disaster Recovery

Abstract:

SQL Server 2005 and SQL Server 2008 offers many technologies that can be used to minimize downtime and maximize data protection for the business to ensure smooth operation, continuous access to business critical data, and meet availability levels according to various service level agreements. This presentation will start with an overview of the high availability and disaster recovery offered and then describe five commonly-deployed architectures using SQL Server 2005 and SQL Server 2008 that are designed to meet the high-availability and disaster recovery requirements of enterprise applications.

SessionID: 33023

Who Needs DMVs? You Do!

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 217

Speaker: Tim Ford

Title: Who Needs DMVs? You Do!

Abstract:

Learn how you can query Dynamic Management Views (and Functions) to troubleshoot performance issues, tune troublesome queries, learn the innermost secrets of your SQL Server instances, and capacity plan among other things. Tim pulls from his new project: The Periodic Table of DMVs as well as his sessions on DMVs at SQL Cruise to examine and discuss a wide variety of DMVs (and DMFs).

SessionID: 33049

Performance Tuning Made Easy

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 215

Speaker: Thomas LaRock

Title: Performance Tuning Made Easy

Abstract:

Performance tuning is hard, everyone knows that. Attend this session and learn how to define, measure, and analyze performance issues as well as implementing changes and also how to make sure those changes continue to have the desired effects. In short, I break down performance tuning into pieces that anyone can understand. Leave this session knowing what actions to take when you get back to work on Monday.

SessionID: 33340

SSIS: The DBA multiplier

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 218

Speaker: Ted Krueger

Title: SSIS: The DBA multiplier

Abstract:

Ever wanted to create clones of yourself to get all your work done faster? I will demonstrate how SSIS can help you perform your DBA tasks as if there were more than one of you. You will leave the session knowing how to use SSIS to automate tasks such as performance monitoring above (and below) the normal health checks and transporting databases from one environment to another. You will also learn how SSIS can be used in assisted HA and DR failover strategies as well as backup solutions that go beyond the simple BACKUP statement.

We’re going to take SSIS and make it a standard tool for your administrative tasks!

SessionID: 33342

Ask the Experts - Prize Giveaway

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 116

Speaker: Ted Krueger

Title: Ask the Experts - Prize Giveaway

Abstract:

Take this time to ask all the experts any questions you have. This will also be our raffle time so make sure you attend for your chance to win some awesome prizes from our awesome sponsors

SessionID: 33343

WIT Panel

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 216

Speaker: Ted Krueger

Title: WIT Panel

Abstract:

Come join several respected Women in Technology (WIT) at lunch.

SessionID: 33465

Advanced TSQL Solutions

Back to calendar

Event Date: 26-03-2011 - Session time: 00:00:00 - Track: Room 217

Speaker: Kevin Boles

Title: Advanced TSQL Solutions

Abstract:

The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven't been shown the light you might never realize what is possible. Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques.

This site is open source. Improve this page.