sqlsathistory

Nr: 652

SQLSaturday #652 - Atlanta 2017

Start Time (24h)	Speaker	Track	Title
08:00:00	Teo Lachev	BI Platform Architecture, Dev, Delivery Admin	What's New for BI in SQL Server 2017
08:00:00	Brian Carrig	Cloud Application Development Deployment	Running SQL Server in AWS
08:00:00	Tim Mitchell	BI Platform Architecture, Dev, Delivery Admin	Deep Dive into the SSIS Catalog
08:00:00	Ed Watson	BI Platform Architecture, Dev, Delivery Admin	Introduction to SQL Server Integration Services
08:00:00	Doug McClurg	Application Database Development	Continuous Deployment with SSDT
08:00:00	Mike Robbins	Other	PowerShell 101: The No-Nonsense Beginner’s Guide to PowerShell
08:00:00	Kiran Math	Analytics Visualization	Extract, Transform And Load - Using R
08:00:00	Tracy Boggiano	Optimization Performance	Collecting Baseline Metrics
08:00:00	Lindsay Clark	Enterprise Database Administration Deployment	Is SQL Server 2016 My Perfect Match?
08:00:00	Patrick LeBlanc	Power BI	Power BI: Customers Stories from the Frontline
09:15:00	Patrick Keisler	Enterprise Database Administration Deployment	SQL Audit - Evidence Never Lies
09:15:00	Andy Leonard	BI Platform Architecture, Dev, Delivery Admin	Designing an SSIS Framework
09:15:00	Eric Peterson	Cloud Application Development Deployment	High Availability in the Cloud
09:15:00	Kate Grass	BI Platform Architecture, Dev, Delivery Admin	Let’s Get Meta: an Overview of ETL Frameworks using Biml
09:15:00	Jim Christopher	Analytics Visualization	Replacing Institutional Knowledge with Artificial Intelligence so I can Take a Damned Vacation
09:15:00	Eric Flamm	Enterprise Database Administration Deployment	Use Visual Studio Code to Access SQL Server from Windows (or Mac, or Linux, or ...)
09:15:00	Shabnam Watson	BI Platform Architecture, Dev, Delivery Admin	Performance Monitoring SQL Server Analysis Services (SSAS)
09:15:00	Bhakthi Liyanage	Analytics Visualization	Azure Machine Learning I : Machine Learning and Predictive Analytics with AML Studio
09:15:00	Robert Verell	Enterprise Database Administration Deployment	New Features in SQL Server 2017
09:15:00	Chris Hyde	Analytics Visualization	Python in SQL Server 2017
10:30:00	Naomi Williams	Enterprise Database Administration Deployment	SQL Server Internals
10:30:00	John Deardurff	Professional Development	How to get Microsoft Certified
10:30:00	Lance Tidwell	Optimization Performance	Introduction to Execution Plans
10:30:00	Louis Davidson	Application Database Development	Database Design Fundamentals
10:30:00	Luis Figueroa	Cloud Application Development Deployment	Enabling EDW and BI workloads on Hadoop with Hive / LLAP
10:30:00	Daniel Glenn	BI Platform Architecture, Dev, Delivery Admin	Power BI SharePoint - A Marriage Made in Redmond
10:30:00	Julie Smith	BI Platform Architecture, Dev, Delivery Admin	Heckin Sweet Reports with Power BI
10:30:00	Andrew Kelly	Optimization Performance	Query Store – What is it all about?
10:30:00	Stuart Ainsworth	Professional Development	The Future of the DBA: DevOps, the Cloud Paradigm, and the Microsoft Data Platform
10:30:00	Damu Venkatesan	BI Platform Architecture, Dev, Delivery Admin	Self-Service ETL with Microsoft Power Query
11:45:00	Rie Irish	Professional Development	Let Her Finish: Supporting Women's Voices from meetings to the board room
11:45:00	Cassius Rhue	Cloud Application Development Deployment	Secrets to Fast, Easy High Availability for SQL Server in AWS
11:45:00	Marsha Pierce	Enterprise Database Administration Deployment	How To Talk To Your Storage Admin
11:45:00	Steve Abraham	Cloud Application Development Deployment	Using SQL Server on Amazon Web Services - High Availability and R
11:45:00	Diane Schuster	BI Platform Architecture, Dev, Delivery Admin	Excel and SSIS: Better Together
11:45:00	Nathan Wood	Optimization Performance	Architecting for Performance
13:00:00	Amy Herold	Other	Making the Leap from Developer to DBA
13:00:00	Aaron Cutshall	Application Database Development	Introduction to Relational Database Design Patterns
13:00:00	Kevin Feasel	Analytics Visualization	Data Cleansing With SQL And R
13:00:00	Angela Henry	Power BI	What is Power BI?
13:00:00	Jonathan Stewart	BI Platform Architecture, Dev, Delivery Admin	Performance Tuning for the BI Professional
13:00:00	Elizabeth Noble	Application Database Development	Making Your List and Checking It Twice: Introduction to unit testing with tSQLt
13:00:00	Dan Mallott	Application Database Development	ORMs and the DBA: How to Make Both Happy
13:00:00	Kevin Wilkie	Professional Development	IT and the Evil Empire (Business) : Friends or Enemies?
13:00:00	Patrick LeBlanc	Cloud Application Development Deployment	Introduction to Azure Analysis Services
13:00:00	Jennifer McCown	Analytics Visualization	T-SQL's Hidden Support Feature
14:15:00	Kellyn Pot'Vin-Gorman	Enterprise Database Administration Deployment	Introducing the Limitless DBA- Copy Data Management, DBA Style
14:15:00	Matt Gordon	Enterprise Database Administration Deployment	New Features and New Speed in SQL Server 2016 (and 2017!) Always On Availability Groups
14:15:00	Christopher Sims	Application Database Development	I like big data for $400 - Exploring quiz show questions using Angular, DocumentDB and Azure Search
14:15:00	Ulysses B Brown Jr	Analytics Visualization	So you have installed Microsoft R Services (In-database) ... Now what "R" you going to do?
14:15:00	Thomas Norman	Application Database Development	Database Project Makes Deployment Consistent
14:15:00	William Wolf	Application Database Development	Blue Collar SQL Tricks - Make Standard Edition Work for you.
14:15:00	Karlyn LeBlanc	Professional Development	Taking Time for You
14:15:00	Robert Cain	Cloud Application Development Deployment	Powering Azure from PowerShell
14:15:00	Katherine Fraser	BI Platform Architecture, Dev, Delivery Admin	Plots and Data Points: Pulling R Charts together in a Power BI Da
14:15:00	Adam Saxton	Power BI	What's New with Power BI
15:30:00	Chris Hyde	Analytics Visualization	SQL Server R Services in SQL 2016
15:30:00	Ryan Wade	Analytics Visualization	Leveraging SQL Server R Services to Perform Advanced Analytics
15:30:00	Jim Wooley	Application Database Development	Getting started with Entity Framework Core
15:30:00	Samir Behara	Application Database Development	Making developers lives easier with SQL Server 2016
15:30:00	Matt Martin	Optimization Performance	Optimization, Optimization – Make Your Queries Faster
15:30:00	Sven Aelterman	Cloud Application Development Deployment	Azure SQL Database: 12 Things To Know
15:30:00	David Klee	Enterprise Database Administration Deployment	Linux for the SQL Server Administrator
15:30:00	Simon Kingaby	BI Platform Architecture, Dev, Delivery Admin	How to Move a Ton of Data from the Mainframe to the Cloud (with B
15:30:00	Todd Kleinhans	Enterprise Database Administration Deployment	VLDB Tips and Migration Tactics
15:30:00	Mike Lawell	Enterprise Database Administration Deployment	Execution Plans for Mere Mortals
15:30:00	Glen Gordon	Professional Development	Agile isn't the A in DBA, but you still should know it

SessionID: 63677

What's New for BI in SQL Server 2017

Back to calendar

Event Date: 15-07-2017 - Session time: 08:00:00 - Track: BI Platform Architecture, Dev, Delivery Admin

Speaker: Teo Lachev

Title: What's New for BI in SQL Server 2017

Abstract:

Just when you are done upgrading to version 2016, SQL Server 2017 is here! SQL Server 2017 delivers important data analytics features and enhancements. Join this session to discover what's new for BI in SSRS, SSAS, and SSIS, and to see these features in action.

SessionID: 63705

Running SQL Server in AWS

Back to calendar

Event Date: 15-07-2017 - Session time: 08:00:00 - Track: Cloud Application Development Deployment

Speaker: Brian Carrig

Title: Running SQL Server in AWS

Abstract:

Amazon Web Services (AWS) is the world's largest public cloud hosting provider with many companies successfully running SQL server on AWS infrastructure. In this session, we explore the options available to you for running SQL server in AWS, either as an RDS managed service or using dedicated EC2 instances. We document the different storage options, HA strategies, security and maintenance caveats to be aware of. We will also detail various approaches to licensing you can take when running SQL server in AWS.

SessionID: 63937

Deep Dive into the SSIS Catalog

Back to calendar

Event Date: 15-07-2017 - Session time: 08:00:00 - Track: BI Platform Architecture, Dev, Delivery Admin

Speaker: Tim Mitchell

Title: Deep Dive into the SSIS Catalog

Abstract:

The SSIS catalog is one of the best-evolved features in the SQL Server Integration Services ecosystem. With integrated package storage, Windows ACL-like security settings, built-in logging, and many other features, the SSIS catalog has become an anchor for many ETL architectures. With all this complexity, it is important to understand the inner workings of the SSIS catalog to keep it running smoothly.

In this demo-heavy presentation, we will dive into the details of the SSIS catalog. We will start with a quick survey of catalog features, followed by an exploration of the moving parts (tables, views, and stored procedures) in the catalog database. We will also review the security capabilities in the catalog, and will discuss maintenance operations. Finally, we'll walk through the mechanics of deployment and execution, reviewing what happens under the covers during these operations.

SessionID: 64363

Introduction to SQL Server Integration Services

Back to calendar

Event Date: 15-07-2017 - Session time: 08:00:00 - Track: BI Platform Architecture, Dev, Delivery Admin

Speaker: Ed Watson

Title: Introduction to SQL Server Integration Services

Abstract:

Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters. This is an introductory course for beginners or users without any SSIS experience. Come learn how to SSIS with me!

SessionID: 64672

Continuous Deployment with SSDT

Back to calendar

Event Date: 15-07-2017 - Session time: 08:00:00 - Track: Application Database Development

Speaker: Doug McClurg

Title: Continuous Deployment with SSDT

Abstract:

DevOps lives at the fast paced intersection of developers and IT professionals. Our business partners are learning, expanding their toolkit, and putting more pressure on BI teams to deliver analytics at an accelerated operational cadence. I'm here to show you how to automate your production database code delivery even in large data warehouse environments.

SessionID: 64725

PowerShell 101: The No-Nonsense Beginner’s Guide to PowerShell

Back to calendar

Event Date: 15-07-2017 - Session time: 08:00:00 - Track: Other

Speaker: Mike Robbins

Title: PowerShell 101: The No-Nonsense Beginner’s Guide to PowerShell

Abstract:

Interested in PowerShell but not sure how to get started? Already have some experience but still having trouble with the basic concepts? This session is for you! Learn to easily figure out what the commands are and how to use those commands without searching the Internet. Extend PowerShell’s functionality to manage products like SQL Server. During this presentation, Microsoft MVP Mike F Robbins will demonstrate several of the core PowerShell cmdlets along with writing one-liners and basics scripts. We’ll discuss how to prevent resume generating events when making changes with PowerShell. Learn what objects, properties, and methods are along with how they’re used in PowerShell. Not a developer? PowerShell is one of those technologies that you can be extremely effective with whether you’re a developer or an IT Pro.

SessionID: 64901

Extract, Transform And Load - Using R

Back to calendar

Event Date: 15-07-2017 - Session time: 08:00:00 - Track: Analytics Visualization

Speaker: Kiran Math

Title: Extract, Transform And Load - Using R

Abstract:

In this session we will Learn R through an Example. We will Extracting Data from Multiple Excel sheets, transforming the data, Visualizing the data and Loading it into SQL Server Table.

SessionID: 65363

Collecting Baseline Metrics

Back to calendar

Event Date: 15-07-2017 - Session time: 08:00:00 - Track: Optimization Performance

Speaker: Tracy Boggiano

Title: Collecting Baseline Metrics

Abstract:

How do you know when your server is on fire? Without a set known-good measurements to compare against to look at you don’t. This session will show you how to capture a performance baseline for a SQL Server instance. The session will help you decide what and when to capture data and where to store it. Then we will walk through different tools and scripts to use. Then walk you through a scenario of using that data to identify a problem.

SessionID: 65442

Is SQL Server 2016 My Perfect Match?

Back to calendar

Event Date: 15-07-2017 - Session time: 08:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Lindsay Clark

Title: Is SQL Server 2016 My Perfect Match?

Abstract:

With a few still supported versions of SQL server to choose from how do you know SQL Server 2016 is the right fit? Let's take it for a quick spin and see how we like it. This will be an introductory view of new features from 10,000 feet. Walk away with some features to look into so you can decide if a next date is right for you and SQL Server 2016.

SessionID: 67753

Power BI: Customers Stories from the Frontline

Back to calendar

Event Date: 15-07-2017 - Session time: 08:00:00 - Track: Power BI

Speaker: Patrick LeBlanc

Title: Power BI: Customers Stories from the Frontline

Abstract:

As the popularity of Power BI continues to grow, so does the number of emails and customer calls about issues that they face. Some are easy to solve, and some require a level of research and testing to solve. Join us in this session to learn from some of the top customer issues and trends that we have faced. Explore the problem, and then dive into how we fixed it!

SessionID: 63660

SQL Audit - Evidence Never Lies

Back to calendar

Event Date: 15-07-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Patrick Keisler

Title: SQL Audit - Evidence Never Lies

Abstract:

We've all heard about massive data breaches from big name companies. As a DBA, you should consider your company's data to be the most valuable assets. So when a data breach happens at your company, will you be able to provide management with the information? If not, then discover how SQL Server Audit can help provide you with an accurate forensic analysis of who did what to your data. In this session, we'll cover what SQL Audit can capture, how to set it up for both on-premise SQL Servers and Azure SQL Database, and finally produce reports from it.

SessionID: 63735

Designing an SSIS Framework

Back to calendar

Event Date: 15-07-2017 - Session time: 09:15:00 - Track: BI Platform Architecture, Dev, Delivery Admin

Speaker: Andy Leonard

Title: Designing an SSIS Framework

Abstract:

Enterprise data integration changed with the introduction of the SSIS Catalog. Implementing enterprise data integration often requires functionality beyond the rich features provided by the SSIS Catalog. Building on his previous work in the field of Data Integration Life Cycle Management (DILM) and SSIS Frameworks development, a Data Integration Architect with 10 years of SSIS experience explains the what, why, and how of an SSIS Catalog-integrated Framework that delivers metadata-driven package execution, connections management, and parameter configuration.

In this session, you will learn:

A method for migrating packages from Development, through the data integration life cycle, to Production without editing SSIS Connection Manager Properties.
A metadata-driven approach to SSIS package execution.
A method for customizing enterprise data integration reporting.

SessionID: 64132

High Availability in the Cloud

Back to calendar

Event Date: 15-07-2017 - Session time: 09:15:00 - Track: Cloud Application Development Deployment

Speaker: Eric Peterson

Title: High Availability in the Cloud

Abstract:

This session will cover techniques and lessons learned in moving a 24X7 system to the cloud, and the changes needed to provide a Highly Available multi-regional cloud based environment.

This session covers all the things that were needed to spin up and get into production including:

Definitions
Environmental setup
Installation
SAN setup
Backups
Clustering
Cold\warm\Hot Standby
Regional Fail-over
Multi regional fail-over
Multi Cloud Fail-over

SessionID: 64502

Let’s Get Meta: an Overview of ETL Frameworks using Biml

Back to calendar

Event Date: 15-07-2017 - Session time: 09:15:00 - Track: BI Platform Architecture, Dev, Delivery Admin

Speaker: Kate Grass

Title: Let’s Get Meta: an Overview of ETL Frameworks using Biml

Abstract:

Do you have SSIS projects that have grown unwieldy, become difficult to troubleshoot or suffer from performance issues? Or maybe you’re getting ready to start a new ETL project and want to learn more about how you can gain efficiency while adding value to your solution?

In this session we’ll discuss the concept of an ETL framework and the potential elements that can be incorporated within one. We will look at the advantages of implementing a framework based on metadata and look at some database design options for storing that metadata.

To start you off on your framework building journey, we’ll introduce Biml and BimlScript and provide some simple code demos to showcase how Biml can be used to help automate your SSIS package generation. This session will be geared for those with a beginner to intermediate knowledge of SSIS and SQL. While we won’t be teaching Biml in great detail, you’ll get an overview of the technology and pointers on where to learn more.

SessionID: 64655

Replacing Institutional Knowledge with Artificial Intelligence so I can Take a Damned Vacation

Back to calendar

Event Date: 15-07-2017 - Session time: 09:15:00 - Track: Analytics Visualization

Speaker: Jim Christopher

Title: Replacing Institutional Knowledge with Artificial Intelligence so I can Take a Damned Vacation

Abstract:

A lot of my job involves leveraging knowledge that only I possess. Anecdotal stuff and volatile-state-of-the-data stuff that gets updated several times a day and is almost entirely in my own head. Taking vacations kind of sucks because that institutional knowledge travels with me, and no one is able to pick up my slack. All of my peers in the organization are in the same predicament.

Recently though, we've been capturing this institutional knowledge in small artificial intelligences. These systems act in an advisory capacity, routinely automating many of the research and state checks that we need to do our jobs. These systems make us more productive, more collaborative, and enable some luxurious time away from the desk.

In this session, you'll learn how we identified the candidates for "micro-AIs," how easy these systems were to implement using freely available tools, and gain some of our hard-won insight into balancing automated AI and human decision-making.

SessionID: 64685

Use Visual Studio Code to Access SQL Server from Windows (or Mac, or Linux, or ...)

Back to calendar

Event Date: 15-07-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Flamm

Title: Use Visual Studio Code to Access SQL Server from Windows (or Mac, or Linux, or ...)

Abstract:

"Visual Studio Code combines the simplicity of a source code editor with powerful developer tooling, like IntelliSense code completion and debugging.

First and foremost, it is an editor that gets out of your way. The delightfully frictionless edit-build-debug cycle means less time fiddling with your environment, and more time executing on your ideas."

Need a quick peek at your SQL Server database but don't want to wait for SSMS to start up? Need to run T-SQL queries from a 32-bit Windows 7 box? Working on a MacBook and don't want to switch to Windows just to run a quick SQL script? Time to try Visual Studio Code. VS Code is a free, open source code editor and IDE from Microsoft built on the Electron project which runs on most popular desktop and mobile systems and starts and executes FAST! Even better, it's extensible - using the MSSQL extension gives users access to stored connection strings, T-SQL for DDL and CRUD queries, and more. This session will demo install and use cases.

SessionID: 64979

Performance Monitoring SQL Server Analysis Services (SSAS)

Back to calendar

Event Date: 15-07-2017 - Session time: 09:15:00 - Track: BI Platform Architecture, Dev, Delivery Admin

Speaker: Shabnam Watson

Title: Performance Monitoring SQL Server Analysis Services (SSAS)

Abstract:

SSAS Servers need maintenance and monitoring post deployment to production; however, when projects forgo this part the overall system performance can suffer. Just like every SQL Server requires a DBA to maintain it, every SSAS server needs a SSAS administrator.

This session introduces you to SSAS administration beyond the initial development of a database. You will learn what to measure and how to determine acceptable ranges of those measurements for your environment. Demos will be used to show you how to use Task Manager, Perfmon and SQL Server Extended Events to get insights into a SSAS server’s health, identify the most common issues with a server in production, and make recommendations for changes to SSAS developers on your team. If you have experience with SSAS development and are interested in learning about SSAS from the sever side, this session is for you. The focus of this session will be on SSAS multidimensional; however, many of the concepts apply to SSAS Tabular as well.

SessionID: 64984

Azure Machine Learning I : Machine Learning and Predictive Analytics with AML Studio

Back to calendar

Event Date: 15-07-2017 - Session time: 09:15:00 - Track: Analytics Visualization

Speaker: Bhakthi Liyanage

Title: Azure Machine Learning I : Machine Learning and Predictive Analytics with AML Studio

Abstract:

SessionID: 65406

New Features in SQL Server 2017

Back to calendar

Event Date: 15-07-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Robert Verell

Title: New Features in SQL Server 2017

Abstract:

Microsoft has moved to 18 month releases for new versions of SQL Server. With that, we're getting new features sooner! In this session, Robert Verell and Dan Evans will cover the new features of 2017, including Graph Database, Adaptive Query Processing, and the Azure Migration Assistant.

SessionID: 65543

Python in SQL Server 2017

Back to calendar

Event Date: 15-07-2017 - Session time: 09:15:00 - Track: Analytics Visualization

Speaker: Chris Hyde

Title: Python in SQL Server 2017

Abstract:

SQL Server 2017 is right around the corner, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!

In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!

SessionID: 63657

SQL Server Internals

Back to calendar

Event Date: 15-07-2017 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Naomi Williams

Title: SQL Server Internals

Abstract:

How does SQL do what it does? Take a look under the hood at how the SQL database engine works with the storage engine. What causes those waits and where do we look to resolve them!

SessionID: 63694

How to get Microsoft Certified

Back to calendar

Event Date: 15-07-2017 - Session time: 10:30:00 - Track: Professional Development

Speaker: John Deardurff

Title: How to get Microsoft Certified

Abstract:

Microsoft has recently streamlined the certification process and this session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for success.

SessionID: 63892

Introduction to Execution Plans

Back to calendar

Event Date: 15-07-2017 - Session time: 10:30:00 - Track: Optimization Performance

Speaker: Lance Tidwell

Title: Introduction to Execution Plans

Abstract:

In this session we will take a look at the basics of execution plans. We will discuss what they are, how they are made, and how they are used. We will explore some of the common operators seen in execution plans and their functions. Next we will look at the differences between estimated and actual execution plans. Throughout, you will be getting insight on how to read execution plans to help tune your queries.

SessionID: 63948

Database Design Fundamentals

Back to calendar

Event Date: 15-07-2017 - Session time: 10:30:00 - Track: Application Database Development

Speaker: Louis Davidson

Title: Database Design Fundamentals

Abstract:

Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.

SessionID: 64177

Enabling EDW and BI workloads on Hadoop with Hive / LLAP

Back to calendar

Event Date: 15-07-2017 - Session time: 10:30:00 - Track: Cloud Application Development Deployment

Speaker: Luis Figueroa

Title: Enabling EDW and BI workloads on Hadoop with Hive / LLAP

Abstract:

In its origin, Hadoop was created as a distributed computing system designed to process data in batches, but the many advantages of the platform lead to an immediate desire to run interactive analytical queries against Data Lakes built on Hadoop. So a few years back the Stinger initiative was created as an ongoing effort to bring interactive SQL querying capabilities to Hive, and its latest release has finally delivered!

In this session, Luis Figueroa (Solutions Engineer @ Hortonworks) will walk you through the latest advancements that make Hadoop a powerful SQL engine that expands you EDW capabilities with unlimited scale and amazing flexibility. Luis will provide a technical overview of the Hive engine, an update on SQL compatibility with the ANSI standard, real world use cases and a live demo. If you are a data pro this session is for you!

SessionID: 64307

Power BI SharePoint - A Marriage Made in Redmond

Back to calendar

Event Date: 15-07-2017 - Session time: 10:30:00 - Track: BI Platform Architecture, Dev, Delivery Admin

Speaker: Daniel Glenn

Title: Power BI SharePoint - A Marriage Made in Redmond

Abstract:

We will explore the relationship between SharePoint and Excel, how Power BI swooped SharePoint off her feet, and the current Business Intelligence soap opera that stars all three. Using live demos, we will look at data interaction between SharePoint, Excel, Power BI (including the iOS app), and the intriguing new next door neighbor - Microsoft Flow.

SessionID: 64579

Heckin Sweet Reports with Power BI

Back to calendar

Event Date: 15-07-2017 - Session time: 10:30:00 - Track: BI Platform Architecture, Dev, Delivery Admin

Speaker: Julie Smith

Title: Heckin Sweet Reports with Power BI

Abstract:

Power BI is constantly evolving; this session is an overview of the current abilities and ways to implement Power BI, based on our experience in the field using it. Topics include the Power BI Service, Power BI Desktop, Pricing models, and intro to SSRS 2016 Preview with Power BI. Sample data set used in this presentation is from @DogRates

SessionID: 64645

Query Store – What is it all about?

Back to calendar

Event Date: 15-07-2017 - Session time: 10:30:00 - Track: Optimization Performance

Speaker: Andrew Kelly

Title: Query Store – What is it all about?

Abstract:

SQL 2016 brings us many new features but one of the most anticipated is surely the Query Store. The Query Store now allows us to track query plans as they change over time giving us a whole slew of new possibilities when it comes to tuning our queries. Even just the ability to compare a previous plan to a new plan is a huge step towards understanding what may be happening in our instance. We can even tell the optimizer which plan we want it to use. These were all either extremely difficult to do before and in some cases impossible to do. This session will give you the insight to get started using this new and wonderful feature set.

SessionID: 64680

The Future of the DBA: DevOps, the Cloud Paradigm, and the Microsoft Data Platform

Back to calendar

Event Date: 15-07-2017 - Session time: 10:30:00 - Track: Professional Development

Speaker: Stuart Ainsworth

Title: The Future of the DBA: DevOps, the Cloud Paradigm, and the Microsoft Data Platform

Abstract:

We’re on the cusp of exciting times for database development and administration; data storage is set to explode in volume over the next 5 years by as much as 500%. Companies are struggling to manage traditional relational databases and several forms of Big Data, including dark, binary, and streaming data. New theories of development, administration, and data management have matured, but what impact do they have on DBA’s? What are the concepts and skills needed for future career growth?

Come explore how DevOps and the Cloud Paradigm have developed to address modern software delivery challenges. We’ll also examine how the Microsoft Data Platform provides a framework for career paths for SQL Server professionals.

SessionID: 65394

Self-Service ETL with Microsoft Power Query

Back to calendar

Event Date: 15-07-2017 - Session time: 10:30:00 - Track: BI Platform Architecture, Dev, Delivery Admin

Speaker: Damu Venkatesan

Title: Self-Service ETL with Microsoft Power Query

Abstract:

In this session, I will introduce you to Microsoft's new self-service ETL tool "Power Query" for Excel PowerBI. I will show you, how to source data from various data sources, how you can massage the data and consume the data for your use in the data pipeline. I will introduce you to "M" language that is used in Power Query. I will show you how you can discover and mash data from public data sources within Power Query. If you would like to do ETL quickly without writing SSIS packages, Power Query is the way go. Come and attend this session to learn "Power Query".

SessionID: 64390

Let Her Finish: Supporting Women's Voices from meetings to the board room

Back to calendar

Event Date: 15-07-2017 - Session time: 11:45:00 - Track: Professional Development

Speaker: Rie Irish

Title: Let Her Finish: Supporting Women's Voices from meetings to the board room

Abstract:

Next time you attend a meeting, watch what happens when women at the table offer ideas. If your office is like most in America, you’ll notice women are interrupted almost three times as often as men. Some interruptions are to assert dominance but sometimes people do it to be helpful offer affirmation. Regardless of the intent, the results are the same. Women are being left out of the conversation. The consequences are real. Male executives that speak more frequently in meetings are rewarded with 10% higher competence ratings from peers better performance reviews from bosses. Women are penalized. This translates into $ when raises and bonuses are handed out.

This discussion will cover positive solutions that help women’s voices be heard. Women need to be more assertive. We need to learn to say “Stop interrupting me.” and “I just said that.” However, men can be, no HAVE to be, part of the solution. They can help women become part of the conversation.

SessionID: 67247

Secrets to Fast, Easy High Availability for SQL Server in AWS

Back to calendar

Event Date: 15-07-2017 - Session time: 11:45:00 - Track: Cloud Application Development Deployment

Speaker: Cassius Rhue

Title: Secrets to Fast, Easy High Availability for SQL Server in AWS

Abstract:

Providing high availability for SQL Server in the cloud doesn’t have to be complicated or expensive. Join the lunch session with high availability experts Cassius Rhue and Heath Carroll, to learn what you need to know about deploying SQL Server on AWS and building high availability solutions for SQL Server in the cloud. Learn how to deploy a high availability SQL Server cluster in AWS EC2 without costly upgrades or complex configuration and learn key secrets that can help you save time and money in your migration of SQL Server to the cloud.

SessionID: 67248

How To Talk To Your Storage Admin

Back to calendar

Event Date: 15-07-2017 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Marsha Pierce

Title: How To Talk To Your Storage Admin

Abstract:

A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.

SessionID: 67295

Using SQL Server on Amazon Web Services - High Availability and R

Back to calendar

Event Date: 15-07-2017 - Session time: 11:45:00 - Track: Cloud Application Development Deployment

Speaker: Steve Abraham

Title: Using SQL Server on Amazon Web Services - High Availability and R

Abstract:

Amazon Web Services offers the ability to run SQL Server as part of its relational database service for managed databases, as well as hosting Windows/SQL Server installations via EC2. This session will compare/contrast these two options, and specifically address how to implement High Availability and Disaster Recovery options with both types of implementations.

SessionID: 67450

Excel and SSIS: Better Together

Back to calendar

Event Date: 15-07-2017 - Session time: 11:45:00 - Track: BI Platform Architecture, Dev, Delivery Admin

Speaker: Diane Schuster

Title: Excel and SSIS: Better Together

Abstract:

If you’ve ever used the standard Excel Source or Destination components in SSIS, you know there are some limitations. Cozyroc’s Excel Source Plus and Excel Destination Plus components remove those limitations. In addition, Cozyroc’s Excel Task enables editing of Excel files from SSIS packages. In this session, I’ll talk about the capabilities of the Cozyroc components and demonstrate how easy it is use use these components with SSIS.

SessionID: 67634

Architecting for Performance

Back to calendar

Event Date: 15-07-2017 - Session time: 11:45:00 - Track: Optimization Performance

Speaker: Nathan Wood

Title: Architecting for Performance

Abstract:

Successful reporting and transactional systems start with proper architectural principles and considerations. Learn how to design new database systems for optimal performance and how to discover, document and prove when performance issues are caused by the system configuration.

SessionID: 63646

Making the Leap from Developer to DBA

Back to calendar

Event Date: 15-07-2017 - Session time: 13:00:00 - Track: Other

Speaker: Amy Herold

Title: Making the Leap from Developer to DBA

Abstract:

You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.

SessionID: 63746

Introduction to Relational Database Design Patterns

Back to calendar

Event Date: 15-07-2017 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Aaron Cutshall

Title: Introduction to Relational Database Design Patterns

Abstract:

The use of design patterns has been quite popular in object-oriented development to help identify best practices for various situations. Unfortunately, this practice has not really reached the world of relational database architecture where they are just as applicable. In this session, we'll discuss some techniques and best practices that help make database design more effective and efficient not only in operation but also in design and administration. With the use of some example scenarios, you'll walk away with a better understanding of design patterns that you can apply right away!

SessionID: 63773

Data Cleansing With SQL And R

Back to calendar

Event Date: 15-07-2017 - Session time: 13:00:00 - Track: Analytics Visualization

Speaker: Kevin Feasel

Title: Data Cleansing With SQL And R

Abstract:

On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.

SessionID: 64175

What is Power BI?

Back to calendar

Event Date: 15-07-2017 - Session time: 13:00:00 - Track: Power BI

Speaker: Angela Henry

Title: What is Power BI?

Abstract:

You’ve heard all the buzz about Power BI, but you have no idea what it is and how it works. This session explains what Power BI is, who can use it and why you would want to. It’s an introductory session that gives you the information you need to determine if Power BI is right for you and your organization.

SessionID: 64254

Performance Tuning for the BI Professional

Back to calendar

Event Date: 15-07-2017 - Session time: 13:00:00 - Track: BI Platform Architecture, Dev, Delivery Admin

Speaker: Jonathan Stewart

Title: Performance Tuning for the BI Professional

Abstract:

Being a BI Professional, you need all the performance tuning the DB folks get and more. In this hour, we will go over important performance tuning tips that you can use to help make your deliverables faster and more effective. We will touch on the MSBI tools of SSIS, SSAS, SSRS and PowerBI as well as some core engine stuff.

SessionID: 64501

Making Your List and Checking It Twice: Introduction to unit testing with tSQLt

Back to calendar

Event Date: 15-07-2017 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Elizabeth Noble

Title: Making Your List and Checking It Twice: Introduction to unit testing with tSQLt

Abstract:

Unit testing allows database code to be consistently tested during the development process, but it can be challenging to get unit testing setup for database development. This session will give an overview on the purpose of unit testing, the installation of the tSQLt framework, and the design of unit tests. I will use general concepts of test driven design to create and run unit tests to confirm that objects exist and to test single and multiple test cases. Learn how to implement unit testing in a development environment and create and run your own units tests.

SessionID: 64574

ORMs and the DBA: How to Make Both Happy

Back to calendar

Event Date: 15-07-2017 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Dan Mallott

Title: ORMs and the DBA: How to Make Both Happy

Abstract:

Talk to any DBA about ORMs and you'll quickly find out all the things you like about ORMs are what DBAs don't like. Interestingly enough, most developers I've talked to have issues with their ORMs, too. In this session, we'll explore why ORMs cause such trouble, some strategies for mitigating those troubles, and I'll introduce some tools (and even yet another ORM) that help solve some of the worst of the problems we see in the database when using ORMs.

SessionID: 64932

IT and the Evil Empire (Business) : Friends or Enemies?

Back to calendar

Event Date: 15-07-2017 - Session time: 13:00:00 - Track: Professional Development

Speaker: Kevin Wilkie

Title: IT and the Evil Empire (Business) : Friends or Enemies?

Abstract:

Tensions between the business and IT can be high. The business sees IT as alien and IT sees the business as cavemen. The difference between a great IT professional and a mediocre one is that a great one can work well with the business. This session will give you 6 practical ways you can implement immediately to make a bigger, better impact on the business.

SessionID: 65376

Introduction to Azure Analysis Services

Back to calendar

Event Date: 15-07-2017 - Session time: 13:00:00 - Track: Cloud Application Development Deployment

Speaker: Patrick LeBlanc

Title: Introduction to Azure Analysis Services

Abstract:

You have been wanting to using SQL Server Analysis Services, but just don't have the physical resources on-premises to set one up. Analysis Services has typically shipped with SQL Server on premises, but now it has been implemented as a fully managed service in Azure. Join this session to learn how to create a and deploy a model, load and refresh data using Azure functions, secure the model, view the model and a little about pricing.

SessionID: 67037

T-SQL's Hidden Support Feature

Back to calendar

Event Date: 15-07-2017 - Session time: 13:00:00 - Track: Analytics Visualization

Speaker: Jennifer McCown

Title: T-SQL's Hidden Support Feature

Abstract:

The most effective T-SQL support feature comes installed with every edition of SQL Server, is enabled by default, and costs no overhead. Yet, the vast majority of database administrator underutilize or completely neglect it. That feature's name is "comments".

In this session, Microsoft Certified Master Jennifer McCown will demonstrate the various commenting methods that make code supportable. Attendees will learn what’s important in a header comment, use code blocking to edit code, build a comprehensive help system, and explore alternative comment methods in stored procedures, SSIS packages, SSRS reports, and beyond. These methods help prevent errors and reduce troubleshooting.

SessionID: 63648

Introducing the Limitless DBA- Copy Data Management, DBA Style

Back to calendar

Event Date: 15-07-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Kellyn Pot'Vin-Gorman

Title: Introducing the Limitless DBA- Copy Data Management, DBA Style

Abstract:

Everything in our day to day lives as a DBA is about limits-

• Limits in space • Limits in platform • Limits in resources • Limits in expertise

This session is about how to remove those limits. How to provide all the databases you need without having to constantly ask for more disk space. How to provide a databases as fast as they are needed for new projects, new test cases and new challenges. How to do more with less time, less people and less hardware and last but not least, how to do all of this without having to become an expert in 20 different languages, products and specialties.

Join Kellyn Pot’Vin-Gorman as she demonstrates why virtualization is key to empowering the database administrator. This session will cover how to: • Ease patching and upgrading. • Offer virtualized environments for every project- development through production with only a 1/3 or the resources once required. • How to change OS and database platforms without losing your mind.

SessionID: 63650

New Features and New Speed in SQL Server 2016 (and 2017!) Always On Availability Groups

Back to calendar

Event Date: 15-07-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Gordon

Title: New Features and New Speed in SQL Server 2016 (and 2017!) Always On Availability Groups

Abstract:

Microsoft has added new performance improvements and new features to SQL Server 2016 and 2017’s implementation of Always On Availability Groups. This session will cover improvements that range from Standard Edition support for AGs to load balanced replicas to new ways to create those replicas. We’ll kick the tires on the improved Azure support and discuss the massive performance improvements in Always On as well.

SessionID: 63653

I like big data for $400 - Exploring quiz show questions using Angular, DocumentDB and Azure Search

Back to calendar

Event Date: 15-07-2017 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Christopher Sims

Title: I like big data for $400 - Exploring quiz show questions using Angular, DocumentDB and Azure Search

Abstract:

In this talk, we will explore two powerful technologies from the Microsoft Azure Stack: DocumentDB and Azure Search. DocumentDB is Microsoft's NoSQL service for building globally scalable schema-free applications. Azure Search allows you to integrate the power of Microsoft's search and natural language processing abilities to explore your complex data stores. During this talk we will cover the benefits of implementing a schema-free database, we will learn how to replicate your data at a global scale with the ease of a simple configuration and we will cover various techniques of querying that data using SQL and the DocumentDB API. Once we have a large datastore in place (we will use 200k+ Jeopardy questions), we will apply the powerful natural language querying capabilities and faceted search features of Azure Search to quickly create an searchable data repository. All of this will be built and exposed using a cross-platform application built in Angular on the Electron framework.

SessionID: 63658

So you have installed Microsoft R Services (In-database) ... Now what "R" you going to do?

Back to calendar

Event Date: 15-07-2017 - Session time: 14:15:00 - Track: Analytics Visualization

Speaker: Ulysses B Brown Jr

Title: So you have installed Microsoft R Services (In-database) ... Now what "R" you going to do?

Abstract:

The TSQL Developer/DBA un-official entry into "R" Coding/Analytics (via TSQL) using RTVS (R Tools for Visual Studio) and SSMS with primary focus and demos around implementing using SQL Server R Services ... (In Database) - (i.e., SQL Server Launchpad (MSSQLSERVER) service)

The goal of this session is for attendees to learn / walk away with: 1 A practical understanding of how to install a full working implementation of all Microsoft R components necessary to perform T-SQL "R" coding 2 Heightened interest in adding some R language syntax and R packages to their knowledge base repository 3 An explanation to help sort through some of the confusing things in "R" life .. so many "R" packages - "R" versions - "R" compilers - WTF ... "R" you confused ? 4 Better understanding of syntax and results ... real-world demo time 5 How TSQL Developers SQL DBAs can go from Newbie >> to >> Talented in a short time (with effort) ... Useful links to available resources

SessionID: 63670

Database Project Makes Deployment Consistent

Back to calendar

Event Date: 15-07-2017 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Thomas Norman

Title: Database Project Makes Deployment Consistent

Abstract:

SessionID: 64220

Blue Collar SQL Tricks - Make Standard Edition Work for you.

Back to calendar

Event Date: 15-07-2017 - Session time: 14:15:00 - Track: Application Database Development

Speaker: William Wolf

Title: Blue Collar SQL Tricks - Make Standard Edition Work for you.

Abstract:

You want Enterprise Edition of SQL Server? Not gonna happen! When we are limited by having just the Standard version we have to dig into our “Blue Collar” roots, we need to become more creative and squeeze every penny it has to offer out of it.

In this session, we will review some of the limitations that Standard has. Then review items such as basic normalization and High Availability options available to Standard. You will also learn Blue Collar techniques to implement partitioning using techniques like as indexed views and partitioned views.

Let’s dig in and learn to make use of all we have until we beg our bosses enough to get Enterprise Edition!

SessionID: 64318

Taking Time for You

Back to calendar

Event Date: 15-07-2017 - Session time: 14:15:00 - Track: Professional Development

Speaker: Karlyn LeBlanc

Title: Taking Time for You

Abstract:

As a working professional, one spends an enormous amount of time creating, maintaining and updating your work skills. The rat race of everyday life, work, work and more work have many people "caught up". The focus becomes, all too often how fast can I move up the corporate ladder? I need to make more money. How can I create a better brand? On top of all of that, one has to make sure to spend time with their family. So, when is there time for YOU? Join me in an interactive session where I will provide various tools and techniques to assist you with improving your quality of life. Ultimately helping you to create a better you.

SessionID: 64459

Powering Azure from PowerShell

Back to calendar

Event Date: 15-07-2017 - Session time: 14:15:00 - Track: Cloud Application Development Deployment

Speaker: Robert Cain

Title: Powering Azure from PowerShell

Abstract:

Azure is seeing phenominal growth. More and more companies, from large enterprises to small start ups, are taking advantage of Azure to host their IT operations. As an IT Pro, you will be asked to manage all these services. While the Azure Portal is a nice user interface, we all know it simply won't scale in the face of the high demands placed on IT Pros. The solution is obvious: PowerShell!

In this session you'll be introduced to the PowerShell cmdlets for managing your Azure infrastructure. You'll see how to manage your Azure storage, create virtual machines, and even work with SQL Azure. By the end of this session you'll understand how to use PowerShell to manage the most common Azure tasks.

SessionID: 64844

Plots and Data Points: Pulling R Charts together in a Power BI Da

Back to calendar

Event Date: 15-07-2017 - Session time: 14:15:00 - Track: BI Platform Architecture, Dev, Delivery Admin

Speaker: Katherine Fraser

Title: Plots and Data Points: Pulling R Charts together in a Power BI Da

Abstract:

SessionID: 65541

What's New with Power BI

Back to calendar

Event Date: 15-07-2017 - Session time: 14:15:00 - Track: Power BI

Speaker: Adam Saxton

Title: What's New with Power BI

Abstract:

A lot of changes have come to Power BI. Do you understand how Premium fits in? What is an app workspace and why would you use it? And, what the heck is a capacity? We will take a look at Premium, Apps and App Workspaces along with the changes to embedding. We will also see how Power BI Report Server fits into the picture.

SessionID: 63642

SQL Server R Services in SQL 2016

Back to calendar

Event Date: 15-07-2017 - Session time: 15:30:00 - Track: Analytics Visualization

Speaker: Chris Hyde

Title: SQL Server R Services in SQL 2016

Abstract:

One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We'll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!

SessionID: 63662

Leveraging SQL Server R Services to Perform Advanced Analytics

Back to calendar

Event Date: 15-07-2017 - Session time: 15:30:00 - Track: Analytics Visualization

Speaker: Ryan Wade

Title: Leveraging SQL Server R Services to Perform Advanced Analytics

Abstract:

SQL Server 2016 is packed with many great features. One of those features is the integration of R in SQL Server via SQL Server R Services. This integration gives us the ability to perform very sophisticated analytics against data inside the database and data warehoused in big data environments such as Spark Hadoop.

In this session I will demonstrate how to productionize models developed by your data scientist via SQL Server R Services. I will demonstrate how to manage the whole process using an IDE that many of us have grown to love, Visual Studio.

SessionID: 63706

Getting started with Entity Framework Core

Back to calendar

Event Date: 15-07-2017 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Jim Wooley

Title: Getting started with Entity Framework Core

Abstract:

With the cross-platform version of .Net, Microsoft has had to rewrite many of the core components that we have come to depend on. If you include data in your applications, chances are you have used Entity Framework in the past. In this session, you'll learn how to get started using EF Core and how to handle the changes in this version.

SessionID: 63794

Making developers lives easier with SQL Server 2016

Back to calendar

Event Date: 15-07-2017 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Samir Behara

Title: Making developers lives easier with SQL Server 2016

Abstract:

In this session, we will learn about the rich set of capabilities of SQL Server 2016 and the new improved features relating to Performance, Productivity and Security.

We will understand how the life of a SQL Developer and Database Administrator will be transformed with features like Query Store, Live Query Statistics, Comparing Execution Plans, Built-in JSON Support, Temporal Database, Stretch Database and other nice T-SQL enhancements. We will take a look at the new security features – Always Encrypted, Row Level Security and Dynamic Data Masking.

At the end, we will look at the new and improved features of SSMS 2016. We will learn a number of tips and tricks to increase productivity and efficiency in SSMS IDE. This will be a content rich session with plenty of demonstrations.

SessionID: 63830

Optimization, Optimization – Make Your Queries Faster

Back to calendar

Event Date: 15-07-2017 - Session time: 15:30:00 - Track: Optimization Performance

Speaker: Matt Martin

Title: Optimization, Optimization – Make Your Queries Faster

Abstract:

In this class, we will take some real world examples of very complex queries that have over a dozen joins (inner, left, and cross) and break them down to their foundational parts, restructure and rebuild, and improve performance dramatically. We will touch on techniques such as leveraging temp tables, creating indexes, and looking at execution plans to know when you’ve gone far enough on the optimization. Time is money right?...time to save a ton!

SessionID: 63854

Azure SQL Database: 12 Things To Know

Back to calendar

Event Date: 15-07-2017 - Session time: 15:30:00 - Track: Cloud Application Development Deployment

Speaker: Sven Aelterman

Title: Azure SQL Database: 12 Things To Know

Abstract:

Up and running with Azure SQL Database already? This session will provide a grab bag of 12 how-to items you'll need to know to successfully keep your database running. Among those, we'll cover PowerShell for Azure SQL DB, geo-replica and other disaster recovery features and monitoring. As Azure SQL DB rapidly gains capabilities, rest assured that this session covers the latest!

SessionID: 63858

Linux for the SQL Server Administrator

Back to calendar

Event Date: 15-07-2017 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: Linux for the SQL Server Administrator

Abstract:

I bet never in your career you thought SQL Server would run on anything other than Windows. Times are changing, and are you ready? SQL Server on Linux is right around the corner! What is Linux - really? Why run your mission-critical databases on an unfamiliar operating system? This introductory session will help seasoned SQL Server DBA understand the basics of Linux and how it is different from Windows, all the way from basic management to performance monitoring. By the end of this session, you will be able to launch your own Linux-based SQL Server instance and get hands-on with this paradigm shift to see if this new platform is right for your organization.

SessionID: 64948

How to Move a Ton of Data from the Mainframe to the Cloud (with B

Back to calendar

Event Date: 15-07-2017 - Session time: 15:30:00 - Track: BI Platform Architecture, Dev, Delivery Admin

Speaker: Simon Kingaby

Title: How to Move a Ton of Data from the Mainframe to the Cloud (with B

Abstract:

So you need to move data from 75 tables on the mainframe to new tables in SQL Azure. Do you: a) hand code one package to load all 75 tables, b) hand code 75 packages that move a table each, or c) wish there was a better way?

