sqlsathistory

Nr: 65

Back to Main list

SQLSaturday #65 - Vancouver 2011

Start Time (24h) Speaker Track Title
00:00:00 Aaron Bertrand Database Administration What's new in SQL Server 2011 ("Denali")?
00:00:00 Allan Hirt Expanded Horizons 1 Is That A Failover Cluster On Your Laptop?
00:00:00 Argenis Fernandez Expanded Horizons 2 Multi-Server Management with SQL Server 2008 R2
00:00:00 Bill Ramos Expanded Horizons 2 Troubleshooting with the SQL Server 2008 DC MDW
00:00:00 Brent Ozar Database Administration Virtualization and SAN Basics for DBAs
00:00:00 Donabel Santos Business Intelligence SQL Server 2008 Reporting from the Ground
00:00:00 Gail Shaw Database Development Introduction to Indexes
00:00:00 Gail Shaw Database Administration Lies, Damned Lies And Statistics
00:00:00 Greg Larsen Database Development Through the Looking-Glass
00:00:00 Jeremiah Peschka Database Development Refactoring SQL
00:00:00 John Welch Business Intelligence Do You Know the Data Flow?
00:00:00 John Welch Business Intelligence Processing Flat Files with SSIS
00:00:00 Karen Lopez Database Administration Database Design Contentious Issues
00:00:00 Kendra Little Database Development No More Bad Dates: Using Temporal Data Wisely
00:00:00 Denny Cherry Expanded Horizons 1 Where should I be encrypting my data
00:00:00 Randy Knight Expanded Horizons 1 Become a Bilingual DBA! Oracle for the SQL Server
00:00:00 Rich Baumet Expanded Horizons 1 NUMA for the SQL Server
00:00:00 Scott Klein Expanded Horizons 2 SQL Azure - Cloud Database Coolness
00:00:00 Simon Sabin Database Development High Performance functions
00:00:00 Tim Ford Expanded Horizons 2 Who Needs DMVs? You Do!
00:00:00 Tim Costello Expanded Horizons 2 Tableau: Delivering Self-Serve BI
00:00:00 Todd McDermid Business Intelligence Data Warehouse ETL with Integration Services
00:00:00 William E Pearson III Expanded Horizons 1 Attribute Discretization in Analysis Services (BI)
00:00:00 William E Pearson III Business Intelligence Getting Started with MDX
00:00:00 John Huang Database Administration Query Plan

SessionID: 28437

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

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Database Administration

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. Lots of demos and no marketing.

SessionID: 28603

Is That A Failover Cluster On Your Laptop?

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Expanded Horizons 1

Speaker: Allan Hirt

Title: Is That A Failover Cluster On Your Laptop?

Abstract:

ver the years, one of the most common questions I am asked is, "How can I configure a cluster on my machine?" Ask no more! Production should never be the only place you have clusters. Having the ability to create a cluster that you can use as a sandbox for testing or as an instruction tool for presentations and demonstrations is something every DBA should have in their arsenal.This session will demystify the "magic" behind configuring a cluster on your laptop or desktop using either Vmware Workstation or Microsoft's Hyper-V in Windows Server 2008 R2, and show how to configure things like the virtual machines, the domain controller, and the iSCSI storage solution.

SessionID: 28802

Multi-Server Management with SQL Server 2008 R2

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Expanded Horizons 2

Speaker: Argenis Fernandez

Title: Multi-Server Management with SQL Server 2008 R2

Abstract:

Learn how to manage multiple instances of SQL Server with the different tools that SQL Server 2008 and 2008 R2 offer. We will discuss Central Management Servers, multiserver queries, Utility Control Point, Policy-Based Management and SQLPS (the Powershell SQL mini-shell). 3rd party tools will be discussed as time permits.

SessionID: 29053

Troubleshooting with the SQL Server 2008 DC MDW

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Expanded Horizons 2

Speaker: Bill Ramos

Title: Troubleshooting with the SQL Server 2008 DC MDW

Abstract:

In this session you will learn about the SQL Server 2008 R2 data collector and management data warehouse for troubleshooting your problem situations with your SQL Server. I'll demonstrate several problem scenarios and how the MDW reports can help you identify the root cause. You'll also learn what data collection strategies might worh best in your environment.

SessionID: 29240

Virtualization and SAN Basics for DBAs

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Database Administration

Speaker: Brent Ozar

Title: Virtualization and SAN Basics for DBAs

Abstract:

These two technologies can make a very big – and very bad – difference in how your SQL Server performs. Wouldn’t it be great if you could get the real, honest lowdown from a virtualization administrator, a SAN administrator, and a DBA? Wouldn’t it be even better if one person had done all three, and could give you the pros and cons of each point of view? That person is Brent Ozar, a Microsoft Certified Master who’s been there and done that.

SessionID: 29953

SQL Server 2008 Reporting from the Ground

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Donabel Santos

Title: SQL Server 2008 Reporting from the Ground

Abstract:

In this session we will explore the rich reporting features introduced in SQL Server 2008 and 2008 R2 Reporting Services, including Report Builder 3.0. We will walk through how to create basic reports, add parameters, enhance layout, and integrate new visualization components including sparklines, data bars, gauges and maps.

SessionID: 30213

Introduction to Indexes

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Database Development

Speaker: Gail Shaw

Title: Introduction to Indexes

Abstract:

Have you heard about these things called indexes, but aren't really sure what they are or how to go about using them? If so, this session is for you.

We'll start with the basics of what an index is and why SQL likes them and look at some general guidelines for creating useful indexes, ones that will make your queries lightning fast.

SessionID: 30214

Lies, Damned Lies And Statistics

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Database Administration

Speaker: Gail Shaw

Title: Lies, Damned Lies And Statistics

Abstract:

Ever wondered what the things called statistics are, why they're important and what needs to be done to maintain them? If so, this session is for you! In this session well take a look at what statistics are and why SQL keeps them; at how SQL maintains them and under what circumstances that maintenance is insufficient; and well look at the problems that result when they are inaccurate. Finally well cover some suggestions and options around maintenance of statistics when the automatic maintenance is not sufficient.

SessionID: 30288

Through the Looking-Glass

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Database Development

Speaker: Greg Larsen

Title: Through the Looking-Glass

Abstract:

"Through the Looking-Glass, and What Alice Found There" - When your world is SQL Server, you need a looking-glass to determine server health, diagnosis problems, and tune performance. In this session will we follow Alice through the looking-glass to determine what she finds in SQLServerLand. Alice will be using dynamic management views and functions (DMVs) to explore the land behind the looking-glass. She will find statistics, poorly performing queries, and much more. Follow Alice and her new friends, as she traverses across SQLServerLand and provides you with snippets of T-SQL code that you can use to explore your own SQLServerLand.

SessionID: 30729

Refactoring SQL

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Database Development

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

Do You Know the Data Flow?

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: John Welch

Title: Do You Know the Data Flow?

Abstract:

The Data Flow task is one of the most powerful and most complex tools available in SSIS. Whether you are brand new to SSIS, or you’ve been using it for a while, it’s likely you’ve had some questions about the Data Flow. Why are some components so much slower than others? Why can’t I store a value (like a row count) in one component, and use it in another component later in the Data Flow? And why does it always seem to be the part of my package that fails when I run it against real data? Well, you’re not alone. During this session, we’ll answer these questions (and many others) by learning how the Data Flow operates internally. After attending this session, you’ll know a lot more about getting the most out of Data Flows in SSIS.

SessionID: 30967

Processing Flat Files with SSIS

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: John Welch

Title: Processing Flat Files with SSIS

Abstract:

When doing data integration, a common requirement is to work with flat files, whether for importing data into a system from an external source, or to export it to provide to other systems. SQL Server Integration Services (SSIS) supports flat files, but there can be a number of challenges when working with them. This is particularly true if your flat files have multiple data formats contained in a single file, the data has complex formatting, or the files have inconsistent formatting. This session will help you to be more efficient when working with these types of files. You’ll learn to handle missing delimiters in the files, and parsing files that have multiple data formats. You’ll also see how to produce complex output formats.

SessionID: 31194

Database Design Contentious Issues

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Database Administration

Speaker: Karen Lopez

Title: Database Design Contentious Issues

Abstract:

SessionID: 31513

No More Bad Dates: Using Temporal Data Wisely

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Database Development

Speaker: Kendra Little

Title: No More Bad Dates: Using Temporal Data Wisely

Abstract:

Temporal data can be confusing in SQL Server. It's no wonder: there are six data types for storing these values. In this session we'll discuss dates, times, and how they are stored internally. We'll talk about how to select a temporal data type and common issues with some types. We'll compare performance of different methods for computing temporal values. We'll also take a look at gotchas in features of SQL Server for which date and time data type choices can be critical. Choose wisely: the correct type and high performing data access logic will help your applications scale and save development and administrative time.

SessionID: 32006

Where should I be encrypting my data

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Expanded Horizons 1

Speaker: Denny Cherry

Title: Where should I be encrypting my data

