sqlsathistory

Nr: 91

Back to Main list

SQLSaturday #91 - Omaha 2011

Start Time (24h) Speaker Track Title
00:00:00 Bill Fellows Business Intelligence - RM117 Kama Sutra of SSIS: A guide to loving ETL
00:00:00 Bill Fellows DBA - RM120 Getting started with CLR for fun and profit
00:00:00 Brad McGehee DBA - RM118 Best Practices Every SQL Server DBA Must Know
00:00:00 Brad McGehee DBA - RM118 Introduction to SQL Trace
00:00:00 David Klee DBA - RM118 Virtualizing SQL Server Deep Dive
00:00:00 David Welch DBA - RM118 Seven Benefits of Virtualization
00:00:00 Joe Ferry DBA - RM118 Performance Monitoring with Perfmon
00:00:00 Kevin Kline DBA - RM119 Top Ten DBA Mistakes
00:00:00 Kevin Kline DBA - RM119 End-to-End Troubleshooting
00:00:00 Kevin Kline DBA - RM119 SQL Server Internals Architecture
00:00:00 Mark House DB Development - RM122 A Survey of Common Performance Problems
00:00:00 Mark House DBA - RM119 Query Performance Analysis via Extended Events
00:00:00 Mike Douglas DB Development - RM122 Continuous Integration for Databases
00:00:00 Pete Ceplecha DB Development - RM121 Data to Dashboards:Back to Basics
00:00:00 Phil Brammer Business Intelligence - RM117 SSIS in Denali: What's new
00:00:00 Phil Brammer DBA - RM120 Database Monitoring with Event Notifications
00:00:00 Randy Knight DB Development - RM122 But it worked great in Dev! Performance for Devs
00:00:00 Randy Knight DB Development - RM121 Don't push the turbo button! Understanding Transa
00:00:00 Steve Hughes Business Intelligence - RM117 Report Lockdown: Implementing SSRS Security
00:00:00 Steve Hughes Business Intelligence - RM117 Performance Monitoring and Tuning in SSAS
00:00:00 Steve Hughes DB Development - RM121 Using SQL Azure in Application Development
00:00:00 Sudhir Gajre DB Development - RM121 What's new and exciting in SQL Server 'Denali'
00:00:00 Kevin Boles DB Development - RM122 Parallel Query Execution Deep Dive
00:00:00 Kevin Boles DBA - RM119 SANs and SQL Server
00:00:00 Kevin Boles DB Development - RM122 Fundamentals of Join Operations
00:00:00 Kevin Boles DBA - RM120 Common TSQL Mistakes
00:00:00 Tim Plas DBA - RM120 High-Availability and DR Options for SQL Server
00:00:00 Kathi Kellenberger DBA - RM120 Denali and T-SQL
00:00:00 Kathi Kellenberger Business Intelligence - RM117 Women in Technology Panel Discussion

SessionID: 29035

Kama Sutra of SSIS: A guide to loving ETL

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence - RM117

Speaker: Bill Fellows

Title: Kama Sutra of SSIS: A guide to loving ETL

Abstract:

Slow running packages? SSIS consuming all your resources? No idea what it's doing?

After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. Additionally, you will be armed with a list of transformations and perfmon counters to

SessionID: 29036

Getting started with CLR for fun and profit

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM120

Speaker: Bill Fellows

Title: Getting started with CLR for fun and profit

Abstract:

This session will provide an overview of the five SQL CLR objects available for SQL Server 2005-2008 and demonstrate how to create, deploy and use these objects for fun and profit.

SessionID: 29188

Best Practices Every SQL Server DBA Must Know

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM118

Speaker: Brad McGehee

Title: Best Practices Every SQL Server DBA Must Know

Abstract:

The focus of this session is on describing best practices every SQL Server DBA needs to know. These are foundational best practices that, if not followed, could have a significant negative effect on the performance and availability of their SQL Servers. This session focuses on key fundamentals, such as: Installing Upgrading SQL Server; SQL Server Configuration; User Data and Log File Management; Database Configuration Settings; Configuring Critical Maintenance Jobs; Setting Up Alerts for Critical Errors; Security Basics; Implementing a Backup and Restore Strategy; Creating a Disaster Recovery Plan; Testing; Monitoring; and Documentation.

SessionID: 29189

Introduction to SQL Trace

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM118

Speaker: Brad McGehee

Title: Introduction to SQL Trace

Abstract:

