sqlsathistory

Nr: 653

Back to Main list

SQLSaturday #653 - Columbus 2017

Start Time (24h)	Speaker	Track	Title
08:30:00	Kevin Feasel	Application Database Development	Polybase In Action
08:30:00	Vladimir Oselsky	Application Database Development	Crash Course on Better SQL Development
08:30:00	Allen White	Enterprise Database Administration Deployment	Emergency! Are You Ready for Disaster to Strike?
08:30:00	Cassandra Faris	Professional Development	Health: The Most Important Tech Tool
09:45:00	Aaron Cutshall	Professional Development	How To Give a Technical Presentation
09:45:00	Jonathan Stewart	BI Administration, Development Analytics	Data Visualization: How to truly tell a great story!
09:45:00	Tracy Boggiano	Enterprise Database Administration Deployment	Collecting Baseline Metrics
09:45:00	Dan Andrews	Application Database Development	The DBA's Role With N-tier Applications
09:45:00	John Morehouse	Application Database Development	SQL Server Databaseology: A Deep Dive Into Database Internals
11:00:00	Greg Deckler	BI Administration, Development Analytics	Power BI and Azure ML - Better Together!
11:00:00	Paul Popovich Jr	Enterprise Database Administration Deployment	Distributed Replay 101
11:00:00	Warren Sifre	Cloud Application Development Deployment	Introduction to Azure Streaming Analytics
11:00:00	Kerry Tyler	BI Administration, Development Analytics	45 Minutes to Your First SSAS Tabular Model
11:00:00	Wendy Pastrick	Application Database Development	Why NULL is not a value (and other SQL gotchas)
13:00:00	Azhagappan Arunachalam	BI Administration, Development Analytics	SQL Server - R Services
13:00:00	Robert Davis	Application Database Development	Securing SQL Server Processes with Certificates
13:00:00	Monica Rathbun	Professional Development	I’m It – Survival Techniques for the Lone DBA
13:00:00	Rob Volk	Enterprise Database Administration Deployment	Revenge: The SQL!
13:00:00	Pat Phelan	Professional Development	Ethics, Morals, and Laws for the DBA 101
14:15:00	Eugene Meidinger	BI Administration, Development Analytics	Power BI Internals: a Deep Dive
14:15:00	Drew Furgiuele	Enterprise Database Administration Deployment	SQL Server Transactional Replication: A Deep Dive
14:15:00	Sam Nasr	Application Database Development	Introduction to Temporal Tables
14:15:00	Jacquelyn Keeper	Application Database Development	Are You There, DBA? It’s Me, The App Developer
14:15:00	Erin Stellato	Application Database Development	Answering the question, "What happened?" with Query Store
15:30:00	Stacia Varga	BI Administration, Development Analytics	Where Does R Fit Into Your SQL Server Stack?
15:30:00	Bert Wagner	Application Database Development	DBAs vs Developers: JSON in SQL Server 2016
15:30:00	Michael Fal	Cloud Application Development Deployment	Intro to Azure SQL Databases
15:30:00	Elizabeth Noble	Application Database Development	Making Your List and Checking It Twice: Introduction to unit testing with tSQLt
15:30:00	Tamera Clark	Enterprise Database Administration Deployment	Reduce your DBA ( DEV) task list by using Microsoft BI tools

SessionID: 63770

Polybase In Action

Back to calendar

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

Speaker: Kevin Feasel

Title: Polybase In Action

Abstract:

Polybase is Microsoft's newest way of integrating SQL Server with external systems such as Hadoop and Azure Blob Storage. In this talk, we will get an overview of the Polybase technology and then implement it to work with an on-premises Hadoop cluster as well as Azure Blob Storage. We will then dive into the mechanics of how Polybase works, using packet captures to understand the cross-network communication. Finally, we will look at ways of tuning common Polybase scenarios and look at a few less-common scenarios.

SessionID: 64051

Crash Course on Better SQL Development

