Nr: 206
SQLSaturday #206 - Madison 2013
SessionID: 10027
Manage SQL Server 2012 on Server Core w/PowerShell
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 321
Speaker: Allen White
Title: Manage SQL Server 2012 on Server Core w/PowerShell
Abstract:
SessionID: 10588
Back It Up Faster!
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 350
Speaker: Bob Pusateri
Title: Back It Up Faster!
Abstract:
Backups: You can't live without them but want them to complete as quickly as possible. The faster they're done, the sooner your server's CPU and IO resources can get back to their normal job of servicing queries.
Queries aren't the only part of SQL Server you can tune for maximum performance - backups fall under this category as well. This session will discuss how backups work and how you can capitalize on this knowledge to ensure they complete as quickly as possible. Cutting your backup (and restore) times by 50% or more is not out of the question when using these methods.
SessionID: 12135
“ColumnStore” Indexes for Fast EDW Query
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 384AB
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: 13886
Unit Testing Fundamentals
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 322
Speaker: Eric Selje
Title: Unit Testing Fundamentals
Abstract:
How can you be certain the "little change" you're about to make to that stored procedure isn't going to take down your whole company? Real developers use a technique called "Unit Testing" to minimize that risk, a concept that's also available to you. With unit testing you can quick ascertain whether the the changes to functions, stored procedures, and even other objects in your database had a negative unforeseen impact.
In this session we'll walk through the basics of what unit testing is, how to set up a simple Unit Testing project in SSMS, how we can tell whether something has negatively changed in our functions or procedures. We'll also enumerate any 3rd party tools available to help us with Unit Testing our databases.
SessionID: 14105
Join Us! Getting Started as a Technical Speaker
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 142A
Speaker: Eddie Wuerch
Title: Join Us! Getting Started as a Technical Speaker
Abstract:
SessionID: 14182
Introduction to Business Intelligence and Data Mod
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 380
Speaker: Farouq Abukhamireh
Title: Introduction to Business Intelligence and Data Mod
Abstract:
SessionID: 14642
You're the DBA. Now What?
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 142B
Speaker: Gill Rowley
Title: You're the DBA. Now What?
Abstract:
Are you an accidental DBA trying to find your way through your new role? Are you an experienced DBA moving to a new position, team, or major application? This presentation is for you! In this presentation, we will review best practices for what to do when you're a brand new DBA. You will learn what to look for when you walk into a new environment, as well as pitfalls to avoid.
SessionID: 15711
Extend Your Knowledge with Extended Events!
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 321
Speaker: Janis Griffin
Title: Extend Your Knowledge with Extended Events!
Abstract:
SessionID: 15957
Discovering the Plan Cache
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 321
Speaker: Jason Strate
Title: Discovering the Plan Cache
Abstract:
SessionID: 16252
PowerShell and SQLPSX the Dynamic Duo for the DBA
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 384AB
Speaker: Jim Dorame
Title: PowerShell and SQLPSX the Dynamic Duo for the DBA
Abstract:
With PowerShell and SQLPSX your DBA life can be a lot simpler.
SMO is powerful, but can be difficult to use. Enter SQLPSX. Chad Miller put together a set of PowerShell functions that
streamline the use of SMO, easing management of a multi-server environment.
Come learn when and how the addition of PowerShell and SQLPSX can benefit you.
SessionID: 16366
Master Data Services
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 380
Speaker: Jeff Prom
Title: Master Data Services
Abstract:
Does your company have similar data in multiple locations? Not really sure which set of data is accurate? With MDS, Microsoft gives you the ability to have one accurate source of non-transactional data to use with your applications or send to other databases and ETL processes. Leverage data stewards to help manage the data repository to ensure it is up-to-date and accurate.
In this session we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel
add-in, security, hierarchies, views, versions, and business rules. After this session, you should have a good understanding of what MDS does, how to use it, and how to get started with your own MDS project.
SessionID: 16520
Getting Started with SSAS Tabular Cubes
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 380
Speaker: Jennifer Salvo
Title: Getting Started with SSAS Tabular Cubes
Abstract:
Prior to the release of SQL Server 2012, Business Intelligence Developers had a single option when creating cubes in Analysis Services, the Multidimensional Model. Now, Microsoft has added the Tabular Model to Analysis Services which opens up many new and exciting possibilities.
In this session, we'll discuss the features and benefits of the Tabular Model and draw comparisons to the Multidimensional Model. We'll also review scenarios when implementing a Tabular cube may be a better choice than Multidimensional. The presentation will conclude with a demo of basic Tabular cube functionality.
SessionID: 16631
Consulting: The Good, The Bad, The Ugly
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 142A
Speaker: Jes Schultz
Title: Consulting: The Good, The Bad, The Ugly
Abstract:
Ted Krueger and Jes will be presenting this session. Consulting is a mystical career path that is often questioned: should I do it, can I do it, and why should I do it? Come join us for a discussion of the pros and cons to consulting with an emphasis on SQL Server and Microsoft Technologies. We'll field questions with real world experiences. Once you leave this open floor session, you'll be able to make better choices in your own professional development and how consulting may or may not effect it.
SessionID: 17517
Demystifying BISM and Tabular Mode SSAS
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 380
Speaker: Josh Fennessy
Title: Demystifying BISM and Tabular Mode SSAS
Abstract:
In this session, attendees will gain understanding of what Multidimensional and Tabular modelling IS, as well as how the BISM layer helps to translate user requests to ensure no confusion is made. Attendees will also learn how to BUILD a Tabular model, and will help design a solution live during the presentation.
SessionID: 17845
What’s Simple About SIMPLE Recovery?
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 321
Speaker: Kalen Delaney
Title: What’s Simple About SIMPLE Recovery?
Abstract:
There is a common misconception that SIMPLE Recovery means no logging, and this is a very dangerous myth to propagate. SQL Server does log database changes in SIMPLE Recovery, but some (not all) operations are minimally logged. In this presentation, I'll tell you what minimal logging means in conjunction with each of the three different recovery models. In addition, I’ll describe the benefits and dangers of the SIMPLE Recovery Model.
SessionID: 18848
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 142B
Speaker: Ken Stuber
Abstract:
SessionID: 18904
Throwing T-SQL 2012 Enhancements Against the Wall
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 350
Speaker: Kyle Neier
Title: Throwing T-SQL 2012 Enhancements Against the Wall
Abstract:
Just like your grandma tested spaghetti to tell if it was done, we'll be throwing several of the new T-SQL enhancements against the wall to see what's good and what falls off. We'll silence the lion's RaiseRror by throwing some meaty exceptions. We'll bring together the old lovers "Coalesce" and "+" for one last jaunt before they are banished by the Concat function. We'll even open the window on some of the new aggregate and analytical functions as well as some other t-sql enhancements introduced in SQL 2012.
SessionID: 19132
Power View Strengths Weaknesses
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 380
Speaker: Leonard Murphy
Title: Power View Strengths Weaknesses
Abstract:
SessionID: 20057
Shoveling Frogs into a Wheelbarrow
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 142B
Speaker: Merrill Aldrich
Title: Shoveling Frogs into a Wheelbarrow
Abstract:
If you face managing over a hundred, or perhaps thousands, of databases, automation, standards and a "policy-based" mindset are critical. In this session we'll do a walk-through of a rules-based backup and index maintenance solution suitable for zillions of smaller databases, and talk at a high level about features and techniques for multi-server management including monitoring, performance data collection, jobs automation, PowerShell and PBM.
SessionID: 20445
Deadlocks: What to do about the dreaded 1205
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 350
Speaker: Michael DeFehr
Title: Deadlocks: What to do about the dreaded 1205
Abstract:
Deadlocks can be very tricky, unpredictable and generally nasty. Is all hope lost? This demo-intensive session will explore several types of deadlocks and give you some insight into how to track them down and prevent them. We wil start with a quick review of locking and blocking concepts, then take a deep-dive into deadlock demos.
SessionID: 21149
SQL 2012 Windows 2012 - Better Together
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 350
Speaker: Michael Steineke
Title: SQL 2012 Windows 2012 - Better Together
Abstract:
Enhancements in Windows Server 2012 that give you more fexability and higher uptime with SQL Server 2012. Including Quorum models, SQL over SMB, Large SQL in HyperV.
SessionID: 21361
Effective Index Partitioning, Compression Strategy
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 384AB
Speaker: Neil Hambly
Title: Effective Index Partitioning, Compression Strategy
Abstract:
Learn how to identify those objects that benefit greatly from being Partitioned or Compressed, OR combining both of these features to even greater effect.
Using Demos to illustrate the performance gains with real-world examples, Take away advanced scripts for use in your own environments.
SessionID: 22389
An Optimistic Approach: Snapshot Isolation in SQL
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 384AB
Speaker: Paul Timmerman
Title: An Optimistic Approach: Snapshot Isolation in SQL
Abstract:
Until 2005, SQL Server was a very pessimistic RDBMS. However with the introduction of the Read Committed Snapshot database option and the new Snapshot Isolation level, that is no longer the case.
After a high level look at all SQL Server isolation levels, we’ll spend the majority of this session discussing the implementation of optimistic concurrency control in SQL Server. We’ll look at the benefits and drawbacks of using an optimistic isolation level and discuss use cases where it may or may not be appropriate.
Come learn how to put one of the more powerful, but least understood, aspects of SQL Server to work for you!
SessionID: 22665
SSIS Templates Can Make Your Life Easier
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 322
Speaker: Brian Davis
Title: SSIS Templates Can Make Your Life Easier
Abstract:
How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again.
SessionID: 23656
Introduction to BI Markup Language (BIML) and BIML
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 322
Speaker: Russel Loski
Title: Introduction to BI Markup Language (BIML) and BIML
Abstract:
In this session we will use BIDS Helper to create a simple SSIS package using BIML. We will handle a couple SSIS scenarios with BIML and BIML Script.
SessionID: 24582
Interrogating the Transaction Log
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 142B
Speaker: Frank Gill
Title: Interrogating the Transaction Log
Abstract:
Without the transaction log, SQL Server would have no way of maintaining a consistent and durable view of its data. It would be pandaemonium!!! Think of the Stay-Puft Marshmallow Man! Thankfully the transaction log is there and we can all breathe easier.
In this session, you will learn how SQL Server uses the transaction log to maintain the durability and consistency of its data, along with methods for reading the transaction log and identifying active transactions.
SessionID: 24977
Flipping Through the SSIS Catalag
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 322
Speaker: MIKE DONNELLY
Title: Flipping Through the SSIS Catalag
Abstract:
SessionID: 26089
Upgrading to SQL Server 2012 with limited downtime
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 142A
Speaker: Ted Krueger
Title: Upgrading to SQL Server 2012 with limited downtime
Abstract:
I don’t and that is why we’re going to look at methods to upgrade or migrate SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 up to SQL Server 2012 with as little downtime as possible - minutes. In this session, we’ll see how mirroring, log shipping and even replication, can make us look like DBA Rock stars at upgrade time.
SessionID: 26858
Don't Box Me In: Escape the Cubicle
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 142A
Speaker: Tim Ford
Title: Don't Box Me In: Escape the Cubicle
Abstract:
I've been telecommuting in some capacity or another since before I was a DBA. For 13 years I've been able to be a productive, responsive, integral and valuable asset to my company without maintaining a physical presence within the confines of a corporate office. Let's have a conversation and discuss what has (and has not) worked for me over the years. Let's discuss the traits of a good telecommuter as well as those attributes that may not make this the right arrangement for everyone. We will even discuss what my Managers have done over the years to not only acommodate telecommuting, but to embrace and succeed from having staff that work remotely!
This session is aimed at staff and management alike.
SessionID: 26859
High IO, High IO, It's a Case Study Yo Ho!
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 350
Speaker: Tim Ford
Title: High IO, High IO, It's a Case Study Yo Ho!
Abstract:
Confronted with the highest IO of any Windows server in our environment one intrepid DBA was able to reduce IO, space consumption, and blocking to new lows. This is a case study, based upon actual events where the names of the innocent as well as the guilty are changed to protect the DBA. Topics covered: DMVs, online operations, Filegroups, Page Compression, and disk formatting best practices.
SessionID: 27813
Navigating the Options for Data Redundancy
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 142B
Speaker: Wendy Pastrick
Title: Navigating the Options for Data Redundancy
Abstract:
SQL Server has so many options for data redundancy, how do you know when you should use replication, or log shipping or AlwaysOn, etc? We will use real world examples where data redundancy is needed and discuss which is the appropriate technology and why. This is more than just a high availability vs disaster recovery discussion. If you have ever been confused or overwhelmed by all of the options, they will be broken down and made clear in this session.
SessionID: 28294
A Powershell Driven Life
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 384AB
Speaker: Zach Mattson
Title: A Powershell Driven Life
Abstract:
Why are we here? I have no idea, but I do know Powershell can probably help make it easier. This session will be entirely demos hitting on a variety of different areas in the SQL Server stack. Using plenty of SQL Server Management Objects(SMO), we will cover a variety of tasks for the data professional on both sides (OLTP / OLAP) of the house including working with SSAS, SQL Server , writing tests and automation. The theoretical will be ignored as well as any common decency towards mass produced beer. A Powerpoint free presentation.
SessionID: 9770
The Secret Life of an INSERT Statement
Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Room 321
Speaker: Argenis Fernandez
Title: The Secret Life of an INSERT Statement
Abstract:
Follow the life of an INSERT statement from the moment it is issued by the Client, through reception, parsing and execution by the SQL Server engine, until the operation is completed and a message is sent back.
This is an Internals session where we will touch on all the different components that comprise the SQL Server Database Engine involved in handling a single INSERT statement. Watch structures on memory and disk get updated, and geek out on details!