In this session you will learn: What is SQL Trace; The Pros and Cons of Using SQL Trace; How SQL Trace Works; What are the SQL Trace System Stored Procedures; How to Create Your Own SQL Trace Script; How to Query Trace Data Directly From a Trace File; and How to use the SQL Server Profiler GUI to Automatically Write SQL Trace Scripts. This session is filled with demonstrations, and assumes attendees have a basic understanding of how to use Profiler. After attending the session, attendees will be able to return to work and immediately put what they have learned into practice.

SessionID: 29908

Virtualizing SQL Server Deep Dive

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM118

Speaker: David Klee

Title: Virtualizing SQL Server Deep Dive

Abstract:

Everyone knows that SQL Server can be virtualized, but most are only virtualizing development and testing environments. Top-tier production workloads can be virtualized too, and this session will provide a deep dive into how to properly prepare for and implement a successful virtualization campaign for ALL your SQL Server environments.

SessionID: 30025

Seven Benefits of Virtualization

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM118

Speaker: David Welch

Title: Seven Benefits of Virtualization

Abstract:

SessionID: 30919

Performance Monitoring with Perfmon

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM118

Speaker: Joe Ferry

Title: Performance Monitoring with Perfmon

Abstract:

As a Premier Field Engineer I use Performance Monitor much more heavily in troubleshooting than I did before coming to Microsoft. The problem with measuring performance using this tool is that no one knows what counters are important, and if they do, they don't know what values are desired. i will discuss the few most significant counters for diagnosing performance problems.

SessionID: 31314

Top Ten DBA Mistakes

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM119

Speaker: Kevin Kline

Title: Top Ten DBA Mistakes

Abstract:

Microsoft SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t mean that database administration on SQL Server is problem free. And since SQL Server is constantly growing from small, home-grown applications, many IT professionals end up encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. In fact, wouldn’t you like to learn about those mistakes before they ever happen? There are a short list of mistakes that, if you know of them in advance, will make your life much easier.

SessionID: 31315

End-to-End Troubleshooting

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM119

Speaker: Kevin Kline

Title: End-to-End Troubleshooting

Abstract:

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

SessionID: 31316

SQL Server Internals Architecture

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM119

Speaker: Kevin Kline

Title: SQL Server Internals Architecture

Abstract:

SessionID: 31756

A Survey of Common Performance Problems

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM122

Speaker: Mark House

Title: A Survey of Common Performance Problems

Abstract:

In this session we'll discuss the common causes of poor overall performance in a SQL instance. We'll cover the tools and techniques for identifying typical performance issues, and ways to address them.

SessionID: 31757

Query Performance Analysis via Extended Events

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM119

Speaker: Mark House

Title: Query Performance Analysis via Extended Events

Abstract:

New to 2008, Extended Events allow granular performance analysis of individual queries that wasn't possible in prior versions of SQL. In this session we'll cover the collection and analysis of poorly-running queries via extended events.

SessionID: 31895

Continuous Integration for Databases

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM122

Speaker: Mike Douglas

Title: Continuous Integration for Databases

Abstract:

Utilizing TFS 2010 and Visual Studio Database Projects, databases can be included with the Application's CI build. We will discuss Database Projects, walk through a basic scenario, and finish with an enterprise solution that performs the following: Drop DB > Create to Prod > Create Development Delta > Apply Development Delta > Run Data Generation plan > Run Database Tests.

SessionID: 32201

Data to Dashboards:Back to Basics

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM121

Speaker: Pete Ceplecha

Title: Data to Dashboards:Back to Basics

Abstract:

Is Business Intelligence a critical strategy within your organization? Companies that have a depth of analytic support, that use it across their entire organization, and value the insights they gain from their analytic solutions—these are companies far more likely to be high corporate performers. And as such, availability of analytics across the enterprise, and the USE of those analytics—this can drive competitive differentiation for an organization. In this session, we will move past the technology and discuss the value of focusing on some very basic, but very critical components to be considered when developing your Business Intelligence strategy.

SessionID: 32212

SSIS in Denali: What's new

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence - RM117

Speaker: Phil Brammer

Title: SSIS in Denali: What's new

Abstract:

SSIS has some drastic changes coming in the next version of SQL Server, code-named "Denali." This session will touch on the major changes and will demonstrate how they are used.

SessionID: 32213

Database Monitoring with Event Notifications

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM120

Speaker: Phil Brammer

Title: Database Monitoring with Event Notifications

Abstract:

Trying to manage many database instances is no easy task. SQL Server Service Broker and Event Notifications are just one way to get near-real time feedback of what is occurring across all instances. This session will demonstrate how Blue Cross and Blue Shield have implemented Event Notifications to monitor database changes, logins, permission changes, log/data file growths, etc...

SessionID: 32385

But it worked great in Dev! Performance for Devs

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM122

Speaker: Randy Knight

