sqlsathistory

Nr: 886

SQLSaturday #886 - Indianapolis 2019

Start Time (24h)	Speaker	Track	Title
08:00:00	Drew Furgiuele	Cloud Application Development Deployment	Introduction to Azure Databricks
08:00:00	Julie Smith	Analytics and Visualization	Leveraging Python in SQL Server
08:00:00	Jay Robinson	Application Database Development	Developer Nights: The Ballad of Bobby Tables
08:00:00	Chris Bell	Enterprise Database Administration Deployment	MSAs, GMSAs, Groups - Use SQL without traditional user accounts
08:00:00	Aaron Urfer	Enterprise Database Administration Deployment	Identifying Sensitive data with Redgate Data Catalog
08:00:00	Clark Hahn	Cloud Application Development Deployment	What I Learned Stepping onto the Cloud
08:00:00	Brett VanderPlaats	BI Platform Architecture, Development Administration	Cloud Data Warehousing with Snowflake on Azure
08:00:00	Chris Koester	BI Platform Architecture, Development Administration	Azure Data Factory - Beyond the Basics
08:00:00	Peter Shore	SQLStarter	SQLStarter - Intro to Database Administration
09:15:00	Dan Mallott	Cloud Application Development Deployment	SSDT, Docker, and (Azure) DevOps: How to Make Your Database Builds a First Class CI/CD Citizen
09:15:00	Michael Huffer	Cloud Application Development Deployment	Brick-by-Brick: Foundational Azure Databricks Concepts
09:15:00	Lou` Russell	Professional Development	Stuck In the Middle: Collaborating With Multiple Stakeholders
09:15:00	Lynn Ballard	Analytics and Visualization	Beginner's Guide to Text Mining: What We Learn from SQL Saturday Presentation Abstracts
09:15:00	Dustin Dorsey	Enterprise Database Administration Deployment	Managing the mystery database
09:15:00	Britton Gray	BI Platform Architecture, Development Administration	Cloud Data Warehousing in Azure: Azure DWH and Snowflake
09:15:00	David Mellinger	BI Platform Architecture, Development Administration	Microsoft/Azure Data Integrations: Factories, Pipelines, and Flows Oh My!
09:15:00	Sumeeth Evans	Strategy and Architecture	SQL Networking Security
09:15:00	Andrew Loree	SQLStarter	SQLStarter - Intro to Data Science
09:15:00	Pat Phelan	Enterprise Database Administration Deployment	DR HA 101, what are they and why do I want them?
10:30:00	Simon Kingaby	Cloud Application Development Deployment	Moving Data to the Cloud (with Azure Data Factory)
10:30:00	Dave Bland	Enterprise Database Administration Deployment	Extended Events: What are they and How do I use them
10:30:00	Andy Wickman	Professional Development	Lessons from Consulting: Vendor Applications
10:30:00	Greg Deckler	Analytics and Visualization	Building a Machine Learning Regression Model with Zero Code in PowerBI
10:30:00	Bob Pusateri	Cloud Application Development Deployment	Dipping Your Toes In: Azure Data Lake for DBAs
10:30:00	Sriharsh Adari	BI Platform Architecture, Development Administration	Enable Real-time Analytics and Machine Learning with Azure Stream Analytics
10:30:00	Elizabeth Noble	Strategy and Architecture	Migrate Your Database(s) with Distributed AGs
10:30:00	Brandon Lukes	Enterprise Database Administration Deployment	Migrating your SQL Server Instance
10:30:00	Warren Sifre	SQLStarter	SQLStarter - Intro to Big Data
10:30:00	Ameena Lalani	Enterprise Database Administration Deployment	Learn History from Temporal Tables
11:45:00	Diane Schuster	BI Platform Architecture, Development Administration	CozyRoc: Dynamic Data Flows in SSIS Without Programming
11:45:00	Tamera Clark	Professional Development	The Community Speaks: WIT, LGBTQ, diversity and inclusion.
11:45:00	Eddie Wuerch	Enterprise Database Administration Deployment	Agile Ops at Billions of Transactions a Day Without Losing Your M
13:00:00	Warren Sifre	Other	Introduction To Data Governance
13:00:00	Liz Amador	Analytics and Visualization	Designing Accessible Power BI Reports
13:00:00	Frank Gill	Enterprise Database Administration Deployment	Accelerated Database Recovery: The Future of the Transaction Log
13:00:00	Thomas Lapp	Cloud Application Development Deployment	Containerized SQL Server on Red Hat OpenShift
13:00:00	Ryan Wade	Analytics and Visualization	AI for the Masses: The Democratization of Artificial Intelligence in the Microsoft Ecosystem
13:00:00	Chad Buher	BI Platform Architecture, Development Administration	Replace Hundreds of Fragmented SSRS Reports with Integrated Dashboards in Weeks
13:00:00	David Stein	BI Platform Architecture, Development Administration	Agile Data Warehouse and ETL Design with Biml
13:00:00	Joe McTaggart	Enterprise Database Administration Deployment	Another new version of SQL Server!? Highlights of new features coming with SQL Server 2019
13:00:00	Josh Fennessy	Advanced Analysis Techniques	Definitive Proof that Pluto is Indeed a Planet
13:00:00	Jay Robinson	SQLStarter	SQLStarter - Intro to Database Development
14:15:00	Vladimir Oselsky	Application Database Development	Performance Tuning for SQL Developer through Execution Plans
14:15:00	David Maxwell	Enterprise Database Administration Deployment	Transaction Log Internals and Performance
14:15:00	Eric Blinn	Enterprise Database Administration Deployment	I have indexes, but do I have the right indexes?
14:15:00	George Bryant	BI Information Delivery	"M" is great! Keep it that way.
14:15:00	Wendy Pastrick	Professional Development	Moving Past Imposter Syndrome
14:15:00	Lucas Feiock	Analytics and Visualization	Intro to SQL Spatial Data: Location Analytics
14:15:00	Kerry Tyler	Cloud Application Development Deployment	Active Directory and Azure Active Directory: Authentication in a Cloudy World
14:15:00	David Stein	BI Platform Architecture, Development Administration	Creating Your Own ETL Automation Framework with Biml for Beginners
14:15:00	CJ Knapp	SQLStarter	SQLStarter - Intro to Business Intelligence
15:30:00	Sam Nasr	BI Information Delivery	New Features in SSRS 2017
15:30:00	Joshua Higginbotham	BI Platform Architecture, Development Administration	Optimizing the ETL Development Process with BIML
15:30:00	Grant Fritchey	Application Database Development	Extending DevOps To SQL Server
15:30:00	Andrew Loree	Analytics and Visualization	SQL Server Machine Learning Services
15:30:00	Rob Volk	Enterprise Database Administration Deployment	Revenge: The SQL!
15:30:00	Louis Gordner	Enterprise Database Administration Deployment	Ansible Automation for MSSQL Server
15:30:00	Peter Shore	Professional Development	Learn Like Your Life Depends On It
15:30:00	Bradley Nielsen	Cloud Application Development Deployment	Docker for DBAs
15:30:00	Hope Foley	SQLStarter	SQLStarter - Discussion/Networking Session

SessionID: 91252

Introduction to Azure Databricks

Back to calendar

Event Date: 17-08-2019 - Session time: 08:00:00 - Track: Cloud Application Development Deployment

Speaker: Drew Furgiuele

Title: Introduction to Azure Databricks

Abstract:

Big data processing solutions don't need to be complicated to get up and running, and thanks to Azure Databricks, it isn't! In this session, we'll cover what Azure Databricks is, go over some popular use cases, and what you can expect from an administrative standpoint if you decide to implement solutions with it. We'll also cover the basics of setting up Azure Databricks and go over what goes on "under the covers" in the cloud when you use it to provision compute for your big data processing needs.

With plenty of demos on how to configure cloud storage, work with Databricks notebooks, and even some Apache Spark thrown in, you'll come to appreciate very quickly just how powerful (and flexible) a solution like Databricks is.

SessionID: 91584

Leveraging Python in SQL Server

Back to calendar

Event Date: 17-08-2019 - Session time: 08:00:00 - Track: Analytics and Visualization

Speaker: Julie Smith

Title: Leveraging Python in SQL Server

Abstract:

The programming language Python has become one of the top 3 languages for data scientists. This session introduces the language and its application in data analysis. I’ll introduce popular packages used in data analysis with Python. We’ll look at Jupyter to introduce the “notebook” experience and then move on to executing some Python scripts inside SQL Server 2017 and Power BI.

SessionID: 91802

Developer Nights: The Ballad of Bobby Tables

Back to calendar

Event Date: 17-08-2019 - Session time: 08:00:00 - Track: Application Database Development

Speaker: Jay Robinson

Title: Developer Nights: The Ballad of Bobby Tables

Abstract:

Hard skills have their place, but the key to successful software development is effective communication and collaboration. Join other developers and DBAs at the end of the day for a lively and informal discussion about how we work together to be successful. In between the jokes and war stories, gain insight into patterns and practices that empower software development teams. And... perhaps a few that don't.

SessionID: 92926

MSAs, GMSAs, Groups - Use SQL without traditional user accounts

Back to calendar

Event Date: 17-08-2019 - Session time: 08:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Bell

Title: MSAs, GMSAs, Groups - Use SQL without traditional user accounts

Abstract:

Security is becoming more critical in today’s database environment. At times it can seem like the DBA is also a Domain Admin and Security team on top of everything else.

Managing user domain accounts access in your DB can get tedious fast, especially as your environment grows. In this session, we will discuss and see some Active Directory features that can help re-enforce the concept of the separation of duties when it comes to security and ways to reduce the risks and complexities in managing a SQL environment’s security. We will review the process and requirements for implementing AD Groups, Active Directory’s Managed Service Accounts (MSA) and Group MSAs to be used to manage access and operate your SQL environment.

SessionID: 93491

Identifying Sensitive data with Redgate Data Catalog

Back to calendar

Event Date: 17-08-2019 - Session time: 08:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Aaron Urfer

Title: Identifying Sensitive data with Redgate Data Catalog

Abstract:

Data Governance is hard. Knowing where all of your sensitive data lives, who has access to it and when is time consuming and hard to manage. Redgate Data Catalog gives you insight to where your data lives and quickly allows you to categorize data. This mostly demo presentation will give you an overview to get started into the data classification processes.

SessionID: 95192

What I Learned Stepping onto the Cloud

Back to calendar

Event Date: 17-08-2019 - Session time: 08:00:00 - Track: Cloud Application Development Deployment

Speaker: Clark Hahn

Title: What I Learned Stepping onto the Cloud

Abstract:

Previously titled Stumbling and Bumbling onto the Cloud. In this "non-technical" presentation the presenter regales the audience with the missteps, mistakes, and land mines, encountered over the past year in his role as DBA/Data Architect/Data Lackey.

When your management says “Cloud First” and you’ve got to ask “How high”, and then work your way into actual solutions, it can lead to some real forehead smacking moments. And by “Cloud First”, they mean Azure First and foremost. If this sounds like a direction in which you will be headed, or you enjoy Schadenfreude… Remember a smart person learns from their mistakes, a wise person learns from other people’s mistakes.

SessionID: 95202

Cloud Data Warehousing with Snowflake on Azure

Back to calendar

Event Date: 17-08-2019 - Session time: 08:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Brett VanderPlaats

Title: Cloud Data Warehousing with Snowflake on Azure

Abstract:

Snowflake has been named a Gartner leader in the data platform and analytics space that leverages the computing power of the AZURE cloud platform that provides pay-for-what-you-use storage (at about $23/mo per TB) and elastic computing resources that is literally scale up and/or out on demand in which storage and compute are separated within Snowflake’s architecture. The product and architecture of Snowflake has helped organizations in lowering their data platform TCO by up to 50%.

This live demo will provide fundamental and technical understanding for roles like CDO, Data Architects, and Data Engineers, The focus will be Snowflake and how the only cloud-build data warehouse offers instant elasticity, secure data sharing, per-second pricing and many other features to enable the data-driven enterprise.

SessionID: 95357

Azure Data Factory - Beyond the Basics

Back to calendar

Event Date: 17-08-2019 - Session time: 08:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Chris Koester

Title: Azure Data Factory - Beyond the Basics

Abstract:

Azure Data Factory has an impressive feature set, but where do you turn when you need something that isn’t supported? Need to run SQL commands in Snowflake? Connect to an unsupported API? No problem. In this session we'll look at how Custom Tasks and Azure Functions can be used to extend Data Factory to do just about anything.

SessionID: 95493

SQLStarter - Intro to Database Administration

Back to calendar

Event Date: 17-08-2019 - Session time: 08:00:00 - Track: SQLStarter

Speaker: Peter Shore

Title: SQLStarter - Intro to Database Administration

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

SSDT, Docker, and (Azure) DevOps: How to Make Your Database Builds a First Class CI/CD Citizen

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: Cloud Application Development Deployment

Speaker: Dan Mallott

Title: SSDT, Docker, and (Azure) DevOps: How to Make Your Database Builds a First Class CI/CD Citizen

Abstract:

Your application developers benefit from Continuous Integration and Continuous Deployment practices to accelerate feature deployment and catch regression issues up front, but your database deployments are still stuck in the proverbial dark ages. The build scripts might be in source control or even an SSDT project already, but deploying is still an exercise in creating the perfect script, and don't even think about making a data (or data type) change!

SSDT and Azure DevOps can solve some of these problems, and even give us a window into the world of automated testing. In this talk, we will explore how to automate your database builds and deployments using SSDT and Azure DevOps, and we will explore automated testing using tSQLt and Docker. Lastly, we will check up on some tasks that you cannot (or should not) automate and talk about how to make sure your application developers are not left behind.

SessionID: 93056

Brick-by-Brick: Foundational Azure Databricks Concepts

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: Cloud Application Development Deployment

Speaker: Michael Huffer

Title: Brick-by-Brick: Foundational Azure Databricks Concepts

Abstract:

As the business need for data becomes more prominent, the platform that IT builds on becomes a crucial component to the success of any data analytics project. Apache Spark centralizes the information management process by providing a unified platform. Azure Databricks takes that concept one step further by providing a layer of abstraction from Apache Spark, which allows for easier adoption of a big data ecosystem. This presentation and demonstration will dive into the core concepts of Azure Databricks by focusing on three main use cases: ETL/ELT, Structured Streaming, and Machine Learning.

SessionID: 93404

Stuck In the Middle: Collaborating With Multiple Stakeholders

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: Professional Development

Speaker: Lou` Russell

Title: Stuck In the Middle: Collaborating With Multiple Stakeholders

Abstract:

Let’s face it – your management and peers have no idea what you’re doing, how much work and time it takes or even what you do as a database professional. Your role is stuck in the middle. Management is reluctant to prioritize the money to create better equipment and software updates. Developers don’t want you messing with their work. Both are annoyed when you bother them with a customer problem or when you can’t fix issues instantly. This dynamic triad (you, developers and management) will always have differing views but this diversity of thought can be leveraged to create powerful customer solutions. In this session, you’ll learn simple techniques to build collaboration, mitigate conflict, meet the customer needs and get everyone on the same page.

SessionID: 93777

Beginner's Guide to Text Mining: What We Learn from SQL Saturday Presentation Abstracts

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: Analytics and Visualization

Speaker: Lynn Ballard

Title: Beginner's Guide to Text Mining: What We Learn from SQL Saturday Presentation Abstracts

Abstract:

Interested in learning text mining techniques but not sure where to start? Want to learn more about SQL Saturday presentations but haven't dug into the details? This is the presentation for you! This is an introduction to text mining techniques that will use the SQL Saturday abstracts as examples. We will look at how to analyze data to find the most commonly used words and patterns and how to do sentiment analysis. Is "database" the most commonly used word in SQL Saturday abstracts? Come and find out!

SessionID: 95155

Managing the mystery database

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Dustin Dorsey

Title: Managing the mystery database

Abstract:

As database administrators, we often are responsible for managing large amounts of databases so it can be difficult to understand who or what is using each of them and why. Yet we are responsible for making sure these databases are backed up, secure and cared for. As well as, we are responsible for leading projects such as upgrades and migrations where this information becomes relevant. If application owners and documentation exist, we can certainly utilize that, but what if it doesn’t or information is limited. This session will look at tips and tricks you can do to figure out what these mystery databases are so you can make better decisions on them.

By figuring out what these mystery databases, you will be more equipped to make decisions on several items such as the following: • Decommissions • Lower resource allocation and costs (especially for storage) • Better planning for database migrations • Troubleshoot connection issues • Better planning for SQL upgrades

SessionID: 95206

Cloud Data Warehousing in Azure: Azure DWH and Snowflake

Back to calendar

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

Speaker: Britton Gray

Title: Cloud Data Warehousing in Azure: Azure DWH and Snowflake

Abstract:

Two major cloud data warehouse solutions exist on Azure - Azure Data Warehouse and Snowflake. This session will discuss the features of each, and the associated use cases, strengths and weaknesses that result. We'll also look at some benchmarks and costs. If you think of it as a bakeoff, it's a pie vs. a cake.

SessionID: 95335

Microsoft/Azure Data Integrations: Factories, Pipelines, and Flows Oh My!

Back to calendar

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

Speaker: David Mellinger

Title: Microsoft/Azure Data Integrations: Factories, Pipelines, and Flows Oh My!

Abstract:

Microsoft Data Integration possibilities have proliferated recently. Some of you may feel dizzy with all the new options and announcements. Its not made easier by similar sounding names sometimes. In this session we'll try and demystify these options by going over the Microsoft (Azure/SQL Server/Power BI) data movement options. That will include Azure Data Factory (Copy/Transform, Mapping Data Flow, Wrangling Data Flow), Azure Databricks, Power BI (Query Editor/M/Power Query, dataflows), and SSIS. We'll dive into the what, when, where, why, and how of each of the options. We'll also demo some of the options.

SessionID: 95394

SQL Networking Security

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: Strategy and Architecture

Speaker: Sumeeth Evans

Title: SQL Networking Security

Abstract:

Azure provides various ways to deploy SQL. You have Azure SQL Database, SQL on Azure VM, Azure SQL Managed Instance. Do you know the various connectivity and networking options required for each of these deployment options? Do you know the different security protection options and capability for each of these deployment options? Do you know how to get visibility into the various attacks that could happen against your SQL deployments in Azure?

This session will cover the different connectivity methods, both public and private, different access methods, different perimeter control options and how you can get proactive insights into your workloads.

Attend to get a demo filled session of how to build highly secure SQL environments in Azure and unlock the power of Azure SQL for your organization.

SessionID: 95494

SQLStarter - Intro to Data Science

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: SQLStarter

Speaker: Andrew Loree

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

DR HA 101, what are they and why do I want them?

Back to calendar

Event Date: 17-08-2019 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Pat Phelan

Title: DR HA 101, what are they and why do I want them?

Abstract:

This session is for the new or "accidental" DBA, and for those who want a gentle introduction to HA DR. It starts by defining what those letters mean, and takes you to the point where you can frame good questions about your needs and understand the answers to those questions.

This session does not try to discuss all of the details or go deep into the technical requirements. It defines terms and provides an understanding of these topics.

SessionID: 91084

Moving Data to the Cloud (with Azure Data Factory)

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: Cloud Application Development Deployment

Speaker: Simon Kingaby

Title: Moving Data to the Cloud (with Azure Data Factory)

Abstract:

You need to move data. A lot of data. To the cloud. You’ve got data in a variety of on- and off-site data sources. There are several ways to do it. Some of them can be quite easily implemented using Azure Data Factory. Learn how to use variables and looping in your Data Factory pipelines. Use the Integration Runtime to pull directly from on-site sources. See how to upload files to blob storage and import them. Learn how to trigger Data Factory activities. And, learn how to keep all those connection strings and passwords secret in Azure Vault. After this session, you will have tools that you can readily implement in your own data migrations.

SessionID: 91116

Extended Events: What are they and How do I use them

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Bland

Title: Extended Events: What are they and How do I use them

Abstract:

Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session. This session will focus on how to use Extended Events as part of your performance troubleshooting process.

SessionID: 91957

Lessons from Consulting: Vendor Applications

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: Professional Development

Speaker: Andy Wickman

Title: Lessons from Consulting: Vendor Applications

Abstract:

Does your company use a lot of vendor applications? Do the specs for them make no sense? In this session, you'll see some all too common issues when dealing with Vendor applications. This will include some bad recommendations that vendors make as well as how to handle these situations. You'll also see a little bit of one of the WORST designed applications I've ever seen!!

SessionID: 93025

Building a Machine Learning Regression Model with Zero Code in PowerBI

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: Analytics and Visualization

Speaker: Greg Deckler

Title: Building a Machine Learning Regression Model with Zero Code in PowerBI

Abstract:

PowerBI recently added support for AutoML (Supervised Automated machine Learning). This session demonstrates the new ML capabilities with an end to end example using Power BI Dataflows. In this session, we will use AutoML to create and apply a regression model. Regression is a machine learning technique used for understanding the relationship between input and output variables. Regression techniques provide additional insight into data, making it easier to see relationships between dependent and independent variables.

SessionID: 93639

Dipping Your Toes In: Azure Data Lake for DBAs

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: Cloud Application Development Deployment

Speaker: Bob Pusateri

Title: Dipping Your Toes In: Azure Data Lake for DBAs

Abstract:

As a data professional, you know what data is, and hopefully know what a lake is too. But what's a Data Lake? This session covers the very basics of Azure Data Lake, and is geared towards those who are familiar with relational databases and also curious about other technologies. Topics covered will include Data Lake storage, security basics, and an introduction to U-SQL, Azure Data Lake's query language. We will finish up with architecture examples showing real-world use cases highlighting Azure Data Lake's strengths. Attend this session to see how Azure Data Lake can complement your existing relational database skills, and give you a great new tool in your data toolbox!

SessionID: 95067

Enable Real-time Analytics and Machine Learning with Azure Stream Analytics

Back to calendar

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

Speaker: Sriharsh Adari

Title: Enable Real-time Analytics and Machine Learning with Azure Stream Analytics

Abstract:

As Organizations are looking to transform into data driven organizations. Stream analytics has emerged as an integral part of Enterprise Data platform architectures along with batch ETL. Stream analytics help to gain maximum value from user-interaction events, applications and machine logs. Ingesting, processing, and analyzing these data streams quickly and efficiently is critical in fraud detection, click stream analysis, sentiment analytics, online recommendations and IOT Scenarios among many examples. In this session we will look at options available in azure for real-time analytics and deep dive into Azure Stream Analytics. Build streaming jobs that can blend and aggregate data as it arrives to drive live Power BI dashboards. Plus, we’ll explore how a complete lambda architecture can be created when combining stream and batch data together and finally how it integrates with Azure ML.

SessionID: 95087

Migrate Your Database(s) with Distributed AGs

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: Strategy and Architecture

Speaker: Elizabeth Noble

Title: Migrate Your Database(s) with Distributed AGs

Abstract:

You find yourself needing to migrate to new hardware or new operating system. If you're running SQL Server 2016+, you're in luck! Distributed Availability Groups (AGs) may just be the solution you want.

In this session I will explain the purpose and usages of Distributed AGs, create a Distributed AG and the associated AGs, and perform a mock data center migration.

NOTE: This session expects that attendees are already familiar with Availability Groups.

SessionID: 95386

Migrating your SQL Server Instance

Back to calendar

Event Date: 17-08-2019 - Session time: 10: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: 95495

SQLStarter - Intro to Big Data

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: SQLStarter

Speaker: Warren Sifre

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

Learn History from Temporal Tables

Back to calendar

Event Date: 17-08-2019 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Ameena Lalani

Title: Learn History from Temporal Tables

Abstract:

SQL Server 2016 came out with a bucket full of cool new features. One of them is Temporal Tables. SQL Server 2017 made some enhancements in this area. Temporal tables are basically history tables of the normal tables; that allows us to retrieve data from any point in time for every change such as updates and deletes. It does this all without any change to application code and without needing any triggers. In this session, we will see what the requirements of creating temporal tables are. We will see the demo on insert and update functionality and how to query historical information using new TSQL clause. We will touch upon retention of history as well. It has lots of demos and less theory.

SessionID: 94229

CozyRoc: Dynamic Data Flows in SSIS Without Programming

Back to calendar

Event Date: 17-08-2019 - Session time: 11:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Diane Schuster

Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming

Abstract:

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.

SessionID: 95396

The Community Speaks: WIT, LGBTQ, diversity and inclusion.

Back to calendar

Event Date: 17-08-2019 - Session time: 11:45:00 - Track: Professional Development

Speaker: Tamera Clark

Title: The Community Speaks: WIT, LGBTQ, diversity and inclusion.

Abstract:

SessionID: 96823

Agile Ops at Billions of Transactions a Day Without Losing Your M

Back to calendar

Event Date: 17-08-2019 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Eddie Wuerch

Title: Agile Ops at Billions of Transactions a Day Without Losing Your M

Abstract:

Every time a human touches a computer, they can damage it”. We’re all human, we all touch computers, and we all have stories to back up that statement. What about dozens of people touching thousands of busy 24x7 clusters, instances, databases, and AGs? Defined processes help, but how do you keep them from bogging down critical fix-it-now work and still prevent damage? Grab lunch and join some Salesforce DBAs as we discuss scaling ITIL, DevOps, and coding your way to an easier life.

SessionID: 93360

Introduction To Data Governance

Back to calendar

Event Date: 17-08-2019 - Session time: 13:00:00 - Track: Other

Speaker: Warren Sifre

Title: Introduction To Data Governance

Abstract:

Data Governance has been seen by many as a very SCARY and BIG thing requiring biblical efforts to understand and more so to implement. Our discussion will provide context for what, why, and how of Data Governance. You will have an understanding of this and more importantly a road map for how to begin to implement and evangelize within the organization.

SessionID: 93415

Designing Accessible Power BI Reports

Back to calendar

Event Date: 17-08-2019 - Session time: 13:00:00 - Track: Analytics and Visualization

Speaker: Liz Amador

Title: Designing Accessible Power BI Reports

Abstract:

We'll look at the new features that have rolled out in response to a major push at Microsoft to make Power BI reports more accessible. What some of the different areas of accessibility to think about, and some handy tools to help you make your reports more usable for everyone.

SessionID: 93524

Accelerated Database Recovery: The Future of the Transaction Log

Back to calendar

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

Speaker: Frank Gill

Title: Accelerated Database Recovery: The Future of the Transaction Log

Abstract:

New in SQL Server 2019, Accelerated Database Recovery (ADR) completely redesigns the SQL Server database engine recovery process. This allows the time spent recovering from a crash or rolling back a transaction to be greatly reduced. ADR also prevents the transaction log from growing during a long-running transaction. Join me for this session to learn about ADR architecture and to see demonstrations of what it can do.

SessionID: 94938

Containerized SQL Server on Red Hat OpenShift

Back to calendar

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

Speaker: Thomas Lapp

Title: Containerized SQL Server on Red Hat OpenShift

Abstract:

Containers and Kubernetes are changing the way applications are deployed and managed, including databases. Red Hat and Microsoft have partnered to deliver SQL Server 2019 in Red Hat Enterprise Linux containers running on OpenShift Container Platform. In this session we'll deploy an always on availability group replica on OpenShift via a Kubernetes operator.

SessionID: 95180

AI for the Masses: The Democratization of Artificial Intelligence in the Microsoft Ecosystem

Back to calendar

Event Date: 17-08-2019 - Session time: 13:00:00 - Track: Analytics and Visualization

Speaker: Ryan Wade

Title: AI for the Masses: The Democratization of Artificial Intelligence in the Microsoft Ecosystem

Abstract:

Data is the new gold and companies are producing it in massive amounts. Historically it has been tough for companies to mine the data because of the amount of technical resources and human capital it takes to mine it. Fortunately, Microsoft has added tools and services in its data platform that addresses this problem.

In this session we will take a tour of the Microsoft ecosystem and explore some of these tools and services. We will explore:

How AI models are easily productionized in the cloud using Azure Machine Learning Services and Azure Databricks
How Microsoft brought data science to the database via SQL Server Machine Learning Services
How AI can be used to enhance Power BI data models
How AI is used in Microsoft Excel to help analyst work more efficiently

Come to this information packed session, and you will walk away with ideas of how you can help your company leverage the gold mine of data it is sitting on to gain a competitive advantage.

SessionID: 95356

Replace Hundreds of Fragmented SSRS Reports with Integrated Dashboards in Weeks

Back to calendar

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

Speaker: Chad Buher

Title: Replace Hundreds of Fragmented SSRS Reports with Integrated Dashboards in Weeks

Abstract:

Has your organization accumulated a ton of reports that are crucial, yet fragmented and difficult to maintain? This session deals with the challenge of documenting those disconnected reports and replacing them with integrated dashboards. We will also discuss the trade offs of different data integration architecture options such as data lakes, dimensional models, real time solutions like data virtualization, and cloud based solutions.

In this session, we will explore:

Different industry solutions to document your existing SSRS reports and SSAS cubes to identify all the columns used in source tables/objects.
Interrogating the database objects (views, stored procedures, etc.) to decipher the ETL mappings and transformations and present this in a human readable format of data lineage with business rules applied to the source system.
Grouping these reports into sets to be consolidated in a few dashboard
Different solutions to accommodate the desired data integration architecture

SessionID: 95378

Agile Data Warehouse and ETL Design with Biml

Back to calendar

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

Speaker: David Stein

Title: Agile Data Warehouse and ETL Design with Biml

Abstract:

Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive presentation you'll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use BimlScript to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.

SessionID: 95387

Another new version of SQL Server!? Highlights of new features coming with SQL Server 2019

Back to calendar

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

Speaker: Joe McTaggart

Title: Another new version of SQL Server!? Highlights of new features coming with SQL Server 2019

Abstract:

A new version of SQL Server is right around the corner and it comes with all new features and improvements to make SQL Server a more compelling modern data platform. SQL Server 2019 is slated to bring better integration with different OS platforms, improvements in performance and availability, and bring big data and AI on-prem. In this session, we will look at the highlights of the new features coming to SQL Server 2019 and discuss why these improvements will justify another upgrade.

SessionID: 95491

Definitive Proof that Pluto is Indeed a Planet

Back to calendar

Event Date: 17-08-2019 - Session time: 13:00:00 - Track: Advanced Analysis Techniques

Speaker: Josh Fennessy

Title: Definitive Proof that Pluto is Indeed a Planet

Abstract:

Ever the one left out, Pluto's status as a key member of the solar system has been under scrutiny in recent years and the debate rages on.

In the age of AI, surely it's an easy problem to solve with computering. I'm sure Microsoft has a crack team of hackstars working on it right now. What toolset do you think they would use to do something like that? Probably some fancy cloud bricks or something.

Anyway, I'm sure this is possible. It has to be, we'd just need to learn about:

A distributed analytics platfrom able to work with tons of raw planetary data
An AI platform that is performant and allows a team of developers to collaborate and improve the product
The ability to call the model billions and billions and billions and billions errr

I don't think this will take much longer than 75 mins. Might as well get to it.

