sqlsathistory

Nr: 145

Back to Main list

SQLSaturday #145 - Nashville 2012

Start Time (24h) Speaker Track Title
00:00:00 David Liebman Mixed Sessions 2 BI in the Cloud
00:00:00 Craig Utley Business Intelligence Why BI Projects Fail--And What You Can Do About It
00:00:00 Daniel Evans Business Intelligence What's new in BI for SQL Server 2012
00:00:00 David Klee Database Administration Virtualizing Business Critical SQL Servers
00:00:00 Louis Davidson Mixed Sessions 2 Quiz Bowl
00:00:00 Eddie Wuerch Database Administration TempDB Performance Troubleshooting and Optimizing
00:00:00 Geoff Hiten Mixed Sessions Bad SQL
00:00:00 Glenn Berry Mixed Sessions Hardware 301: Diving Deeper into Database Hardware
00:00:00 J.D. Pellerin Database Administration Custom SQL Server Transaction Log Shipping
00:00:00 Jason Strate Mixed Sessions Extended Events, Work Smarter Not Harder
00:00:00 Jon Boulineau Application Development T-SQL: Beyond the Basics
00:00:00 Joseph D'Antoni Professional Development And More You Wouldn't Let HR Manage Your DBs...
00:00:00 Jeffrey Garbus Application Development Rewriting bad T-SQL Code
00:00:00 Josh Fennessy Professional Development And More New Models! An Introduction to Tabular Mode SSAS
00:00:00 Joe Webb Professional Development And More Professional Development
00:00:00 Jonathan Gardner Professional Development And More Adventures in Project Management
00:00:00 Joe Murphree Professional Development And More Beginners guide to Table Expressions
00:00:00 Karen Lopez Mixed Sessions Database Design Throwdown
00:00:00 Kathi Kellenberger Mixed Sessions SQL Server 2012 T-SQL
00:00:00 Keith Mayer Mixed Sessions 2 Virtualizing SQL Server with Windows Server 2012 a
00:00:00 Mark Swofford Professional Development And More I Shoulda Taken That Left Turn at Albuquerque...
00:00:00 Gareth Swanepoel Business Intelligence The Fangorn Forest - ColumnStore Indexes
00:00:00 Mark Stacey Mixed Sessions 2 Slowly changing dimensions- an integrated approach
00:00:00 Denny Cherry Application Development TBA - Introductory SQL Session
00:00:00 Pam Shaw Business Intelligence Taking the Scary out of Monster Reports
00:00:00 Rick Morelan Application Development Do SQL XML queries have to scare me?
00:00:00 Rob Volk Application Development Revenge: The SQL Part 2: The Sequel!
00:00:00 Sanil Mhatre Application Development Parameter sniffing - make it work for you !
00:00:00 Sarah Barela Database Administration Bulletproof: Hardening your SQL Server from Attack
00:00:00 Kevin Boles Database Administration Indexing Deep Dive
00:00:00 Tim Ford Mixed Sessions 2 The Periodic Table of Dynamic Management Objects
00:00:00 Wayne Snyder Mixed Sessions 2 Deeper into Tabular Models - M-to-M and the "W"
00:00:00 William E Pearson III Business Intelligence Bridging the Chasm: BI Theory vs. Practice
00:00:00 Adam Belebczuk Database Administration SQL Server 2012 AlwaysOn Readable Secondaries
00:00:00 Robert Cain Business Intelligence The Decoder Ring for Data Warehousing / BI
00:00:00 Allen White Mixed Sessions Gather SQL Server Performance Data with PowerShell

SessionID: 10477

BI in the Cloud

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions 2

Speaker: David Liebman

Title: BI in the Cloud

Abstract:

In this session we will take a look at some strategies for building Business Intelligence solutions on the Windows Azure platform. We’ll see methods for transferring on-premises data to the cloud, report deployment to Windows Azure Reporting Services and options for performing ad-hoc analysis. We’ll look at some of the challenges faced when moving BI into the cloud, such as high-performance ETL, schema management and transient fault handling.