Title: But it worked great in Dev! Performance for Devs

Abstract:

If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production and how this can be avoided.

SessionID: 32386

Don't push the turbo button! Understanding Transa

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM121

Speaker: Randy Knight

Title: Don't push the turbo button! Understanding Transa

Abstract:

SQL Server offers several isolation levels beyond the default "READ COMMITTED". But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.

SessionID: 33218

Report Lockdown: Implementing SSRS Security

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence - RM117

Speaker: Steve Hughes

Title: Report Lockdown: Implementing SSRS Security

Abstract:

When working with Reporting Services, you need to consider all aspects of security from access to the report server to filtering the report data. This session will delve into the various techniques used to secure reports throughout the architecture and the nuances of integrating with SharePoint security as well.

SessionID: 33219

Performance Monitoring and Tuning in SSAS

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence - RM117

Speaker: Steve Hughes

Title: Performance Monitoring and Tuning in SSAS

Abstract:

As SQL Server Analysis Services becomes commonly used in various business intelligence solutions, many administrators are looking for ways to monitor and tune performance on the platform. This session will cover various monitioring techniques and tools and how to use that information to tune Analysis Services.

SessionID: 33220

Using SQL Azure in Application Development

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM121

Speaker: Steve Hughes

Title: Using SQL Azure in Application Development

Abstract:

As Microsoft continues to expand its cloud computing offerings, this session will look at how developers can leverage the SQL Azure platform in their applications. In this session, we will use SQL Azure as a data store for .NET applications. We will cover how to set up a SQL Azure database and connect to it with our application. During the session, we will also highlight key differences between SQL Server and SQL Azure that can impact how you can leverage SQL Azure in your environment.

SessionID: 33261

What's new and exciting in SQL Server 'Denali'

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM121

Speaker: Sudhir Gajre

Title: What's new and exciting in SQL Server 'Denali'

Abstract:

Attend this session to learn the new and exciting things coming the next release of SQL Server codenamed 'Denali'. Denali is just round the corner and bring some amazing improvements in the core engine, HA, DR, BI, and DW space. You do not want to miss this discussion on the new and exciting features of Denali. This session will help you decide on how to leverage the new featurses of Denali.

SessionID: 33403

Parallel Query Execution Deep Dive

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM122

Speaker: Kevin Boles

Title: Parallel Query Execution Deep Dive

Abstract:

What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it's use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.

SessionID: 33404

SANs and SQL Server

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM119

Speaker: Kevin Boles

Title: SANs and SQL Server

Abstract:

Simple title says it all. Lets get down and dirty on some fundamentals and then numerous details of how SANs work and how we can best utilize and tune them to improve SQL Server's IO performance and reliability.

SessionID: 33408

Fundamentals of Join Operations

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM122

Speaker: Kevin Boles

Title: Fundamentals of Join Operations

Abstract:

This is a wonderful session for those that don't yet grok the three types of joins available to the SQL Server engine or the scenarios for which each join type is optimal. All will be explained here with some very slick visual demonstrations of internal data flow as well as TSQL code samples.

SessionID: 33409

Common TSQL Mistakes

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM120

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey too, some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I have given this talk over a dozen times now and it is always very highly rated!

SessionID: 33581

High-Availability and DR Options for SQL Server

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM120

Speaker: Tim Plas

Title: High-Availability and DR Options for SQL Server

Abstract:

A comparison of SQL HA DR options, by a practitioner who has implemented managed all the SQL HA and DR approaches ( various combinations thereof). Tim is an operational SQL DBA, who keeps SQL servers up running optimized for managed-services customers. We will compare trade-offs between the various SQL HA DR options: for complexity, usability, hardware, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc. And we’ll briefly cover some of the upcoming SQL Denali HA / DR features.

SessionID: 34695

Denali and T-SQL

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM120

Speaker: Kathi Kellenberger

Title: Denali and T-SQL

Abstract:

Denali has something for everyone: new HA/DR flexibility, an SSIS overhaul, unmatched data warehouse query speeds and much more. Have you heard about all the new T-SQL features and functions that will be delivered with Denali? Attend this session to learn how you will benefit from Microsoft's continued investment in T-SQL!

SessionID: 34696

Women in Technology Panel Discussion

Back to calendar

Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence - RM117

Speaker: Kathi Kellenberger

Title: Women in Technology Panel Discussion

Abstract:

Everyone has heard that the number of women in technology is declining. How can all of us, women and men, encourage more young women to consider a career in technology? Join Kathi and other dynamic Women in Technology to discuss this important and hot topic. Attendees are encouraged to ask questions, make suggestions, and share their experiences as well.