sqlsathistory

Nr: 287

Back to Main list

SQLSaturday #287 - Madison 2014

Start Time (24h) Speaker Track Title
00:00:00 Ben Miller Track 2 Be Friendly to SQL Server with TSQL Best Practices
00:00:00 Bill Fellows Track 1 SSIS development is done: now what? Deployment, migration, maintenance and troubleshooting
00:00:00 Bill Lescher Track 7 Fast and Flexible with Better Database Design
00:00:00 Brent Ozar Track 8 How to Tune Queries
00:00:00 Brian Beswick Track 6 Database Unit Testing
00:00:00 Chuck Heinzelman Track 5 SQL Server 2014: Platform for Hybrid Cloud
00:00:00 Chirag Shah Track 2 SQL Server 2014 Buffer Pool Extension
00:00:00 David Klee Track 5 Squeezing Top Performance from Your Virtualized SQL Server
00:00:00 Dan English Track 5 Delivering Self-Service BI with Power
00:00:00 David Maxwell Track 6 DBA 911 - Database Corruption
00:00:00 Gill Rowley Track 4 You're the DBA. Now What?
00:00:00 Jim Dorame Track 6 Contained Databases: What, Why and Where.
00:00:00 Janis Griffin Track 6 Advanced Performance Tuning Tips with Database Performance Analyzer (formerly Confio Ignite)
00:00:00 Janis Griffin Track 1 Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues
00:00:00 Jason Carter Track 7 Maintenance and Backups: Intro to Ola Hallengren
00:00:00 Jason Strate Track 2 Recognizing the Parallel Data Warehouse (PDW) Workload
00:00:00 Jes Schultz Track 5 SSMS: More Than Meets The Eye
00:00:00 Jonathan Kehayias Track 8 Solving Complex Problems with Extended Events
00:00:00 Joe Sack Track 2 Practical SQL Server Cardinality Estimation
00:00:00 John Morehouse Track 3 Social Networking Is Alive!!!
00:00:00 John Pertell Track 3 An Introduction to FileTables
00:00:00 Kalen Delaney Track 8 Hekaton Data: A Whole New World
00:00:00 Kirby Richter Track 2 Implement a Dynamic Table Partitioning Solution
00:00:00 Ken Stuber Track 1 Performance-Tuning for Extract/Transform/Load (ETL) Operations
00:00:00 Lara Rubbelke Track 8 Building Hadoop Clusters on Azure
00:00:00 Marc Temkin Track 7 Using DAX in SSMS and C#
00:00:00 Mark Vaillancourt Track 3 DANGER: The Art and Science of Presenting
00:00:00 Merrill Aldrich Track 7 PowerShell 101
00:00:00 Michael Schulte Track 4 Extending SQL Server with Advanced Analytics and R
00:00:00 Michael Steineke Track 1 SQL 2012 and 2014 AlwaysOn Configuration Deep Dive
00:00:00 Michelle Ufford Track 1 Resistance is Futile: What You Need To Know About Big Data
00:00:00 Paul Timmerman Track 3 Database Snapshots - Making Your Job Easier
00:00:00 Brian Davis Track 5 Getting Started with Hekaton (In-Memory OLTP)
00:00:00 Luke Jian Track 4 How to baseline IO performance for your next SQL Server
00:00:00 Scott Hietpas Track 7 How Skyline Does Innovative BI
00:00:00 Steve Jones Track 8 Unstructured Data in SQL Server
00:00:00 Pat Wright Track 5 Integrate SQL Server with hadoop
00:00:00 Andy Yun Track 4 Every Byte Counts: Why Your Datatype Choices Matter
00:00:00 MIKE DONNELLY Track 6 Forward the Federations
00:00:00 Terry Bunio Track 6 How do I create an automated ETL test suite ??
00:00:00 Ted Krueger Track 7 Upgrading and Migrating SQL Server with limited downtime
00:00:00 Ted Krueger Track 8 Keynote
00:00:00 Tracy McKibben Track 4 10 Ways To Abuse T-SQL

SessionID: 10221

Be Friendly to SQL Server with TSQL Best Practices

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Ben Miller

Title: Be Friendly to SQL Server with TSQL Best Practices

Abstract:

This session will take a look at things that you should regularly know and use when coding TSQL. How can you be really friendly to SQL? The items covered will show you things that will help ensure that your code is readable, efficient and maintainable. We will look at query semantics, datatypes, things to avoid as well as how to be super friendly to the SQL Engine and allow things to work well.

SessionID: 10445

SSIS development is done: now what? Deployment, migration, maintenance and troubleshooting

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Bill Fellows

Title: SSIS development is done: now what? Deployment, migration, maintenance and troubleshooting

Abstract:

After attending this session, you will have the knowledge to care and maintain an SSIS Project Deployment model outside of SSDT

SessionID: 10522

Fast and Flexible with Better Database Design

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 7

Speaker: Bill Lescher

Title: Fast and Flexible with Better Database Design

Abstract:

Are you a jack of all trades? Have you been writing application code AND designing databases?  Are you a DBA who can’t get that expensive database design training approved?  Are you spending lots of time altering your tables knowing there has just got to be a better way? This session will take a dive into common pitfalls in database designs, 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: 10744

How to Tune Queries

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 8

Speaker: Brent Ozar

Title: How to Tune Queries

Abstract:

You’re in a dark room with an ugly query. What do you do next? Microsoft Certified Master Brent Ozar shares his time-tested method of tuning queries starting with simplifying, analyzing the execution plan, making index tweaks, and measuring improvements with statistics. You’ll learn a repeatable process you can use to make queries go faster.

SessionID: 10769

Database Unit Testing

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 6

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

SQL Server 2014: Platform for Hybrid Cloud

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Chuck Heinzelman

Title: SQL Server 2014: Platform for Hybrid Cloud

Abstract:

SQL Server 2014 provides a great platform for Hybrid Cloud as it enable new hybrid cloud solution such as backup to cloud, HA to cloud as well as other hybrid scenarios that can help you reduce costs and improve on-premises DR. We have also made it much easier for DBAs who may not be familiar with Microsoft Azure to easily deploy and manage SQL Server workloads to it. In this session, we will discuss how SQL Server 2014 offers a unique value proposition when it comes to building hybrid cloud solutions is our Cloud OS strategy of ensure a great and consistent experience no matter where you are running your data platform with a common set of tools across the entire application lifecycle.

SessionID: 12056

SQL Server 2014 Buffer Pool Extension

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Chirag Shah

Title: SQL Server 2014 Buffer Pool Extension

Abstract:

SQL Server 2014 Buffer Pool Extension to SSD.

We will explore this new feature

a) When it is make sense to use it

b) Common misconception about this feature

c) Demo!

SessionID: 12505

Squeezing Top Performance from Your Virtualized SQL Server

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 5

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

Delivering Self-Service BI with Power

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Dan English

Title: Delivering Self-Service BI with Power

Abstract:

In this session, we will discuss the enhancements and new features that are provided with Excel 2013 as Microsoft continues its roadmap with self-service BI. First we will go over the changes that have been made in Excel 2013, covering the new features. From there we will show how PowerPivot models can be used to integrate and load data to be used for analysis. Lastly, we will look at using Power View inside Excel to provide self-service reporting capabilities that are highly interactive.

SessionID: 13306

DBA 911 - Database Corruption

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 6

Speaker: David Maxwell

Title: DBA 911 - Database Corruption

Abstract:

SessionID: 14643

You're the DBA. Now What?

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 4

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

Contained Databases: What, Why and Where.

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 6

Speaker: Jim Dorame

Title: Contained Databases: What, Why and Where.

Abstract:

In SQL Server 2012, Microsoft added the new feature "contained databases".

Database movement with out the orphans! Developers working independent of an instance! Delegate some database administration with out granting SA! Sound to good to be true?

Come learn how these and other elements of a "contained database", can impact your database life.

SessionID: 15724

Advanced Performance Tuning Tips with Database Performance Analyzer (formerly Confio Ignite)

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 6

Speaker: Janis Griffin

Title: Advanced Performance Tuning Tips with Database Performance Analyzer (formerly Confio Ignite)

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. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.

SessionID: 15725

Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Janis Griffin

Title: Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Abstract:

Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.

SessionID: 15795

Maintenance and Backups: Intro to Ola Hallengren

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 7

Speaker: Jason Carter

