sqlsathistory

Nr: 291

Back to Main list

SQLSaturday #291 - Chicago 2014

Start Time (24h) Speaker Track Title
00:00:00 Bill Fellows Room 214 2012 TSQL Sweets
00:00:00 Bill Lescher Room 218 Fast and Flexible Applications with Better Database Design
00:00:00 Brent Ozar Room 116 How to Think Like the Engine
00:00:00 Brent Ozar Room 216 Real-Life SQL 2012 and 2014 Availability Group Deployments
00:00:00 Brian Beswick Room 116 Database Unit Testing
00:00:00 Colleen Morrow Room 214 SQL Audit - auditing doesn't have to be boring
00:00:00 Dave Mattingly Room 219 Achievement Unlocked: How to Get Promoted
00:00:00 David Klee Room 116 SQL Server Virtualization 101
00:00:00 David Klee Room 216 Squeezing Top Performance from Your Virtualized SQL Server
00:00:00 David Maxwell Room 214 DBA 911 - Database Corruption
00:00:00 Ed Leighton-Dick Room 117 SQL Server Features That Will Blow Your Mind!
00:00:00 Eric D. Boyd Room 215 Working with Data in Windows Azure
00:00:00 Grant Fritchey Room 215 Best Practices for Database Deployment
00:00:00 Haidong Ji Room 117 Introduction to Big Data
00:00:00 Hope Foley Room 214 Spatial Data: Cooler Than You'd Think!
00:00:00 Jim Dorame Room 215 PowerShell and SQLPSX the Dynamic Duo for the DBA
00:00:00 Jason Strate Room 219 Managing SQL Server Performance with Extended Events
00:00:00 Jason Strate Room 217 5 Ways to Improve Performance through Indexing
00:00:00 Joseph D'Antoni Room 117 The Modern Analytics Architecture
00:00:00 Joseph D'Antoni Room 217 In-Memory Columnstore Indexes--Make Your Data Warehouse Fly
00:00:00 Jeff Prom Room 218 Master Data Services
00:00:00 Ken Stuber Room 218 Database Development using SQL Server Data Tools
00:00:00 Laerte Junior Room 215 How to properly gather performance counter data using Windows PowerShell
00:00:00 Meagan Longoria Room 218 Choose Your Geospatial Mapping Adventure
00:00:00 Mark Vaillancourt Room 217 MDX Trek: First Contact
00:00:00 Mark Vaillancourt Room 116 DANGER: The Art and Science of Presenting
00:00:00 Merrill Aldrich Room 217 Eureka! Visual deep dive into storage internals
00:00:00 Melissa Meyer Room 218 PowerPivot and Excel Reporting
00:00:00 Michael Schulte Room 215 Extending SQL Server with Advanced Analytics and R
00:00:00 Ross LoForte Room 116 Take SQL Server performance to the next level with SQL 2014 in-memory OLTP
00:00:00 Luke Jian Room 117 How to baseline performance for SQL Server
00:00:00 Frank Gill Room 214 Designing a Restore Strategy
00:00:00 Stacia Varga Room 217 Introducing Power BI
00:00:00 Scott Shaw Room 117 Pig\Hive - All That's New is Old Again
00:00:00 Andy Yun Room 219 Every Byte Counts: Why Your Data Type Choices Matter
00:00:00 David Ortiz Room 218 Self Service Pitfalls
00:00:00 MIKE DONNELLY Room 219 Forward the Federations
00:00:00 Ted Krueger Room 216 SSIS: The DBA Multiplier
00:00:00 Tim Ford Room 215 Query Tuning Superstardom for Beginners
00:00:00 Warner Chaves Room 214 Best Practices for your Very Large Databases
00:00:00 Wendy Pastrick Room 219 Women In Technology Panel
00:00:00 Wendy Pastrick Room 216 Using Dell tools to improve visibility, efficiency and overall performance
00:00:00 Wendy Pastrick All Attendees Keynote
00:00:00 Wendy Pastrick Room 217 Replicate and sync SQL Server data on mobile devices
00:00:00 Wendy Pastrick Room 117 When Cluster and Virtualization Aren't Enough: How to Create an Application Availability Framework
00:00:00 Wendy Pastrick Room 219 Advanced Performance Tuning Tips with Database Performance Analyzer
00:00:00 Allan Hirt Room 216 Hybrid Solutions: The Future of SQL Server Disaster Recovery
00:00:00 Allan Hirt Room 216 Business Continuity: The Real Reason for HA and DR
00:00:00 Adam Machanic Room 116 Query Tuning Mastery: Clash of the Row Goals

SessionID: 10449

2012 TSQL Sweets

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 214

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

Fast and Flexible Applications with Better Database Design

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 218

Speaker: Bill Lescher

Title: Fast and Flexible Applications with Better Database Design

Abstract:

Are you a jack of all trades? Have you been writing application code AND designing databases? Are you spending lots of time altering your tables knowing there has just got to be a better way? This beginner session will take a tour through common pitfalls in database designs, discuss the repercussions of lacking standards, prove out consistency issues and help you keep your applications fast and flexible. A properly designed database should perform at the highest levels and not require a gargantuan effort to adapt to routine application growth.

SessionID: 10740

How to Think Like the Engine

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 116

Speaker: Brent Ozar

Title: How to Think Like the Engine

Abstract:

You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In this session with Microsoft Certified Master Brent Ozar, you’ll role play as the database engine while Brent gives you queries. You’ll learn first-hand about clustered indexes, nonclustered indexes, execution plans, sargability, statistics, TempDB spills, and T-SQL anti-patterns.

SessionID: 10741

Real-Life SQL 2012 and 2014 Availability Group Deployments

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 216

Speaker: Brent Ozar

Title: Real-Life SQL 2012 and 2014 Availability Group Deployments

Abstract:

You want to deploy AlwaysOn, but you're concerned about hidden drawbacks, performance impacts, and how it affects development. Brent Ozar has deployed SQL 2012 and SQL 2014 Availability Groups at big web sites including StackOverflow.com and the Discovery Channel, plus used it to scale out reads at data warehouses. Come learn what he's found in real-life deployments of AlwaysOn.

SessionID: 10770

Database Unit Testing

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 116

Speaker: Brian Beswick

Title: Database Unit Testing

Abstract:

Learn about Database Unit Testing, how it can add value to your projects, and how to do It with Microsoft Visual Studio. Brian will be speaking about the fundamentals of what database unit testing is and the Microsoft Visual Studio Tools for implementing database unit test projects. This talk is intended for audiences who are new to database unit testing and want to learn the basics behind using Visual Studio to perform automated database unit tests.

SessionID: 11778

SQL Audit - auditing doesn't have to be boring

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 214

Speaker: Colleen Morrow

Title: SQL Audit - auditing doesn't have to be boring

Abstract:

Let's face it, auditing isn't fun. But if you're a DBA, you need to know what's going on in your SQL Server instance. Fortunately, SQL Audit makes it easy. In this session, we'll cover what you can and can't audit using SQL Audit, enhancements in 2012, configuring database and server audits, ways to process output, and ideas for how to implement SQL Audit on a larger scale. Auditing doesn't have to be hard. And with the help of a little custom coding, it can even be fun.

SessionID: 12247

Achievement Unlocked: How to Get Promoted

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 219

Speaker: Dave Mattingly

Title: Achievement Unlocked: How to Get Promoted

Abstract:

Have you ever felt like an extra in Office Space? You've got the skills. You've got the big brain. You feel like you have a higher calling, but those other guys get picked instead. What's the deal?

In this session, you'll learn how to promote yourself, how to speak confidently, how to build your personal brand, how to demonstrate value, and how to interview.

SessionID: 12506

SQL Server Virtualization 101

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 116

Speaker: David Klee

Title: SQL Server Virtualization 101

Abstract:

What is virtualization? What impact does it have on DBAs and their systems? What aspects of their job stays the same, and what changes? What is really going on inside that black box? The fundamentals of private cloud computing and how it impacts data professionals will be discussed in this interactive session. Tips on how to use the best of virtualization to improve their daily tasks and efficiencies will be demonstrated, and common questions and concerns will be addressed.

SessionID: 12507

Squeezing Top Performance from Your Virtualized SQL Server

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 216

Speaker: David Klee

Title: Squeezing Top Performance from Your Virtualized SQL Server

Abstract:

Just about anyone can click through a SQL Server installation and get it working, but more than a little tuning is required to get the most performance out of your servers. Once virtualized, additional tuning can help get even more performance out of that virtual machine. David Klee (@kleegeek) will discuss valuable details for both VMware vSphere and Microsoft Hyper-V on how to tweak and tune your virtual infrastructure for business-critical virtualized SQL Servers. Tips on configuring your SQL Server installations for maximum performance when virtualized will be covered in detail.

SessionID: 13304

DBA 911 - Database Corruption

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 214

Speaker: David Maxwell

Title: DBA 911 - Database Corruption

Abstract:

SessionID: 13676

SQL Server Features That Will Blow Your Mind!

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 117

Speaker: Ed Leighton-Dick

Title: SQL Server Features That Will Blow Your Mind!

Abstract:

How many lines of code does it take to generate a running total? How would you find a value in the next row of data - without using a cursor or loop? How can you efficiently store rows of data with a lot of optional fields, and how can you quickly find which of those rows have values? And how can you eliminate locking without resorting to dirty reads? SQL Server has answers for all of these questions, and none requires more than a few lines of code. Give me an hour, and I will blow your mind!

SessionID: 13894

Working with Data in Windows Azure

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 215

Speaker: Eric D. Boyd

Title: Working with Data in Windows Azure

Abstract:

The Windows Azure Platform provides a plethora of options for data storage and trying to make sense of it all can be overwhelming. In this session we will explore the many Azure data services including Windows Azure SQL Database , Azure Storage, Local Storage and Caching. We will walk through the scenarios that each storage service addresses. Next we will dig into how to use each storage service and how they can complement each other when used together. Finally, we will explore the pricing and economic drivers that encourage one storage service over another when multiple fit into your solution.

SessionID: 14774

Best Practices for Database Deployment

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 215

Speaker: Grant Fritchey

Title: Best Practices for Database Deployment

Abstract:

The easiest part of any deployment is running the deployment script on production. But what have you done to prepare that script for production? Was the script tested? Is the script tightly coupled with the application code?

The difference between a successful deployment and a failed or problematic deployment is all the preparation work you've done to ensure that you're deploying the right script, the right way to your production environment. This session will explore best practices that you can implement to ensure that your deployments are as successful as they can be.

SessionID: 14926

Introduction to Big Data

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 117

Speaker: Haidong Ji

Title: Introduction to Big Data

Abstract:

Political campaign predication, Google Flu trend, DNA sequencing, public sentiment on Twitter, and should I add ginger to the dish I am experimenting with? All the aforementioned topics have something in common: they use Big Data to help us understand this world and make intelligent decisions.

In this session, I will talk about some use cases of Big Data and the technologies behind the scene that enables it: Cloud computing, Hadoop/MapReduce, NoSQL, machine learning, statistics modeling, and such. I will also talk about what we this mean to data professionals like us and what we need to learn to face these challenges

SessionID: 15000

Spatial Data: Cooler Than You'd Think!

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 214

Speaker: Hope Foley

Title: Spatial Data: Cooler Than You'd Think!

Abstract:

Spatial data has been around since 2008 but it should fire it's PR person. It's too bad that spatial data gets no love, it's actually something that pretty much all SQL Server shops could use. This session will focus on utilizing these native types to store, analyze, and retrieve spatial data. I will use some real world examples to help get the wheels turning on how you can use it within your organization and show how powerful it can be to see your data visually on a map.

SessionID: 15555

PowerShell and SQLPSX the Dynamic Duo for the DBA

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 215

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

Managing SQL Server Performance with Extended Events

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 219

Speaker: Jason Strate

Title: Managing SQL Server Performance with Extended Events

Abstract:

One of a DBA's primary responsibilities is managing the performance of a SQL Server environment. When performance problems arise, DBAs need to have the correct tools in place to be able to dig in and discover the issues that are occurring. Although it's one of the newer tools in the DBA toolbox, Extended Events is one of the most powerful tools available. In this session, we will discuss performance management responsibilities for DBAs and provide a foundation, through Extended Events, to understand and resolve performance issues.

SessionID: 15966

5 Ways to Improve Performance through Indexing

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 217

Speaker: Jason Strate

Title: 5 Ways to Improve Performance through Indexing

Abstract:

Sometimes the hardest performance issues in your environment have simple solutions. One of these simple solutions is through properly indexing the database. In this session, we’ll look at five ways that performance of a database can be improved through indexing. When we finish, you’ll be armed with scripts and methodologies that you can put into place today to improve database performance.

SessionID: 16157

The Modern Analytics Architecture

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 117

Speaker: Joseph D'Antoni

Title: The Modern Analytics Architecture

Abstract:

The traditional data warehouse has been around a long time, and it isn’t going away anytime soon. However, with other options such as Hadoop and new analytic and data mining techniques, the warehouse is no longer the center of our business analytics universe. In this session, we will cover these new platforms and our approach for integrating them into your warehouse environment.

SessionID: 16158

In-Memory Columnstore Indexes--Make Your Data Warehouse Fly

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 217

Speaker: Joseph D'Antoni

Title: In-Memory Columnstore Indexes--Make Your Data Warehouse Fly

Abstract:

Columnstore indexes were introduced in SQL Server 2012, along with a new type of query processing "batch mode". In SQL 2014 they get even better--we can use a Columnstore index as a clustered index and update it. In this session we will explore the basics and beyond of Columnstore indexes and how they can help your warehouse performance. We will also examine their impact to insert and update performance, and the best use cases for implementation.

SessionID: 16373

Master Data Services

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 218

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

Database Development using SQL Server Data Tools

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 218

Speaker: Ken Stuber

Title: Database Development using SQL Server Data Tools

Abstract:

In 2007, Microsoft introduced Data Dude for Visual Studio 2005 to help bring the processes, controls and tools for code management to Database Development that Application developers had been enjoying for ages. It had its problems, but it mostly worked and was a welcome step in the right direction. Many versions later we have SQL Server Data Tools for Visual Studio 2013 (and 2012 and 2010...). A more mature product that finally brings database development up to par with traditional application development and has many features data geeks, like ourselves, will truly love. This talk will provide an overview of SSDT’s features and show you how to get started using it to save time, implement better code controls and be a better DBA or database developer.

SessionID: 18925

How to properly gather performance counter data using Windows PowerShell

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 215

Speaker: Laerte Junior

Title: How to properly gather performance counter data using Windows PowerShell

Abstract:

We DBA´s know how important it is to collect performance data. In this session, I will show to you how to properly use the native Get-Counter PowerShell cmdlet to get all information you need from your servers. It has never been as easy to collect performance counter data and save it to a CSV file or a SQL Server table for baselining and later analysis. You may be thinking "But I don’t know nothing about PowerShell and explicitly using .NET classes in my code". Don’t worry; you don’t need to know this to collect counters. Although this is a 100-level session, you’ll be producing 400-level results and your scripts will scale as the number of servers increase, because we’ll use asynchronous collection and processing. And better yet, we’ll schedule all of it. All this using native PowerShell cmdlets and a minimal amount of script code.

SessionID: 19190

Choose Your Geospatial Mapping Adventure

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 218

Speaker: Meagan Longoria

Title: Choose Your Geospatial Mapping Adventure

Abstract:

You have geospatial data and you know that plotting it on a map will deliver insights. Or maybe you keep hearing “geospatial” as a current BI buzzword and you want to be informed about your options when you get to it. The Microsoft BI stack provides several options for visualizing location data. But how do you know which tool will best serve your purpose, or what factors are important in making this decision? We’ll identify factors to consider when choosing a tool to visualize your data in maps such as system requirements, availability and type of location data, required level of technical understanding, and more. You’ll leave the session confident in your ability to choose the best tool within Excel and SQL Server.

SessionID: 19653

MDX Trek: First Contact

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 217

Speaker: Mark Vaillancourt

Title: MDX Trek: First Contact

Abstract:

Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment.

SessionID: 19654

DANGER: The Art and Science of Presenting

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 116

Speaker: Mark Vaillancourt

Title: DANGER: The Art and Science of Presenting

Abstract:

Is there a great difference in the brain chemistry of someone fleeing a hungry mountain lion and someone presenting to a group of colleagues in a corporate board room? The answer is: NO. Over the past decade, a lot has been learned about the chemistry of the brain and why humans react the way we do to events in our environment. The concept of EQ (Emotional Intelligence) is a compelling and growing concept that applies this knowledge in a set of learnable, improvable skills for leading human beings. While EQ is often applied to corporate leadership, the parallels to presenting are fantastic. This session will explain the basics of EQ and demonstrate how you can apply it to make your presentations better in the following areas: * Crafting better slide decks * Preparing yourself for presenting * Delivering your content * Dealing with the unexpected Understanding and practicing the concepts of EQ can make your presentations a better experience for everyone in the room--including you.

SessionID: 20067

Eureka! Visual deep dive into storage internals

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 217

Speaker: Merrill Aldrich

Title: Eureka! Visual deep dive into storage internals

Abstract:

Sometimes half the battle in computing is just to see what's happening. We will take a visual tour of physical database storage structures, using live demos with the freeware application SQL Server File Layout Viewer and our old friends the DBCC commands as guides. See what happens in a data file when you convert a table from a heap to a clustered index! See fragmentation and the havoc wrought by Shrink! Marvel at the behavior of multiple files and filegroups! Index Rebuilds! Eureka!

SessionID: 20976

PowerPivot and Excel Reporting

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 218

Speaker: Melissa Meyer

Title: PowerPivot and Excel Reporting

Abstract:

In this session, learn how anyone with Excel experience can take advantage of PowerPivot, the free add-in for Excel, to quickly and easily turn data from different sources such as traditional databases, Analysis Services, Excel, or the web into a workable dataset. Use this data for ad hoc analysis or to create visually impressive reports directly in Excel. Then leverage SharePoint to automatically refresh the data and publish it to share with others in the organization.

SessionID: 21130

Extending SQL Server with Advanced Analytics and R

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 215

Speaker: Michael Schulte

Title: Extending SQL Server with Advanced Analytics and R

Abstract:

The Microsoft SQL Server stack provides an excellent set of tools for storing, visualizing, and analyzing data, but sometimes we want to do more. In this session, we’ll take a look at the open-source statistical software R and how we can use it to connect to SQL Server, analyze data, and put the results of our analysis back into SQL Server for later use. We’ll look at examples of analyses performed by a fictional company as they segment their customers, forecast their sales, and examine interesting relationships among their product offerings. Along the way, we’ll see what some of these analyses would take if done in SQL Server itself and why R is so effective when paired with SQL Server.

SessionID: 23454

Take SQL Server performance to the next level with SQL 2014 in-memory OLTP

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 116

Speaker: Ross LoForte

Title: Take SQL Server performance to the next level with SQL 2014 in-memory OLTP

Abstract:

SQL Server 2014 ships with a powerful, new feature, to take your performance to the next level with In-Memory OLTP (Codename Hekaton). In-Memory OLTP unleashes today’s powerful processors and removes the roadblocks to new heights in performance. During the session, you will learn about the In-Memory OLTP capability, see a demo of its capabilities and gain an understanding on the behavior, scalability and use cases where it apply based on our extensive benchmark testing that we have completed.

SessionID: 24306

How to baseline performance for SQL Server

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 117

Speaker: Luke Jian

Title: How to baseline performance for SQL Server

Abstract:

Optimal configuration of he I/O subsystem is critical and can ultimately be responsible for the response times of your applications. In this session we analyze the different options that you have for your IO subsystem, what are their pros and cons, what tools are available to baseline the performance of the hardware that you will use for SQL Server and what numbers are important to you.

SessionID: 24594

Designing a Restore Strategy

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 214

Speaker: Frank Gill

Title: Designing a Restore Strategy

Abstract:

Do you back up your databases? If the answer is yes (and I really hope it is), do you test your restores? If a table gets dropped at 1:53PM, can you restore the database to 1:52PM using log backups? Can you use the WITH STANDBY parm to apply log backups to a read-only copy of a database?

For the answers to these questions and a whole lot more about database restores, plus some nifty scripts, join me for this presentation.

SessionID: 24643

Introducing Power BI

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 217

Speaker: Stacia Varga

Title: Introducing Power BI

Abstract:

Microsoft has brought business intelligence to the cloud. What does this mean and how does this work? In this session, we'll review the BI components available in the cloud BI stack. We'll also compare and contrast functionality of the cloud BI tools with on-premises tools. After attending this session, you'll have a better understanding of what's possible and whether it's time to launch your BI-in-the-cloud solution.

SessionID: 24836

Pig\Hive - All That's New is Old Again

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 117

Speaker: Scott Shaw

Title: Pig\Hive - All That's New is Old Again

Abstract:

Pig and Hive sound strange and exotic, but what are they? As a SQL Server DBA you'll find these two technologies to be quite familiar and easy to learn. Why? Because both were created for you. If you are a SQL Server DBA and you have to manage data in Hadoop, Pig and Hive may be your first tools of choice. This session will demystify both with clear examples and demos.

SessionID: 24880

Every Byte Counts: Why Your Data Type Choices Matter

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 219

Speaker: Andy Yun

Title: Every Byte Counts: Why Your Data Type Choices Matter

Abstract:

Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns? Did your gut tell you that this is bad, but you had difficulty explaining why? Did you know that these Datatype Choices can be a real performance killer? Attend this session, learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now! When you leave, you should be able to explain why datatype choices matter to your colleagues, assess your own systems, and implement some best practices to mitigate these performance killers.

SessionID: 24897

Self Service Pitfalls

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 218

Speaker: David Ortiz

Title: Self Service Pitfalls

Abstract:

Every Business Department, BI Developer, BI Sales Consultant can put together a snazzy Power Pivot Demo and even prettier Power View Dashboard. They will wow you with capabilities and even convince you that Self Service BI can cure all that ails your organization. And while these tools are very powerful and provide huge benefit to organizations when used properly, in the wrong hands they can cause chaos and confusion. In this session we will discuss common pitfalls when implementing Self Service BI. We will discuss important issues such as Data Quality, Data Security, Properly defining Roles and Responsibilities for end users. Yes, at the end of the day Self-Service BI is very powerful and a GREAT asset to organization, however implementing it properly is more important than the pretty Power View Visualization the sales person shows you!

SessionID: 24959

Forward the Federations

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 219

Speaker: MIKE DONNELLY

Title: Forward the Federations

Abstract:

If you are working with Windows Azure SQL Database (WASD) then you know that the way to scale large data sets is to use federations. If you were using SSIS to move data into a federated database you know how challenging this can be. This year Microsoft released a new SSIS component that handles a lot of the federated headache. I'll give the steps you need to set up federations in your WASD database and how to use SSIS to fill the tables with data.

SessionID: 26069

SSIS: The DBA Multiplier

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 216

Speaker: Ted Krueger

Title: SSIS: The DBA Multiplier

Abstract:

ever wanted to create clones of yourself to get all your work done faster? I will demonstrate how SSIS can help you perform your DBA tasks as if there were more than one of you. You will leave the session knowing how to use SSIS to automate tasks such as performance monitoring above (and below) the normal health checks and transporting databases from one environment to another. You will also learn how SSIS can be used in assisted HA and DR failover strategies as well as backup solutions that go beyond the simple BACKUP statement. We’re going to take SSIS and make it a standard tool for your administrative tasks!

SessionID: 26874

Query Tuning Superstardom for Beginners

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 215

Speaker: Tim Ford

Title: Query Tuning Superstardom for Beginners

Abstract:

In this session aimed at the novice query tuner we'll explore what big results may be yielded through the smallest of query tweaks. We will explore impacts of removing unnecessary joins, predicate blunders and problems with returning too much information. The end result is to improve those bad queries and make you look like a tuning superstar.

SessionID: 27635

Best Practices for your Very Large Databases

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 214

Speaker: Warner Chaves

Title: Best Practices for your Very Large Databases

Abstract:

As businesses' data needs keep growing so do the sizes of the databases we are entrusted to manage. Faced with constant growth and the scale of multiple Terabytes, more DBA's are facing the challenges to properly tune and maintain the VLDB's in their environment.

In this session we will go into the best practices, tips and tricks learned from helping customers in the field with this common growing pain. We will cover the best way to do integrity checks, stats updates, index maintenance, partitioned tables and more so you can to tame your Very Large Databases and keep them running in top shape.

SessionID: 27815

Women In Technology Panel

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 219

Speaker: Wendy Pastrick

Title: Women In Technology Panel

Abstract:

Join us to hear from women in the SQL Server Community as they discuss their success as Women In Technology!

SessionID: 27816

Using Dell tools to improve visibility, efficiency and overall performance

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 216

Speaker: Wendy Pastrick

Title: Using Dell tools to improve visibility, efficiency and overall performance

Abstract:

An overview of Dell Software’s Spotlight on SQL Server Enterprise and Performance Analysis for SQL Server. The session will focus on how the Dell tools improve visibility, efficiency and overall performance.

SessionID: 27817

Keynote

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: All Attendees

Speaker: Wendy Pastrick

Title: Keynote

Abstract:

SQL 2014 - What's New

SessionID: 27818

Replicate and sync SQL Server data on mobile devices

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 217

Speaker: Wendy Pastrick

Title: Replicate and sync SQL Server data on mobile devices

Abstract:

Zumero for SQL Server (ZSS) provides synchronization of SQL Server data with mobile devices (including iOS, Android, WinRT, WP8, Phonegap, and Xamarin). This session will provide an overview of ZSS and how it can be used to integrate with your existing SQL Server data and create great mobile apps that work offline.

SessionID: 27819

When Cluster and Virtualization Aren't Enough: How to Create an Application Availability Framework

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 117

Speaker: Wendy Pastrick

Title: When Cluster and Virtualization Aren't Enough: How to Create an Application Availability Framework

Abstract:

Join us for a talk on how to create an application availability framework for any SQL Server implementation. Clustering and virtualization solved some of the issues around high availability, but then these "infrastructure-up" approaches raised new challenges, including rigid configuration rules and restrictions, expensive software stacks, and complex operational models. In this webinar, we'll show you how you can focus on what matters most- your applications. Whether or not your environment already uses virtualization or clustering, this webinar will show you how to create an application availability framework that provides heterogeneous instance mobility from anything to anything, anywhere - truly physical, virtual, OS, SQL Server version agnostic. Ready for a new approach to assured availability? Attend this talk to learn how.

SessionID: 27820

Advanced Performance Tuning Tips with Database Performance Analyzer

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 219

Speaker: Wendy Pastrick

Title: Advanced Performance Tuning Tips with Database Performance Analyzer

Abstract:

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis with Database Performance Analyzer (formerly Confio Ignite). Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.

SessionID: 9256

Hybrid Solutions: The Future of SQL Server Disaster Recovery

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 216

Speaker: Allan Hirt

Title: Hybrid Solutions: The Future of SQL Server Disaster Recovery

Abstract:

The cloud is a polarizing buzzword in IT, especially for DBAs. The reality is that all of us will be affected by it over the next few years in one way or another much like we have been by virtualization. One of the best uses for the cloud is creating disaster recovery easier than we have been able to do in the past. This session will discuss the cloud from a SQL Server DBA perspective and how things like hybrid on premise/cloud solutions can be architected today to bring resiliency to current solutions with features like availability groups in SQL Server 2012 and 2014.

SessionID: 9258

Business Continuity: The Real Reason for HA and DR

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 216

Speaker: Allan Hirt

Title: Business Continuity: The Real Reason for HA and DR

Abstract:

These days, I've stopped counting how many times I've been approached to help implement feature X because a customer thinks/was told it provides 24x7 for a DB/instance. These decisions often lead to more downtime and less uptme if the technology choice was not right or cannot be administered by the current staff. The secret sauce is not what gets implemented but understanding everything behind the scenes that influences the final architecture based on your actual requirements. It’s less about technology and more about understanding what it will take to keep your business going even when things seems like they are crumbling down around you. This session will cover how to approach achieving business continuity with the right amount of uptime.

SessionID: 9367

Query Tuning Mastery: Clash of the Row Goals

Back to calendar

Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Room 116

Speaker: Adam Machanic

Title: Query Tuning Mastery: Clash of the Row Goals

Abstract:

The fight for better performance is a battle of wits: your mind, your intelligence, and your honor pitted against the less-than-dependable whims of the Query Optimizer. But alas, the arbitrary rewrites and clunky hints leveraged by most developers to get around optimization deficiencies make things feel less like a proper duel and more like a skirmish at the sandbox. To truly engage your enemy you must comprehend his inner workings, and in the case of the Query Optimizer, that means you must delve into the mysteries of "row goals." These internal metrics are tracked and enforced within Top iterators--and they exhibit a considerable amount of influence over plan shape and flow, both at compile time and as your query runs. Attend this session to learn how to take charge of optimization, expertly mold your query plans, and gain a new set of tools for eliminating bottlenecks in even your most complex problem queries. En garde!