SessionID: 12113

Why BI Projects Fail--And What You Can Do About It

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Craig Utley

Title: Why BI Projects Fail--And What You Can Do About It

Abstract:

Is your organization planning to build a data warehouse or BI solution? Data warehousing projects, like many large IT projects, have high failure rates. While the exact rate of failure for data warehousing projects is difficult to pin down, the causes of these failures fall into a small number of categories. It is obviously possible to successfully complete a data warehousing project and deliver value to the business. Craig Utley has seen Microsoft BI solutions in various states of completeness at over 30 companies worldwide and has seen some awesome successes and some spectacular failures. This session addresses the reasons data warehousing projects fail and how you can succeed in overcoming these obstacles.

SessionID: 12124

What's new in BI for SQL Server 2012

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Daniel Evans

Title: What's new in BI for SQL Server 2012

Abstract:

Many new features of SQL Server 2012 enable businesses to leverage Business Intelligence efforts. Come learn what's new in SQL Server 2012 for BI and the new capabilities with Tabular models, PowerPivot and Power View.

SessionID: 12567

Virtualizing Business Critical SQL Servers

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Database Administration

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

Quiz Bowl

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions 2

Speaker: Louis Davidson

Title: Quiz Bowl

Abstract:

A rough cut preview of the SQL PASS opening session game show of SQL and general trivia.

SessionID: 14064

TempDB Performance Troubleshooting and Optimizing

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Database Administration

Speaker: Eddie Wuerch

Title: TempDB Performance Troubleshooting and Optimizing

Abstract:

Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.

SessionID: 14491

Bad SQL

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions

Speaker: Geoff Hiten

Title: Bad SQL

Abstract:

Good Code, Bad Code. It can be the difference between a server running smoothly and an unresponsive piece of junk. This session digs into what makes some SQL code perform faster and scale better. Session is almost all interactive demo.

SessionID: 14675

Hardware 301: Diving Deeper into Database Hardware

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions

Speaker: Glenn Berry

Title: Hardware 301: Diving Deeper into Database Hardware

Abstract:

Making the right hardware selection decisions is extremely important for database scalability. Having properly sized and configured hardware can both increase application performance and reduce capital expenses dramatically. Unfortunately, there are so many different choices and options available when it comes to selecting hardware and storage subsystems, it is very easy to make bad choices based on outmoded conventional wisdom. This session will give you a framework for how to pick the right hardware and storage subsystem for your workload type. You will learn how to evaluate and compare key hardware components, such as processors, chipsets, and memory.

SessionID: 15513

Custom SQL Server Transaction Log Shipping

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Database Administration

Speaker: J.D. Pellerin

Title: Custom SQL Server Transaction Log Shipping

Abstract:

Using a custom database transaction log shipping process instead of the built in SQL Server transaction log shipping component. Custom database transaction log shipping has several advantages, including:

a) The SQL Server instances need not have any connectivity to one another b) Applying of the transaction log backups can be suspended for weeks and then enabled, with the log shipped database being brought as current as the most recent transaction log backup. While transaction log backups are suspended, the Log Shipped Database can be placed in standby/Read Only mode, for querying. c) Using custom database transaction log shipping also allows more control over each part of the process.

SessionID: 15949

Extended Events, Work Smarter Not Harder

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions

Speaker: Jason Strate

Title: Extended Events, Work Smarter Not Harder

Abstract:

There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.

SessionID: 16078

T-SQL: Beyond the Basics

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Application Development

Speaker: Jon Boulineau

Title: T-SQL: Beyond the Basics

Abstract:

If you've been writing T-SQL code for a while, but have never delved into what happens after you submit your queries there is a whole world that you are missing. Taking the next step as a T-SQL developer requires understanding the basics of the SQL Server architecture and what it means to use a declarative language. Have you ever wondered why cursors are so slow, why query performance can be unpredictable, or how you can begin to analyze your queries more deeply? In this session we will cover what SQL Server has to do to turn your T-SQL code into the results you expect and how you can use this knowledge to make your code better.