Back to calendar

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

Speaker: Vladimir Oselsky

Title: Crash Course on Better SQL Development

Abstract:

SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.

SessionID: 64452

Emergency! Are You Ready for Disaster to Strike?

Back to calendar

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

Speaker: Allen White

Title: Emergency! Are You Ready for Disaster to Strike?

Abstract:

Most of the time pilots are learning to fly, they're actually learning how to recover from emergency conditions. While we as Database Administrators focus on taking backups, how much time do we actually spend practicing recovering with those backups? This session will focus on the kinds of situations that can dramatically affect a data center, and how to use checklists to practice recovery processes to assure business continuity.

Learning objectives: 1 Understand the kinds of issues that can arise in critical data environments 2 Understand the expectations for performance and recovery of those data environments 3 Define a Personal Minimums contract for meeting the data availability expectations of the business

SessionID: 65614

Health: The Most Important Tech Tool

Back to calendar

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

Speaker: Cassandra Faris

Title: Health: The Most Important Tech Tool

Abstract:

Working in the tech industry often involves spending long hours sitting down, staring at a screen, consuming copious amounts of pizza and caffeine. The work is mentally demanding and can be stressful. In the rush to get everything done, it can be easy to neglect our health. But a healthy body and mind are necessary for effective performance. Based on HR training, research, and personal experience, this session provides realistic suggestions for managing your well-being at work. It covers the connection between physical and mental health, as well as how to discuss these topics with your employer. You’ll leave with a better idea of how to take care of yourself and be a happier, healthier, more productive person.

SessionID: 64168

How To Give a Technical Presentation

Back to calendar

Event Date: 22-07-2017 - Session time: 09:45:00 - Track: Professional Development

Speaker: Aaron Cutshall

Title: How To Give a Technical Presentation

Abstract:

Most people don't like to speak in public and technical folks are certainly no exception. Yet, you've got some ideas for a great presentation but just don't know how to go about putting it all together. On top of that, how do you go about giving the presentation itself? This session will cover how to pull your material together in an organized fashion and present it such that your audience can follow along and get the message you want to relay. We'll also discuss how to deal with issues that cause presenters stress to help you to make the process enjoyable and rewarding for all.

SessionID: 65273

Data Visualization: How to truly tell a great story!

Back to calendar

Event Date: 22-07-2017 - Session time: 09:45:00 - Track: BI Administration, Development Analytics

Speaker: Jonathan Stewart

Title: Data Visualization: How to truly tell a great story!

Abstract:

We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…

SessionID: 65365

Collecting Baseline Metrics

Back to calendar

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

Speaker: Tracy Boggiano

Title: Collecting Baseline Metrics

Abstract:

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

SessionID: 65391

The DBA's Role With N-tier Applications

Back to calendar

Event Date: 22-07-2017 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Dan Andrews

Title: The DBA's Role With N-tier Applications

Abstract:

This session is for DBAs with little or no application architecture experience and/or application developers who want to work on enterprise applications. We'll go over N-tier applications, what are the different tiers, and why DBAs should encourage enterprise application development in their company. While the architecture is independent of any specific language, any examples will be in C#. If done right, multiple languages can access the data in the same way and receive the same results.

SessionID: 65775

SQL Server Databaseology: A Deep Dive Into Database Internals

Back to calendar

Event Date: 22-07-2017 - Session time: 09:45:00 - Track: Application Database Development

Speaker: John Morehouse

Title: SQL Server Databaseology: A Deep Dive Into Database Internals

Abstract:

Have you ever taken apart a toaster or an alarm clock just to see how it worked? Ever wondered how that database actually functions at the record level, behind the scenes? SQL Server Databaseology is the study of SQL Server databases and their structures down to the very core of the records themselves. In this session, we will explore some of the deep inner workings of a SQL Server database at the record and page level. You will walk away with a better understanding of how SQL Server stores data and that knowledge will allow you to build better, faster databases.

SessionID: 63814

Power BI and Azure ML - Better Together!

Back to calendar

Event Date: 22-07-2017 - Session time: 11:00:00 - Track: BI Administration, Development Analytics

Speaker: Greg Deckler

Title: Power BI and Azure ML - Better Together!

Abstract:

There has been a lot of interest in the analytics community in visualizing the output of an Azure Machine Learning model inside Power BI. To add to the challenge, it would also be great to operationalize Azure ML models through the Power BI service. Imagine if you could have Power BI regularly bring in the latest output of your fraud model or the sentiment for recent Tweets about your products. This session will outline and demonstrate a proposed approach for doing just that.

SessionID: 64069

Distributed Replay 101

Back to calendar

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

Speaker: Paul Popovich Jr

Title: Distributed Replay 101

Abstract:

Before you go and move that mission critical application to a new version of SQL or new hardware you are probably creating some sort of testing and benchmarking scenarios to ensure a smooth upgrade. Right? Come learn how distributed replay can capture your workload and play it back on your new instance. Be it an upgrade of SQL or hardware we can review all sorts of scenarios to help make your upgrade a smooth process.

SessionID: 64666

Introduction to Azure Streaming Analytics

Back to calendar

Event Date: 22-07-2017 - Session time: 11: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: 65754

45 Minutes to Your First SSAS Tabular Model

Back to calendar

Event Date: 22-07-2017 - Session time: 11:00:00 - Track: BI Administration, Development Analytics

Speaker: Kerry Tyler

Title: 45 Minutes to Your First SSAS Tabular Model

Abstract:

Have you been watching SSAS Tabular develop? What about the new Azure Analysis Services product? Or you've looked at these and like what they can add in Power BI or classic BI scenarios, but haven't had a chance to dive in and figure all of this out? Now is the time!

SSAS Tabular is a new-ish form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, in addition to the various options for deployment, before exploring the development process of creating a tabular model ready for ad-hoc querying through Excel or Power BI.

SessionID: 66529

Why NULL is not a value (and other SQL gotchas)

Back to calendar

Event Date: 22-07-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Wendy Pastrick

Title: Why NULL is not a value (and other SQL gotchas)

Abstract:

Allowing NULL "values" in your database is simple, but managing them is a whole different story. Learn what NULL really means and why you may want to avoid it in your systems. I will share techniques for overcoming NULL and other SQL idiosyncrasies leading to bad data or incorrect query results.

SessionID: 63754

SQL Server - R Services

Back to calendar

Event Date: 22-07-2017 - Session time: 13:00:00 - Track: BI Administration, Development Analytics

Speaker: Azhagappan Arunachalam

Title: SQL Server - R Services

Abstract:

SQL Server R Services: Microsoft acquired Revolution Analytics in early 2015, and introduced R services (in-database/stand-alone) with SQL Server 2016 this year. With the first Microsoft Data Science summit behind us this past Sept, in Atlanta, let us review what R Services in SQL Server brings to the table and see how it complements/supersedes features that are available with other R offerings (R GUI, Microsoft R Client [R Studio], Microsoft R Open [RROpen], Microsoft R Server[RREnterprise] etc.,)

SessionID: 64138

Securing SQL Server Processes with Certificates

Back to calendar

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

Speaker: Robert Davis

Title: Securing SQL Server Processes with Certificates

Abstract:

What do you do if the DBA won’t let you enable the Trustworthy setting?

Things like Trustworthy and cross-database ownership chaining open up huge security threats. Fortunately, there’s a better way.

You can secure things like cross-database operations, service broker communication, and high-privileged stored procedure execution with certificates via a process call signing. Additionally things like CLR assemblies that need external access can be executed safely using signed assemblies instead of enabling Trustworthy.

This session will cover common processes that can be secured through certificate signing, show how to sign the processes, and cover some basics of certificate management.

Note: this session does not cover securing SQL Server connections with SSL or self-signed certificates.

SessionID: 64437

