sqlsathistory

Nr: 173

Back to Main list

SQLSaturday #173 - Washington DC 2012

Start Time (24h) Speaker Track Title
00:00:00 Allen White DBA 1 PowerShell 101 for the SQL Server DBA
00:00:00 Brian Moran Professional Development The Art of Questions and success as an IT Pro
00:00:00 Derek Dai BI / SSAS 2 “ColumnStore” Indexes for Fast EDW Query
00:00:00 David Klee DBA 2 Virtualizing Business Critical SQL Servers
00:00:00 Konstatin Melamud Developer PerfTuning: Intro To Execution Plan Analysis
00:00:00 Carlton Ramsey DBA 1 How PowerShell helps me as a DBA
00:00:00 Eddie Wuerch Professional Development Join Us! Getting Started as a Technical Speaker
00:00:00 Geoff Johnson BI / SSAS 1 Using Expressions to Avoid Three SSRS Annoyances
00:00:00 Ira Warren DBA 1 (SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own
00:00:00 Jason Horner BI / SSAS 1 Isn't that Spatial! (BI Edition)
00:00:00 Jason Thomas BI / SSAS 2 Advanced Charting Techniques in SSRS
00:00:00 Joseph D'Antoni DBA 2 SQL 2012 -- All About HA and DR
00:00:00 Jason Hall Professional Development Recipe for a happy DBA
00:00:00 John Sterrett BI / SSAS 2 Performance Tuning for Pirates
00:00:00 Kevin Goode Professional Development Let's Talk Licensing
00:00:00 Kevin Goff BI / SSAS 1 SQL Server 2012 Columnstore index
00:00:00 Michael Corey DBA 2 Virtualizing SQL 2012: Doing It Right
00:00:00 Mike Walsh Developer DBA Worst Practices, Disasters and Horror Stories
00:00:00 Paul Rizza BI / SSAS 2 Shortcuts to Building SSIS in .Net
00:00:00 Rob Volk Developer Revenge: The SQL!
00:00:00 Rob Volk Developer Revenge: The SQL Part 2: The Sequel!
00:00:00 Stacia Varga BI / SSAS 2 Taking BI to the Next Level: Collaboration
00:00:00 Steven Wright DBA 1 Resource Governor for SQL Server
00:00:00 Kevin Boles Developer SQL Server 2012 TSQL Enhancements and Additions
00:00:00 Kevin Boles DBA 2 Common TSQL Mistakes
00:00:00 Tim Radney DBA 2 Know Backups and Know Recovery
00:00:00 Wayne Sheffield DBA 1 Table Vars Temp Tables - What you NEED to Know!
00:00:00 Wayne Sheffield Developer Windowing Functions in SQL Server 2012
00:00:00 William E Pearson III BI / SSAS 1 Getting Started with MDX: The (Very) Basics
00:00:00 Ryan Brickey Professional Development DBA’s1st Date - Getting to know a new environment
00:00:00 SQLSAT DC Professional Development Panel discussion - Professional Development
00:00:00 Andy Leonard BI / SSAS 1 Loading Data Warehouse Partitions with SSIS 2012

SessionID: 10015

PowerShell 101 for the SQL Server DBA

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: DBA 1

Speaker: Allen White

Title: PowerShell 101 for the SQL Server DBA

Abstract:

The more you have to manage, the more likely you'll want to automate your processes. PowerShell is the scripting language that will make you truly effective at managing lots of servers. This session will introduce you to PowerShell and show you how to use it to manage SQL Server across many instances.

SessionID: 10762

The Art of Questions and success as an IT Pro

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: Professional Development

Speaker: Brian Moran

Title: The Art of Questions and success as an IT Pro

Abstract:

Data professionals spend a lot of time asking questions. You spend countless hours refining your techcial skills but how much time do you spend learning researching and practicing the art of asking questions?

What might happen to your career if you did?

This session presents a bit of theory on the art and science of questions. Here's a question for you: Did you know that asking "why" questions can make people feel defensive and can color the way they respond to you? Strange but true. We'll review some of the biggest mistakes you can make when asking questions and I’ll offer a few some tips on how you can turn mediocre questions into great questions.

And oh yeah. I'll leave time for asking questions at the end.

SessionID: 12129

“ColumnStore” Indexes for Fast EDW Query

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: BI / SSAS 2

Speaker: Derek Dai

Title: “ColumnStore” Indexes for Fast EDW Query

Abstract:

This session will introduce the new xVelocity Memory-Optimized Columnstore Index feature of SQL 2012. This presentation will describe what a column store index is, how this feature is used to store data by columns instead of by rows and compare the advantages and disadvantages between the two storage methods. Live demos will explore how to create columnstore indexes, when to create them, best practices for using them and typical data warehouse scenarios that can leverage the columnstore index to drastically speed up data warehouse queries, in many cases by a factor of 10 to 100, so you are equipped to start implementing this feature into your database environment.

SessionID: 12578

Virtualizing Business Critical SQL Servers

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: DBA 2

Speaker: David Klee

Title: Virtualizing Business Critical SQL Servers

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 David Klee (@kleegeek) will provide valuable insight into how to properly prepare for and implement a successful virtualization campaign for ALL of your SQL Server environments and prepare your organization for the change. Practical tips, tricks, and gotcha’s will be discussed in this dynamic dialog session.

SessionID: 13227

PerfTuning: Intro To Execution Plan Analysis

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: Developer

Speaker: Konstatin Melamud

Title: PerfTuning: Intro To Execution Plan Analysis

Abstract:

Topic will provide a more in depth look into query execution plans and is targeted for junior to senior DBA’s. You will learn how to identify what indexes are being used by the SQL optimizer, different type of index operations that are performed by SQL server and what operations are generally considered as a preferred method of data retrieval. We will discuss how to determine if indexes used by the optimizer are the optimal ones and the exceptions to the rules. Finally we will discuss the relationship between different types of index operation and different types of join types within SQL Server including how the SQL Optimizer determines which join type it will use and pros and cons of each type.

SessionID: 13649

How PowerShell helps me as a DBA

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: DBA 1

Speaker: Carlton Ramsey

Title: How PowerShell helps me as a DBA

Abstract:

This session will go over what PowerShell is and walk though some example code of ways I use PowerShell to help me as a DBA.

SessionID: 14084

Join Us! Getting Started as a Technical Speaker

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: Professional Development

Speaker: Eddie Wuerch

Title: Join Us! Getting Started as a Technical Speaker

Abstract:

Have you ever thought about speaking at a user group or SQL Saturday, but weren't quite sure how to get started? If so, this session is for you! Technical speaking is loads of fun, great for your career, and you get to hang out with some terrific people. This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you'll be able to: * Identify your topic and build a killer abstract for it, * Design and build the presentation, and * Prepare and deliver your first session

SessionID: 14472

Using Expressions to Avoid Three SSRS Annoyances

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: BI / SSAS 1

Speaker: Geoff Johnson

Title: Using Expressions to Avoid Three SSRS Annoyances

Abstract:

SessionID: 15507

(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: DBA 1

Speaker: Ira Warren

Title: (SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own

Abstract:

Fuzzy Matching, Similarity Matching or Record Linkage is the most critical and least understood process in any Data Warehouse, BI, Integration, Big Data , Data Quality, MDM , Social Network or integrating crap effort. Over at LinkedIn there is Group run by Henrik Liliendahl Sorensen for Data Matching, Bill Winkler, principal researcher at the US Census" has written a series of white papers on record linkage and particular a technique called "Blocking Indexs". In addition we wil cover William Cohen Research Professor, Machine Learning Department, Carnegie Mellon University white papers an implementations. Presented will be our collection of "real world" examples(Code) and you will leave a master of record linkage and the concepts behind it

SessionID: 15841

Isn't that Spatial! (BI Edition)

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: BI / SSAS 1

Speaker: Jason Horner

Title: Isn't that Spatial! (BI Edition)

Abstract:

In this session, we will walk through the process of building a spatial data

warehouse from the ground up. We will first design a basic spatial data warehouse, then identify and import a spatial data source by using Microsoft SQL Server Integration Services (SSIS), and finally write a spatial query to provide data to SQL Server Reporting Services (SSRS). We will also review basic concepts of working with spatial data in SQL Server.

SessionID: 15903

Advanced Charting Techniques in SSRS

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: BI / SSAS 2

Speaker: Jason Thomas

Title: Advanced Charting Techniques in SSRS

Abstract:

SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts.

This session will talk about the basic functionalities of all the charts as well as some tips and tricks around them. Come to this session and take your charting skills to the next level.

SessionID: 16176

SQL 2012 -- All About HA and DR

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: DBA 2

Speaker: Joseph D'Antoni

Title: SQL 2012 -- All About HA and DR

Abstract:

Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start. In this presentation you'll learn all about the new DR features in SQL Server 2012 and see them in practice.

SessionID: 16765

Recipe for a happy DBA

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: Professional Development

Speaker: Jason Hall

Title: Recipe for a happy DBA

Abstract:

In a world where separation of responsibilities becomes more and more important, the borders between DBAs and developers have grown wider than ever. For the developer seeking to employ the services of SQL Server, Interaction with one or more DBAs at certain stages of the development life cycle is nearly a given. This session discusses tips and techniques to follow that can ensure these interactions are civil, and maybe even pleasant. This topic includes tips on TSQL scripting, deployment techniques, bad habits to avoid and beginning execution plan analysis.

SessionID: 17703

Performance Tuning for Pirates

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: BI / SSAS 2

Speaker: John Sterrett

Title: Performance Tuning for Pirates

Abstract:

If you follow baseball you will notice that the Pittsburgh Pirates (this speaker’s favorite team) has to do more with less to be successful. This trend can also exist within IT shops. If you need to improve the performance of your SQL Server instances and cannot purchase 3rd party tools this session is for you. You will learn how to improve your performance tuning process by using several free tools. This session will cover wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and SQLDiag.

SessionID: 18142

Let's Talk Licensing

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: Professional Development

Speaker: Kevin Goode

Title: Let's Talk Licensing

Abstract:

Being a DBA is not all smiles and sunshine; sometimes you have to deal with the tedious topic of licensing. As a DBA, developer, or consultant, you are responsible for ensuring that your company or client is in compliance and can pass software audits. As with any Microsoft product license, there are complicated nuances of the SQL Server licensing program with many new twists added in 2012. This session will help you understand what you can and cannot do with various license types, and, how you could save your company some serious money.

SessionID: 18307

SQL Server 2012 Columnstore index

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: BI / SSAS 1

Speaker: Kevin Goff

Title: SQL Server 2012 Columnstore index

Abstract:

It might seem far-fetched that a company would upgrade to SQL Server 2012 “just” for a database index. But after you see the performance enhancements gained from the new columnstore index in SQL Server 2012, you’ll see why many are calling this one of the most important features in the history of SQL Server. In this presentation, I’ll talk about the physical aspects of columnstore index in SQL Server 2012, how to create it, and what environments (mainly data warehousing environments) and queries can make use of it. I’ll show performance benchmarks between columnstore indexes in SQL Server 2012, and compare them to index strategies prior to SQL Server 2012. I'll also show how the new Batch execution mode can improve performance as well

SessionID: 20231

Virtualizing SQL 2012: Doing It Right

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: DBA 2

Speaker: Michael Corey

Title: Virtualizing SQL 2012: Doing It Right

Abstract:

A database is a very resource intensive by its very nature and one of the most resource intensive applications you will ever virtualize. If best practices are not followed, the database will never perform as needed. This presentation will teach the DBA how to virtualize a business critical application like SQL server 2012. It will be based upon experience learned using VMWare as the virtualization platform. But many of the lessons taught will carry over to any virtualized platform.

SessionID: 20438

DBA Worst Practices, Disasters and Horror Stories

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: Developer

Speaker: Mike Walsh

Title: DBA Worst Practices, Disasters and Horror Stories

Abstract:

Join Brian Moran, Tim Radney, Mike Walsh and perhaps a few more special guests in a panel discussion on some of the worst practices we often see DBAs do. A little secret - we've done them, too. We'll tell you some of the ways you are hurting your databases, tell you about some of the disasters we've been involved in and even share a few horror stories of the ones we've caused. We'll leave plenty of time for QA and give you a chance to share your own or stump us with a "what would you do...." question.

SessionID: 21785

Shortcuts to Building SSIS in .Net

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: BI / SSAS 2

Speaker: Paul Rizza

Title: Shortcuts to Building SSIS in .Net

Abstract:

Using an Open Source project API Library this session will show how SSIS Packages can be created as easily in C# .Net as they are in BIDS. During the session real world examples will be used to show how SSIS Code can be created in BULK.

SessionID: 23295

Revenge: The SQL!

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: Developer

Speaker: Rob Volk

Title: Revenge: The SQL!

Abstract:

Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG! This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them...even though they deserved it! Learn how to create tables with no names, columns with duplicate names, and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you'll ache for the chance!

SessionID: 23296

Revenge: The SQL Part 2: The Sequel!

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: Developer

Speaker: Rob Volk

Title: Revenge: The SQL Part 2: The Sequel!

Abstract:

SessionID: 24701

Taking BI to the Next Level: Collaboration

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: BI / SSAS 2

Speaker: Stacia Varga

Title: Taking BI to the Next Level: Collaboration

Abstract:

Self-service BI is usually an independent activity. But when individuals discover interesting information that they want to share, they need a centralized location to do that. When people work together, new insights are possible, and that’s what collaboration is all about. As more people see the benefits of the solution, they become more likely to use it. As individual products, SQL Server 2008 R2, SharePoint 2010, and Excel 2010 expand your options for enabling BI in your organization, but collectively they create a solid platform for collaborative BI. Knowing which tool to use for which job can be tricky. Come to this session to learn how to use these tools to foster collaboration.

SessionID: 25943

Resource Governor for SQL Server

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: DBA 1

Speaker: Steven Wright

Title: Resource Governor for SQL Server

Abstract:

In this presentation, Steve will provide an overview of Resource Governor, a feature introduced in SQL Server 2008 that gives DBAs and system administrators much more granular control over how CPU and memory are used by SQL Server. He’ll discuss the components that make up Resource Governor, then walk through examples of how to set it up along with various usage scenarios.

SessionID: 26254

SQL Server 2012 TSQL Enhancements and Additions

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: Developer

Speaker: Kevin Boles

Title: SQL Server 2012 TSQL Enhancements and Additions

Abstract:

The breadth and depth of improvements in TSQL coming out with SQL Server 2012 represent the most significant changes in, well, probably ever! This fast and furious overview will touch on a large range of these goodies, with plenty of sample code for you to take home and review at your leisure!

SessionID: 26256

Common TSQL Mistakes

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: DBA 2

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 GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over a dozen times now and it is always very highly rated!

SessionID: 26698

Know Backups and Know Recovery

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: DBA 2

Speaker: Tim Radney

Title: Know Backups and Know Recovery

Abstract:

It is easy to schedule full backups to run each night, but is that the right decision for your organization? You say you have a backup strategy, but what is your recovery strategy? Do you have a well-executed recovery plan?

In this session I will cover several methods for performing much needed backups and how to recover those backups. Full, Differential, File Group, Transaction logs and recovery the tail end of a the log. He will discuss industry best practices and hopefully cause you to validate and test your current strategy.

SessionID: 27705

Table Vars Temp Tables - What you NEED to Know!

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: DBA 1

Speaker: Wayne Sheffield

Title: Table Vars Temp Tables - What you NEED to Know!

Abstract:

Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"

SessionID: 27706

Windowing Functions in SQL Server 2012

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: Developer

Speaker: Wayne Sheffield

Title: Windowing Functions in SQL Server 2012

Abstract:

SQL Server 2012 brings with it nearly full ANSI compliance with the windowing functions. Come to this code filled session to learn about all of the windowing functions in SQL Server 2012: Ranking functions, changes for windowing in the Aggregate functions, and the new Analytic and Sequence functions. We’ll examine how this latest implementation of the windowing functions allows us to perform running and sliding aggregations; retrieve data from adjacent rows in the partition, and much more – all without self-joins back to the source table.

SessionID: 28024

Getting Started with MDX: The (Very) Basics

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: BI / SSAS 1

Speaker: William E Pearson III

Title: Getting Started with MDX: The (Very) Basics

Abstract:

In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, 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: 34865

DBA’s1st Date - Getting to know a new environment

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: Professional Development

Speaker: Ryan Brickey

Title: DBA’s1st Date - Getting to know a new environment

Abstract:

With more entry level DBA positions becoming available, and non-DBA’s shifting into DBA roles, you may find yourself in a position where you need to become familiar with a new server environment quickly and efficiently but not know where to begin. To help prevent this for happening, we will review the do’s and don’ts that should be considered when getting to know with a new environment.

SessionID: 34879

Panel discussion - Professional Development

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: Professional Development

Speaker: SQLSAT DC

Title: Panel discussion - Professional Development

Abstract:

An hour of open panel QA to discuss your professional development. Topics may include resumes, interviews other questions. Join Brian Moran and others as they openly discusses and answers any questions you have regarding your professinal development in SQL Server.

SessionID: 9532

Loading Data Warehouse Partitions with SSIS 2012

Back to calendar

Event Date: 08-12-2012 - Session time: 00:00:00 - Track: BI / SSAS 1

Speaker: Andy Leonard

Title: Loading Data Warehouse Partitions with SSIS 2012

Abstract:

Co-presented with Darryll Petrancuri! SQL Server 2012 table partitions offer powerful Big Data solutions to the Data Warehouse ETL Developer. In this presentation, Andy Leonard demonstrates one approach to loading partitioned tables and managing the partitions using SSIS 2012, and reporting partition metrics using SSRS 2012.Objectives1. A practical solution for loading Big Data Fact tables (1B+ rows).2. Learn more about SQL Server 2012 table partitioning.3. Learn more about using SSIS Expression Language to generate dynamic SQL in SSIS 2012.