Nr: 173
SQLSaturday #173 - Washington DC 2012
SessionID: 10015
PowerShell 101 for the SQL Server DBA
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
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
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
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
Event Date: 08-12-2012 - Session time: 00:00:00 - Track: Developer
Speaker: Konstatin Melamud
Title: PerfTuning: Intro To Execution Plan Analysis
Abstract:
SessionID: 13649
How PowerShell helps me as a DBA
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
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:
SessionID: 14472
Using Expressions to Avoid Three SSRS Annoyances
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:
As powerful as it is, SQL Server Reporting Services still has frustrating annoyances. Three in particular are: 1) non-queried parameter values must be entered one value at a time, with lots of clicking along with way; 2) the page header and page footer sections cannot contain data regions and therefore cannot display sets of data-driven values; and 3) matrix reports promise the analytical ability of Excel PivotTables but fall short because they are fixed and lack the ability to dynamically slice-and-dice data by values selected by the user. With the expression techniques taught in this session, these annoyances will annoy no longer because you will be able to work around all three.
SessionID: 15507
(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own
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)
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
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
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
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
Event Date: 08-12-2012 - Session time: 00:00:00 - Track: BI / SSAS 2
Speaker: John Sterrett
Abstract:
SessionID: 18142
Let's Talk Licensing
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
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
Event Date: 08-12-2012 - Session time: 00:00:00 - Track: DBA 2
Speaker: Michael Corey
Title: Virtualizing SQL 2012: Doing It Right
Abstract:
SessionID: 20438
DBA Worst Practices, Disasters and Horror Stories
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
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!
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!
Event Date: 08-12-2012 - Session time: 00:00:00 - Track: Developer
Speaker: Rob Volk
Title: Revenge: The SQL Part 2: The Sequel!
Abstract:
In a world...where DBAs are blamed, mistreated, and overworked...one man...WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, cursors and missing WHERE clauses, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys!
SessionID: 24701
Taking BI to the Next Level: Collaboration
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:
SessionID: 25943
Resource Governor for SQL Server
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
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
Event Date: 08-12-2012 - Session time: 00:00:00 - Track: DBA 2
Speaker: Kevin Boles
Title: Common TSQL Mistakes
Abstract:
SessionID: 26698
Know Backups and Know Recovery
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!
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
Event Date: 08-12-2012 - Session time: 00:00:00 - Track: Developer
Speaker: Wayne Sheffield
Title: Windowing Functions in SQL Server 2012
Abstract:
SessionID: 28024
Getting Started with MDX: The (Very) Basics
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
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
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
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.