(Psst: You're going to learn all about scalable data processing and web scale analytics using Azure Databricks, MLFlow, and Azure ML)

SessionID: 95496

SQLStarter - Intro to Database Development

Back to calendar

Event Date: 17-08-2019 - Session time: 13:00:00 - Track: SQLStarter

Speaker: Jay Robinson

Title: SQLStarter - Intro to Database Development

Abstract:

Session in the SQLStarter beginner track to introduce the database development 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: 91082

Performance Tuning for SQL Developer through Execution Plans

Back to calendar

Event Date: 17-08-2019 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Vladimir Oselsky

Title: Performance Tuning for SQL Developer through Execution Plans

Abstract:

Performance Tuning for SQL Developer session aims to provide essential building blocks to get starting with this challenging subject. When it comes to performance tuning the execution plan needs to be the first stop for every developer however many developers don’t know how to read and extract relevant information. When looking at execution plans in SSMS, there are many different ways of getting relevant information however it is not always simple to understand. The goal of this presentation is to provide tools and high-level overview of pertinent information to enable each developer to start optimizing their code.

SessionID: 91750

Transaction Log Internals and Performance

Back to calendar

Event Date: 17-08-2019 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: David Maxwell

Title: Transaction Log Internals and Performance

Abstract:

The transaction log is one of the most critical, yet often misunderstood, components of SQL Server. From out of control log growth to very long start-up times, problems with the transaction log can cause a lot of pain. In this session, we'll look at how the transaction log works and what information is actually stored in the log. You'll learn how to optimize the log's performance, determining the right settings for log growth, and what to do when things get out of control.

SessionID: 92103

I have indexes, but do I have the right indexes?

Back to calendar

Event Date: 17-08-2019 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Blinn

Title: I have indexes, but do I have the right indexes?

Abstract:

Do you have all the right indexes on your SQL Server databases? Have you implemented any indexes other than traditional clustered and non-clustered indexes? If the answer to either question is a “no” or an “I don’t know”, then this session is for you.

This session will help introduce less commonly used index types and settings along with indexing methodologies. Follow along while we learn which indexes your SQL Server is begging you to make and others it wishes you would drop. Learn use cases for filtered, full-text, and columnstore indexes. There will be plenty of demos and shareable scripts to showcase the benefits too!

Are you using a version and edition of SQL Server is able to use these features? We’ll cover that too and you’ll leave this class with a repeatable indexing methodology you can use to improve your database performance.

SessionID: 93131

"M" is great! Keep it that way.

Back to calendar

Event Date: 17-08-2019 - Session time: 14:15:00 - Track: BI Information Delivery

Speaker: George Bryant

Title: "M" is great! Keep it that way.

Abstract:

Power BI is great for modelling. Having the ability to edit and clean your data quick and easy is one of its greatest boons. It is however very easy to have your model bogged down with applied steps. This talk will open the window to best practices with modelling and how to utilise "M" to your advantage.

SessionID: 93919

Moving Past Imposter Syndrome

Back to calendar

Event Date: 17-08-2019 - Session time: 14:15:00 - Track: Professional Development

Speaker: Wendy Pastrick

Title: Moving Past Imposter Syndrome

Abstract:

We have heard a lot on recognizing Imposter Syndrome and how to address it. However, what if it’s not Imposter Syndrome after all? We will discuss working scenarios and how you approach or deal with them to determine “is it you or is it me?”

SessionID: 94740

Intro to SQL Spatial Data: Location Analytics

Back to calendar

Event Date: 17-08-2019 - Session time: 14:15:00 - Track: Analytics and Visualization

Speaker: Lucas Feiock

Title: Intro to SQL Spatial Data: Location Analytics

Abstract:

In this session we will cover Spatial Data Types available in SQL Server. Then we will review the basics of spatial queries and the different methods to create points, lines, and polygons. Finally we will demo a few examples of location analytics and how to integrate into other data sets.

SessionID: 95354

Active Directory and Azure Active Directory: Authentication in a Cloudy World

Back to calendar

Event Date: 17-08-2019 - Session time: 14:15:00 - Track: Cloud Application Development Deployment

Speaker: Kerry Tyler

Title: Active Directory and Azure Active Directory: Authentication in a Cloudy World

Abstract:

If you're planning on deploying Office 365 or Azure, whether you know it or not, you will be using Azure Active Directory (AAD). But, you've already got on-prem Active Directory. How do these two products work together? Are they the same thing? SHOULD they work together? In this session I'll answer these questions, compare and contrast AD and AAD usage in Azure and hybrid scenarios, discuss costs, and some best practices.

This is a beginner session, but there will be some networking involved, in addition to "legacy" AD functionality and settings.

SessionID: 95380

Creating Your Own ETL Automation Framework with Biml for Beginners

Back to calendar

Event Date: 17-08-2019 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: David Stein

Title: Creating Your Own ETL Automation Framework with Biml for Beginners

Abstract:

You may have heard of Business Intelligence Markup Language or even tried to learn it. But how can you take the time to learn it, while getting the rest of your work done. In this highly interactive presentation, I’ll guide you through the process of learning/using Biml, without sacrificing your daily productivity.

We’ll cover how to: Identify “easy” ETL patterns to BimlScript Take incremental steps in automating these processes Move to metadata driven BimlScript Tie it all together into a full-fledged framework

As a bonus, you’ll leave the presentation with a completed framework which dynamically generates most types of flat files that you can use in your own environment.

SessionID: 95497

SQLStarter - Intro to Business Intelligence

Back to calendar

Event Date: 17-08-2019 - Session time: 14:15:00 - Track: SQLStarter

Speaker: CJ Knapp

Title: SQLStarter - Intro to Business Intelligence

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

New Features in SSRS 2017

Back to calendar

Event Date: 17-08-2019 - Session time: 15:30:00 - Track: BI Information Delivery

Speaker: Sam Nasr

Title: New Features in SSRS 2017

Abstract:

SQL Server Reporting Services 2017 offer many new features, making it more robust than ever. These features include Web Report Portal with KPI, Mobile Report Publisher, Redesigned report rendering engine supporting HTML5, and treemap sunburst chart types.

With intuitive interfaces and rich data visualization, business users and stake holders can now view valuable information, not just numbers. This session will cover requirements for installing and configuring SSIS, and how to quickly generate reports.

SessionID: 91953

Optimizing the ETL Development Process with BIML

Back to calendar

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

Speaker: Joshua Higginbotham

Title: Optimizing the ETL Development Process with BIML

Abstract:

In this discussion, we will overview the benefits Biml can bring to the ETL Development process. How used in conjunction with other languages like SQL and PowerShell, can build out large scale ETL packages in a fraction of the time it would take under traditional SSIS development.

SessionID: 92595

Extending DevOps To SQL Server

Back to calendar

Event Date: 17-08-2019 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Grant Fritchey

Title: Extending DevOps To SQL Server

Abstract:

Most organizations are under pressure to speed up the software delivery cycle, whether that’s to respond more quickly to the needs of the business, the needs of your customers or just to keep up with the competition. Unfortunately the database is commonly considered a bottleneck. Without the right processes in place, database change management can slow things down, adding risk, uncertainty, and getting in the way of development and operations working together to deliver. Any organization that wants to fully benefit from a DevOps approach is going to have to overcome some specific challenges presented by the database. This session will teach you how to take DevOps principles and practices and apply them to SQL Server so that you can speed up the database delivery cycle at the same time you protect the information contained within.

SessionID: 92827

SQL Server Machine Learning Services

Back to calendar

Event Date: 17-08-2019 - Session time: 15:30:00 - Track: Analytics and Visualization

Speaker: Andrew Loree

Title: SQL Server Machine Learning Services

Abstract:

SQL Server 2017 Machine Learning Services is more than just R and Python language support for SQL Server. SQL Machine Learning Services provides analytics for any size of data, runs in SQL Server, or alongside Windows, Linux, HDInsight Spark or Hadoop clusters, is simple to administer and allows you to integrate and deploy simply. In this session, learn architecture and deployment options, focused on in-database deployment, along with some real-world use-cases. Learn how to leverage Machine Learning Services with new TSQL PREDICT language support, training and deploying models, scaling beyond memory with RevoScaleR to generating millisecond predictions in-database. With any size data environment, SQL Machine Learning Services can provide analytics in both an operationally sound and easy to administer paradigm.

A beginner level understanding of Machine Learning and process is highly recommended but not required.

SessionID: 94666

Revenge: The SQL!

Back to calendar

Event Date: 17-08-2019 - Session time: 15:30: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 * in 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: 95322

Ansible Automation for MSSQL Server

Back to calendar

Event Date: 17-08-2019 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Louis Gordner

Title: Ansible Automation for MSSQL Server

Abstract:

Automation is now required. For DevOps, for Infrastructure-as-Code (IaC), for Platform-as-a-Service (PaaS), for user self-service, and for overworked staff, automation is the buzzword. Ansible provides that cross-platform functionality with minimal effort. In this session we'll install and configure MSSQL on a Windows host, install and configure a fail-over cluster on RHEL hosts using pacemaker and availability groups, and provision and deploy a new schema to an existing instance all utilizing playbooks. Also, we'll walk through getting started and example use-cases.

SessionID: 95363

Learn Like Your Life Depends On It

Back to calendar

Event Date: 17-08-2019 - Session time: 15:30:00 - Track: Professional Development

Speaker: Peter Shore

Title: Learn Like Your Life Depends On It

Abstract:

You have read this far, great! I already know this session is for you. How do I know? It is exceedingly rare that today’s “9-5” job provides anywhere near what is needed to develop the career you want to have. For the purposes of this session it does not matter if you are a newly minted, “wet behind the ears” data professional or a grizzled veteran. What does matter is that you know that you have a career oriented mindset and a desire to grow beyond what you are today.

This session is designed to help with just that. In addition to talking about a learning plan that fits your needs, we will discuss how to execute that plan, including lab environments, as well as resources to help you execute those plans. If you have reached this point, you simply need to be in this session, see you there.

SessionID: 95371

Docker for DBAs

Back to calendar

Event Date: 17-08-2019 - Session time: 15:30:00 - Track: Cloud Application Development Deployment

Speaker: Bradley Nielsen

Title: Docker for DBAs

Abstract:

In the past five years there has been an explosive increase in Docker adoption. However, uptake has been slow among data professionals. DBAs are naturally wary of Docker's stateless and transient paradigm. In this session we'll discuss what Docker is, how SQL Server uses it, Docker deployment strategies in Azure, and when using Docker does and doesn't make sense.

SessionID: 95581

SQLStarter - Discussion/Networking Session

Back to calendar

Event Date: 17-08-2019 - Session time: 15:30:00 - Track: SQLStarter

Speaker: Hope Foley

Title: SQLStarter - Discussion/Networking Session

Abstract:

Ending the day of SQLStarter sessions with a mix of QA and networking.

This site is open source. Improve this page.