sqlsathistory

Nr: 499

Back to Main list

SQLSaturday #499 - Madison 2016

Start Time (24h)	Speaker	Track	Title
09:00:00	Adam Belebczuk	Application Database Development	XML Without Xanax: How to Handle XML in SQL Server
09:00:00	Jared Karney	Enterprise Database Administration Deployment	I Installed SQL Server... Now What?
09:00:00	Jes Schultz	Enterprise Database Administration Deployment	Everyday Extended Events
09:00:00	Pat Phelan	Application Database Development	Data Architecture 101
09:00:00	Gill Rowley	BI Platform Architecture, Development Administration	Introduction to Data Warehousing
09:00:00	Phillip Labry	BI Platform Architecture, Development Administration	Why do I need Analysis Services?
09:00:00	Grant Fritchey	Application Database Development	The Query Store and Query Tuning in SQL Server vNext
09:00:00	Jason Brimhall	Enterprise Database Administration Deployment	Working with Object Compression in SQL Server
09:00:00	Rob Long	BI Information Delivery	Getting More from Analysis Services – Writing Data Back
10:30:00	Gary Schultz	Professional Development	SSMS Tips and Tricks
10:30:00	Paul Popovich Jr	Enterprise Database Administration Deployment	Clusters! From the ground up, let's build one together
10:30:00	Paul Timmerman	Enterprise Database Administration Deployment	SQL Server Hybrid Cloud Strategy: Best Of Both Worlds With On-Prem + Cloud
10:30:00	Ben Miller	Application Database Development	Be Friendly to SQL Server with TSQL Best Practices
10:30:00	Michael Fal	Enterprise Database Administration Deployment	Exploring SQLPS, the SQL Server Powershell Module
10:30:00	Andy Yun	Application Database Development	Every Byte Counts: Why Your Data Type Choices Matter
10:30:00	Jason Strate	BI Platform Architecture, Development Administration	Azure SQL Data Warehouse Overview
10:30:00	Michael Steineke	Enterprise Database Administration Deployment	All things you need to know before you start setting up SQL AlwaysOn
10:30:00	Omni Resources Speaker Panel	Application Database Development	How Developers Can Use SQL 2016
13:00:00	Ross LoForte	Enterprise Database Administration Deployment	What's new in SQL Server 2016
13:00:00	Thomas Lane	Enterprise Database Administration Deployment	"I Love Replication"...Something Rarely if Ever Said By DBAs But Should Be
13:00:00	Bob Pusateri	Enterprise Database Administration Deployment	Introduction to SQL Server Encryption
13:00:00	George Bryant	Analytics and Visualization	Power Query: Making developers redundant since 2015
13:00:00	David Klee	Enterprise Database Administration Deployment	Infrastructure Tuning for SQL Server Performance
13:00:00	Andy Yun	Enterprise Database Administration Deployment	Uncovering Duplicate, Redundant, Missing Indexes
13:00:00	Reed Powell	Professional Development	Surviving a Technical SQL Interview
13:00:00	Brian Larson	BI Information Delivery	Effective Reporting through SSRS Advanced Authoring Features
13:00:00	Seth Bauer	BI Information Delivery	Power BI - A new way to Explore SQL Server Database and Performance Metrics
14:30:00	David Maxwell	Enterprise Database Administration Deployment	The Usual SUSPECTs: When Good Databases Go Bad
14:30:00	Kevin Feasel	BI Platform Architecture, Development Administration	Data Migration Using BIML
14:30:00	Ross Parks	BI Information Delivery	PowerBI Other Self Service BI tools: Where They Fit in the Enterprise.
14:30:00	Luke Jian	Enterprise Database Administration Deployment	Anatomy of an Optimizer
14:30:00	Michael Fal	Enterprise Database Administration Deployment	Managing Availability Groups (What happens after the build!)
14:30:00	Grant Fritchey	Application Database Development	Automating Your Database Deployments
14:30:00	Jared Zagelbaum	Application Database Development	SQL Server 2016 - New Security Features
14:30:00	Elizabeth Block	Enterprise Database Administration Deployment	DBA Cheat Sheet
14:30:00	Julie Koesmarno	BI Platform Architecture, Development Administration	Azure SQL Database Monitoring and Performance Tuning 101
16:00:00	Dave DuVarney	BI Platform Architecture, Development Administration	Architecting Cloud Based BI Solutions using Microsoft Azure
16:00:00	Jes Schultz	Enterprise Database Administration Deployment	Minimize Data Loss with Advanced Restore Methods
16:00:00	John Pertell	Analytics and Visualization	"R" You Ready For SQL 2016?
16:00:00	Colleen Morrow	Enterprise Database Administration Deployment	Enterprise Auditing with SQL Server Audit
16:00:00	David Klee	Enterprise Database Administration Deployment	Objective SQL Server Performance
16:00:00	Ed Leighton-Dick	Application Database Development	Understanding SQL Server 2016 Always Encrypted
16:00:00	Bill Preachuk	Information Delivery	Hadoop for the SQL Server Developer/DBA
16:00:00	Jim Dorame	Application Database Development	JSON for the DBA
16:00:00	Doug Lane	Application Database Development	Living and Dying by Dynamic SQL

SessionID: 42470

XML Without Xanax: How to Handle XML in SQL Server

Back to calendar

Event Date: 09-04-2016 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Adam Belebczuk

Title: XML Without Xanax: How to Handle XML in SQL Server

Abstract:

Do you cringe whenever you have to look at an XML document? Does the very thought of XML data living in your database make you scream? Do you have a panic attack any time you have to parse XML? If you answered yes to any of these questions, then this session is for you!

We'll start with reasons why having XML in SQL Server might be a good thing, then we'll face our fears and turn tabular data into XML, and finally we'll confront the true source of our anxiety by parsing XML back into tabular data using xQuery.

If you survive this session, you'll have faced your fears about XML in SQL Server, you'll have a solid understanding of creating XML from tabular data, and you'll know how to use xQuery to parse XML.

SessionID: 42527

I Installed SQL Server... Now What?

Back to calendar

Event Date: 09-04-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jared Karney

Title: I Installed SQL Server... Now What?

Abstract:

Before handing over a new SQL Server to DevOps or a Dev team, there are several things you should do to follow best practices and ensure optimal performance. In this session, Jared will go through his build checklist and explain why he is doing things like setting Cost Threshold for Parallelism, verifying Kerberos, and checking disk drive settings. When you leave this session, you will have the knowledge and tools to successfully implement a new SQL Server instance – and a copy of his checklist!

SessionID: 44690

Everyday Extended Events

Back to calendar

Event Date: 09-04-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jes Schultz

Title: Everyday Extended Events

Abstract:

As a DBA or developer, you want to know what is happening inside SQL Server. Extended Events are the modern framework for finding and interpreting SQL Server's actions. In this session, you'll see practical examples to solve everyday problems, such as capturing queries and their resources, measuring wait statistics, tracking I/O for database files, and deadlocks. Many useful features will be shown, such as the depth of events, filtering, and multiple target types!

SessionID: 44800

Data Architecture 101

Back to calendar

Event Date: 09-04-2016 - Session time: 09:00: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: 45358

Introduction to Data Warehousing

Back to calendar

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

Speaker: Gill Rowley

Title: Introduction to Data Warehousing

Abstract:

Are you new to Data Warehousing and Business Intelligence? This session will explain the basics of a Data Warehouse, how it is used, why it is used, and how it differs from conventional normalized Relational Databases. We'll cover design basics, ETL strategies, and an over view of a total Data Warehouse Solution, from raw data to report presentation.

SessionID: 45540

Why do I need Analysis Services?

Back to calendar

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

Speaker: Phillip Labry

Title: Why do I need Analysis Services?

Abstract:

Do you write a lot of SSRS reports with SQL queries or stored procedures? Have you heard about analysis services but don't know if it's a good fit for you? Are you trying to decide whether you should go with Tabular or OLAP? Are you thinking about using Power BI? In this session Phillip will go over use cases for Analysis Services and highlight the differences and strengths of each flavor of SSAS. If you have a data warehouse and aren't using SSAS come learn how SSAS will make your users love you.

SessionID: 45650

The Query Store and Query Tuning in SQL Server vNext

Back to calendar

Event Date: 09-04-2016 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Grant Fritchey

