sqlsathistory

Nr: 159

SQLSaturday #159 - Kansas City 2012

Start Time (24h)	Speaker	Track	Title
00:00:00	Bill Fellows	1 Amazon	2012 TSQL Sweets
00:00:00	Chris Shaw	3 Columbia	"What is the Best Disaster Recovery Solution?"
00:00:00	Christopher Price	4 Seine	Introduction to Master Data Services 2012
00:00:00	Christopher Price	4 Seine	Integrating DQS, MDS and Your Data Warehouse
00:00:00	David Valentine	1 Amazon	SSRS: Reporting on Reports
00:00:00	David Klee	0 Sports Bar	Database Health and Performance
00:00:00	David Klee	5 Hudson	Virtualizing Business Critical SQL Servers
00:00:00	Doug Lane	2 Danube	Devs are from Mars, Report Servers are from Venus
00:00:00	Frank Kearney	3 Columbia	Building your first PowerView report
00:00:00	Nathan Heaivilin	3 Columbia	Introduction to Execution Plans
00:00:00	Jason Strate	4 Seine	Discovering the Plan Cache
00:00:00	Jason Strate	2 Danube	Extended Events, Work Smarter Not Harder
00:00:00	Jason Kassay	2 Danube	The Accidental Programmer
00:00:00	Juan Soto	6 Missouri	So you want to be a computer consultant?
00:00:00	Karen Lopez	1 Amazon	Database Design Throwdown
00:00:00	Karen Lopez	2 Danube	Model-Driven Database Design
00:00:00	Meagan Longoria	1 Amazon	Reporting Services tips for the Stephen Few fan
00:00:00	Rick Krueger	0 Sports Bar	Freaky Fast Database Development Tips
00:00:00	Rushabh Mehta	4 Seine	SSIS 2012 Management Considerations and Best Pract
00:00:00	Rushabh Mehta	4 Seine	Introduction to Data Quality Services
00:00:00	Rowland Gosling	0 Sports Bar	Storage Design and SQL Server Performance
00:00:00	Thomas LaRock	0 Sports Bar	Choose Your Own Adventure: Performance Tuning
00:00:00	Steve Wake	2 Danube	SSIS 2012: More Than Just a Pretty UI
00:00:00	Tamera Clark	1 Amazon	45 Minutes to Build Your First Reporting Services
00:00:00	Kevin Boles	3 Columbia	Parallel Query Execution Deep Dive
00:00:00	Kevin Boles	3 Columbia	SQL Server 2012 Column Store Index
00:00:00	Andy Thiru	5 Hudson	SQL Azure Intro and What's New
00:00:00	Andy Thiru	5 Hudson	SQL Azure Data Sync and What's New
00:00:00	John Morehouse	0 Sports Bar	10 Things That Every DBA Should Know!
00:00:00	John Morehouse	6 Missouri	Social Networking Is Alive!
00:00:00	Andy Galbraith	5 Hudson	Maintain Your DBs with Help from Ola Hallengren

SessionID: 10434

2012 TSQL Sweets

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 1 Amazon

Speaker: Bill Fellows

Title: 2012 TSQL Sweets

Abstract:

The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences.

SessionID: 11488

"What is the Best Disaster Recovery Solution?"

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 3 Columbia

Speaker: Chris Shaw

Title: "What is the Best Disaster Recovery Solution?"

Abstract:

It depends, every situation is different. The question is often asked of DBA's to provide a solution to very open ended requirements. However, the best solution can only be provided if the database professional is getting all the answers. This session is a case study into many of Disaster Recovery options that we as database professionals have. Understand the answers to the important questions that we should be asking to provide the best solution not only for the database but for the business as well. As an attendee you will learn how to change an answer from it depends into a solid solution that can be built upon. We will take examples from experiences and as a group determine what the best solution is.

SessionID: 11948

Introduction to Master Data Services 2012

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 4 Seine

Speaker: Christopher Price

Title: Introduction to Master Data Services 2012

Abstract:

Businesses depend on reliable data that can be managed effectively and shared through-out the enterprise. In this session we will look at the how Master Data Services 2012 can provide a solid platform for your organization's master data management implementation. We will spend a majority of the session building a model, loading it with data and then refining it to highlight the features and capabilities that are available both out-of-the-box and through the excel plug-in.

SessionID: 11950

Integrating DQS, MDS and Your Data Warehouse

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 4 Seine

Speaker: Christopher Price

Title: Integrating DQS, MDS and Your Data Warehouse

Abstract:

With SQL Server 2012 it has never been easier to empower your data stewards and give them greater control over the data management process. Dive in as we integrate Master Data Services and Data Quality Services into a data warehouse. We will explore how Master Data Services and the new plugins available in 2012 can facilitate the management of your organization’s master data. A look at Data Quality Services will highlight how it can be leveraged to provide value to the data management process through its cleansing and matching capabilities. Finally, we evaluate the options available to integrate back into the data warehouse.

SessionID: 12365

SSRS: Reporting on Reports

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 1 Amazon

Speaker: David Valentine

Title: SSRS: Reporting on Reports

Abstract:

Business Intelligence gets a lot of press these days, but do you often wonder to yourself as you are writing a report, ‘Who is going to use this’? Learn about the rich information that SSRS is already capturing for you about your reports: who is running them and how often, how long do they take to execute, how much time is spent in data retrieval vs rendering, which parameters were passed in, and more… Co-Presenter: Rick Krueger (@DataOgre)

SessionID: 12574

Database Health and Performance

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 0 Sports Bar

Speaker: David Klee

Title: Database Health and Performance

Abstract:

Sure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? This dynamic dialog session will present a solid process for checking your environment's overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO.

SessionID: 13259

Virtualizing Business Critical SQL Servers

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 5 Hudson

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 this session 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 gotchya’s will be discussed in this dynamic dialog session.

SessionID: 13386

Devs are from Mars, Report Servers are from Venus

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 2 Danube

Speaker: Doug Lane

Title: Devs are from Mars, Report Servers are from Venus

Abstract:

At first, you loved working with Reporting Services, but now the honeymoon's over. What good are charts and tables when Reporting Services won't tell you what's wrong, renders too slow, and messes up your layout? You may be thinking about seeing other reporting products, but don't give up.

