sqlsathistory

Nr: 597

SQLSaturday #597 - Phoenix 2017

Start Time (24h)	Speaker	Track	Title
10:00:00	Jim Donahoe	Enterprise Database Administration Deployment	New Instance, Now what?
10:00:00	Kevin Feasel	Application Database Development	APPLY Yourself
10:00:00	Stan Geiger	BI Platform Architecture, Development Administration	Polybase, Didn't that go out with the 70's?
10:00:00	Mindy Curnutt	Application Database Development	Fun with SQL Server Spatial Data
10:00:00	Jay Robinson	Application Database Development	Adding Lightness: Better Performance Through Compression
10:00:00	Rachael Martino	BI Information Delivery	Power BI Gotcha's
10:00:00	Vern Rabe	Enterprise Database Administration Deployment	Query Optimization Statistics : Driving Force Behind Performance
10:00:00	Amy Herold	Enterprise Database Administration Deployment	Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
10:00:00	Josh Sivey	Cloud Application Development Deployment	Are you down with MPP? - Part 1 - Hadoop Based Solutions
10:00:00	Frank Cegelski	BI Platform Architecture, Development Administration	Logical Data Warehousing with Tableau 10
10:00:00	Phil Robinson	Analytics and Visualization	Data Wrangling for Reporting Analytics
10:00:00	Peter Kral	Application Database Development	JSON and the Astronauts
11:15:00	Stan Geiger	Application Database Development	JSON Processing in SQL Server 2016 or Why I hate XML
11:15:00	Vern Rabe	Enterprise Database Administration Deployment	It’s Time for a Change: Temporal Table Support in SQL Server 2016
11:15:00	Jeremy Frye	BI Platform Architecture, Development Administration	Speed Up Your SSAS Cube's Data Refresh With Dynamic Partition Processing
11:15:00	Grant Fritchey	Application Database Development	Faster Provisioning with SQL Clone
11:15:00	Tim Mitchell	BI Platform Architecture, Development Administration	Deep Dive into the SSIS Catalog
11:15:00	Amy Herold	Professional Development	Making the Leap from Developer to DBA
11:15:00	Josh Sivey	Cloud Application Development Deployment	Are you down with MPP? - Part 2 - SQL Based Solutions
11:15:00	Karla Benefiel	Advanced Analysis Techniques	An Introduction to Advanced Analytics
11:15:00	Jude Dcosta	Analytics and Visualization	Tableau and Power BI-Compare and Contrast
11:15:00	Mike Byrd	Application Database Development	SS2014/2016 In-Memory Tables --Formula One Performance Unleashed, Part 1
11:15:00	Connie Fowler	BI Information Delivery	Master Data Services 2016 - Giving users control of their data
11:15:00	Chris Hyde	Analytics and Visualization	SQL Server R Services in SQL 2016
13:00:00	Mike Byrd	Application Database Development	In-Memory Indexes: Part 2 -- The rest of the story!
13:00:00	Jay Robinson	Application Database Development	Partitioned Tables and Query Performance
13:00:00	Sayed Saeed	BI Information Delivery	Enabling Familiar, Powerful Business Intelligence
13:00:00	Grant Fritchey	Enterprise Database Administration Deployment	Azure SQL Database for the DBA
13:00:00	Lance Tidwell	Application Database Development	Introduction to Execution Plans
13:00:00	Martin Schoombee	BI Information Delivery	Power Query: The basics
13:00:00	Kathi Kellenberger	Application Database Development	Indexing for Beginners
13:00:00	Sergio Pacheco	Enterprise Database Administration Deployment	SQL Server in Azure, One Year In
13:00:00	Cristian Vasconez	Analytics and Visualization	SSRS 2016, Tableau, Power BI: Using Data Visualization Tools to consume API data
13:00:00	Divya Saini	Advanced Analysis Techniques	Pick the right R - R, Microsoft R Open and Microsoft R Server
13:00:00	Randy Knight	Enterprise Database Administration Deployment	Understanding the SQL Server Transaction Log
13:00:00	Robert Miller	Enterprise Database Administration Deployment	SQL lessons learned operating at scale
14:15:00	Ryan McCauley	Strategy and Architecture	How to troubleshoot beyond what you understand
14:15:00	Armando Lacerda	Enterprise Database Administration Deployment	Unleashing Stretched Databases
14:15:00	TJay Belt	Enterprise Database Administration Deployment	PowerBI, from a DBA
14:15:00	Kathi Kellenberger	Application Database Development	Introduction to Window Functions
14:15:00	Jason Brimhall	Application Database Development	The Anatomy of Select
14:15:00	Surya Vipparthy	Advanced Analysis Techniques	Big Data Use Case and Implementation with Cloudera
14:15:00	Venus Lin	Analytics and Visualization	Common Linear and Classification for Machine Learning using Microsoft R
14:15:00	Yueying Li	Advanced Analysis Techniques	An Introduction to Market Basket Analysis Demonstrations
14:15:00	Randy Knight	Application Database Development	Understanding Transaction Isolation Levels
14:15:00	Ginger Grant	Cloud Application Development Deployment	Data Analytics with U-SQL
14:15:00	Jennifer McCown	Application Database Development	Beginning T-SQL
14:15:00	Konstantin Melamud	Enterprise Database Administration Deployment	Turbo Boost Performance: In Memory Tables index optimizations
15:00:00	Anders Pedersen	Enterprise Database Administration Deployment	I/O Tuning 101
15:30:00	Kevin Feasel	Application Database Development	Kafka For .NET Developers
15:30:00	Tim Mitchell	Strategy and Architecture	Change Detection in SQL Server
15:30:00	Lori Edwards	Other	DBA 101 – Let’s Get Started
15:30:00	Jason Brimhall	Enterprise Database Administration Deployment	A Masters Passport to Extended Events
15:30:00	Rachael Phillips	Advanced Analysis Techniques	Sentiment Analysis with R
15:30:00	Corey Kreun	Strategy and Architecture	The Logical Data Warehouse: How the Logical Data Warehouse is enabling Advanced Analytics
15:30:00	Eric Peterson	Application Database Development	SQL vs noSQL
15:30:00	Cyndi Johnson	BI Platform Architecture, Development Administration	SHARPen Your BIMLSCRIPT
15:30:00	Paul Graham	BI Information Delivery	Change Data Capture, maybe you should consider it again.
15:30:00	Sean McCown	Enterprise Database Administration Deployment	Loading SQL Server Data with Powershell
16:15:00	Joseph Barth	Cloud Application Development Deployment	Azure Data and Anayltics Hybrid Solution in the Cloud

SessionID: 56679

New Instance, Now what?

Back to calendar

Event Date: 25-03-2017 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jim Donahoe

Title: New Instance, Now what?

Abstract:

Congratulations, you’re now our DBA! A new SQL instance is like a blank canvas, you stare at it and wonder where to start. As an accidental dba, this session will help you learn how to survive in your new role.

In this session, you will be supplied with the beginning brush strokes to make your server a master piece. To do so, we will review best practices for standard configurations, backups, maintenance, and disaster recovery.

By the end of this session, you will have developed a pallet of tools to help you create your SQL Server Masterpiece and be able to use it as a print for others.

SessionID: 56833

APPLY Yourself

Back to calendar

Event Date: 25-03-2017 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Kevin Feasel

Title: APPLY Yourself

Abstract:

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

SessionID: 56853

Polybase, Didn't that go out with the 70's?

Back to calendar

Event Date: 25-03-2017 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Stan Geiger

Title: Polybase, Didn't that go out with the 70's?

Abstract:

"With the release of SQL Server 2016, Microsoft has included two features that could fundamentally change the way we look at Data Warehousing. The addition of Polybase for connecting to external data sources such as Hadoop and Azure Blob for native TSQL queries extends the reach of the DW. In this session we will discuss how to configure Polybase, best use cases, as well as live demos of the technology.

SessionID: 57086

Fun with SQL Server Spatial Data

Back to calendar

Event Date: 25-03-2017 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Mindy Curnutt

Title: Fun with SQL Server Spatial Data

Abstract:

SessionID: 57378

Adding Lightness: Better Performance Through Compression

Back to calendar

Event Date: 25-03-2017 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Jay Robinson

Title: Adding Lightness: Better Performance Through Compression

Abstract:

This is a deep dive into the data compression features in SQL Server and how it affects the performance of your database. After attending this session, you will be able to recognize situations in which enabling compression will help, how to configure it, and how to deploy it in your production systems.

SessionID: 57950

Power BI Gotcha's

Back to calendar

Event Date: 25-03-2017 - Session time: 10:00:00 - Track: BI Information Delivery

Speaker: Rachael Martino

Title: Power BI Gotcha's

Abstract:

There are a few "gotcha's" that can make you spend more time than necessary when creating or deploying your Power BI solution. During this demonstration based session you will see those traps and how to avoid them. You will save time on your Power BI projects when you use these tips.

SessionID: 58214

Query Optimization Statistics : Driving Force Behind Performance

Back to calendar

Event Date: 25-03-2017 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Vern Rabe

Title: Query Optimization Statistics : Driving Force Behind Performance

Abstract:

When the SQL Server optimizer evaluates a query to determine how best to execute it, the statistics are quite possibly the most important tool at its disposal. But SQL Server statistics objects aren’t perfect because they only contain summary information. In this session, we’ll start with an overview of what the statistics objects are, how the optimizer uses them, and some general guidelines for their maintenance. Then we’ll look at some of the issues – and solutions – that can arise due to their imperfection: ascending keys, correlated predicates, skewed distribution, or downright bad summary information.

SessionID: 59509

Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Back to calendar

Event Date: 25-03-2017 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Abstract:

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.

SessionID: 60954

Are you down with MPP? - Part 1 - Hadoop Based Solutions

Back to calendar

Event Date: 25-03-2017 - Session time: 10:00:00 - Track: Cloud Application Development Deployment

Speaker: Josh Sivey

Title: Are you down with MPP? - Part 1 - Hadoop Based Solutions

Abstract:

Massively Parallel Processing (MPP) architectures allow the use of large numbers of processors (or computers) to perform a set of coordinated computations simultaneously. MPP architectures can help with the processing and aggregation of large volumes of data with varying shapes, but can be complicated and costly to deploy and maintain. We'll explore using the Microsoft Azure cloud as a platform for quickly creating cost-effective MPP solutions. We will use Microsoft Azure to deploy and process data with a Hadoop based MMP architecture (using HDInsight). The pros and cons of Hadoop based MPP, as well as when a company might choose a Platform-as-a-Service (PaaS) offering over an Infrastructure-as-a-Service (IaaS) solution. This talk will be packed full of demos and real-world learnings.

SessionID: 61036

Logical Data Warehousing with Tableau 10

Back to calendar

Event Date: 25-03-2017 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Frank Cegelski

Title: Logical Data Warehousing with Tableau 10

Abstract:

Abstract - Logical Data Warehousing with Tableau 10

Logical Data Warehousing has become a trending BI topic. The purpose of an LDW is to extend a traditional Data Warehouse with supplemental information, and is even being used to reduce development time by supplanting the traditional data warehouse altogether.

Many tools are now available that will help in the creation of an LDW. The latest version of Tableau provides tools for combining data from disparate sources into a unified data source that is consumable by end users.

Learn about LDW, and learn how Tableau 10 can help provide value to your client in less time than with a classic data warehouse solution.

SessionID: 61107

Data Wrangling for Reporting Analytics

Back to calendar

Event Date: 25-03-2017 - Session time: 10:00:00 - Track: Analytics and Visualization

Speaker: Phil Robinson

Title: Data Wrangling for Reporting Analytics

Abstract:

This session will review common challenges encountered when preparing new data sets for use in analytics and reporting. We will look at tools for exploring and modifying large CSV/TXT files and discuss design patterns for cleaning and repair.

SessionID: 61131

JSON and the Astronauts

Back to calendar

Event Date: 25-03-2017 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Peter Kral

Title: JSON and the Astronauts

Abstract:

In one small step, SQL Server 2016 has taken a giant leap...to JSON! In this session, we'll launch a probe into a JSON data file containing profiles of NASA astronauts using new JSON T-SQL functions in SQL Server. With each astronaut we meet, we'll learn to validate, read, and manipulate "unstructured" JSON data. We'll get The Right Stuff to start developing, no previous JSON experience required. Let's go where NoSQL has gone before!

Prerequisites: You should have experience writing queries in T-SQL. No previous knowledge of JSON is needed.

Goals: Learn about JSON, and its basic data types Discover how SQL Server 2016 can handle JSON data Be amazed at the cool people NASA sends into space!

SessionID: 56855

JSON Processing in SQL Server 2016 or Why I hate XML

Back to calendar

Event Date: 25-03-2017 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Stan Geiger

Title: JSON Processing in SQL Server 2016 or Why I hate XML

Abstract:

For years XML was the generic data format for the masses. With the advent of JSON, there is a much easier, readable format for storing data that is platform agnostic. In this presentation we will explore what JSON is and how its different from XML as well as how to read an write JSON files using new functions available in SQL Server 2016

SessionID: 58212

It’s Time for a Change: Temporal Table Support in SQL Server 2016

Back to calendar

Event Date: 25-03-2017 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Vern Rabe

Title: It’s Time for a Change: Temporal Table Support in SQL Server 2016

Abstract:

Without temporal tables (AKA history tables), we can only see the current version of data. We can’t see rows that have been deleted or rows as they existed before the latest update. The temporal table support in SQL Server 2016 gives us the ability to create system maintained “history” tables to track all changes to the table data.

In this session we’ll discuss how you can benefit from temporal support in your tables, how to implement temporal tables in SQL Server 2016, and how to write “time travel queries” using the new FOR SYSTEM_TIME clause in a SELECT statement to easily query historical information.

SessionID: 59386

Speed Up Your SSAS Cube's Data Refresh With Dynamic Partition Processing

Back to calendar

Event Date: 25-03-2017 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jeremy Frye

Title: Speed Up Your SSAS Cube's Data Refresh With Dynamic Partition Processing

Abstract:

Are you sometimes plagued with the unfortunate event of your multidimensional SSAS cube refresh exceeding the scheduled maintenance window? Maybe you simply need to update recent data to reflect a critical change during business hours, but can’t afford several hours of downtime. I have a solution for you! In this session, we will focus on building an ETL framework while leveraging your cube’s logical partition design to dynamically process only the necessary data within your measure group. We will discuss audit logging, cube processing options, partition design and metadata access. These techniques and strategies will provide a faster data refresh process for your warehouse or data mart.

SessionID: 59390

Faster Provisioning with SQL Clone

Back to calendar

Event Date: 25-03-2017 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Grant Fritchey

Title: Faster Provisioning with SQL Clone

Abstract:

Database provisioning requests are the bane of many DBA’s working lives. Developers want to work with realistic data, DBAs want to protect Production and secure data.

But copying databases for development and test is a job that gets 'delegated up'; DBAs, IT Managers, those with the keys to Production find themselves performing the task, and the development team is often blocked while it takes place.

The same people are often responsible for ensuring the copy is appropriate for the environment (permissions, configuration data, sensitive data), so have to perform semi-manual tasks and maintain brittle scripts to do so.

In this session Redgate’s Grant Fritchey shows how new tool SQL Clone enables self-service or easy automation of database copies and is near-instant at the time of need, using a fraction of the disk space, and allowing quick reversion to a baseline or snapshotting of changes.

SessionID: 59456

Deep Dive into the SSIS Catalog

Back to calendar

Event Date: 25-03-2017 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

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

Making the Leap from Developer to DBA

Back to calendar

Event Date: 25-03-2017 - Session time: 11:15:00 - Track: Professional Development

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

Are you down with MPP? - Part 2 - SQL Based Solutions

Back to calendar

Event Date: 25-03-2017 - Session time: 11:15:00 - Track: Cloud Application Development Deployment

Speaker: Josh Sivey

Title: Are you down with MPP? - Part 2 - SQL Based Solutions

Abstract:

Massively Parallel Processing (MPP) architectures allow the use of large numbers of processors (or computers) to perform a set of coordinated computations simultaneously. MPP architectures can help with the processing and aggregation of large volumes of data with varying shapes, but can be complicated and costly to deploy and maintain. We'll explore using the Microsoft Azure cloud as a platform for quickly creating cost-effective MPP solutions. We will use Microsoft Azure to deploy and process data with a SQL based MMP architecture (Azure SQL Data Warehouse). The pros and cons of SQL based MPP will be discussed, as well as when a company might choose a Platform-as-a-Service (PaaS) offering over an Infrastructure-as-a-Service (IaaS) solution. This talk will be packed full of demos and real-world learnings.

SessionID: 60956

An Introduction to Advanced Analytics

Back to calendar

Event Date: 25-03-2017 - Session time: 11:15:00 - Track: Advanced Analysis Techniques

Speaker: Karla Benefiel

Title: An Introduction to Advanced Analytics

Abstract:

By leveraging advancements in statistical computing and the large volumes of data generated by businesses today, Advanced Analytics empowers business users to make more strategic decisions that can help to reduce costs or increase profit. By utilizing relationships in historical data, predictive analytics and other machine learning algorithms can model future predictions and enable the business user to more accurately prescribe solutions. In this session, Karla will demonstrate a step-by-step process needed to implement an Advanced Analytics solution into a current data strategy. This includes statistical modeling methodology and techniques, but will also take a deeper dive into a few use cases and the data surrounding these models.

SessionID: 60980

Tableau and Power BI-Compare and Contrast

Back to calendar

Event Date: 25-03-2017 - Session time: 11:15:00 - Track: Analytics and Visualization

Speaker: Jude Dcosta

Title: Tableau and Power BI-Compare and Contrast

Abstract:

The goal of self-service BI is to give users the means to interact and understand their data quickly. There are a plethora of tools in the Market. For many years Tableau was the undisputed leader in this rapidly evolving space. Post 2015 a new tool from Microsoft emerged – Power BI. It was and is still considered a disruptor in the Data visualization space.

Faced with a tool that has been in the market for over 10 years and a rapidly evolving product that has the backing of a Software giant from Redmond , how does an individual or an organization go about choosing the right product. Let’s dive deeper. In this demonstration rich session we’ll look at how the tools compare against different functional scenarios.

We’ll see how each tool can handle-

Represent Data using Maps
Drill downs and Hierarchies
Trending and Forecasting
Grouping and Organizing data
Combing data from different sources and source type
```
  Community support
```

And much more..!

SessionID: 61074

SS2014/2016 In-Memory Tables --Formula One Performance Unleashed, Part 1

Back to calendar

Event Date: 25-03-2017 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: SS2014/2016 In-Memory Tables --Formula One Performance Unleashed, Part 1

Abstract:

Query performance is what it is all about. SQL Server 2014/2016 now has the new in-memory functionality that takes a completely different approach to data access and manipulation. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables with and without columnstore indexes over equivalent disk based tables.

This session is all about when and how to apply in-memory tables in a production environment. After this session you will

Understand what in-memory tables are and how to create and maintain them including their limitations
Be able to identify performance gains over equivalent disk back tables
Comprehend the new data monitoring needed for in-memory table