Title: The Query Store and Query Tuning in SQL Server vNext

Abstract:

For the most part, query tuning in one version of SQL Server is pretty much like query tuning in the next. SQL Server 2016 introduces a number of new functions and methods that directly impact how you’re going to do query tuning in the future. The most important change is the introduction of the Query Store. This session will explore how the Query Store works and how it’s going to change how you tune and troubleshoot performance. With the information in this session, not only will you understand how the Query Store works, but you’ll know everything you need to apply it to your own SQL Server 2016 tuning efforts as well as your Azure SQL Databases.

SessionID: 46461

Working with Object Compression in SQL Server

Back to calendar

Event Date: 09-04-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Brimhall

Title: Working with Object Compression in SQL Server

Abstract:

SQL Server 2008 introduced object compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What you might not know boils down to some subtleties of compression. For example, not all page compressed objects are entirely page compressed. Many pages can be uncompressed or just row-compressed.

This session shows you how to reach into the database and discover compression states at the page level. At the lower level, this session also shows how to determine compression settings of objects in the database. You can use both some undocumented and more commonly known commands to derive some interesting information from the database engine.

SessionID: 46465

Getting More from Analysis Services – Writing Data Back

Back to calendar

Event Date: 09-04-2016 - Session time: 09:00:00 - Track: BI Information Delivery

Speaker: Rob Long

Title: Getting More from Analysis Services – Writing Data Back

Abstract:

Excel power users have become accustomed to pivot tables displaying data from an Analysis Services Cube. What happens when they want to “tweek” things in what-if-analysis or make future projections? SSAS writeback measure groups allow for these scenarios.

In this demo-centric session we’ll see what it takes to setup and use a writeback enabled measure group. We will work through a specific but simple business use-case to help reinforce the overall process.

SessionID: 43061

SSMS Tips and Tricks

Back to calendar

Event Date: 09-04-2016 - Session time: 10:30:00 - Track: Professional Development

Speaker: Gary Schultz

Title: SSMS Tips and Tricks

Abstract:

This is a 100 level session that anyone who uses SQL Server Management Studio (developers and DBA's alike) may find helpful. We will demonstrate several features that are somewhat hidden, such as split screens, Tab groups, block replacement, RegEx, multi-server queries, SQL Command Mode, templates, query organization tips, connection coloring, Object Explorer Details, and a few FREE add-ins that will make a DBA's job more simple and more productive. I presented the session at work and got the following email from a developer: "Very good presentation today. I've been using SSMS daily for almost 10 years and I was surprised by the number of new tricks I learned."

SessionID: 44130

Clusters! From the ground up, let's build one together

Back to calendar

Event Date: 09-04-2016 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Paul Popovich Jr

Title: Clusters! From the ground up, let's 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: 44932

SQL Server Hybrid Cloud Strategy: Best Of Both Worlds With On-Prem + Cloud

Back to calendar

Event Date: 09-04-2016 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Paul Timmerman

Title: SQL Server Hybrid Cloud Strategy: Best Of Both Worlds With On-Prem + Cloud

Abstract:

For years it seemed that the only message SQL Server professionals were hearing was "to the Cloud.... you must get to the Cloud!". However, if you work in a highly regulated industry, or one simply averse to change, this likely was not an option for you. The good news is, Microsoft heard your feedback and has been busy incorporating Cloud connectivity, compatibility, and functionality into the box product.

Come spend the hour with me and you’ll learn how to leverage the power of the Cloud with your on-premises SQL Server install. We’ll cover backup and restore options with Windows Azure Storage, using Windows Azure VMs for high availability, how to store your data files in Windows Azure Storage, and more. We’ll start with SQL Server 2012 and work our way up to the most recently released bits for SQL Server 2016. You can have the best of both worlds with a SQL Server Hybrid Cloud strategy!

SessionID: 45029

Be Friendly to SQL Server with TSQL Best Practices

Back to calendar

Event Date: 09-04-2016 - Session time: 10:30:00 - Track: Application Database Development

Speaker: Ben Miller

Title: Be Friendly to SQL Server with TSQL Best Practices

Abstract:

TSQL is a necessity when interacting with SQL Server so knowing can be half the battle. Performance is always good as the database starts to grow, but building in resilience when you begin is a greater advantage than refactoring. I will go over 5 key things to know when you write TSQL, use DataTypes and/or variables in comparisons and you will also learn about the procedure cache and how to avoid pitfalls there. This is a beginners session but the concepts in this session are a great foundation to begin with. If you are looking for a solid foundation to build on and need the basics to start, this session is definitely for you.

SessionID: 45443

Exploring SQLPS, the SQL Server Powershell Module

Back to calendar

Event Date: 09-04-2016 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Fal

Title: Exploring SQLPS, the SQL Server Powershell Module

Abstract:

A big hurdle for using Powershell and SQL Server together is the SQLPS module. Both old and new users of Powershell don’t completely understand its capabilities. In this session, we’ll talk about the cmdlets you may not know about, tricks to save time using the provider, and even a few gotchas on how the provider works that can save you some time and energy. When we’re finished, you will have a deeper understanding of how you can use SQL Server and Powershell together.

SessionID: 45790

Every Byte Counts: Why Your Data Type Choices Matter

Back to calendar

Event Date: 09-04-2016 - Session time: 10:30:00 - Track: Application Database Development

Speaker: Andy Yun

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

Abstract:

Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns? Did your gut tell you that this is bad, but you had difficulty explaining why? Did you know that these data type choices can be a real performance killer?

Attend this session to learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now!

When you leave, you will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.

SessionID: 46494

Azure SQL Data Warehouse Overview

Back to calendar

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

Speaker: Jason Strate

Title: Azure SQL Data Warehouse Overview

Abstract:

Microsoft recently announced the SQL Data Warehouse Platform as a Service (PaaS) feature for Microsoft Azure. This platform provides an on-demand Massively Parallel Processing (MPP) platform for build data warehouses that can handle from 10s of TBs of data up to PBs. This session will provide an overview of SQL Data Warehouse with a discussion on the value that Massively Parallel Processing (MPP) brings to your data warehouse and why the cloud may be the best platform for your solution. In this session, we’ll also dig into the capabilities of SQL Data Warehouse and compare those to other offerings.

• Scale from terabytes to petabytes • Save on costs through on-demand scale • Take advantage of architecture designed for scalable performance • Gain a cloud integrated data warehouse solution

SessionID: 46498

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

Back to calendar

Event Date: 09-04-2016 - Session time: 10:30: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: 49187

How Developers Can Use SQL 2016

Back to calendar

Event Date: 09-04-2016 - Session time: 10:30:00 - Track: Application Database Development

Speaker: Omni Resources Speaker Panel

Title: How Developers Can Use SQL 2016

Abstract:

The release of SQL Server 2016 is right around the corner, and DBAs will be eager to encourage their companies to upgrade. Engineers and developers have a lot to gain in the feature set of SQL Server 2016, but may not know exactly how the upgrade will benefit them. You can help!

In this session, we’ll share what our development team loves about SQL Server 2016. Arm yourself with useful tips, tricks and ideas to share with YOUR developers to help generate excitement. With a better understanding of the benefits, they will be much more likely to help you build the case to upgrade at your company.

SessionID: 42391

What's new in SQL Server 2016

Back to calendar

Event Date: 09-04-2016 - Session time: 13:00: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: 42993

"I Love Replication"...Something Rarely if Ever Said By DBAs But Should Be

Back to calendar

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

Speaker: Thomas Lane

Title: "I Love Replication"...Something Rarely if Ever Said By DBAs But Should Be

Abstract:

As luck would have it you need to get data from point A to point B on a regular basis so someone suggests replication. Many things run through your mind like maybe I could deliver the data myself I have a few thumb drives, “who is the DBA anyway?”and then finally which replication model and which type would be best to fit our needs? This talk will go over all replication options available in SQL Server along which the many of the pitfalls and gotchas you should be aware of before setting things up. An outline of steps and processes to put in place once replication has been set up to maintain and monitor the publication will also be provided.

SessionID: 44863

Introduction to SQL Server Encryption

Back to calendar

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

Speaker: Bob Pusateri

Title: Introduction to SQL Server Encryption

Abstract:

High-profile attacks by hackers have made the news more and more the past few years, and your database is a prized target! Fortunately SQL Server offers many possible layers of protection, one of which is encryption. This session will cover SQL Server's encryption capabilities, how they work, and what they have to offer. Topics discussed will include certificates, encryption algorithms, backup encryption, transparent database encryption, and column-level encryption. Attend this session and learn how SQL Server can help you hide your data in plain sight!

SessionID: 45130

Power Query: Making developers redundant since 2015

Back to calendar

Event Date: 09-04-2016 - Session time: 13:00:00 - Track: Analytics and Visualization

Speaker: George Bryant

Title: Power Query: Making developers redundant since 2015

Abstract:

Power Query is a wonderful Excel tool which also has ties and carryovers in Power BI. What is truly great about it however is that you can use it for anything, therefore this is a session for how the layman can use Power Query to beat the odds and learn some development basics in the process.

SessionID: 45201

Infrastructure Tuning for SQL Server Performance

Back to calendar

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

Speaker: David Klee

Title: Infrastructure Tuning for SQL Server Performance

Abstract:

Mention SQL Server performance to any DBA, and the impulse is to dive headfirst into the database and queries. However, if the infrastructure underneath the data is your performance bottleneck, the time spent tuning at the database layer is usually in vain. Server hardware, operating system parameters, storage, interconnects, and networking will all be discussed in depth in terms that DBAs can relate to. Practical architecture guidelines and troubleshooting techniques will be presented so you can analyze your environments and see if your performance bottlenecks are where you think they are.

SessionID: 45789

Uncovering Duplicate, Redundant, Missing Indexes

Back to calendar

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

Speaker: Andy Yun

Title: Uncovering Duplicate, Redundant, Missing Indexes

Abstract:

Do you design your database's indexes? Well, have you ever analyzed how those indexes are being used, if at all? And do you know if SQL Server needs other indexes to improve performance? Attend this session and discover how SQL Server tracks actual index usage. We will use this data to identify wasteful, unused, redundant indexes. Finally, we will dive into the Missing Index DMV and learn how to make proper use of its recommendations. We will spend the second half of this session interactively working through a demo exercise, to reinforce the entire process.

SessionID: 45916

Surviving a Technical SQL Interview

Back to calendar

Event Date: 09-04-2016 - Session time: 13:00:00 - Track: Professional Development

Speaker: Reed Powell

Title: Surviving a Technical SQL Interview

Abstract:

At some point every SQL interview is going to get technical. This session will go through my favorite questions as an interviewer and talk about their overall relevance and answers. We'll talk about how to handle the situations where you aren't sure of the answer - or when you know that you don't know the answer The questions will cover database design, DBA, SSIS and SSRS aspects of SQL server. Pointers to resources will also be given.

SessionID: 46063

Effective Reporting through SSRS Advanced Authoring Features

Back to calendar

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

Speaker: Brian Larson

Title: Effective Reporting through SSRS Advanced Authoring Features

Abstract:

Effective reporting is not simply the output of data, but the meaningful presentation of that data in a manner that informs the user. SQL Server Reporting Services provides a myriad of features to create a clear, instructive, and interactive experience. This session will demonstrate techniques to utilize SSRS advanced authoring features to facilitate more informative communication. These features include: nesting data regions, leveraging scope, geographic/geometric reporting, complex charting, rich formatting, incorporating managed code assemblies, intuitive drilldown, data from multiple datasets in a single data region, datasets that update source data, and more.

SessionID: 46124

Power BI - A new way to Explore SQL Server Database and Performance Metrics

Back to calendar

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

Speaker: Seth Bauer

Title: Power BI - A new way to Explore SQL Server Database and Performance Metrics

Abstract:

Power BI is a powerful analytics tool. It allows users to easily shape and transform their data into actionable insights in a very short period of time. We’ll explore how the tool can connect to your SQL Server database and allow you to visualize Database and Performance Metrics, such as, file size, Buffer Pool and Plan Cache, Wait Stats and more. We will create visualizations and reports in Power BI Desktop using SQL queries, publish that information to the Power BI Service, and walk through sharing and mobile consumption. The goal of this session is to provide you with a better understanding of how to leverage Power BI for yourself and your organization.

SessionID: 42942

The Usual SUSPECTs: When Good Databases Go Bad

Back to calendar

Event Date: 09-04-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: David Maxwell

Title: The Usual SUSPECTs: When Good Databases Go Bad

Abstract:

You just finished patching your SQL Server. After rebooting it, though, some of your databases aren't coming online. What do you do? In this session we'll cover some of the various states that a database can be in. We’ll look at useful states like OFFLINE and STANDBY, as well as damaged states like SUSPECT or RECOVERY_PENDING. You’ll learn how databases get into those states, and the proper techniques to bring your data safely back online.

SessionID: 44185

Data Migration Using BIML

Back to calendar

Event Date: 09-04-2016 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Kevin Feasel

Title: Data Migration Using BIML

Abstract:

Many companies scale out their databases horizontally, partitioning data by customer (or some other identifier) into separate databases or instances. Sometimes, it becomes important to move that data from one database to another. SQL Server Integration Services is a fantastic tool for ETL, but creating and maintaining dozens or hundreds of data flows by hand is exhaustingly tedious. Instead of doing it the hard way, use the BI Markup Language (BIML) to automate package development. This talk will show how we can use metadata tables and BIML to auto-create SSIS packages to migrate data from one database to another, handling foreign key constraints along the way.

SessionID: 44388

PowerBI Other Self Service BI tools: Where They Fit in the Enterprise.

Back to calendar

Event Date: 09-04-2016 - Session time: 14:30:00 - Track: BI Information Delivery

Speaker: Ross Parks

Title: PowerBI Other Self Service BI tools: Where They Fit in the Enterprise.

Abstract:

Self-service BI tools such as Power BI and Tableau provide business users the ability to use their data when they need it – without relying heavily on IT. Self-service BI tools speed up analysis, take strain off of IT for BI requests, and allow businesses to truly be more data driven. Power BI or Tableau alone usually won't be complete BI solutions; they're designed to be pieces of a larger enterprise puzzle. In this session Ross Parks, will talk about where Power BI stands in the market of self-service BI tools and how it can be utilized within an enterprise. He will also demonstrate multiple implementation strategies for companies considering a self-service BI tool. Ross Parks has worked with several companies across with Wisconsin to implement self-service BI tools and will discuss his experiences as use-case examples.

SessionID: 44923

Anatomy of an Optimizer

Back to calendar

Event Date: 09-04-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Luke Jian

Title: Anatomy of an Optimizer

Abstract:

In this session, we look in depth at how the query processor architecture and show what operations it performs during query optimization to generate equivalent query plans and find a “good enough” plan with limited time during query optimization, explain query optimization phases and show a few DMVs that are useful when diagnosing optimizer behavior

We will also explore the differences between In-Memory OLTP tables vs Disk based tables, and have a look at some considerations when you use the new cardinality estimator We explain why query optimization complexity increases exponentially with the number of tables included in the plan, and how to diagnose and remedy issues that relate to bad query plans

SessionID: 45444

Managing Availability Groups (What happens after the build!)

Back to calendar

Event Date: 09-04-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Fal

Title: Managing Availability Groups (What happens after the build!)

Abstract:

Have you built a SQL Server Availability Group only to be suddenly surprised by all the gotchas and hurdles that pop up? Are you struggling with keeping your Availability Group running smoothly without a lot of management on your part? This session will cover what happens after you have created an Availability Group and how to manage it. We will review tips, tricks, and patterns for handling all the considerations that running this popular high availability solution. After this session, you will be prepared for managing your Availability Groups and how you can streamline that management to make your availability strategy more robust.

SessionID: 45648

Automating Your Database Deployments

Back to calendar

Event Date: 09-04-2016 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Grant Fritchey

Title: Automating Your Database Deployments

Abstract:

Deploying your database changes to production can be nerve-wracking as you introduce changes while attempting to protect your data. In order to take the stress out of these deployments, you must ensure that you practice your deployments before you ever get near production. This session shows how automating the deployment and testing processes through your various development and pre-production environments can make the whole experience of production deployments more repeatable, more reliable and more robust.

In this session, we'll explore the concepts of continuous integration and continuous delivery for databases – what to consider, the challenges, the benefits, the testing, and the crucial approval gates necessary for a reliable production deployment. We'll discuss these and other release strategies as you think about how to evolve your deployment pipeline towards a more automated approach, starting with continuous integration and ending at your production systems.

SessionID: 45654

SQL Server 2016 - New Security Features

Back to calendar

Event Date: 09-04-2016 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Jared Zagelbaum

Title: SQL Server 2016 - New Security Features

Abstract:

SQL Server 2016 is the latest version of the data platform from Microsoft (currently in public preview). Per Microsoft, “It is the biggest leap forward in Microsoft's data platform history with real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technology, and new hybrid cloud scenarios.”

There’s a ton of ground to cover on all of the new enhancements, so this session will focus on some of the new advanced security offerings that Microsoft has incorporated into the platform: Dynamic Data Masking, Row-Level Security, and Always Encrypted.

SessionID: 46463

DBA Cheat Sheet

Back to calendar

Event Date: 09-04-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Elizabeth Block

Title: DBA Cheat Sheet

Abstract:

Do you have trouble remembering common administrative T-SQL commands? Remember when you created a cheat sheet in school to help you study for an exam? Use that same principle with the DBA Cheat Sheet! The DBA Cheat Sheet is a document filled with some basic administrative TSQL commands you’ll need in your daily work. During the session I’ll show you a few SSMS tricks and review some of the topics in the DBA Cheat Sheet document. You’ll leave the session with a document that you can use as a reference every day.

SessionID: 46680

Azure SQL Database Monitoring and Performance Tuning 101

Back to calendar

Event Date: 09-04-2016 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Julie Koesmarno

Title: Azure SQL Database Monitoring and Performance Tuning 101

Abstract:

Choosing appropriate performance levels, monitoring and optimizing resource usage of Azure SQL database is of primary interest to SQL database users. Azure SQL DB now has a number of great tools to help sizing, scaling, monitoring and performance tuning your database solutions. This talk will provide an overview of resource usage monitoring, scaling capabilities and techniques as well as performance tuning tools that you can use today, such as Query Store, Index Advisor, Extended Events and DMVs

SessionID: 44331

Architecting Cloud Based BI Solutions using Microsoft Azure

Back to calendar

Event Date: 09-04-2016 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dave DuVarney

Title: Architecting Cloud Based BI Solutions using Microsoft Azure

Abstract:

Companies today use a variety of core systems including on-premise applications and SaaS solutions. Additionally, the landscape of data analysis tools is continually changing. Microsoft is releasing services and tools at a break neck pace.

In this session we will break down the major architectural components of a BI solution and look at both how they were implemented in the past and how services in Microsoft Azure are changing that. We’ll view various different architecture scenarios and discuss the pros and cons of each.

SessionID: 44691

Minimize Data Loss with Advanced Restore Methods

Back to calendar

Event Date: 09-04-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jes Schultz

Title: Minimize Data Loss with Advanced Restore Methods

Abstract:

Data loss can strike any server at any time. Are you prepared for the inevitable? A good DBA takes regular backups and practices regular restores; a great DBA has advanced restore techniques planned and tested. In this session, I will demonstrate three advanced restore methods that can make you a great DBA - point-in-time restores, page restores, and piecemeal restores, and will discuss the appropriate situations when each should be considered. Attend this session to better protect your business and your job.

SessionID: 44795

"R" You Ready For SQL 2016?

Back to calendar

Event Date: 09-04-2016 - Session time: 16:00:00 - Track: Analytics and Visualization

Speaker: John Pertell

Title: "R" You Ready For SQL 2016?

Abstract:

R is one of the fastest growing programming languages, useful for data analysis and visualization. You've been able to connect to SQL databases to work with large data sets before using R packages. But now, with the upcoming SQL 2016 release, R will be included as an Advanced Analytics Extension. You'll be able to run the same R scripts right in your database.

In this beginner session we will look at how to set up R on your SQL instance. We'll work with some sample data to show how R works with SQL inside and outside the database with some basic R commands. And we'll create some graphs and charts for use in some SSRS reports.

SessionID: 45196

Enterprise Auditing with SQL Server Audit

Back to calendar

Event Date: 09-04-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Colleen Morrow

Title: Enterprise Auditing with SQL Server Audit

Abstract:

Audit. The very word strikes fear in the bravest of hearts. But as a DBA, the need to know who is doing what in your production databases is critical. In SQL Server 2008, Microsoft finally gave us a true auditing tool. But how does it work, what exactly can it track, and how can you handle its output?

In this session, we cover SQL Server Audit from the ground up. We go from the basics of which events can be audited to a look at how SQL Server Audit works "under the covers", and what that means for performance. While implementing server and database audits, we discuss audit granularity and filtering, as well as the pros and cons of Audit's output options.

Whether it's through the SQL Server Management Studio (SSMS) interface, via T-SQL, or using PowerShell and Server Management Objects (SMO), at the end of this session you'll be able to deploy SQL Server Audit across your enterprise and manage its output, fearlessly.

SessionID: 45203

Objective SQL Server Performance

Back to calendar

Event Date: 09-04-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: Objective SQL Server Performance

Abstract:

“It’s slow! FIX IT!” is not a fun way to walk into the office on a Monday morning. However, putting objective metrics to the subjectivity of ‘slow’ is as much a science as it is art. Performance engineering takes effort well before an issue arises. Collecting the right metrics, trending and comparing against an established baseline, and identifying bottlenecks are all part of the performance process. This interactive session will help the DBA fine-tune their performance tuning approach so that the foundation for long-term proactive performance review is in place. The DBA can then shift the job responsibilities from a reactive response to a more predictive and proactive role.

SessionID: 45481

Understanding SQL Server 2016 Always Encrypted

Back to calendar

Event Date: 09-04-2016 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Ed Leighton-Dick

Title: Understanding SQL Server 2016 Always Encrypted

Abstract:

Always Encrypted is a highly-touted new feature of SQL Server 2016 that promises to make encryption simple to use and transparent to applications while still protecting the data both at rest and in motion, even from high-privilege users such as developers and DBAs. Does that sound too good to be true? It isn’t - Always Encrypted is an incredible feature - but like any new technology, it does have some limitations. In this session, you’ll see how to configure Always Encrypted, and we’ll talk about when you should and shouldn’t use it in your environment.

SessionID: 46388

Hadoop for the SQL Server Developer/DBA

Back to calendar

Event Date: 09-04-2016 - Session time: 16:00:00 - Track: Information Delivery

Speaker: Bill Preachuk

Title: Hadoop for the SQL Server Developer/DBA

Abstract:

Are you new to Hadoop? In this beginner-friendly (but technical) session you'll learn about the Hortonworks Data Platform (HDP) and Microsoft HDInsight from the ground up with a focus on what SQL Server professionals like yourself need to know.

We will go into technical detail about what HDFS, MapReduce and YARN/Tez actually are how they work. Then you'll discover the Hadoop ecosystem and the myriad of projects within. We'll see demos of how Hive complements the traditional relational database world, and discuss real-world data tasks/use cases that Hadoop can accomplish.

SessionID: 46407

JSON for the DBA

Back to calendar

Event Date: 09-04-2016 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Jim Dorame

Title: JSON for the DBA

Abstract:

In SQL Server 2016 Microsoft has include native handling of JSON. What does that mean? What is JSON? Why do I care? Will there be knives and hockey masks? Come to this session and you will learn what JSON is, where and how it is used and why as a DBA you need to know this.

SessionID: 46505

Living and Dying by Dynamic SQL

Back to calendar

Event Date: 09-04-2016 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Doug Lane

Title: Living and Dying by Dynamic SQL

Abstract:

Ask any DBA if they want to manage dynamic SQL: "Impossible-to-read source code and SQL injection? No thanks!" they'll say. However, dynamic SQL not a tool of the desperate and unskilled. It is flexible and makes complex queries screaming fast when more conventional methods cannot. In this session, we focus on:

• Understanding pros and cons of dynamic SQL
• Writing fast and efficient dynamic SQL code
• Monitoring dynamic SQL statements and their performance

To spark discussion and keep the audience riveted, this session is styled as a technical presentation weaved into an interactive murder mystery, complete with suspects, interrogations, and clues. Attendees form small groups to observe, discuss, and ultimately solve the mystery of the deadly dynamic SQL.

Developers and DBAs: if you want to become wise in the ways of dynamic SQL, this session is for you. Be sure to bring your sleuthing skills!

This site is open source. Improve this page.