I’m It – Survival Techniques for the Lone DBA

Back to calendar

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

Speaker: Monica Rathbun

Title: I’m It – Survival Techniques for the Lone DBA

Abstract:

Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We’ll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you’ll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.

SessionID: 65424

Revenge: The SQL!

Back to calendar

Event Date: 22-07-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Volk

Title: Revenge: The SQL!

Abstract:

Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?

Hint: You attend Revenge: The SQL!

This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!

Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.

SessionID: 65719

Ethics, Morals, and Laws for the DBA 101

Back to calendar

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

Speaker: Pat Phelan

Title: Ethics, Morals, and Laws for the DBA 101

Abstract:

Ethics, Morals, and Laws each aspects of our behavior as people and DBAs. They govern which actions we take and which actions we avoid.

Understanding the basics of these guides and how they coordinate (and sometimes conflict) with each other helps you to make choices you can live with from both a personal and professional perspective.

This session presents basic definitions, ideas, and discussion points. It is intended to be an interactive presentation where the audience contributes to the discussion, so no two presentations are exactly the same!

SessionID: 63758

Power BI Internals: a Deep Dive

Back to calendar

Event Date: 22-07-2017 - Session time: 14:15:00 - Track: BI Administration, Development Analytics

Speaker: Eugene Meidinger

Title: Power BI Internals: a Deep Dive

Abstract:

When people talk about Power BI, it can be all sizzle and no steak. Instead, we are going to take a slightly deeper dive into the inner workings of PowerBI. We will cover the different components of the Power BI ecosystem: PowerQuery, DAX, Power BI visuals, Data gateways, and the Power BI service. Instead of just showing off pretty graphs, we will focus on a more fundamental understanding of these tools.

SessionID: 64009

SQL Server Transactional Replication: A Deep Dive

Back to calendar

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

Speaker: Drew Furgiuele

Title: SQL Server Transactional Replication: A Deep Dive

Abstract:

Ah, SQL Server Transactional Replication. The technology everyone loves to hate. But for all the notoriety, there's some interesting technology to be had in it that might you might want to leverage. In this session, we'll explore what happens when you create a new transactional publication: what happens during a snapshot, how data gets delivered to subscribers, and how you can monitor, tweak, and tune your publications. We'll also see some common trouble spots and how to identify them. There will be plenty of examples and demos and, yes, even some PowerShell!

SessionID: 65707

Introduction to Temporal Tables

Back to calendar

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

Speaker: Sam Nasr

Title: Introduction to Temporal Tables

Abstract:

Many times developers have to support users by answering the “What happened to the data?” The task of retrieving data from a specific point in time is not an easy one. Often this involves retrieving a backup and restoring the data in question (hopefully!). SQL Server 2016 introduced Temporal Tables, allowing a developer to retrieve data from a specific point in time, without backups. With a few TSQL commands a historical table can be created, automatically updated, and readily accessed.

SessionID: 65746

Are You There, DBA? It’s Me, The App Developer

Back to calendar

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

Speaker: Jacquelyn Keeper

Title: Are You There, DBA? It’s Me, The App Developer

Abstract:

Are you a frustrated DBA trying to improve performance on an application you didn’t write? Or perhaps you’re an application developer struggling to understand why your queries run slowly on someone else’s database? This talk will cover practical techniques to help developers and DBAs work together efficiently to troubleshoot poorly performing applications.

Beginner/Intermediate software developers and DBAs will learn: when you need the actual query execution plan (and how to get it), why queries executed from SSMS perform differently than they do in the application, and how you can improve an application to make database troubleshooting easier. When the DBA and Developer join forces, there’s no problem they can’t solve!

SessionID: 66553

Answering the question, "What happened?" with Query Store

Back to calendar

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

Speaker: Erin Stellato

Title: Answering the question, "What happened?" with Query Store

Abstract:

One of the most anticipated new features in SQL Server 2016 is Query Store. It's referred to as the "flight recorder" for SQL Server because it tracks query information, namely query plans and runtime statistics. If you've ever had to drop everything to troubleshoot a sudden change in performance, then you've probably already realized the value of this feature.

In this session, we'll step through how Query Store works - you’ll understand what information it captures and how to access the historical data through the UI and the system views. We'll look at the data collected to identify queries that don't perform well and those that have regressions in performance due to different plans. Finally, we'll see how to force a specific plan for a query, discover what happens when the optimizer cannot use that plan, and examine how plan forcing compares to using plan guides. Expect to learn how to make troubleshooting easier with this feature that’s included in all editions of SQL Server 201

SessionID: 64277

Where Does R Fit Into Your SQL Server Stack?

Back to calendar

Event Date: 22-07-2017 - Session time: 15:30:00 - Track: BI Administration, Development Analytics

Speaker: Stacia Varga

Title: Where Does R Fit Into Your SQL Server Stack?

Abstract:

Now that SQL Server 2016 includes support for R in the database, how does this change your BI implementation options?

In this session, we start with a brief introduction to R and explain why it’s increasingly popular, the typical development workflow, which tools you can use, common use cases, and where it fits into the latest Microsoft stack at a high level.

Then we’ll review how to implement R Services so that you can use R with SQL Server data, including how to install R packages on SQL Server, how to use rx functions, and how to operationalize R in SQL Server.

Then we explore options for using R to prepare data for analytics using SSIS or Power BI and how to report and visualize data using SSRS or Power BI.

SessionID: 65039

DBAs vs Developers: JSON in SQL Server 2016

Back to calendar

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

Speaker: Bert Wagner

Title: DBAs vs Developers: JSON in SQL Server 2016

Abstract:

The war between DBAs and developers has been raging since the dawn of relational databases. One reason for disagreement comes from developers who want to store their data in JSON because it is fast, standard, and flexible. DBAs cringe when they hear of long text strings being stored in their SQL databases; they cry with concern, “No data validation? No schema binding?”. Is there any hope for these two warring factions to see eye-to-eye?

This session will explore the new JSON functionality introduced in SQL Server 2016. We will use T-SQL examples to learn how these functions can be used to parse, create, and modify JSON data. More importantly, we will discuss how to optimize performance when using these functions.

By the end of this session DBAs and developers will know how to efficiently work with JSON in SQL Server 2016. It will also usher in an era of peace between DBAs and developers…

… at least until someone brings up the topics of cursors, NOLOCKs, or Entity Framework.

SessionID: 65081

Intro to Azure SQL Databases

Back to calendar

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

Speaker: Michael Fal

Title: Intro to Azure SQL Databases

Abstract:

Azure SQL Databases are still something that is new and not completely understood by many data professionals. There is a definite shift from installing SQL Server on a machine to creating and using a Microsoft's Platform-as-a-Service database. This session will cover the basics of what an Azure SQL Database is, how we create one, and what it takes to access and use this database. After attending this session, you will have a solid understanding of what Azure SQL Database is, how to configure it, and how to use in your own environment.

SessionID: 65670

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

Back to calendar

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

Speaker: Elizabeth Noble

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

Abstract:

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

SessionID: 65763

Reduce your DBA ( DEV) task list by using Microsoft BI tools

Back to calendar

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

Speaker: Tamera Clark

Title: Reduce your DBA ( DEV) task list by using Microsoft BI tools

Abstract:

Are you a DBA or DBA Dev with access to the Microsoft BI Stack? Why not utilize some of these amazing tools to make your life a little easier?

Are you working without fancy monitoring and reporting tools? Do you dream of having time to pull data into Excel ans show you management staff what is going on? Do you run queries to answer questions for projects or at the department's request on a regular basis? Wanna know what is going on with your report server?

Come to this "BI for the Engine Guy" session and let me help you make visualizations for all your engine's health care needs and your user's (customer) data demands.

This site is open source. Improve this page.