Abstract:

In this session we'll be looking at all the various places within the application stack that data can be encrypted. This includes the application layer, the database layer, encrypting over the wire, transparent data encryption, encrypting using your MPIO driver and offloading encryption to your HBAs.

SessionID: 32411

Become a Bilingual DBA! Oracle for the SQL Server

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Expanded Horizons 1

Speaker: Randy Knight

Title: Become a Bilingual DBA! Oracle for the SQL Server

Abstract:

In today's enterprise environments, it is becoming increasingly necessary to integrate data from a variety of sources. As SQL Server continues its march into the enterprise, the days of focusing 100% on one platform are over. At a bare minimum, we need to be able to communicate with DBA's for other platforms. Terminology as simple as Instance and Database mean very different things in Oracle than they do in SQL Server. In this session, we will compare and contrast the two platforms in terms of features and terminology. We will also discuss some of the best practices and pitfalls when integrating the two.

SessionID: 32447

NUMA for the SQL Server

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Expanded Horizons 1

Speaker: Rich Baumet

Title: NUMA for the SQL Server

Abstract:

In this session you will learn what is NUMA, how to identify systems with it, how SQL Server utilizes it, how to adjust SQL Server settings to accomidate for it, and finally how it can impact legacy SQL Server versions.

SessionID: 32832

SQL Azure - Cloud Database Coolness

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Expanded Horizons 2

Speaker: Scott Klein

Title: SQL Azure - Cloud Database Coolness

Abstract:

What is SQL Azure and why should you be interested in it? What benefits can it have for your company? This session will discuss what SQL Azure is, why you should be looking at it, and how to work with SQL Azure. We will discuss deployment scenarios, briefly discuss how to develop applications for SQL Azure, including OData, and how SQL Azure can help face constant infrastructure challenges and demands. We will look at how to improve SQL Azure performance by looking at technologies such as Sharding and caching.

SessionID: 32922

High Performance functions

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Database Development

Speaker: Simon Sabin

Title: High Performance functions

Abstract:

Functions are something we are taught in our first programming lesson are a good development practice, to encapsulate common code and ensure code reuse. In this session we will look at the different ways you can write functions in SQL Server and importantly look at the performance and pitfalls of each option.

SessionID: 33024

Who Needs DMVs? You Do!

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Expanded Horizons 2

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

Tableau: Delivering Self-Serve BI

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Expanded Horizons 2

Speaker: Tim Costello

Title: Tableau: Delivering Self-Serve BI

Abstract:

rapid-fire visual analysis. ad hoc query capability. easy interactive dashboard building. No, this insn't going to be an hour of buzzword bingo. This time we will actually deliver on the promise of self service BI. Using SQL in conjunction with a visual analysis tool like Tableau we can help our users find the questions they didn't know they wanted to answer. This session will be demo heavy and will highlight best practices in data visualization and dashboard design.

SessionID: 33762

Data Warehouse ETL with Integration Services

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Todd McDermid

Title: Data Warehouse ETL with Integration Services

Abstract:

Microsoft designed Integration Services with ETL processing for Data Warehouses in mind, so loading one should be pretty easy. It's not that bad, but there are a few things you should avoid and non-obvious best practices to use to make that ETL faster and more reliable. This session will explain how to accomplish Kimball style ETL using SQL Server Integration Services. We'll review the SCD Wizard and how it works for processing your dimension tables - and what alternatives you have to it. We'll also examine fact table loading using a surrogate key replacement pipeline. Finally, we’ll look at specific and easy performance tweaks, techniques and best practices that apply directly to DW loads.

SessionID: 34264

Attribute Discretization in Analysis Services (BI)

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Expanded Horizons 1

Speaker: William E Pearson III

Title: Attribute Discretization in Analysis Services (BI)

Abstract:

Attribute discretization is an oft-overlooked feature in Analysis Services that allows us to automatically create a manageable number of groups of attribute values that are clearly separated by boundaries. Discretization can help us to make it easier for information consumers to work with large numbers of possible attribute member values. In this session, we will discuss the varied options, the design (and other) considerations involved, and best practices surrounding the use of this capability.

SessionID: 34265

Getting Started with MDX

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: William E Pearson III

Title: Getting Started with MDX

Abstract:

In this session we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.

SessionID: 34684

Query Plan

Back to calendar

Event Date: 26-02-2011 - Session time: 00:00:00 - Track: Database Administration

Speaker: John Huang

Title: Query Plan

Abstract:

This session will cover logical and physical operators that frequently showing on the query plan, and how to interpret query plans.