SessionID: 61110

Master Data Services 2016 - Giving users control of their data

Back to calendar

Event Date: 25-03-2017 - Session time: 11:15:00 - Track: BI Information Delivery

Speaker: Connie Fowler

Title: Master Data Services 2016 - Giving users control of their data

Abstract:

Master Data Services can replace some ETL practices. This session shows how Excel can be used to directly modify data in SQL Server.

SessionID: 61136

SQL Server R Services in SQL 2016

Back to calendar

Event Date: 25-03-2017 - Session time: 11:15:00 - Track: Analytics and 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: 57407

In-Memory Indexes: Part 2 -- The rest of the story!

Back to calendar

Event Date: 25-03-2017 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: In-Memory Indexes: Part 2 -- The rest of the story!

Abstract:

This session is a continuation of my in-memory table presentation (Part 1) given at 8 SQL Saturdays in 2016 only now concentrating on in-memory indexes. This session will do an in-depth dive into hash, range, and columnstore indexes in the in-memory environment. It will be about 30% presentation and 70% demos with emphasis on when and how to apply in-memory indexes for stated environments/scenarios.

After this session you will

Understand the three in-memory index types, how to create, and when to apply them for selected scenarios
Be able to identify performance gains over equivalent disk back tables/indexes
Comprehend the new data monitoring needed for in-memory tables/indexes

SessionID: 57443

Partitioned Tables and Query Performance

Back to calendar

Event Date: 25-03-2017 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Jay Robinson

Title: Partitioned Tables and Query Performance

Abstract:

Partitioned tables are an ideal solution for improving write performance in certain situations. But they present unique challenges for the developer who simply needs to query the data. In this session, you will learn how the optimizer takes partitioned tables into account when producing query plans, recognize common query plan issues, and learn tactics for improving performance when querying partitioned data.

SessionID: 58179

Enabling Familiar, Powerful Business Intelligence

Back to calendar

Event Date: 25-03-2017 - Session time: 13:00:00 - Track: BI Information Delivery

Speaker: Sayed Saeed

Title: Enabling Familiar, Powerful Business Intelligence

Abstract:

This session focuses on Microsoft’s BI technologies and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. With the recent release of SQL Server, Microsoft dramatically enhanced the Microsoft BI platform. During this session you will explore the improvements to SQL Server reporting services and Power BI to show you how to create a blended value from your BI platform.

SessionID: 59389

Azure SQL Database for the DBA

Back to calendar

Event Date: 25-03-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Grant Fritchey

Title: Azure SQL Database for the DBA

Abstract:

Everyone knows that Azure SQL Database only supports a small subset of SQL Server functionality, small databases, and has really bad performance. Except, everyone is wrong. In fact, Azure SQL Server Database is ready to support many, if not most, databases within your enterprise. This session reintroduces Azure SQL Database and shows the high degree of functionality and improved performance that is now available. We'll cover topics from monitoring, to high availability to disaster recovery, all within Azure SQL Database. You’ll leave this session with a more thorough understanding of the strengths and weaknesses of Azure SQL Database so that you can make a more informed choice over when, or if, you should use it within your environment.

SessionID: 59403

Introduction to Execution Plans

Back to calendar

Event Date: 25-03-2017 - Session time: 13:00:00 - Track: Application Database Development

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

Power Query: The basics

Back to calendar

Event Date: 25-03-2017 - Session time: 13:00:00 - Track: BI Information Delivery

Speaker: Martin Schoombee

Title: Power Query: The basics

Abstract:

With the increasing popularity of Power BI and the future inclusion of Power Query in SSIS, Power Query (or the M language) will undoubtedly play a significant role in our lives as BI professionals.

In this session we will cover the basics of Power Query, and show you the benefits of knowing this powerful new language.

SessionID: 59816

Indexing for Beginners

Back to calendar

Event Date: 25-03-2017 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Kathi Kellenberger

Title: Indexing for Beginners

Abstract:

To a beginner, indexes may seem like magic. The right index can drastically reduce query time. But, how do you know which indexes are the right ones? SQL Server will suggest helpful indexes in the graphical execution plan and with the Database Engine Tuning Advisor, but follow that advice with caution. This session will explain how indexes work and how to tune indexes so that your application has the best performance.

SessionID: 59924

SQL Server in Azure, One Year In

Back to calendar

Event Date: 25-03-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Sergio Pacheco

Title: SQL Server in Azure, One Year In

Abstract:

SessionID: 60981

SSRS 2016, Tableau, Power BI: Using Data Visualization Tools to consume API data

Back to calendar

Event Date: 25-03-2017 - Session time: 13:00:00 - Track: Analytics and Visualization

Speaker: Cristian Vasconez

Title: SSRS 2016, Tableau, Power BI: Using Data Visualization Tools to consume API data

Abstract:

With the possibility to visualize data with different tools it has become difficult to choose or determine which one is better or when to use one over another. In this session, I'll be using three of the most popular tools to visualize data from outlook REST API. This session will also provide a high level understanding on how these tools can be used for this scenario and other possible cases, as well as their similarities and differences.

SessionID: 61068

Pick the right R - R, Microsoft R Open and Microsoft R Server

Back to calendar

Event Date: 25-03-2017 - Session time: 13:00:00 - Track: Advanced Analysis Techniques

Speaker: Divya Saini

Title: Pick the right R - R, Microsoft R Open and Microsoft R Server

Abstract:

After Microsoft acquired Revolution Analytics, it has released Microsoft R Open (MRO, formerly Revolution R Open) and Microsoft R Server (MRS, formerly Revolution R Enterprise). While there is publicly available information on these, analytics community is still getting familiar with these. During the presentation, Divya will address these three questions –

• What do R, MRO, and MRS have in common? • What’s new in MRO and MRS compared with R? • Why should I use MRO or MRS instead of R? In addition to this, she will also give a demo of how to get started with Microsoft R Open and Microsoft R Server. She will also demonstrate how to deploy an end to end application using SQL Server R Services and Power BI.

SessionID: 61120

Understanding the SQL Server Transaction Log

Back to calendar

Event Date: 25-03-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Randy Knight

Title: Understanding the SQL Server Transaction Log

Abstract:

The SQL Server transaction log is one of the most misunderstood components of the database engine. What makes it grow? How does it get truncated? Should I shrink it? What is a VLF? In this session we will answer these questions and more.

SessionID: 61153

SQL lessons learned operating at scale

Back to calendar

Event Date: 25-03-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Robert Miller

Title: SQL lessons learned operating at scale

Abstract:

When your SQL Server environment runs 247 and is very sensitive* to interruptions, how one performs basic maintenance activities, supports development and deployment, and ensures proper backups requires a different mindeset for performing these tasks.

Everything from how you implement SQL Server to how a table is designed requires a different thought process when the daily "overnight" or weekly "downtime" windows do not exist.
Everything you do happens alongside and impacts user-facing activity. In this session I will present various high-level lessons learned along the path of user happiness in an always-in-use environment.

SessionID: 56961

How to troubleshoot beyond what you understand

Back to calendar

Event Date: 25-03-2017 - Session time: 14:15:00 - Track: Strategy and Architecture

Speaker: Ryan McCauley

Title: How to troubleshoot beyond what you understand

Abstract:

Troubleshooting can be easy when the cause of an issue is obvious - except sometimes it isn't because it's not. In those cases, how do you find the cause - especially when it's something you don't directly control? You're having issues with your storage, but is it a result of RAID being setting up improperly or a constraint on the fiber channel switch? Can you tell the difference between a blockage of firewall ports and a network switch that's nearing capacity? You're not a SAN admin or a firewall engineer, but you don't need to be to understand enough to identify whether these systems are involved.

In this session, we'll talk about troubleshooting as a process - how you can identify issues beyond what you can see and may not understand. While we may discuss some specific situations or hard-to-identify causes in the examples, the session will be focused on understanding the impact of different issues, and how you can better identify the cause of an issue when it's outside your system.

SessionID: 59409

Unleashing Stretched Databases

Back to calendar

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

Speaker: Armando Lacerda

Title: Unleashing Stretched Databases

Abstract:

This is a deep dive session full of demos about SQL 2016 stretched databases feature. It will go from pre-reqs and blocking factor through deployment and disaster recovery. Everything you need to know and when to use this new cloud-based exciting capability.

SessionID: 59469

PowerBI, from a DBA

Back to calendar

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

Speaker: TJay Belt

Title: PowerBI, from a DBA

Abstract:

Microsoft’s PowerBI is the new hotness. In this session, you will get your hands dirty and dive into PowerBI and create an actual report, with actual data. You will get to learn from examples from what a DBA has done to implement PowerBI in his shop and make his data accessible.

As a DBA, we often need to collect and display data in a friendly and interactive fashion. We will play with some PowerShell to collect data from several systems, store this data in an Azure DB in the Cloud, then point PowerBI at this data to display and interact with said data. You will learn a little about PowerShell, Azure SQL DB, PowerBI, and how to make these work for you.

You will be given permissions to an Azure DB, and get connected to this source. You will also need to have PowerBI desktop downloaded and installed. We will be using this to create the report during the session. So please come prepared to interact with the internet, with a cloud-based database you will be provided, and PowerBI Desk

SessionID: 59814

Introduction to Window Functions

Back to calendar

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

Speaker: Kathi Kellenberger

Title: Introduction to Window Functions

Abstract:

SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could.

This session will teach you how to avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.

SessionID: 59868

The Anatomy of Select

Back to calendar

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

Speaker: Jason Brimhall

Title: The Anatomy of Select

Abstract:

TSQL is one of the most valuable tools any SQL Server professional can add to their tool-set. More aptly, TSQL is a whole chest of tools for the SQL Server professional. One of the most important tools in that TSQL chest is a good understanding of the SELECT statement.

When was the last time you sat down to evaluate a SELECT statement? What actually goes into the processing of that teeny little word? There might be a fair bit more to this simple term than just fetching data from the database. This session covers the simplicity of the select. Then we take it a step further to dive into some of the complexities tied directly to this particular statement.

This session will help the attendee better understand the Select statement. With a more solid understanding of this statement, the attendee can return and implement some of this new knowledge to help improve processing and query response times in their own environments.

SessionID: 60959

Big Data Use Case and Implementation with Cloudera

Back to calendar

Event Date: 25-03-2017 - Session time: 14:15:00 - Track: Advanced Analysis Techniques

Speaker: Surya Vipparthy

Title: Big Data Use Case and Implementation with Cloudera

Abstract:

Over the last few years Big data technologies like Hadoop gained increasing popularity for processing and storing both structured, unstructured and semi structured data in the order of Peta Bytes or Zeta Bytes. A big data use case can help you solve a specific business challenge by using patterns or examples of big data technology solutions. Cloudera is an open-source Apache Hadoop distribution, CDH (Cloudera Distribution Including Apache Hadoop), targets enterprise-class deployments of that technology leveraging Big Data Applications. In this session Surya will explain the a few Big Data use cases and implementation using Cloudera.

SessionID: 60964

Common Linear and Classification for Machine Learning using Microsoft R

Back to calendar

Event Date: 25-03-2017 - Session time: 14:15:00 - Track: Analytics and Visualization

Speaker: Venus Lin

Title: Common Linear and Classification for Machine Learning using Microsoft R

Abstract:

This session will use RevoScaleR packages in Microsoft R to showcase the common linear and classification for machine learning, such as linear regression, logistic regression, etc. The presentation will also include the parameters or methods to create a good model as well as data visualization using PowerBI.

SessionID: 61037

An Introduction to Market Basket Analysis Demonstrations

Back to calendar

Event Date: 25-03-2017 - Session time: 14:15:00 - Track: Advanced Analysis Techniques

Speaker: Yueying Li

Title: An Introduction to Market Basket Analysis Demonstrations

Abstract:

As an unsupervised learning algorithm, market basket analysis/association rule mining has its advantages over other predictive analytics techniques. As a deeper dive into the algorithms, models, and tools used in machine learning tasks and how they change today’s business world, in this session, Ying will explore several business scenarios where market basket analysis can make a huge impact and present demos built with R, Azure ML, Tableau, and Power BI.

SessionID: 61121

Understanding Transaction Isolation Levels

Back to calendar

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

Speaker: Randy Knight

Title: Understanding Transaction Isolation Levels

Abstract:

SQL Server offers several isolation levels beyond the default "READ COMMITTED". But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.

SessionID: 61128

Data Analytics with U-SQL

Back to calendar

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

Speaker: Ginger Grant

Title: Data Analytics with U-SQL

Abstract:

This session introduces attendees to U-SQL, the new language created to combine the strengths of both SQL and C#. This powerful language can be used to query data which is stored in many different formats, including tab delimited , comma delimited files and JSON format. Demonstrations will show how to write code using Visual Studio and query information stored in an Azure Data Lake.

SessionID: 61572

Beginning T-SQL

Back to calendar

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

Speaker: Jennifer McCown

Title: Beginning T-SQL

Abstract:

If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!

SessionID: 62564

Turbo Boost Performance: In Memory Tables index optimizations

Back to calendar

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

Speaker: Konstantin Melamud

Title: Turbo Boost Performance: In Memory Tables index optimizations

Abstract:

With the introduction of in-memory based tables in SQL Server 2014, it’s natural to expect significant increases in query performance. But what do we do when queries which utilize in-memory tables actually start to perform same or, in some cases, even worse than their equivalent disk based table predecessors? In this session, we are going to take a look at the changes to the indexing design for in-memory based objects and how it differs from existing disk based table indexing. Also, we are going to cover how to choose the appropriate indexes for your in-memory object to give you the performance boost that you have been expecting.

SessionID: 57501

I/O Tuning 101

Back to calendar

Event Date: 25-03-2017 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Anders Pedersen

Title: I/O Tuning 101

Abstract:

One of the most common problems I have encountered as a DBA is the complaints from users that a particular query is slow, just one query. Many times one that used to run in acceptable time, but that over time has slowed down substantially.

In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.

First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.

The second part will focus on how to reduce I/O requests.

All of this can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.

SessionID: 56836

Kafka For .NET Developers

Back to calendar

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

Speaker: Kevin Feasel

Title: Kafka For .NET Developers

Abstract:

SessionID: 59459

Change Detection in SQL Server

Back to calendar

Event Date: 25-03-2017 - Session time: 15:30:00 - Track: Strategy and Architecture

Speaker: Tim Mitchell

Title: Change Detection in SQL Server

Abstract:

Change detection is a critical component of any system that moves data from one structure to another. Most data movement mechanisms are designed to move a subset of the data – only that which is new or changed since the last load. For that to work properly, there must be a reliable system for detecting delta data touched since the most recent load.

In this session, we will review the tools and design patterns available in SQL Server for performing change detection. From source detection methods including change tracking and change data capture, to in-flight comparisons using hashed values, and even brute-force methods as a last resort, we’ll cover the spectrum of change detection tools in SQL Server.

SessionID: 59736

DBA 101 – Let’s Get Started

Back to calendar

Event Date: 25-03-2017 - Session time: 15:30:00 - Track: Other

Speaker: Lori Edwards

Title: DBA 101 – Let’s Get Started

Abstract:

We've all installed SQL Server and, most of the times, the default settings work just fine. This is a beginner session that will help you to understand what those settings mean along with why there might be times that you want to use something other than the defaults and how that might impact your server. We'll also go through unattended installs, both with and without a config file. This can really help to standardize your SQL Server installations and save you some precious keystrokes.

SessionID: 59866

A Masters Passport to Extended Events

Back to calendar

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

Speaker: Jason Brimhall

Title: A Masters Passport to Extended Events

Abstract:

"As is commonly the case, all good things come to an end. And now is as good a time as any for the use of SQL Trace and Profiler to come to an end. Let’s face it, Trace was a good tool and had some wonderful uses. Profiler for that matter was a good tool and was useful at times.

It is time to let those old tools retire gracefully and move into the world of XE. This full day workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.

This full day session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties. This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.

You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE. Take advantage

SessionID: 59923

Sentiment Analysis with R

Back to calendar

Event Date: 25-03-2017 - Session time: 15:30:00 - Track: Advanced Analysis Techniques

Speaker: Rachael Phillips

Title: Sentiment Analysis with R

Abstract:

SessionID: 60963

The Logical Data Warehouse: How the Logical Data Warehouse is enabling Advanced Analytics

Back to calendar

Event Date: 25-03-2017 - Session time: 15:30:00 - Track: Strategy and Architecture

Speaker: Corey Kreun

Title: The Logical Data Warehouse: How the Logical Data Warehouse is enabling Advanced Analytics

Abstract:

The traditional Enterprise Data Warehouse (EDW) has become common place in today's technology landscape and is a key enabler for analytics solutions. However, an EDW introduces certain limitations and is not the right tool for every situation. We'll talk about what these limitations are and how the LDW opens up a whole new realm of possibilities for modern Advanced Analytics solutions.

SessionID: 60966

SQL vs noSQL

Back to calendar

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

Speaker: Eric Peterson

Title: SQL vs noSQL

Abstract:

A SQL perspective on noSql document databases.

What’s the difference between a SQL database and a document db? Why would you choose one over the other? What does the implementation look like? Are noSql databases taking over the world?

SessionID: 60990

SHARPen Your BIMLSCRIPT

Back to calendar

Event Date: 25-03-2017 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Cyndi Johnson

Title: SHARPen Your BIMLSCRIPT

Abstract:

You're looking for a way to speed up the creation of your SSIS packages. BIML intrigues you but you are no .NET developer. You'd like to enhance your BIML with some basic C#, but where do you start? In this session, we'll go over some C# constructs that can be quickly learned and applied within your BIML. We will also cover the basics of working with BIML in general.

SessionID: 61148

Change Data Capture, maybe you should consider it again.

Back to calendar

Event Date: 25-03-2017 - Session time: 15:30:00 - Track: BI Information Delivery

Speaker: Paul Graham

Title: Change Data Capture, maybe you should consider it again.

Abstract:

SessionID: 61566

Loading SQL Server Data with Powershell

Back to calendar

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

Speaker: Sean McCown

Title: Loading SQL Server Data with Powershell

Abstract:

Powershell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting. This is a no holds barred session taught by an enterprise SQL Server scripting expert. You can’t afford to miss this session if you do any level of scripting in your shop.

SessionID: 56706

Azure Data and Anayltics Hybrid Solution in the Cloud

Back to calendar

Event Date: 25-03-2017 - Session time: 16:15:00 - Track: Cloud Application Development Deployment

Speaker: Joseph Barth

Title: Azure Data and Anayltics Hybrid Solution in the Cloud

Abstract:

Join me in a presentation on how to create your Azure environment for Data and Analytics.

creating Azure resources
population of data for POC
creating a template to make POC a possibility (how to recreate on demand)
real world situations and lessons learned in Azure situations
consumption of that data through Power BI Embedded

This presentation will include creation of an Hybrid solution for Operational Analytics in Azure using Azure SQL DB, an historical Azure SQL DW and using Azure Analysis Services to create the ultimate Data and Analytics experience in the cloud. Make the move from on prem BI solutions to an Azure Data and Analytics solution.

This site is open source. Improve this page.