Title: Maintenance and Backups: Intro to Ola Hallengren

Abstract:

This session will provide an overview of the critically acclaimed SQL Server Maintenance Solution written and maintained by Ola Hallengren. If you're using Maintenance plans, you're started in the right direction, but Ola's solution is the Gold Standard for Maintenance scripts. We will review the options and show you how these scripts can leave you more at ease with your backup, database and index maintenance duties.

SessionID: 15968

Recognizing the Parallel Data Warehouse (PDW) Workload

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Jason Strate

Title: Recognizing the Parallel Data Warehouse (PDW) Workload

Abstract:

If you are like many, you've been hearing a lot about Parallel Data Warehouse (PDW) lately. PDW is Microsoft's appliance solution with SQL Server 2012 that allows massively parallel processing (MPP) of database workloads. But how do you know that you have a workload that requires or could benefit from MPP over the standard symmetric multiprocessing (SMP) architecture? In this session, we'll review that question and more with a run through of how to identify MPP workloads? As part of the session, we'll also review some of the key components and differentiators of the PDW platform. You'll leave this session with a clear understanding of the value that PDW can bring to an organization and the types of workloads that it is best suited for.

SessionID: 16637

SSMS: More Than Meets The Eye

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Jes Schultz

Title: SSMS: More Than Meets The Eye

Abstract:

SQL Server Management Studio is the standard tool for working with SQL Server databases. It does the job well. But if you’re using the default settings, you’re missing out! You can enable word wrap and number the lines. Change the settings when you script objects out. Filter through objects. Create templates, projects, and snippets. Let me guide you through the world of SSMS settings!

SessionID: 17069

Solving Complex Problems with Extended Events

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 8

Speaker: Jonathan Kehayias

Title: Solving Complex Problems with Extended Events

Abstract:

New to SQL Server 2008, Extended Events provide a refreshingly new method of looking at what occurs inside of SQL Server. This session will show you how to leverage Extended Events to solve complex problems by identifying the root cause faster than other methods of data collection provide.

SessionID: 17125

Practical SQL Server Cardinality Estimation

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Joe Sack

Title: Practical SQL Server Cardinality Estimation

Abstract:

What is cardinality estimation and why should you care? In this session we'll cover the mechanics behind cardinality estimation and why it is so very critical to overall query performance. We'll cover concepts applicable to the last few major versions of SQL Server and also preview cardinality estimator changes being introduced in SQL Server 2014.

SessionID: 17256

Social Networking Is Alive!!!

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: John Morehouse

Title: Social Networking Is Alive!!!

Abstract:

Social Networking/Media is all over the news today. Did you see that on Facebook? Johnny 5 said what on Twitter?? Can you believe Susie moved to that company?? Do any of those sound familiar? No? Never heard of Twitter? Don't have any fear as this session is for you! Social networking can be a very confusing place and when you don't know where to start, that makes it even worse. In this session, we will go over different facets of Social Networking/Media and how you can use them to enhance not only your personal lives but just as importantly, your professional one. We'll be covering Facebook, LinkedIn and Twitter.

SessionID: 17546

An Introduction to FileTables

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: John Pertell

Title: An Introduction to FileTables

Abstract:

With the release of SQL Server 2012 Microsoft introduced FileTables, a better way to store large objects inside a database. With FileTables you get the advantage of the security and transactional consistency of a database AND improved file streaming from the OS. In this session I'll show you how easy it is to set up and use FileTables, as well as improved methods of searching document keywords with FullText and Semantic searches.

SessionID: 17848

Hekaton Data: A Whole New World

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 8

Speaker: Kalen Delaney

Title: Hekaton Data: A Whole New World

Abstract:

SQL Server 2014's In-Memory OLTP stores your data and indexes in a whole new way. In this session we'll take a look at way SQL Server 2014 In-Memory Database keeps track of your data with two new kinds of indexes, and why your data storage is so much more efficient.

SessionID: 18390

Implement a Dynamic Table Partitioning Solution

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Kirby Richter

Title: Implement a Dynamic Table Partitioning Solution

Abstract:

Have a large or potentially large database that you would like to partition? Manually implementing partitioning and the corresponding maintenance can be a lot of work, especially if you have many tables. In this presentation we look at how you would implement a partitioning solution dynamically for all tables with the designated partition column. We set it up to keep a FIXED number of file groups. The partition maintenance will recycle the file groups over time as partitions are dropped and created. We do as much as possible through dynamic scripting. This solution can easily be used for archiving but in this example we are simply keeping the most current 6 months of data and dropping the rest. Assumes you have a basic understanding of SQL Server table partitioning.

SessionID: 18851

Performance-Tuning for Extract/Transform/Load (ETL) Operations

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Ken Stuber

Title: Performance-Tuning for Extract/Transform/Load (ETL) Operations

Abstract:

Much has been written about performance tuning transactional systems and reports, but what about those huge queries used to populate your data warehouse, data marts or large data extracts? What good are reports if you can’t deliver the underlying data in a timely manner? What can be done to make handling millions of rows at a time go faster? In this talk, we’ll go over how to architect an ETL solution that will use every trick in the SQL-Server engine to make data move faster! We’ll be focusing on T-SQL based ETL stored procedures (and a little SSIS) rather than expensive tool-based ETL. We’ll also discuss hardware issues and how to tune processes that you can’t “change”.

SessionID: 18949

Building Hadoop Clusters on Azure

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 8

Speaker: Lara Rubbelke

Title: Building Hadoop Clusters on Azure

Abstract:

Big data and the cloud offer unparalleled opportunities for compute elasticity and deployment model flexibility. Learn about your options with the Windows Azure platform for deploying and managing Hadoop in the cloud. We'll demonstrate cluster deployment and integration with the various options.

SessionID: 19507

Using DAX in SSMS and C#

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 7

Speaker: Marc Temkin

Title: Using DAX in SSMS and C#

Abstract:

While the Tabular Model provides great self-service features with Excel and Power View many BI needs exceed these solutions. Using the DAX language within SSMS provides more flexibility and power. Incorporating these statements into a solution, such as in C#, can provide for better delivery of complicated BI requests that users cannot complete on their own. This presentation will give you a start on creating DAX statements and using those statements within a programming language.

SessionID: 19652

DANGER: The Art and Science of Presenting

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 3

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

PowerShell 101

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 7

Speaker: Merrill Aldrich

Title: PowerShell 101

Abstract:

If you haven't dug in to PowerShell at this point, you're missing out on some amazing, powerful, practical stuff that could save you time every day. PowerShell does have a learning curve at the outset, especially for those not already familiar with OO concepts or programming in a language like C#, so this introductory session will go through the very basics of PowerShell syntax. If that collection of pipes and hyphens and curly braces seems to be written in some incomprehensible foreign language, this session is for you. At the end of the session you should have a grasp of how and why a PowerShell script does what it does, and the confidence to dig in deeper and begin using POSH scripts in your own work.

SessionID: 21132

Extending SQL Server with Advanced Analytics and R

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 4

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

SQL 2012 and 2014 AlwaysOn Configuration Deep Dive

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Michael Steineke

Title: SQL 2012 and 2014 AlwaysOn Configuration Deep Dive

Abstract:

Brief overview of AlwaysOn features, then dive into what you need to consider when implementing these new features. This session will be interactive, with demos and systems refer to. Bring ideas and questions on how to make this work in the real world. We will discuss the entire infrastructure needed to support DR and HA, and why you need to have a very good understanding of AD to have a successful implementation. We may even break out a white board!

SessionID: 21172

Resistance is Futile: What You Need To Know About Big Data

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Michelle Ufford

Title: Resistance is Futile: What You Need To Know About Big Data

Abstract:

The data community is all abuzz about Big Data, and for good reason. Much like Business Intelligence before it, we're rapidly approaching the point where all data professionals should have at least a cursory understanding of what Big Data is and how it fits into an organization. To that end, this presentation will provide an overview of what Big Data is, discuss some common use cases for Big Data across a variety of industry verticals, and explore some common architectures for integrating relational and analytical data with Big Data. We'll conclude with QA and an overview of resources for learning more.

SessionID: 22398

Database Snapshots - Making Your Job Easier

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Paul Timmerman

Title: Database Snapshots - Making Your Job Easier

Abstract:

Want to off load some of that reporting workload, make an emergency rollback during a production upgrade faster, or make managing your test databases easier? If any of these appeal to you, then you should be familiar with database snapshots within SQL Server. Available since SQL Server 2005, use of this feature can make your life a lot easier.We'll spend the first part of this session taking an in depth look at how database snapshots work. We’ll look at what exactly is happening behind the scenes when you create a snapshot and when you query a snapshot. Once we've covered the basics, we'll spend the rest of our time analyzing and discussing a number of real world use cases where snapshots can be very beneficial and save you a great deal of time.

SessionID: 22646

Getting Started with Hekaton (In-Memory OLTP)

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Brian Davis

Title: Getting Started with Hekaton (In-Memory OLTP)

Abstract:

So you've heard of Hekaton (In-Memory OLTP) but you aren't sure where to start or if it's for you or not. Maybe you've heard or read some information and not sure what's true or not. There's a number of misconceptions out there about Hekaton. By the end of this session you'll have a better understanding of what Hekaton is and how it may be able to help you. We'll discuss the basics of Hekaton and more as well as walking through some demos to show you how to use Hekaton and what it can do as well as help you get started diving into Hekaton on your own.

SessionID: 24303

How to baseline IO performance for your next SQL Server

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Luke Jian

Title: How to baseline IO performance for your next 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: 24416

How Skyline Does Innovative BI

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 7

Speaker: Scott Hietpas

Title: How Skyline Does Innovative BI

Abstract:

Skyline Technologies will share their experience in using Agile project methodology and "Dev Camp" events to promote innovation and build technical skills - all while having fun! In particular, Skyline will highlight their recent project to demonstrate the mobile BI capabilities of Datazen and PowerBI using data around the recent NCAA March Madness.

SessionID: 24539

Unstructured Data in SQL Server

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 8

Speaker: Steve Jones

Title: Unstructured Data in SQL Server

Abstract:

A look at the Filestream and Filetable features in SQL Server that can allow you to handle unstructured data inside your SQL Server database.

SessionID: 24875

Integrate SQL Server with hadoop

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Pat Wright

Title: Integrate SQL Server with hadoop

Abstract:

Our company built a system mixing Big Data technologies (hadoop/ElasticSearch) along with SQL Server to make a system that is both highly scalable and cost effective. In this session I’ll walk you through the ETL process of pulling data through sqoop, transforming data in hive and presenting a denormalized table in hive. If you are looking to understand how to get data from SQL Server into hadoop and leveraging parallel architecture this is the session for you.

SessionID: 24882

Every Byte Counts: Why Your Datatype Choices Matter

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Andy Yun

Title: Every Byte Counts: Why Your Datatype 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: 24958

Forward the Federations

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 6

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

How do I create an automated ETL test suite ??

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 6

Speaker: Terry Bunio

Title: How do I create an automated ETL test suite ??

Abstract:

There are many automated test frameworks available for different types of applications, but Extract, Transform, and Load (ETL) data movement applications seem to lack an efficient and easy to use automated test suite.

We will review how the automated test suite is a data driven approach by showing how the tests self-generate based upon the data in the Information-Model schema in SQL Server and 4 slender custom tables that define the field data mapping between the source and target.

The last half of the session will be a demonstration of the tests to illustrate how they execute. To do this we will quickly review the stored procedure code that generates the tests.

SessionID: 26064

Upgrading and Migrating SQL Server with limited downtime

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 7

Speaker: Ted Krueger

Title: Upgrading and Migrating SQL Server with limited downtime

Abstract:

With SQL Server 2012 released and going strong, SQL Server 2014 coming quick, we’re all wanting the latest and greatest, high performing, SQL Engine sitting on our servers. How we do that is another question. How do you get a weekend of downtime? Do you like convincing the business you need it? 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 and 2014 with as little downtime as possible – minutes..seconds! 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: 26071

Keynote

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 8

Speaker: Ted Krueger

Title: Keynote

Abstract:

Keynote - Opening Remarks

SessionID: 27060

10 Ways To Abuse T-SQL

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Tracy McKibben

Title: 10 Ways To Abuse T-SQL

Abstract:

Learn 10 common T-SQL mistakes and how to avoid them. Procedural coding, misuse of user-defined functions, and non-SARGable filters are just some of the topics we'll cover.