Nr: 111
SQLSaturday #111 - Atlanta 2012
SessionID: 11111
SQL Server is the Least of My Problems!
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: BEG
Speaker: Julie Smith
Title: SQL Server is the Least of My Problems!
Abstract:
You’ve finally gotten your first job working with SQL Server (SS) as the junior DBA at company XYZ. All the studying, the classes, the pricey SS certification exams, the User Group attendance has paid off.
Your first day at the job your boss walks you through some new job duties. He wants you to remote out to the server to look at the file directory where the FTP process writes the encrypted files make sure the file share didn’t disappear when the cluster failed over. You slip away to the bathroom, lock yourself in a stall, have a seat and rock side to side muttering -What is he talking about?I thought there would be tables.
If this sounds familiar this session is for you. Learn about the SS ecosystem how to navigate it as a new
SessionID: 13884
Analytical Master Data Management with MDS 2012
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: SSAS\IS\RS
Speaker: Eric Melcher
Title: Analytical Master Data Management with MDS 2012
Abstract:
Recent changes in Business Intelligence have placed greater emphasis on on enabling end-user analytics. While compelling in theory, in practice there are many challenges when creating a foundation that supports end-users analytics. Many of these challenges revolve around making consistent reference (i.e. dimensional) data available to end users. This can be addressed using a Master Data Management solution.
This session session will explore ways that Master Data Services 2012 can be used to support the definition and management of master data used to support analytics (BI) solutions. It will start with a high level overview of MDM and MDS 2012, and finish with a demo of an analytical MDM solution.
SessionID: 14674
Managing data in a Windows Phone application
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Glen Gordon
Title: Managing data in a Windows Phone application
Abstract:
Learn about the various options for managing data in a Windows Phone application, including local storage, accessing data feeds, synchronization, and more.
SessionID: 15017
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: SSAS\IS\RS
Speaker: Hope Foley
Abstract:
SessionID: 16603
It's Spring - Are You Still Compressed?
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Jeremy Carroll
Title: It's Spring - Are You Still Compressed?
Abstract:
In this session we will review the growing parts of rows and how to keep them as lean as possible.
The following topics will be studied:
• Row structure with a concentration on the parts that grow
• Row and page compression and their effect on row structure
• Prefix and Dictionary compression and their effect on row structure
• The CPU cost of running queries against compressed data
• Some strategies for compressing various data
• Leave the attendees with additional demos and scripts for studying compression and testing it on your own machine
SessionID: 16661
Report Parts: Increasing Productivity Since 2008R2
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: SSAS\IS\RS
Speaker: Jessica Moss
Title: Report Parts: Increasing Productivity Since 2008R2
Abstract:
Using SQL Server 2008 R2 Reporting Services and Report Builder 3.0, report writers can store, re-use, and modify pieces of reports using "report parts". Report parts are stored on the report server and are provided to others for collaboration in a report part library to increase initial development productivity and decrease maintenance turn-around time. This presentation will describe how to set up a user-friendly and easily maintained report part library by discussing how to create report parts, how to store them on the report server, and how to import them into a new report.
SessionID: 16834
PowerShell Modules You Should Know About
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: POW
Speaker: Jim Christopher
Title: PowerShell Modules You Should Know About
Abstract:
You know that problem you're working on? Chances are someone has already solved it, and has packaged their solution up in a nice pretty PowerShell module for you to use.
Come learn about PowerShell modules - what they are, how you use them, where you can find them. And let's explore some of these modules and see what problems they can solve for us.
SessionID: 16857
Managing Database Changes with Visual Studio
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Jim Wooley
Title: Managing Database Changes with Visual Studio
Abstract:
SessionID: 17192
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: SSAS\IS\RS
Speaker: John Welch
Abstract:
SessionID: 17998
Windows Operating System Internals for DB Pros
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Brian Kelley
Title: Windows Operating System Internals for DB Pros
Abstract:
SessionID: 18001
Being the Swiss Army Knife of DB Pros
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: BEG
Speaker: Brian Kelley
Title: Being the Swiss Army Knife of DB Pros
Abstract:
Being a specialist means you're really, really good at one thing. Being a generalist means you're good at a a lot of different things. The generalist has an advantage over the specialist because he or she can see and solve problems the specialists can't. In this session I'll cover why it's important to diversify your skill set, not only for career protection, but to be better as a database professional. We'll look at what skill sets to build on to expand your abilities around SQL Server to include the operating system, development, networks, and security. Remember, this saying isn't complete, "Jack of all trades, master of none." The full saying is, "Jack of all trades, master of none, though often times better than master of one."
SessionID: 22256
Using NULL the Right Way
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Phil Pledger
Title: Using NULL the Right Way
Abstract:
SessionID: 22345
Taking the Scary out of Monster Reports
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: SSAS\IS\RS
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 2008 R2 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: 24723
Power View: A Peek Behind the Curtain
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: SSAS\IS\RS
Speaker: Stacia Varga
Title: Power View: A Peek Behind the Curtain
Abstract:
SessionID: 26358
Fundamentals of Physical Join Operations
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Kevin Boles
Title: Fundamentals of Physical Join Operations
Abstract:
SessionID: 26939
The Personal-Team-Organizational BI Conundrum
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: SSAS\IS\RS
Speaker: Teo Lachev
Title: The Personal-Team-Organizational BI Conundrum
Abstract:
SessionID: 28498
Benchmarking, Baselines and Monitoring Storage
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Wesley Brown
Title: Benchmarking, Baselines and Monitoring Storage
Abstract:
Benchmarking, Baselines and Monitoring Storage
There are several steps in the life cycle of your storage systems. We have several tools to help us understand our storage systems from initial deployment through its useful life.
We will cover:
SQLIO, a specific SQL Server benchmarking tool.
Iometer, a general IO benchmarking tool and simulator.
SQLIOSim a specific SQL Server base lining tool and simulator.
TPC style testing focused on TPC-C, TPC-E and TPC-H.
Monitoring your system using WMI and virtual file stats.
Finally, what it all really means, how to read these results and compare them with each other.
With these tools you can plan, deploy and manage your storage for years to come!
SessionID: 28696
Designing an SSIS Framework
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: SSAS\IS\RS
Speaker: Andy Leonard
Title: Designing an SSIS Framework
Abstract:
SessionID: 29118
Introduction to SQL Server Column-Level Encryption
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Bob Langley
Title: Introduction to SQL Server Column-Level Encryption
Abstract:
SessionID: 29545
Working with Server Side Traces
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Christina Leo
Title: Working with Server Side Traces
Abstract:
You may have heard that it’s a good idea to use a server-side trace to capture SQL profiler data, but do you know how to create one? And, do you know how to process the data you’ve captured? If not, then this session is for you.
First, we’ll examine the anatomy of a server-side trace script and look at the different ways it can be customized. Then, we’ll talk about methods for stopping and starting the trace, how to know what traces are already running, and ways to schedule a trace to start under certain server conditions. Last, we’ll look at different tools available to you for analyzing the data you’ve gathered, including the SQL Server Profiler client application, “home-grown” T-SQL queries, ClearTrace, and the ReadTrace.
SessionID: 30033
Windows PowerShell Best Practices
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: POW
Speaker: Ed Wilson
Title: Windows PowerShell Best Practices
Abstract:
Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences
SessionID: 30242
Moving Day - Successful SQL Migrations with ShareP
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: SSAS\IS\RS
Speaker: Geoff Hiten
Title: Moving Day - Successful SQL Migrations with ShareP
Abstract:
SessionID: 30274
Common Backup Problems and How to Deal With Them
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: BEG
Speaker: Grant Fritchey
Title: Common Backup Problems and How to Deal With Them
Abstract:
SQL Server backups can be burdensome to set up and maintain. All sorts of different problems can occur. This session targets the most common problems encountered while working with SQL Server backup and shows you how to identify these issues in your environment. In fact, I’ll walk you through how to prevent these common issues from ever cropping up within your systems in the first place. Be prepared for information you can take back to the office and put to work right away making your system backups more reliable. With backups running correctly all the time, you’ll be protecting your systems better, and feeling a lot less stress when it times to perform an emergency restore.
SessionID: 30276
Execution Plans a Deep Dive
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Grant Fritchey
Title: Execution Plans a Deep Dive
Abstract:
SessionID: 30292
PowerScripting Live! (PowerShell podcast / BoF)
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: POW
Speaker: Hal Rottenberg
Title: PowerScripting Live! (PowerShell podcast / BoF)
Abstract:
Do you listen to podcasts? It's like the radio, but more Internetty. Well, Atlanta just so happens to be the home to the two co-hosts of the PowerScripting Podcast, the first podcast devoted to talking about Windows PowerShell. We have news, interviews, tips and resources that we present every week at powerscripting.net, but this time, the show is coming to you live! We'll come prepared to hit most any general PowerShell topic you want, and we'll probably sneak some SQL + PowerShell experts on stage to help out. This won't be a canned lecture, it will be more of a Birds of a Feather or talk show feel. Audience participation is REQUIRED!
SessionID: 30565
Concurrency in PowerShell
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: POW
Speaker: Jon Boulineau
Title: Concurrency in PowerShell
Abstract:
Moore's law is not dead; it lives on as CPU manufacturers add more and more CPU cores to the same chip real estate. In this session, we will look at the ways in which you can leverage concurrent processing in your PowerShell code to dramatically increase the efficiency of your code. Speed up those ETL processes, execute code on multiple servers at the same time, and complete your maintenance tasks much faster using the techniques you will learn.
SessionID: 30691
Mobile Business Intelligence
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Jen Underwood
Title: Mobile Business Intelligence
Abstract:
SessionID: 30693
Beginning T-SQL
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: BEG
Speaker: Jennifer McCown
Title: Beginning T-SQL
Abstract:
If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!
SessionID: 30694
T-SQL Brush-up:The Best Things You Forgot You Knew
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Jennifer McCown
Title: T-SQL Brush-up:The Best Things You Forgot You Knew
Abstract:
You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. This session is chock full of code examples, including before-and-after demos and how-to illustrations.
SessionID: 31146
Extended Events, Work Smarter Not Harder
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Jason Strate
Title: Extended Events, Work Smarter Not Harder
Abstract:
SessionID: 31187
Database Design Contentious Issues
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Karen Lopez
Title: Database Design Contentious Issues
Abstract:
A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
SessionID: 31610
EIM - Bringing Together SSIS, DQS, and MDS (300)
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: SSAS\IS\RS
Speaker: Matt Masson
Title: EIM - Bringing Together SSIS, DQS, and MDS (300)
Abstract:
Enterprise Information Management (EIM) is an industry term for managing your data for data integration, quality, and governance. This session revolves around a demo which brings together the EIM functionality in SQL Server, a key part of our Credible, Consistent Data story for the 2012 release. We will show you how SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS) and other Microsoft technologies work together to provide a comprehensive EIM solution.
SessionID: 31930
“Managed Self-Service BI” and “Data As A Service”
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: SSAS\IS\RS
Speaker: Melissa Coates
Title: “Managed Self-Service BI” and “Data As A Service”
Abstract:
You know BI. Right? Well kids, traditional Business Intelligence is changing … you heard about the ambitious data analyst down the hall who created a mashup of data from the internal data warehouse + Excel + an Azure feed? Empowering knowledge workers is Microsoft's vision of delivering "BI for the Masses." In this session we will dismiss the hype examine how this new world of "Managed Self-Service BI" complements Corporate BI in SQL Server 2012 and SharePoint 2010. Goals: (1) Overview of each Self-Service component. (2) Introduce Codename "Data Explorer" and Data As A Service. (3) Techniques to monitor, manage, secure the Self-Service BI environment.
SessionID: 32010
Index Internals
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Denny Cherry
Title: Index Internals
Abstract:
During this session we will be digging into the internals of SQL Server indexes.
SessionID: 32013
SQL Server Table Partitioning from the ground up
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Denny Cherry
Title: SQL Server Table Partitioning from the ground up
Abstract:
In this session we will be looking at the SQL Server table partitioning features which were introduced in SQL Server 2008. We will
look at how to create partitioned tables and indexes as well as the internals of the table. We will also look at how to move data
from one partition to another and from one table to another with minimal to no impact to the users.
SessionID: 32494
SSIS 2012: Project Deployment Model and Catalog
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: SSAS\IS\RS
Speaker: Rafael Salas
Title: SSIS 2012: Project Deployment Model and Catalog
Abstract:
SSIS in SQL Server 2012 is getting major face lift and comes loaded with a great deal of enhancements and new features. In this session we explore the new the new project deployment model, design and runtime features along with deployment and management considerations using the also brand new SSIS catalog. This session provides you with valuable to get you going in your next SSIS 2012 project.
SessionID: 32561
Revenge: The SQL Part 2: The Sequel!
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
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, hiding and obfuscating data and code, 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: 33079
Applied Enterprise Semantic Mining
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: SSAS\IS\RS
Speaker: Mark Tabladillo
Title: Applied Enterprise Semantic Mining
Abstract:
SQL Server 2012 debuts a new Semantic Platform (commonly known as the applied task, Semantic Search). This text mining technology leverages the already established Full Text Index, and builds semantic indexes in a two-phase process. This presentation provides a science description and demo for the Enterprise implementation of Tag Index and Document Similarity Index. At present (RC0), the indexes work for 15 languages. Included are strategy tips for how to best leverage the technology along with already-existing Microsoft text mining and data mining.
SessionID: 33257
Working with "Biggish Data"
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Stuart Ainsworth
Title: Working with "Biggish Data"
Abstract:
Most database professionals know (from firsthand experience) that there continues to be a "data explosion", and there's been a lot of focus lately on "big data". But what do you do when your data's just kind of "biggish"? You're managing Terabytes, not Petabytes, and you're trying to squeeze out as much performance out of your aging servers as possible. The focus of this session is to identify some key guidelines for the design, management, and ongoing optimization of "larger-than-average" databases. Special attention will be paid to the following areas: * query design * logical and physical data structures * maintenance backup strategies
SessionID: 33294
Introduction to FileTables
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Sven Aelterman
Title: Introduction to FileTables
Abstract:
SQL Server 2012 introduces the first significant enhancement to FILESTREAM: FileTables. FileTables use the underlying FILESTREAM storage, but expose the stored data using traditional Windows file I/O APIs. In addition, they also support hierarchical data storage (read "folders"). This session will show how to set up your SQL Server instance to support FileTables, how to create a FileTable and how to access it using standard Windows file APIs.
It may be valuable to attend the Introduction to FILESTREAM session also.
SessionID: 33616
It is TEMPDB, Why Should You Care?
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Tim Radney
Title: It is TEMPDB, Why Should You Care?
Abstract:
TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session.
SessionID: 33823
Introduction to Common Table Expressions
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Vicky Harp
Title: Introduction to Common Table Expressions
Abstract:
Introduced in SQL 2005, Common Table Expressions, or CTEs, are temporary result sets that offer increased flexibility in your T-SQL coding and provide a simple syntax for recusive queries. In this session for intermediate T-SQL coders, learn how to use CTEs to improve the readability and maintainability of your most complex queries.
SessionID: 33877
Table Vars Temp Tables - What you NEED to Know!
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
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: 34300
PowerPivot for Excel: For Those Unacquainted ...
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: William E Pearson III
Title: PowerPivot for Excel: For Those Unacquainted ...
Abstract:
Microsoft BI Architect and SQL Server MVP Bill Pearson overviews PowerPivot for Excel, the client side of Microsoft’s foray into self-service BI. The targeted audience includes BI professionals who are seeking an introduction to what PowerPivot offers their organizations. Among others interested will be Excel power users who are fluent with PivotTables and want to understand the new capabilities.
SessionID: 34634
Think Outside the Group! Take MDX to the next leve
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: SSAS\IS\RS
Speaker: Erika Bakse
Title: Think Outside the Group! Take MDX to the next leve
Abstract:
SessionID: 8869
Time Saving Tips Tricks for SSMS 2012
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Aaron Nelson
Title: Time Saving Tips Tricks for SSMS 2012
Abstract:
SQL Server Management Studio can be really annoying sometimes. Over the years a few really nice features have been added that you may have overlooked or just couldn’t find. This session will focus some time saving tips and tricks for SSMS 2008 R2. We’ll also cover a few great new features being introduced in SSMS 2012. Since I can’t provide scripts for this session I guess I better get started working on some screen shots on where they hid all this stuff!
SessionID: 9365
Query Tuning Mastery: Manhandling Parallelism
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: DBA\DEV
Speaker: Adam Machanic
Title: Query Tuning Mastery: Manhandling Parallelism
Abstract:
SessionID: 9702
Configuring SQL Server 2012 Reporting Services
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: SSAS\IS\RS
Speaker: Robert Cain
Title: Configuring SQL Server 2012 Reporting Services
Abstract:
SessionID: 9703
The Decoder Ring for Data Warehousing / BI
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: BEG
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: 9998
Manage SQL Server 2012 on Server Core w/PowerShell
Event Date: 14-04-2012 - Session time: 00:00:00 - Track: POW
Speaker: Allen White
Title: Manage SQL Server 2012 on Server Core w/PowerShell
Abstract: