sqlsathistory

Nr: 530

Back to Main list

SQLSaturday #530 - Indianapolis 2016

Start Time (24h) Speaker Track Title
08:00:00 Warren Sifre Cloud Application Development Deployment Introduction to Azure Streaming Analytics
08:00:00 Peter Shore Enterprise Database Administration Deployment DBA 102: Now What
08:00:00 Andrew Loree Enterprise Database Administration Deployment Stretch Database and Managed Backups: Cloud Services for your SQL Servers
08:00:00 Ryan Wade BI Platform Architecture, Development Administration Why “R” you not leveraging the power of “R” in Power BI?!?
08:00:00 Allen White Application Database Development Scalable Application Design with Service Broker
08:00:00 Rob Volk Enterprise Database Administration Deployment Azure, PowerShell, and SQL Server Virtual Machines
08:00:00 Josh Fennessy SQLStarter Beginner SQLStarter - Intro to Big Data
08:00:00 Aaron King Application Database Development ORMs… can’t live with ‘em, can’t kill ‘em.
09:15:00 Kevin Feasel Application Database Development Peanut Butter Chocolate: Integrating Hadoop with SQL Server
09:15:00 Dave Mattingly Advanced Analysis Techniques Word Up: Text Mining in SQL
09:15:00 Jay Robinson Application Database Development Adding Lightness: Better Performance Through Compression
09:15:00 Drew Furgiuele Enterprise Database Administration Deployment SQL Server and PowerShell: Let's Get Serious
09:15:00 David Maxwell Enterprise Database Administration Deployment Wait Statistics - The Top 5 Waits You Should Know
09:15:00 Adam Belebczuk Enterprise Database Administration Deployment Availability Groups 101: An Introduction
09:15:00 Dave Leininger SQLStarter Beginner SQLStarter - Intro to Data Science
09:15:00 Daniel Glenn BI Platform Architecture, Development Administration Power BI SharePoint - A Marriage Made in Redmond
10:30:00 Kevin Kline Application Database Development Learning and Optimizing the SQL Server Plan Cache
10:30:00 Jonathan Stewart BI Platform Architecture, Development Administration An introduction to the magical world of BIML!
10:30:00 Andy Yun Application Database Development Performance Pitfalls from Code Reuse
10:30:00 Ben Miller Enterprise Database Administration Deployment SQL Server Encryption
10:30:00 Frank Gill Enterprise Database Administration Deployment Using Powershell to Automate Your Restore Strategy
10:30:00 Wendy Pastrick Enterprise Database Administration Deployment Using SQL Nexus for system health
10:30:00 David Maxwell SQLStarter Beginner SQLStarter - Intro to DBA
10:30:00 Dustin Elery Advanced Analysis Techniques Data, Statistics, and R Integration with BI...Why you should care!
11:45:00 Ross LoForte Enterprise Database Administration Deployment What's new in SQL Server 2016
11:45:00 John Deardurff SQLStarter Beginner SQLStarter - Certification/Recruiter Discussion
11:45:00 Andrew Mauch Other Pyramid Analytics BI to Transform into a Data-Driven Organization
11:45:00 Tom Spreacker Other Maximizing Microsoft SQL Server Storage Investments
13:00:00 Peter Shore Enterprise Database Administration Deployment Infrastructure for the DBA: An Introduction
13:00:00 Paul Popovich Jr Enterprise Database Administration Deployment Clusters! From the ground up, let us build one together
13:00:00 Brian Beswick BI Platform Architecture, Development Administration SSAS 2016 Tabular - Diving into the new features
13:00:00 Wylie Blanchard BI Information Delivery Using PowerPivot in MS Excel to analyze SQL Server Data
13:00:00 Kevin Kline SQLStarter Beginner SQLStarter - Intro to Database Development
13:00:00 Mike Lawell Enterprise Database Administration Deployment Execution Plans for Mere Mortals
13:00:00 Chris Koester Application Database Development Web APIs for the BI Developer
13:00:00 Bradley Nielsen Application Database Development Explore the Microsoft Azure Data Landscape
14:15:00 Michael Steineke Enterprise Database Administration Deployment All things you need to know before you start setting up SQL AlwaysOn
14:15:00 Meagan Longoria BI Information Delivery Overcoming Chartaphobia with Power BI
14:15:00 Jim Bennett SQLStarter Beginner SQLStarter - Intro to BI
14:15:00 Jeremy Frye BI Platform Architecture, Development Administration Speed Up Your SSAS Cube's Data Refresh With Dynamic Partition Processing
14:15:00 Pat Phelan Application Database Development Data Architecture 101
14:15:00 Adam Machanic Application Database Development SQL Server 2016 "Hidden Gems"
14:15:00 Kerry Tyler BI Information Delivery Connecting Power BI to On-Prem Data with SSAS
14:15:00 Ed Leighton-Dick Enterprise Database Administration Deployment Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)
14:15:00 Tim Ford Enterprise Database Administration Deployment Making the Accidental DBA Look Good: Ten Insights You Need to Hav
15:30:00 Brandon Lukes Enterprise Database Administration Deployment Migrating your SQL Server Instance
15:30:00 Aaron Cutshall Application Database Development XML X-Treme!
15:30:00 Britton Gray Application Database Development How to Speak Australian: Oracle for the SQL Server Developer
15:30:00 Eddie Wuerch Enterprise Database Administration Deployment TempDB Done Right
15:30:00 Frank Murphy Analytics and Visualization SQLServer to Google Earth: visualizing spatial data in KML format
15:30:00 Ginger Grant BI Platform Architecture, Development Administration Administration, Security and Data Management in Power BI
15:30:00 Tamera Clark BI Information Delivery Microsoft Business Intelligence 2016 – More Love for Your Data

SessionID: 46899

Introduction to Azure Streaming Analytics

Back to calendar

Event Date: 13-08-2016 - Session time: 08:00:00 - Track: Cloud Application Development Deployment

Speaker: Warren Sifre

Title: Introduction to Azure Streaming Analytics

Abstract:

This session will cover what is Streaming Analytics and the various use cases. We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review. The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.

SessionID: 46906

DBA 102: Now What

Back to calendar

Event Date: 13-08-2016 - Session time: 08:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Peter Shore

Title: DBA 102: Now What

Abstract:

Things happened, you got a knock on the head and when you awoke your boss said “congratulations” you are our new DBA, perhaps you came to the role in a more intentional manner or are just DBA curious. Your environment is running but you are wondering “now what” or “what’s next”. In this session we will give an overview of a few things that could, perhaps even should be next and give some recommendations as to where you can find more resources on-line and maybe even suggest a few sessions to attend at this very SQL Saturday. So, what will be covered, recovery strategy (you think I mean backups, I don’t, you’ll see why), a touch on performance tuning with a hint of indexing thrown in, add a pinch of high availability and a smattering of security all of which will give you some idea how to answer “now what”.

SessionID: 48317

Stretch Database and Managed Backups: Cloud Services for your SQL Servers

Back to calendar

Event Date: 13-08-2016 - Session time: 08:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrew Loree

Title: Stretch Database and Managed Backups: Cloud Services for your SQL Servers

Abstract:

Utilizing Azure cloud services does not mean moving all of your data or control away from your on-premises SQL Servers. In this session we will cover the new SQL 2016 Stretch Database and the SQL 2014 Managed Backups to Azure features. We will look at use-cases and limitations of both features to illustrate how these cloud services may fit into your current SQL Server environment.

SessionID: 48411

Why “R” you not leveraging the power of “R” in Power BI?!?

Back to calendar

Event Date: 13-08-2016 - Session time: 08:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ryan Wade

Title: Why “R” you not leveraging the power of “R” in Power BI?!?

Abstract:

R is a very powerful statistical programming language that has been gaining a lot of traction in recent years. In early 2015 Microsoft acquired Revolution Analytics, a major provider of software and services for R. Microsoft has since incorporated R in Azure ML, SQL Server 2016, and Power BI.

In this session I will focus on the benefits of using R in Power BI. I will show how to leverage R for data munging (ETL) and I will also show how to leverage R to create custom visualizations. I will focus on the "Wickham stack" which is a group of very popular R packages developed by Hadley Wickham. The “Wickham stack” includes the ggplot2, dplyr, and tidyr packages. I will discuss logical use cases for using R within Power BI as well as some of the pitfalls that you may run into.

SessionID: 50647

Scalable Application Design with Service Broker

Back to calendar

Event Date: 13-08-2016 - Session time: 08:00:00 - Track: Application Database Development

Speaker: Allen White

Title: Scalable Application Design with Service Broker

Abstract:

How your business applications interact directly with the corporate database can dramatically affect how successful you are. One of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates, you can focus performance concerns where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently and minimizes conflicts with your critical updates. This session walks you through the steps to get Service Broker running and providing a consistent delivery of your business data.

SessionID: 50690

Azure, PowerShell, and SQL Server Virtual Machines

Back to calendar

Event Date: 13-08-2016 - Session time: 08:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Volk

Title: Azure, PowerShell, and SQL Server Virtual Machines

Abstract:

SessionID: 50701

SQLStarter - Intro to Big Data

Back to calendar

Event Date: 13-08-2016 - Session time: 08:00:00 - Track: SQLStarter Beginner

Speaker: Josh Fennessy

Title: SQLStarter - Intro to Big Data

Abstract:

Session in the SQLStarter beginner track to introduce big data careers. Will discuss aspects of what this job entails and what day to day could look like in this career path. We'll go over important skills and where to find training information.

SessionID: 52413

ORMs… can’t live with ‘em, can’t kill ‘em.

Back to calendar

Event Date: 13-08-2016 - Session time: 08:00:00 - Track: Application Database Development

Speaker: Aaron King

Title: ORMs… can’t live with ‘em, can’t kill ‘em.

Abstract:

Object-relational mappers enable developers to work with relational databases like Microsoft SQL using the languages they know and love. Sometimes that means that the developers don’t know the underlying queries and statements being sent to the database. This doesn’t mean that the developers don’t love SQL. It just means that they don’t know it yet.

In this session, we’ll look at the latest builds of Microsoft’s Entity Framework and see what programming tools developers use to work with SQL databases. We’ll also take a look at Sequelize. Sequelize is an open source ORM written in JavaScript for Node.js.

We’ll take a look at code first development, advanced querying techniques, connecting to existing databases and migrations. We’ll also take a look at lazy and eager loading techniques. We’ll take a look at these two ORM’s from the eyes of the developer and the DBA.

SessionID: 46955

Peanut Butter Chocolate: Integrating Hadoop with SQL Server

Back to calendar

Event Date: 13-08-2016 - Session time: 09:15:00 - Track: Application Database Development

Speaker: Kevin Feasel

Title: Peanut Butter Chocolate: Integrating Hadoop with SQL Server

Abstract:

So you jumped on the bandwagon and set up a Hadoop cluster…but now what? Your database developers and app developers know how to integrate with and develop against SQL Server, but the Hadoop world is a completely different experience. This talk will help bridge the gap between SQL Server and Hadoop, using tools such as SQL Server Integration Services and Sqoop to migrate data between a Hadoop cluster and a SQL Server instance, as well as PolyBase to integrate the two like never before.

SessionID: 47096

Word Up: Text Mining in SQL

Back to calendar

Event Date: 13-08-2016 - Session time: 09:15:00 - Track: Advanced Analysis Techniques

Speaker: Dave Mattingly

Title: Word Up: Text Mining in SQL

Abstract:

Would a database by any other name smell as sweet?

Our databases are filled with words. By mining our text for patterns and meanings, we can extract the emotional content, track changes over time, ferret out plagiarism, find common phrases and usage, and even predict future text.

Learn how to dig through your library of language to make your data better.

SessionID: 47362

Adding Lightness: Better Performance Through Compression

Back to calendar

Event Date: 13-08-2016 - Session time: 09:15: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: 48534

SQL Server and PowerShell: Let's Get Serious

Back to calendar

Event Date: 13-08-2016 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Drew Furgiuele

Title: SQL Server and PowerShell: Let's Get Serious

Abstract:

Whether you've dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell is something worth learning to make your life as a SQL Server professional easier. Whether you're a DBA, a SSIS developer, or security professional, In this session you'll see practical, real world examples of how you can blend SQL Server and PowerShell together, and not just a bunch of regular T-SQL tasks that have been made more complicated.

SessionID: 48962

Wait Statistics - The Top 5 Waits You Should Know

Back to calendar

Event Date: 13-08-2016 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: David Maxwell

Title: Wait Statistics - The Top 5 Waits You Should Know

Abstract:

Wait statistics are a great tool for troubleshooting performance problems in SQL Server. However, there are so many different wait types in SQL Server, it can be challenging to determine what to focus on and what can be ignored. Even after discovering that SQL Server is waiting for something, most DBAs don't know where to look next. In this session, we'll examine 5 of the most frequently seen wait types in SQL Server and how to troubleshoot each of them. You'll learn how to determine the root cause of a particular wait type, and how to avoid common mistakes made when troubleshooting with wait statistics.

SessionID: 49155

Availability Groups 101: An Introduction

Back to calendar

Event Date: 13-08-2016 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Adam Belebczuk

Title: Availability Groups 101: An Introduction

Abstract:

One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we'll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you're just curious about Availability Groups, then you won't want to miss this session.

SessionID: 50705

SQLStarter - Intro to Data Science

Back to calendar

Event Date: 13-08-2016 - Session time: 09:15:00 - Track: SQLStarter Beginner

Speaker: Dave Leininger

Title: SQLStarter - Intro to Data Science

Abstract:

Session in the SQLStarter beginner track to introduce data science careers. Will discuss aspects of what this job entails and what day to day could look like in this career path. We'll go over important skills and where to find training information.

SessionID: 51230

Power BI SharePoint - A Marriage Made in Redmond

Back to calendar

Event Date: 13-08-2016 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration

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

Learning and Optimizing the SQL Server Plan Cache

Back to calendar

Event Date: 13-08-2016 - Session time: 10:30:00 - Track: Application Database Development

Speaker: Kevin Kline

Title: Learning and Optimizing the SQL Server Plan Cache

Abstract:

SQL Server memory management is one of the most important aspects of a writing T-SQL code. And yet many of us don’t know the fundamentals beyond “SQL Server will take care of that”. In this session, we’ll go deep into the internal behavior of the plan cache. We’ll cover four main problem scenarios within the plan cache, what causes them, and how to fix them, including:

  1. Bloating – scenarios that cause SQL Server to needlessly waste space in the plan cache.
  2. Suboptimal plans – scenarios where SQL Server can’t help but choose a bad execution plan, usually self-inflicted.
  3. Parameter sniffing – situations in which SQL Server specifically chooses a bad execution plan do to the type of parameters pass into T-SQL code.
  4. Recompiles – situations where SQL Server is unable to completely process a block of T-SQL code without having to recompile it.

If you don’t know much about SQL Server memory management, especially if you write T-SQL code, then this session is for you! You’ll learn

SessionID: 50114

An introduction to the magical world of BIML!

Back to calendar

Event Date: 13-08-2016 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jonathan Stewart

Title: An introduction to the magical world of BIML!

Abstract:

Ever feel like you are just doing busy work while creating new SSIS packages? Feel like you are doing the same thing over and over while changing the names to protect the innocent? Ever wonder if there is a better way? Well wonder no more. Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors. Come with intrigue and leave with a fundamental understanding of BIML!

SessionID: 50216

Performance Pitfalls from Code Reuse

Back to calendar

Event Date: 13-08-2016 - Session time: 10:30:00 - Track: Application Database Development

Speaker: Andy Yun

Title: Performance Pitfalls from Code Reuse

Abstract:

Have you ever found yourself deconstructing endless layers of nested code? Is your T-SQL codebase written in an object-oriented format with functions views? Did you know that object-oriented code reuse can come at a significant penalty?

Come to this session and learn why applying object-oriented principles can be extremely detrimental to your T-SQL's performance. You will learn how T-SQL is not like other common programming languages. We will peek inside the Query Optimizer to see how it handles these scenarios. Through extensive demos, we will explore solutions to maximize performance. You will be introduced to a T-SQL tool that will aid you in unraveling nested code. Alternate design patterns will be shown to help you mitigate these performance pitfalls.

SessionID: 50340

SQL Server Encryption

Back to calendar

Event Date: 13-08-2016 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Ben Miller

Title: SQL Server Encryption

Abstract:

Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? What about encrypting your backups? This session will go over all the steps and caveats that go with this technology. TDE allows you to have your database encrypted on disk and the same Encryption Hierarchy allows you to back up your database and have it encrypt the contents in the backup file. We will discuss the Encryption Hierarchy which is used for encryption in SQL Server and take you through keeping your secrets safe. Master the concepts of SQL Server Encryption when you are done with this session.

SessionID: 50437

Using Powershell to Automate Your Restore Strategy

Back to calendar

Event Date: 13-08-2016 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Frank Gill

Title: Using Powershell to Automate Your Restore Strategy

Abstract:

As DBAs, our most important job is protecting the data. Making sure our backups are running successfully gets us halfway there, but those backups are useless if we can’t restore them. Join me for this session to learn how to use Powershell to automate a restore process for backup validation.

SessionID: 50481

Using SQL Nexus for system health

Back to calendar

Event Date: 13-08-2016 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Wendy Pastrick

Title: Using SQL Nexus for system health

Abstract:

How do you determine a root cause of failure in your database server? What do you do with stack dump data and other logging you may be collecting? What do you do if you don't have a 3rd party tool to diagnose issues? Take a look at SQL Nexus, the latest tool for SQL Server aimed at making you a Rockstar DBA! We will cover setup, collection and analysis of the data.

SessionID: 50703

SQLStarter - Intro to DBA

Back to calendar

Event Date: 13-08-2016 - Session time: 10:30:00 - Track: SQLStarter Beginner

Speaker: David Maxwell

Title: SQLStarter - Intro to DBA

Abstract:

Session in the SQLStarter beginner track to introduce the database administrator career. Will discuss aspects of what this job entails and what day to day could look like in this career path. We'll go over important skills and where to find training information.

SessionID: 51158

Data, Statistics, and R Integration with BI...Why you should care!

Back to calendar

Event Date: 13-08-2016 - Session time: 10:30:00 - Track: Advanced Analysis Techniques

Speaker: Dustin Elery

Title: Data, Statistics, and R Integration with BI...Why you should care!

Abstract:

With the introduction of R Services in SQL Server 2016, many professionals and clients are using the buzz words: “Statistical Analysis”, “Statistical Approach”, “Predictive Analytics”, “Open Source R” and many more. This discussion will cover some key differences between the SQL Server R integration and the open source R tools available. I will cover how an organization can use basic statistical modeling to optimize business processes and improve turn-around-time. Finally, I will demonstrate how R can be used to predict future business metrics to help drive business decisions to meet the prediction or avoid the predicted outcome.

SessionID: 46883

What's new in SQL Server 2016

Back to calendar

Event Date: 13-08-2016 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Ross LoForte

Title: What's new in SQL Server 2016

Abstract:

Come to this session to learn the new features and functionalities available in SQL Server 2016.

SQL Server 2016 delivers breakthrough mission-critical capabilities with in-memory performance and operational analytics built-in. Comprehensive security features like new Always Encrypted technology help protect your data at rest and in motion, and a world-class high availability and disaster recovery solution adds new enhancements. Organizations will gain deeper insights into all of their data with new capabilities that go beyond business intelligence to perform advanced analytics directly within their database. Additionally to the ability to dynamically stretch warm and cold transactional data to Microsoft Azure in a secured way.

SessionID: 52550

SQLStarter - Certification/Recruiter Discussion

Back to calendar

Event Date: 13-08-2016 - Session time: 11:45:00 - Track: SQLStarter Beginner

Speaker: John Deardurff

Title: SQLStarter - Certification/Recruiter Discussion

Abstract:

We'll have a split discussion. One portion will discuss certifications. One portion will discuss importance of networking and building a personal brand with a technical recruiter.

SessionID: 53666

Pyramid Analytics BI to Transform into a Data-Driven Organization

Back to calendar

Event Date: 13-08-2016 - Session time: 11:45:00 - Track: Other

Speaker: Andrew Mauch

Title: Pyramid Analytics BI to Transform into a Data-Driven Organization

Abstract:

Pyramid Analytics’ industry-leading Modern BI platform balances IT control and business user success. It offers enterprise capabilities such as advanced data modeling, self-service data discovery, interactive dashboards, and narrative reporting on any device. Here’s what makes Pyramid Analytics unique:

#183; A true analytics platform that combines the security and stability of IT governance with the flexibility and utility of user-driven analysis #183; A scalable platform that supports the volume and variety of data, subject areas, and users across the enterprise #183; The BI Office collaboration engine lets users share analysis, comments, and context to bring the power of the collective to every decision #183; Enterprise-grade, role-based security that enables the right access for the appropriate audiences across the platform – even down to the cell level of content #183; Merging advanced visuals and powerful analytics as well as Pyramid#39;s integration with Power B

SessionID: 53776

Maximizing Microsoft SQL Server Storage Investments

Back to calendar

Event Date: 13-08-2016 - Session time: 11:45:00 - Track: Other

Speaker: Tom Spreacker

Title: Maximizing Microsoft SQL Server Storage Investments

Abstract:

2016 is the year of All-Flash for primary storage and EMC’s industry leading portfolio of All-Flash arrays unlock the speed, efficiency, and agility that your business stakeholders have been demanding. Whether supporting 1,000 or 10,000,000 IOPS, EMC has a broad portfolio to ensure consistent sub-millisecond response time regardless of workload type.

Beyond just production database performance, EMC provides robust database repurposing via our iCDM or Integrated Copy Data Management capabilities. Creating and maintaining test/dev, near real-time analytic, or sandbox environments has never been simpler. Join us and hear how we can address the needs of all of your Microsoft SQL Server instances.

SessionID: 46907

Infrastructure for the DBA: An Introduction

Back to calendar

Event Date: 13-08-2016 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Peter Shore

Title: Infrastructure for the DBA: An Introduction

Abstract:

It doesn’t matter if you are a Junior DBA, an accidental DBA or all the way up to a Senior DBA, the infrastructure your SQL Server environment runs on is important. Many among the DBA community came in as developers or perhaps directly into database administration roles it is equally possible that you have been out of the operations world long enough to have fallen out of the loop with what is happening. This session is intended to provide a full stack infrastructure overview so that you can talk shop with your cohorts in operations to resolve issues and maybe even be proactive. We will discuss, in an introductory fashion, hardware, network, storage, virtualization and operating system layers. Additionally, some suggestions as to where to find more information will be provided.

SessionID: 48543

Clusters! From the ground up, let us build one together

Back to calendar

Event Date: 13-08-2016 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Paul Popovich Jr

Title: Clusters! From the ground up, let us build one together

Abstract:

You're looking to protect your SQL instance from a machine failure. Or maybe your storage budget and tight and you don't want to have your databases in two places with one of the other highly available options that SQL provides. Let's learn what a cluster is and why it might be the right thing for you. We'll explore the system, network, storage and database administration sides of the equation. And, when it's all said and done we'll even have built a SQL clustered instance!

SessionID: 49998

SSAS 2016 Tabular - Diving into the new features

Back to calendar

Event Date: 13-08-2016 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Brian Beswick

Title: SSAS 2016 Tabular - Diving into the new features

Abstract:

Taking a looking at all the new features of SSAS 2016 Tabular, how to use them effectively and avoid pitfalls. Features include Bi-Directional Cross Filtering, Parallel Partition Processing, Calculated Tables, etc.

SessionID: 50564

Using PowerPivot in MS Excel to analyze SQL Server Data

Back to calendar

Event Date: 13-08-2016 - Session time: 13:00:00 - Track: BI Information Delivery

Speaker: Wylie Blanchard

Title: Using PowerPivot in MS Excel to analyze SQL Server Data

Abstract:

Your end users want to analyze data in your data warehouse. They could deal with the learning curve of SSAS but they'd prefer to utilize a familiar application like MS Excel. Welcome PowerPivot, a tool that retrieves data from your data warehouse by combining the power of SSAS models and your SQL Server Data warehouse within the familiar interface of MS Excel. In this presentation well explore SSAS BI Semantic model, PowerView, PowerPivot in Excel.

SessionID: 50704

SQLStarter - Intro to Database Development

Back to calendar

Event Date: 13-08-2016 - Session time: 13:00:00 - Track: SQLStarter Beginner

Speaker: Kevin Kline

Title: SQLStarter - Intro to Database Development

Abstract:

In this session, you will learn the most important aspects of the database developer job and what it entails from a technical and interpersonal perspective. We’ll cover what a day in the life of a database developer looks like, the common salary ranges of this job, as well as job responsibilities. We will also go over important technical skills and where to find deeper training information, such as reading database models, building a database metadata library, basic SQL Server programmatic objects and when to use them, and basic T-SQL transaction writing.

SessionID: 51207

Execution Plans for Mere Mortals

Back to calendar

Event Date: 13-08-2016 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Lawell

Title: Execution Plans for Mere Mortals

Abstract:

Abstract: As a beginner database professional, execution plans are intimidating. In this 1 hour session, I will take you through the basics of reading graphical execution plans and drill into key operators, warnings and properties.

Prerequisites: Basic understanding of T-SQL and the SQL Server Engine. Sections: • You will understand how, why and when the execution plan will be created and saved to plan cache. • Reading the execution plan will be much less intimidating as you can talk 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, the operator properties and identify common performance issues and tuning opportunities. • Finally, you will be able to capture the execution plan, save it for later analysis and comparison after modifications have occurred.

SessionID: 52351

Web APIs for the BI Developer

Back to calendar

Event Date: 13-08-2016 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Chris Koester

Title: Web APIs for the BI Developer

Abstract:

There are thousands of web APIs offering data on a wide range of topics. Web APIs are also a very common way for vendors to provide data to their clients. This session aims to demystify concepts such as REST, tokens, etc., and show you how to obtain data from the web using the SSIS Script Task, PowerShell, and Power Query.

SessionID: 52367

Explore the Microsoft Azure Data Landscape

Back to calendar

Event Date: 13-08-2016 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Bradley Nielsen

Title: Explore the Microsoft Azure Data Landscape

Abstract:

The Microsoft Azure ecosystem has exploded in size and variety in recent years. There are now a multitude of ways to persist your data in the cloud. Trying to choose among the different options can be a daunting task. In this session we will examine the use cases, strengths, and weaknesses of the following data services: SQL Database, SQL Data Warehouse, Document DB, Redis Cache, Storage (Table, Queue, and VM), and Azure Data Lake Store.

SessionID: 46903

All things you need to know before you start setting up SQL AlwaysOn

Back to calendar

Event Date: 13-08-2016 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Steineke

Title: All things you need to know before you start setting up SQL AlwaysOn

Abstract:

Running the Availability Group Wizard, or installing a clustered SQL instance can go pretty smoothly. But in complex and larger networks, that is not always the case. Even if the wizards complete without error and you think you have a highly available system, you may not.

This session will review all the gotcha’s and things you need to know before you run the shiny wizard or run some PowerShell to make your HA/DR implementation of SQL a success.

SessionID: 50455

Overcoming Chartaphobia with Power BI

Back to calendar

Event Date: 13-08-2016 - Session time: 14:15:00 - Track: BI Information Delivery

Speaker: Meagan Longoria

Title: Overcoming Chartaphobia with Power BI

Abstract:

SessionID: 50874

SQLStarter - Intro to BI

Back to calendar

Event Date: 13-08-2016 - Session time: 14:15:00 - Track: SQLStarter Beginner

Speaker: Jim Bennett

Title: SQLStarter - Intro to BI

Abstract:

Session in the SQLStarter beginner track to introduce the business intelligence career. Will discuss aspects of what this job entails and what day to day could look like in this career path. We'll go over important skills and where to find training information.

SessionID: 51019

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

Back to calendar

Event Date: 13-08-2016 - Session time: 14: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 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: 52285

Data Architecture 101

Back to calendar

Event Date: 13-08-2016 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Pat Phelan

Title: Data Architecture 101

Abstract:

This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!

This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.

SessionID: 52295

SQL Server 2016 "Hidden Gems"

Back to calendar

Event Date: 13-08-2016 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Adam Machanic

Title: SQL Server 2016 "Hidden Gems"

Abstract:

By far the most important SQL Server release since the heady days of 2005, SQL Server 2016 represents a huge leap forward in a number of key areas. You've no doubt heard plenty about such features as Query Store, JSON support, Polybase, and the other big-ticket items. But there are also a number of very cool features that don't usually make the top 10 lists. In this talk you'll learn about enhancements to indexing (including both Columnstore and traditional b-tree indexes), DMVs, compression, string handling, encryption, configuration, and even timezone support. These smaller features may not be highlighted in the latest glossy ads from Microsoft's marketing department, but they're the kinds of things that add up to make your life easier. Attend this session to learn all sorts of new and different reasons to upgrade as quickly as possible.

SessionID: 52345

Connecting Power BI to On-Prem Data with SSAS

Back to calendar

Event Date: 13-08-2016 - Session time: 14:15:00 - Track: BI Information Delivery

Speaker: Kerry Tyler

Title: Connecting Power BI to On-Prem Data with SSAS

Abstract:

Microsoft Power BI is going great places. Its great visualizations, easy-to-use tools, and robust sharing capabilities are improving with new releases almost every time you turn around. But, what if uploading or storing your company's data in the cloud is a potential deal-breaker? Fortunately, the Microsoft Power BI Gateway - Enterprise make it possible to live query data in an on-premises SSAS instance for display in Power BI. In this session, we will go through what this gateway does, how it works, and how it is installed to show that BI in the cloud doesn't require data in the cloud.

SessionID: 52392

Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)

Back to calendar

Event Date: 13-08-2016 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Ed Leighton-Dick

Title: Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)

Abstract:

As DBAs, we are asked all sorts of impossible questions. Who dropped that important table last month? Why was everything slow last week? Who made that user a sysadmin? You’d have to be a mind reader to know the answers to some of those, right? Not necessarily! SQL Server can help you find information about these and other common problems with its default trace and system_health Extended Events session, but you have to know how to collect and interpret the data they provide. In this session, we’ll explore what system_health and the default trace are, what information they contain, and how to use them to find the answers you’re searching for.

SessionID: 52750

Making the Accidental DBA Look Good: Ten Insights You Need to Hav

Back to calendar

Event Date: 13-08-2016 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Ford

Title: Making the Accidental DBA Look Good: Ten Insights You Need to Hav

Abstract:

No one grows up saying they want to be a DBA yet there are plenty of us out there. Once in the role you never intended to be in you may find it hard to know where to go to answers - or even what questions to ask. You may find yourself struggling for time to accomplish all you need to do. You're going to feel overwhelmed and be looking for support from others but not know where to turn. In this highly interactive session join Tim as he helps you navigate the most common questions you'll likely face in your first years as a DBA - including a few you may not have considered - and where to go for those answers. He will also give you some of those insider shortcuts that it takes years to stumble across if your lucky. Finally we'll discuss your support mechanisms and he community of like-minded people standing by your side globally and virtually.

Walk away from this session renewed, energized, and full of new insights... plus a downloadable cheat sheet for quick reference!

SessionID: 49885

Migrating your SQL Server Instance

Back to calendar

Event Date: 13-08-2016 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Brandon Lukes

Title: Migrating your SQL Server Instance

Abstract:

Have an old SQL instance hanging around and need to migrate it? Have you had issues migrating a SQL instance before? Well we will cover the basics of migrating SQL. This includes planning, preparing your current environment, setting up the new environment, migrating the databases, and validation.

SessionID: 50022

XML X-Treme!

Back to calendar

Event Date: 13-08-2016 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Aaron Cutshall

Title: XML X-Treme!

Abstract:

At some point we’ve all had to work with XML, and you may have even searched XML documents in a text editor. However, did you know that you can query XML documents within SQL Server? In this session, I’ll show you how you can query XML documents as a data source right along with SQL Server tables and how to optimize your queries for better performance. You’ll learn how to check conditions that determine if the data you need exists and how to deal with incomplete or missing data.

SessionID: 50133

How to Speak Australian: Oracle for the SQL Server Developer

Back to calendar

Event Date: 13-08-2016 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Britton Gray

Title: How to Speak Australian: Oracle for the SQL Server Developer

Abstract:

Even in the career of a SQL Server and/or MSBI expert, you will undoubtedly encounter Oracle databases – most often as source systems or data migrations. While the underlying structures and languages are mostly similar, there are a few differences which can be stumping. We’ll highlight some differences, including: Connecting to Oracle, Databases and schemata, object naming, and differences between T-SQL and PL/SQL, and tool selection.

SessionID: 51206

TempDB Done Right

Back to calendar

Event Date: 13-08-2016 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Eddie Wuerch

Title: TempDB Done Right

Abstract:

Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. There are additional concerns when using Always On Availability Groups. This session will dig into many of the otherwise-hidden issues that can kill server performance. Attend this session and you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.

SessionID: 52381

SQLServer to Google Earth: visualizing spatial data in KML format

Back to calendar

Event Date: 13-08-2016 - Session time: 15:30:00 - Track: Analytics and Visualization

Speaker: Frank Murphy

Title: SQLServer to Google Earth: visualizing spatial data in KML format

Abstract:

Visualizing SQLServer spatial data in Google Earth is easy enough and can be done in a variety of ways. See these various techniques demonstrated and discuss the relative strengths and weaknesses of each approach. These same techniques can be adapted for use with other spatial analysis software packages.

SessionID: 52411

Administration, Security and Data Management in Power BI

Back to calendar

Event Date: 13-08-2016 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ginger Grant

Title: Administration, Security and Data Management in Power BI

Abstract:

Attendees will learn Power BI’s administrative features providing security and best practice methods for development and deployment. As Power BI does not use network security, the importance in things like Group Workspaces to ensure visualizations aren’t lost when people leave the organization are discussed. Practices to increase scalability over time are reviewed. Development of content packs are explored to increase adoption of Power BI while establishing data access standards using scheduled refreshes with gateways. Licensing strategies and use of One Drives and their impact on update strategies are also reviewed.

Without any guidelines, many organizations proliferate data models over time leading to complaints about data accuracy as updates can be random. Learn processes for the use of gateways and their role to prevent rampant data model and create the ability to maintain the quality of the visualizations over time to provide a usable data framework for Power BI.

SessionID: 52414

Microsoft Business Intelligence 2016 – More Love for Your Data

Back to calendar

Event Date: 13-08-2016 - Session time: 15:30:00 - Track: BI Information Delivery

Speaker: Tamera Clark

Title: Microsoft Business Intelligence 2016 – More Love for Your Data

Abstract:

Heartbroken over Microsoft’s neglect of SSRS over the years? Well the 2016 release might start healing that broken heart. This upcoming release boast a handful of great new items; from connecting SSRS PowerBI to mobile report publishing. Join me while I walk you through the best of 2016 for Business Intelligence and help you fall in love with Microsoft BI again.

This site is open source. Improve this page.