In this couples therapy for you and SSRS, rekindle your love by reviewing how reports perform best, seeing what RS has been trying to tell you (but you haven't been listening), and discovering new and simple tricks you never knew reports could do. You'll learn about:

• Dealing with blank extra pages • Designing reports for high performance • Powerful properties for precise layout and appearance • Troubleshooting using the execution log • ..a

SessionID: 14270

Building your first PowerView report

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 3 Columbia

Speaker: Frank Kearney

Title: Building your first PowerView report

Abstract:

So have you heard about this new fangled BI tool called PowerView from Microsoft? Well if you haven't then this is the session for you. During this session we will take a look at PowerView and discuss all the cool things it can do. Once we get all the talk'n out of the way, we walk through building your first PowerView report.

SessionID: 14951

Introduction to Execution Plans

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 3 Columbia

Speaker: Nathan Heaivilin

Title: Introduction to Execution Plans

Abstract:

Ever wonder what happens when a query is processed? Got a process that is running slow at the office and your boss in looking at you for answers? Want to look like a hero to your boss for fixing something that no one else could figure out? Then you might want to consider this session. Execution plans tell you what steps were taken to generate the results sets you did. In analyzing these plans, you can figure out what you are doing that is not efficient, so you can fix it. This session will give you the foundation you will need to do analysis so you can write better code and help your company with their performance issues.

SessionID: 15932

Discovering the Plan Cache

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 4 Seine

Speaker: Jason Strate

Title: Discovering the Plan Cache

Abstract:

SessionID: 15933

Extended Events, Work Smarter Not Harder

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 2 Danube

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

The Accidental Programmer

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 2 Danube

Speaker: Jason Kassay

Title: The Accidental Programmer

Abstract:

Most people in the database world have heard of the term, "The Accidental DBA", those programmers who out of nowhere get thrown into working with databases. Well what about the other side of the coin? What about those DB Developers and DBA's who have to write code? This presentation is a best practices guide for working with SQL Server in a .Net environment. It covers optimizing your code to reduce database requests, standard object oriented concepts such as data abstraction and encapsulation, tier architecture, security, and translating SQL data result sets into strongly typed class objects in .Net.

SessionID: 17659

So you want to be a computer consultant?

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 6 Missouri

Speaker: Juan Soto

Title: So you want to be a computer consultant?

Abstract:

Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn't start earlier? (and walk away from a cushy job).

I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I've learned the hard way. In this session you will lean sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out.

SessionID: 17899

Database Design Throwdown

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 1 Amazon

Speaker: Karen Lopez

Title: Database Design Throwdown

Abstract:

A highly interactive debate between Thomas LaRock and Karen Lopez about options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys NULL vs NOT NULL Quality vs Performance...and others. Bring your votes, your debates, and your opinions.

SessionID: 17900

Model-Driven Database Design

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 2 Danube

Speaker: Karen Lopez

Title: Model-Driven Database Design

Abstract:

Model-Driven Database Development: Myths, Magic and Methods. In this presentation, Karen discusses data model-driven database development from the point of view of the Data Architect, the DBA, and the Developer. She will cover topics such as "Who does what?", "Why are we doing this?", "Do I have to Use a GUI?" and "Just who do you think you are?". Demos, too. Finally, 10 tips for making model-driven database development successful in your organization's culture and environment.

SessionID: 19200

Reporting Services tips for the Stephen Few fan

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 1 Amazon

Speaker: Meagan Longoria

Title: Reporting Services tips for the Stephen Few fan

Abstract:

Do you opt for bullet charts over big, round gauges? Do 3-D pie charts make you sad? Have you ever redesigned a graph to get a better data-to-ink ratio? Whether you answered yes to all of these questions or you are unfamiliar with all of the above terms, come to this session to learn about helpful features and tools available when using Reporting Services to visually represent data in an efficient and effective manner. We will also discuss common challenges faced in the workplace when trying to implement the ideals in real life.

SessionID: 23023

Freaky Fast Database Development Tips

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 0 Sports Bar

Speaker: Rick Krueger

Title: Freaky Fast Database Development Tips

Abstract:

Join Rick and Dave on this most excellent adventure as they teach you how to get more work done in less time. Leave your checkbook at home, because this is all about maximum productivity with minimum budget. Leave with Visual Studio and SQL Server Management Studio shortcut keys, extensions, macros, and add-ins. We guarantee you will see something you haven’t seen before, or your money back.

Co-Presenter: Dave Valentine (@IngeniousSQL)

SessionID: 23118

SSIS 2012 Management Considerations and Best Pract

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 4 Seine

Speaker: Rushabh Mehta

Title: SSIS 2012 Management Considerations and Best Pract

Abstract:

SQL Server 2012 introduces a number of exciting new features that will change the way we design, deploy and manage SSIS packages. We will explore the new features, understand how to take advantage of them and formulate some best practices for efficient management of these packages

SessionID: 23119

Introduction to Data Quality Services

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 4 Seine

Speaker: Rushabh Mehta

Title: Introduction to Data Quality Services

Abstract:

Data Quality Services (DQS) has been introduced as part of the Microsoft SQL Server 2012 stack. In this session, we will take a first look at DQS and how it can transform the way we enable and set data quality standards to ensure clean data.

SessionID: 23478

Storage Design and SQL Server Performance

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 0 Sports Bar

Speaker: Rowland Gosling

Title: Storage Design and SQL Server Performance

Abstract:

This discussion will be about storage design and how it affects SQL Server's performance. Topic will include Solid State Drives (SSDs), SAN and Direct Attached Storage (DAS) and how the perform using RAID 5,RAID 6 and RAID 10. We will also cover File Groups, Files and entry level Table Partitioning.

SessionID: 25123

Choose Your Own Adventure: Performance Tuning

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 0 Sports Bar

Speaker: Thomas LaRock

Title: Choose Your Own Adventure: Performance Tuning

Abstract:

Life is all about choices, and when it comes to SQL Server it is no different. If you don't have a methodology for researching questions and resolving issues then you need to get one, and soon. Join Microsoft MVP Thomas LaRock from Confio Software as he helps guide you while YOU make the choices in this interactive performance tuning adventure.

SessionID: 25688

SSIS 2012: More Than Just a Pretty UI

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 2 Danube

Speaker: Steve Wake

Title: SSIS 2012: More Than Just a Pretty UI

Abstract:

SSIS 2012 added rounded corners and Undo/Redo to the designer, but what else was added to make this worth the upgrade? In this session there will be as many demos of the new features as can be fit into the time provided. Along with the rounded corners, you will also see the changes to deployment, SSIS catalog database, metadata/XML updates, Parameters, logging updates, Data Taps, ODBC support, script debugging, PowerShell interface and as many others as we can get through. If you haven't seen what has been updated in SSIS 2012, this will be the session to cover the most!

SessionID: 26000

45 Minutes to Build Your First Reporting Services

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 1 Amazon

Speaker: Tamera Clark

Title: 45 Minutes to Build Your First Reporting Services

Abstract:

Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2008 R2 and go interstellar with some space data!

SessionID: 26259

Parallel Query Execution Deep Dive

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 3 Columbia

Speaker: Kevin Boles

Title: Parallel Query Execution Deep Dive

Abstract:

SessionID: 26261

SQL Server 2012 Column Store Index

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 3 Columbia

Speaker: Kevin Boles

Title: SQL Server 2012 Column Store Index

Abstract:

Take your relational data warehouse query performance all the way to ELEVEN!! The Column Store Index is a new feature that allows for stunning performance. We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas.

SessionID: 27343

SQL Azure Intro and What's New

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 5 Hudson

Speaker: Andy Thiru

Title: SQL Azure Intro and What's New

Abstract:

In this session, you will get introduced to SQL Azure and learn how to get started. We will explore how to migrate an existing on-premise SQL Server database to SQL Azure. We will then walkthrough how to manage and administer your SQL Azure servers and databases. We will take a look at how to connect and build applications using SQL Azure. Next, we will look at more advanced scenarios using new capabilities like reporting with SQL Azure Reporting, synchronizing data with SQL Azure Data Sync for hybrid scenarios and global reach. Finally, we will explore some of the things you should consider when using SQL Azure

SessionID: 27344

SQL Azure Data Sync and What's New

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 5 Hudson

Speaker: Andy Thiru

Title: SQL Azure Data Sync and What's New

Abstract:

In this session, you will get introduced to SQL Azure Data Sync and learn how to get started. We will explore how to migrate data from an existing on-premise SQL Server database to SQL Azure and bi-directional data synchronization and data management capabilities allowing data to be easily shared across SQL Azure databases across multiple data centers.

What you will learn: • Overview of SQL Azure • How to Get Started with SQL Azure Data Sync • Cloud to cloud synchronization • Enterprise (on-premises) to cloud • Cloud to on-premises. • Bi-directional or sync-to-hub or sync-from-hub synchronization

SessionID: 34830

10 Things That Every DBA Should Know!

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 0 Sports Bar

Speaker: John Morehouse

Title: 10 Things That Every DBA Should Know!

Abstract:

Are you just starting out in the DB world? Are you unsure of things that you should know? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered 'Yes' to any of those question, then this is the session for you! John will be talk about things that he's seen in the trenches that every DBA should know and understand.

SessionID: 34831

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 6 Missouri

Speaker: John Morehouse

Abstract:

SessionID: 9611

Maintain Your DBs with Help from Ola Hallengren

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: 5 Hudson

Speaker: Andy Galbraith

Title: Maintain Your DBs with Help from Ola Hallengren

Abstract:

One of the most widely respected and recommended free tools for SQL Server is Ola Hallengren's MaintenanceSolution.sql. It is a one-stop package to backup your databases, maintain your indexes and statistics, and validate the integrity of databases. Come learn about the solution and how it can help you escape the world of canned maintenance plans as well as the importance of performing the various maintenance tasks.

This site is open source. Improve this page.