SessionID: 16188

You Wouldn't Let HR Manage Your DBs...

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Professional Development And More

Speaker: Joseph D'Antoni

Title: You Wouldn't Let HR Manage Your DBs...

Abstract:

So don't let them manage your career. This session will be a panel discussion with three long term IT professionals representing several different career tracks in IT. Learn about how your HR organization works, what salary levels and midpoints are, and get great career advice from our expert panel.

SessionID: 16295

Rewriting bad T-SQL Code

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Application Development

Speaker: Jeffrey Garbus

Title: Rewriting bad T-SQL Code

Abstract:

This session provides 2 case studies of poorly performing T-SQL code, and works through rewrites into better performing code.

SessionID: 16712

New Models! An Introduction to Tabular Mode SSAS

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Professional Development And More

Speaker: Josh Fennessy

Title: New Models! An Introduction to Tabular Mode SSAS

Abstract:

In this session, attendees will be treated to an introduction to tabular mode. Installation, configuraiton, development tips, maintance, and end user reporting options will all be introduced. A description of BISM and what it means for our beloved Multi-Dimension cubes will be discussed. Attendees wanting to know when to use tabular, and when to stick with multi-dimensional will want to attend this introductory session.

SessionID: 17133

Professional Development

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Professional Development And More

Speaker: Joe Webb

Title: Professional Development

Abstract:

Imagine trying to steer a car blindfolded. How about shooting a jump shot without being able to see the goal. It's not easy, is it? Yet, that's exactly what your team is doing if you are not providing clear and effective feedback about their work and behavior.

In this session, you'll learn how to provide effective feedback to your peers and direct reports. You'll learn how to deliver feedback that encourages the behavior that you'd like to see repeated and provides recommended changes for behavior that is subpar or not acceptable. You'll also lean how to customize your feedback based on different personality types.

SessionID: 17326

Adventures in Project Management

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Professional Development And More

Speaker: Jonathan Gardner

Title: Adventures in Project Management

Abstract:

Projects that run long, run over budget, or flat out fail always get management's attention, and not good attention. This session will cover the project management process and demonstrate how it can help deliver higher quality results on time and on budget.

Case studies and real world examples will arm managers and team leads with tools including communication management plans, requirements documentation, stakeholder management plans, and change management. These tools will help mitigate and manage common project pitfalls like status update meetings, gold plating, and scope creep.

At the end of the session attendees will be armed with the knowledge necessary to streamline projects and how to deliver a top quality work product.

SessionID: 17822

Beginners guide to Table Expressions

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Professional Development And More

Speaker: Joe Murphree

Title: Beginners guide to Table Expressions

Abstract:

Common Tables Expressions (CTE) were introduced in SQL 2005. If you have only heard about them and would like to know more about how they work and there benefits this class is for you.

What you will learn:

SessionID: 17908

Database Design Throwdown

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions

Speaker: Karen Lopez

Title: Database Design Throwdown

Abstract:

Karen and Tom debate about options and best practices of common and advanced design issues, such as:

SessionID: 18397

SQL Server 2012 T-SQL

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions

Speaker: Kathi Kellenberger

Title: SQL Server 2012 T-SQL

Abstract:

You have heard all about AlwaysOn, BI Semantic Model, and Power View. Did you know that SQL Server 2012 has a host of new T-SQL features? Attend this session to learn more about the Sequence object, new functions and enhancements to the OVER clause.

SessionID: 18535

Virtualizing SQL Server with Windows Server 2012 a

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions 2

Speaker: Keith Mayer

Title: Virtualizing SQL Server with Windows Server 2012 a

Abstract:

Windows Server 2012 has been acclaimed by industry pundits as the most ambitious release of a Microsoft Server OS since Windows 2000! Windows Server 2012 is now available, and now is a great time to start evaluating it for your next project. Attend this session to learn what’s new in Windows Server 2012 and Hyper-V in Scalability, Virtualization, Storage, Networking and Manageability and get a jump start in preparing for how best to leverage Windows Server 2012 in your environment for SQL Server database workloads.

SessionID: 19619

I Shoulda Taken That Left Turn at Albuquerque...

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Professional Development And More

Speaker: Mark Swofford

Title: I Shoulda Taken That Left Turn at Albuquerque...

Abstract:

The first 24 months are extremely important in our careers when we’ve been offered the opportunity to take on the ‘DBA’ role. To be successful, it takes a solid foundation of general concepts, career development, training, fearlessness, confidence, and mentorship from more experienced professionals.

Organization, planning, and having a roadmap to where you are going will be crucial to your success. This session will bring these topics together so you can set your GPS to success avenue.

SessionID: 20024

The Fangorn Forest - ColumnStore Indexes

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Gareth Swanepoel

Title: The Fangorn Forest - ColumnStore Indexes

Abstract:

In the fantasy world of Middle-earth live the Ents. The Ents are tall tree-people who help the Fellowship by parallelizing the fight against Saruman. Come and learn how the new SQL 2012 feature, ColumnStore Indexes, can parallelize your Data Warehouse aggregations in the same way. I will be doing a deep dive into the inner workings of ColumnStore indexes.If you are a production DBA who needs to find out about some of the additional hot features that have been included with CSI's, like batch mode processing and data segments or if you are a BI developer who needs to find out how CSI's can increase the performance of your aggregations and star-joins by up to 40 times, then this session is for you.

SessionID: 20111

Slowly changing dimensions- an integrated approach

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions 2

Speaker: Mark Stacey

Title: Slowly changing dimensions- an integrated approach

Abstract:

There are many treatments of table design for slowly changing dimenions, and almost as many on doing ETL on an SCD. Much less has been said about building a cube around a slowly changing dimension.

In this session, Mark will review the types of slowly changing dimensions, describe the performance implications of various methods of loading SCDs in SSIS (SCD task, Lookups, Merge, and Script component), and build the versioning directly into the dimension in Analysis Services

SessionID: 21048

TBA - Introductory SQL Session

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Application Development

Speaker: Denny Cherry

Title: TBA - Introductory SQL Session

Abstract:

TBA

SessionID: 22351

Taking the Scary out of Monster Reports

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Pam Shaw

Title: Taking the Scary out of Monster Reports

Abstract:

So the big wigs have come up with a “master” report that shows everything you could ever want on a single report.  It includes grids and charts of varying sizes and complexities.  Did I mention they want it pretty as well?  In this session we will discuss how to use SQL Reporting Services to bring it all together while avoiding the pit falls and mistakes.  The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts.  We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work.  To get the most out of this session, you should be able to build a report in SSRS.

SessionID: 23017

Do SQL XML queries have to scare me?

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Application Development

Speaker: Rick Morelan

Title: Do SQL XML queries have to scare me?

Abstract:

I have seen days of amazing C# XML library coding work replaced by 2 lines of a FOR XML statement in SQL. Built into SQL is the power to make XML do pretty much whatever you need it to. Learn how to use the XML data type and built-in XQuery functions. You will also see how to join (or “bind”) a SQL table to an XML stream to produce a single result set.

SessionID: 23314

Revenge: The SQL Part 2: The Sequel!

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Application Development

Speaker: Rob Volk

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

Abstract:

SessionID: 23949

Parameter sniffing - make it work for you !

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Application Development

Speaker: Sanil Mhatre

Title: Parameter sniffing - make it work for you !

Abstract:

In this session we will discuss the workings of Parameter Sniffing and demonstrate how it helps improve the performance of your database applications. We will also explore how Parameter Sniffing can go wrong and its impact. Several ways to fix bad Parameter Sniffing will be demonstrated to help make an appropriate choice for your scenario.

SessionID: 23975