There is! Business Intelligence Markup Language (Biml) can automate the creation of packages so that they all follow the same script. In this beginner level session, we will create some simple metadata to be able to generate multiple packages and their associated connection managers. You will see Biml in action. You will see the XML that Biml uses to define packages and connections. You will see the C# code that Biml uses to fetch metadata and dynamically generate packages in SSIS. And you will see packages and connection managers generated from Biml before your very eyes.

SessionID: 64983

VLDB Tips and Migration Tactics

Back to calendar

Event Date: 15-07-2017 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Todd Kleinhans

Title: VLDB Tips and Migration Tactics

Abstract:

SessionID: 65437

Execution Plans for Mere Mortals

Back to calendar

Event Date: 15-07-2017 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Lawell

Title: Execution Plans for Mere Mortals

Abstract:

For beginning database professionals, execution plans can be intimidating. This 1-hour session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache.

Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.

SessionID: 65441

Agile isn't the A in DBA, but you still should know it

Back to calendar

Event Date: 15-07-2017 - Session time: 15:30:00 - Track: Professional Development

Speaker: Glen Gordon

Title: Agile isn't the A in DBA, but you still should know it

Abstract:

Backlogs! Standups! Burndowns! If you ever find yourself - as a data professional - immersed in an organization that follows an agile methodology, you're going to want to have a basic understanding of typical roles, artifacts, events, and nomenclature associated with that methodology. In this session, you'll get a quick overview of agile methodologies (focusing on Scrum) and how they apply to the way data professionals work as part of a software development team. You'll leave with an understanding of the goals that agile methodologies try to achieve, resources to learn more, and confidence in knowing a PBI from a PBR.

This site is open source. Improve this page.