Bulletproof: Hardening your SQL Server from Attack

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Database Administration

Speaker: Sarah Barela

Title: Bulletproof: Hardening your SQL Server from Attack

Abstract:

Recent major security breaches have not only exposed customer data, but also the system vulnerabilities DBAs must overcome daily. As data protection is a DBA’s primary responsibility, establishing an impenetrable environment to host the data is the first step towards risk-free security. How can DBAs ensure SQL Servers are fortified against the latest threats and vulnerabilities? In this session, we will go through the process of hardening your SQL Server from attack from Windows Server to the database level step-by-step. I will share will share with you how establish security baselines and monitor for changes to your security foundation. This session will provide specific actions for you to take back and apply to your servers.

SessionID: 26279

Indexing Deep Dive

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Database Administration

Speaker: Kevin Boles

Title: Indexing Deep Dive

Abstract:

SessionID: 26854

The Periodic Table of Dynamic Management Objects

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions 2

Speaker: Tim Ford

Title: The Periodic Table of Dynamic Management Objects

Abstract:

Taking the periodic table of elements into consideration I've created The Periodic Table of Dynamic Management Objects as a reference tool for these functions and views that have become so critical for today's SQL Server DBA to performance tune and gain metadata insights into their various SQL instances. In navigating the table we will examine key DMVs and DMFs of interest: requests, sessions, wait stats, indexes, system information will all be covered. We will also delve into how these DMOs - just like their elemental counterparts - can be combined to yield interesting insights into your servers. We will also look at how things can go awry as well! Like mixing vinegar and baking soda, sometimes combining DMOs can cause a big mess too!

SessionID: 27673

Deeper into Tabular Models - M-to-M and the "W"

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions 2

Speaker: Wayne Snyder

Title: Deeper into Tabular Models - M-to-M and the "W"

Abstract:

You will need to understand how many-to-many relationships work in tabular models. While different than dimensional models, you can be successful in getting many of the behaviors you will need. Understanding how filters propagate is necessary requisite. We will use a "W" diagram to understand how this occurs in tabular models. Then we will learn how to force filter propagation, called cross-filtering. Then we will cross-filter conditionally, based on what the user has chosen for filters. If time permits we will also learn how to handle large numbers of fact rows, both in development and production.

SessionID: 27901

Bridging the Chasm: BI Theory vs. Practice

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: William E Pearson III

Title: Bridging the Chasm: BI Theory vs. Practice

Abstract:

A Dynamic Dialog session: According to research compiled by Gartner from discussions with many BI clients, a substantial disparity exists, in the implementation of BI, between theory (standard approaches, promises, claims and expectations) and practice (shortfalls, compromises and other realities). In this session, Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog within which we will gain an understanding of the general types of discrepancies between the “ideal” approach to BI and the compromised reality that a large number of organizations experience. We’ll then share and class experiences as a group, and discuss ways to avoid these discrepancies in future projects.

SessionID: 8984

SQL Server 2012 AlwaysOn Readable Secondaries

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Database Administration

Speaker: Adam Belebczuk

Title: SQL Server 2012 AlwaysOn Readable Secondaries

Abstract:

One of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups and the ability to have readable secondary replicas. In this session, we will cover the pros and cons of using AlwaysOn as well as the basics of how to set it up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications databases, are currently using Database Mirroring, or if you're just curious about AlwaysOn, then you won't want to miss this session.

SessionID: 9698

The Decoder Ring for Data Warehousing / BI

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Robert Cain

Title: The Decoder Ring for Data Warehousing / BI

Abstract:

Business Intelligence is one of the hottest job skills in the IT field. DBAs and Database Developers are being asked to implement databases with non-traditional design, and are having a lot of new vocabulary thrown their way. In this talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean.

SessionID: 9997

Gather SQL Server Performance Data with PowerShell

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions

Speaker: Allen White

Title: Gather SQL Server Performance Data with PowerShell

Abstract:

We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.