sqlsathistory

Nr: 841

Back to Main list

SQLSaturday #841 - Dallas 2019

Start Time (24h) Speaker Track Title
08:30:00 Hasan Savran Analytics and Visualization How to use GeoSpatial Data in SQL Server
08:30:00 Adam Saxton BI Information Delivery Introduction to Power BI Desktop
08:30:00 John Sterrett Cloud Application Development Deployment Successfully Migrating Existing Databases to Azure SQL Database
08:30:00 Thomas Norman Application Database Development Encrypting Data within Sql Server
08:30:00 Brent Ozar Application Database Development Dynamic SQL: When, Why, and How to Use It
08:30:00 Mohammad Darab Professional Development 3 Keys to Successful Consulting
08:30:00 Jennifer McCown Enterprise Database Administration Deployment Beginning Admin: The Care and Feeding of SQL Server
08:30:00 Thomas LeBlanc Application Database Development Execution Plans for Performance Tuning SQL Server 2017
08:30:00 Angela Tidwell Strategy and Architecture Data Collection and Usage: Illegal or Unethical?
09:45:00 Anders Pedersen Application Database Development I/O Tuning 101
09:45:00 Abdullah Mamun Enterprise Database Administration Deployment SQL Server on Azure VM (IaaS)
09:45:00 Bob Ward Enterprise Database Administration Deployment Inside SQL Server 2019
09:45:00 Ben Miller Enterprise Database Administration Deployment Tips and Tricks for the PowerShell DBA
09:45:00 Taiyebali Zakir Enterprise Database Administration Deployment SQL Replication on Linux
09:45:00 Andy Yun Application Database Development Why Your Data Type Choices Matter
09:45:00 Paul LaGrone BI Platform Architecture, Development Administration SSIS 2017 Scale Out for HA/DR ETL
09:45:00 Leslie Andrews BI Platform Architecture, Development Administration A Perfect Ten: The Data Model
09:45:00 Julie Smith Advanced Analysis Techniques Leveraging Python in SQL Server
09:45:00 Peter Doyle Analytics and Visualization Become a T-SQL Pivoting Ninja in 60 Minutes Or Less
11:00:00 Jay Falck Enterprise Database Administration Deployment Introduction to Linux for SQL Server
11:00:00 Anna Hoffman Analytics and Visualization Microsoft SQL Server Machine Learning Services - a Complete Platform for E2E ML
11:00:00 Eddy Djaja Enterprise Database Administration Deployment What Is Clogging Your Database Performance?
11:00:00 Ryan Adams Enterprise Database Administration Deployment TempDB Inside Out
11:00:00 Alicia Moniz Analytics and Visualization AI Cognitive Services: Vision 101
11:00:00 Dave Bland Enterprise Database Administration Deployment Extended Events: What are they and How do I use them
11:00:00 Ganesh Lohani BI Platform Architecture, Development Administration Implementing ETL solution for incremental data load
11:00:00 Chris Hyde BI Platform Architecture, Development Administration Python in SQL Server 2017 and 2019
11:00:00 Allan Hirt Enterprise Database Administration Deployment Modern Infrastructure Fundamentals for SQL Server
13:15:00 Martin Perez Application Database Development T-SQL Tools: Simplicity for Synchronizing Changes
13:15:00 Matt Gordon Analytics and Visualization Feelings Quantified: Scoring and Storing Social Media Sentiment
13:15:00 Kevin Feasel Application Database Development A Map To Success: Functional Programming For Database Developers
13:15:00 Roberto Cavalcanti Cloud Application Development Deployment Azure SQL Managed Instance - Lessons learned from the trenches
13:15:00 Brent Ozar Enterprise Database Administration Deployment What's New in SQL Server 2019: 100% Demos
13:15:00 Trevor Barkhouse Enterprise Database Administration Deployment Backing up to Azure BLOB Storage
13:15:00 Lance Tidwell Application Database Development Introduction to Execution Plans
13:15:00 Melissa Stein BI Platform Architecture, Development Administration The True Story of Learning Biml
13:15:00 William Assaf Enterprise Database Administration Deployment SQL Security Principals and Permissions 101
13:15:00 Andy Leonard Cloud Application Development Deployment Moving Data with Azure Data Factory
14:30:00 Buck Woody Advanced Analysis Techniques Introduction to SQL Server Big Data Clusters
14:30:00 Eugene Meidinger BI Information Delivery An (Advanced) Introduction to DAX
14:30:00 Kevin Boles Application Database Development Query Plan Deep Dive
14:30:00 Kathi Kellenberger Application Database Development T-SQL Window Function Performance in 2019
14:30:00 Anthony Nocentino Cloud Application Development Deployment Practical Container Scenarios in Azure
14:30:00 Mike Burek Application Database Development Raspberry Pi and SQL Server
14:30:00 Christine Assaf Professional Development Mastering your Resume Interview: Tips to Get Hired
15:45:00 Reinaldo Kibel Strategy and Architecture Hackers move away, we are Always Encrypted
15:45:00 Kellyn Pot'Vin-Gorman Cloud Application Development Deployment Be Part of the Solution with Automation
15:45:00 Kenneth Fisher Application Database Development SQL Server Security from the ground up
15:45:00 Mark Moore Enterprise Database Administration Deployment SQL in Azure 101
15:45:00 Mike Byrd Application Database Development Indexing Like a Rocket Scientist
15:45:00 Sean McCown Enterprise Database Administration Deployment Beginning Powershell for DBAs 1.0
15:45:00 Mike Diehl BI Platform Architecture, Development Administration Building measures in Power BI (and SQL Server Analysis Services tabular models)
15:45:00 Paul Bell Strategy and Architecture Where should I store my database?
15:45:00 Joshua Higginbotham Application Database Development Introduction to GitHub
15:45:00 Kalen Delaney Enterprise Database Administration Deployment Are You Optimistic About Concurrency?

SessionID: 88315

How to use GeoSpatial Data in SQL Server

Back to calendar

Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Analytics and Visualization

Speaker: Hasan Savran

Title: How to use GeoSpatial Data in SQL Server

Abstract:

If you would like to learn about Spatial Data but don’t know where to start, this session is for you. We will begin by focusing on what Spatial Data is through examples and interactive demo’s. The goal is to show how Spatial Data can improve your professional experience and serve as an asset to your business.

I will introduce you to Spatial Data in the SQL server and show how to import data into SQL Server. We will focus on demonstrations of the SQL Server 2016 and JSON functions used to create geoJSON objects from Spatial Data. Next we will cache these objects by using In-Memory tables with the help of SQL Server 2017.

SessionID: 88580

Introduction to Power BI Desktop

Back to calendar

Event Date: 01-06-2019 - Session time: 08:30:00 - Track: BI Information Delivery

Speaker: Adam Saxton

Title: Introduction to Power BI Desktop

Abstract:

Most of us are overwhelmed with data from all the different applications that we use on a daily basis. Bringing all the data together is often a very time-consuming and sometimes a challenging process. Even further, attempting to analyze and visualize the data poses new challenges that is sometime difficult or impossible to overcome. Now with Power BI this can all be made very simple. Individuals, ranging from novice information workers to advanced IT professionals can quickly and easily transform, analyze and visualize data using a single tool, Power BI Desktop. In this course we will work through four main topics: Shaping Data, Building a Data Model and Visualizing Data.

SessionID: 88614

Successfully Migrating Existing Databases to Azure SQL Database

Back to calendar

Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: John Sterrett

Title: Successfully Migrating Existing Databases to Azure SQL Database

Abstract:

First impressions have long-lasting effects. When dealing with an architecture change like migrating to Azure SQL Database the last thing you want to do is leave a bad first impression by having an unsuccessful migration. In this session, you will learn the difference between Azure SQL Database, SQL Managed Instances, and Elastic Pools. How to use tools to test migrations for compatibility issues before you start the migration process. You will learn how to successfully migrate your database schema and data to the cloud. Finally, you will learn how to determine which performance tier is a good starting point for your existing workload(s) and how to monitor your workload over time to make sure your users have a great experience while you save as much money as possible.

SessionID: 88637

Encrypting Data within Sql Server

Back to calendar

Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Thomas Norman

Title: Encrypting Data within Sql Server

Abstract:

Data breaches abound! Do you want to keep off of the data breach list? What are some of the data privacy laws affecting you? How will encrypting data affect your database performance? What data fields should you encrypt? What else can you do to protect your sensitive data?

In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption and Always Encrypted. The session will deep dive into setting up Always Encrypted encryption and share my experiences implementing the encryption. In addition, the session will review auditing of sensitive data usage.

You will leave the session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance. In addition, you will gather information on how to fully protect and review your sensitive data usage.

SessionID: 89087

Dynamic SQL: When, Why, and How to Use It

Back to calendar

Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Brent Ozar

Title: Dynamic SQL: When, Why, and How to Use It

Abstract:

You're comfortable writing T-SQL, and you've built a lot of stored procedures that have a bunch of parameters. For example, you have that "product search" stored proc with parameters for product category, name, price range, sort order, etc, and you have to accept any of 'em.

So how do we make those go fast? And how can we get 'em to use indexes?

In one all-demo hour, performance tuner Brent Ozar will show you several ways that fail in comically bad ways. You'll learn how to write dynamic SQL that's easy to tune, manage, and troubleshoot.

SessionID: 89459

3 Keys to Successful Consulting

Back to calendar

Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Professional Development

Speaker: Mohammad Darab

Title: 3 Keys to Successful Consulting

Abstract:

Interested in becoming a consultant? Think it's too overwhelming? Want to be your own boss? Wish to expand your clientele? 

The hardest thing about being your own boss is getting in the right mindset and to truly understand that your past doesn’t equal your future.

In this 60 minute session, I cover 3 keys to being a successful consultant. I share techniques used to help others get in the right mindset and tackle the mental blocks to achieving success in their entrepreneurial pursuits.

Whether you are interested in starting your own business, or a consultant wanting to expand your clientele, this session will position you for future success as an entrepreneur.

SessionID: 90391

Beginning Admin: The Care and Feeding of SQL Server

Back to calendar

Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Jennifer McCown

Title: Beginning Admin: The Care and Feeding of SQL Server

Abstract:

Design and development may be exciting, but database administration is absolutely critical (and, reasonably well-paying!) The care and feeding of a server tends to get short-changed or neglected. In this class, we'll cover the basics of the big five administrator tasks:

Being a database administrator is a big job, but we can cover the basics in one session!

SessionID: 91961

Execution Plans for Performance Tuning SQL Server 2017

Back to calendar

Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Thomas LeBlanc

Title: Execution Plans for Performance Tuning SQL Server 2017

Abstract:

Performance Tuning starts with looking at a plan SQL Server internally uses to execute T-SQL. There are many parts to the plan as well as additional options for performance tuning. This session will provide real-world examples of T-SQL that can cause execution plans to not be optimal. The plan might also expose additions in the form of new indexes that can be added to improve performance.

There are many paths to reading these plans that need to be discussed and probably you will hear 'it depends' in this session. Explanations of why it depends will be used with examples.

SessionID: 92208

Data Collection and Usage: Illegal or Unethical?

Back to calendar

Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Strategy and Architecture

Speaker: Angela Tidwell

Title: Data Collection and Usage: Illegal or Unethical?

Abstract:

Data collection and usage is all around us, it is what we do. But is what we do with the data ethical? Are we collecting and processing biased data? We will take a look at ethical data collection and usage, what it means to your models and forecasts, and how being aware of possible biases can impact your bottom line. You might be training on extremely biased data and not know it, skewing your forecasts in the wrong direction.

SessionID: 87864

I/O Tuning 101

Back to calendar

Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Anders Pedersen

Title: I/O Tuning 101

Abstract:

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

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

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

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

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

SessionID: 87880

SQL Server on Azure VM (IaaS)

Back to calendar

Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Abdullah Mamun

Title: SQL Server on Azure VM (IaaS)

Abstract:

SQL Server on Azure virtual machines enables you to use full versions of SQL Server in the Cloud without having to manage any on-premises hardware. The session covers options, features and best practices on SQL Server on Azure VM. We will highlight frequently asked questions, common issues with SQL server on Azure VM and how to avoid them.

SessionID: 88572

Inside SQL Server 2019

Back to calendar

Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Bob Ward

Title: Inside SQL Server 2019

Abstract:

Come learn all the new capabilities of SQL Server 2019 directly from the Microsoft engineering team. This session will provide the strategy behind SQL Server 2019 as well as a deep dive into all the new features and how they can help you modernize your data estate with SQL Server.

SessionID: 89100

Tips and Tricks for the PowerShell DBA

Back to calendar

Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Ben Miller

Title: Tips and Tricks for the PowerShell DBA

Abstract:

Do you have more than 1 server that you manage? More than 1 database? Then this session is for you. PowerShell interest is on the rise and it is one of the coolest tools you can learn as a DBA. Learn tips and tricks using PowerShell that will help you manage SQL Servers and get more done with less effort. From getting started in PowerShell to getting information about your servers/databases to making changes to your SQL Servers all using PowerShell. This is one tool you will want in your toolbelt to help sharpen your skills.

SessionID: 89345

SQL Replication on Linux

Back to calendar

Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Taiyebali Zakir

Title: SQL Replication on Linux

Abstract:

SQL 2019 will support Replication to Linux. In this Session we talk about how Replication on Linux is similar to that in Windows, Steps to configure, Security and some demos.

SessionID: 89829

Why Your Data Type Choices Matter

Back to calendar

Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Andy Yun

Title: Why Your Data Type Choices Matter

Abstract:

Did you know that poor data type choices can be a real performance killer? Would you be surprised to learn that data type decisions can have a significant impact on your database design and performance?

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

SSIS 2017 Scale Out for HA/DR ETL

Back to calendar

Event Date: 01-06-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Paul LaGrone

Title: SSIS 2017 Scale Out for HA/DR ETL

Abstract:

2016 SSIS packages can access data anywhere throughout the network, but normally run on the server they are deployed on. And if something terrible happens to that server, the manual setup of the SSISDB can be time consuming. With 2017, SSIS packages can be deployed once and run on several servers, even simultaneously. This session will show you how to set up 2017 SSIS Scale Out packages so that your SSIS packages can now be in a Highly Available and Disaster Recovery environment.

SessionID: 89916

A Perfect Ten: The Data Model

Back to calendar

Event Date: 01-06-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Leslie Andrews

Title: A Perfect Ten: The Data Model

Abstract:

Do you know what makes a great data model? What does it mean to be Third Normal Form or a Star Schema? When would you use one over the other and why? How can you identify bad designs? In this presentation you will be exposed to good and bad models and learn what you should do in order to create a perfect ten model of your own!

SessionID: 91577

Leveraging Python in SQL Server

Back to calendar

Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Advanced Analysis Techniques

Speaker: Julie Smith

Title: Leveraging Python in SQL Server

Abstract:

SessionID: 92511

Become a T-SQL Pivoting Ninja in 60 Minutes Or Less

Back to calendar

Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Peter Doyle

Title: Become a T-SQL Pivoting Ninja in 60 Minutes Or Less

Abstract:

Stop wasting time going to Excel to create pivot tables when using T-SQL.

Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight with ease. In this demo-heavy presentation, you will learn how to build pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator.

Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris. *Not Possible

SessionID: 88608

Introduction to Linux for SQL Server

Back to calendar

Event Date: 01-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jay Falck

Title: Introduction to Linux for SQL Server

Abstract:

SQL Server is now available on Linux but you only know Windows, now what? During this session we'll introduce the Linux version of Windows commands you use on a daily basis for administering SQL Server. We'll look at updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. We'll also look at default file locations for SQL Server and what can be moved and how to accomplish that.

SessionID: 88816

Microsoft SQL Server Machine Learning Services - a Complete Platform for E2E ML

Back to calendar

Event Date: 01-06-2019 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Anna Hoffman

Title: Microsoft SQL Server Machine Learning Services - a Complete Platform for E2E ML

Abstract:

Learn how Machine Learning Services in SQL Server makes it a powerful end-to-end ML platform for customers, on both Windows and Linux, on prem and in Azure. Come learn about the unique value proposition of doing entire machine learning pipeline in-database – right from data pre-processing, feature engineering, and model training to deploying ML models and scripts to production in secure and compliant environment without moving data out.

SessionID: 89070

What Is Clogging Your Database Performance?

Back to calendar

Event Date: 01-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Eddy Djaja

Title: What Is Clogging Your Database Performance?

Abstract:

A concise and systematic approaches rather than guessing to analyze SQL Server performance will be presented. Through measuring the response time and wait time at the query level, the performance bottleneck is pinpointed and tuned. The presentation will look at the basic of gathering the stats from SQL Server DMVs.

SessionID: 90795

TempDB Inside Out

Back to calendar

Event Date: 01-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ryan Adams

Title: TempDB Inside Out

Abstract:

Either you are experiencing TempDB contention or you are not sure and want to find out. This pain is something every DBA has experienced or will experience, but it's not easy to figure out how to set it up correctly. You will learn how to identify if TempDB is having contention, what causes it to happen, where it can come from, and how to fix it. We will discuss the required trace flags and when to use them as I demo the behavior. You will walk away with the scripts and knowledge of how to configure TempDB per best practice.

SessionID: 91175

AI Cognitive Services: Vision 101

Back to calendar

Event Date: 01-06-2019 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Alicia Moniz

Title: AI Cognitive Services: Vision 101

Abstract:

Are you curious about Visual Recognition and Object Detection in Azure? Are you wondering what the difference is between the Computer Vision API and the Custom Vision API? Do you want a quick introduction to get you up to speed on both, so that you can quickly build and deploy a Cognitive Services model?

Join us for an introduction to the Cognitive Services Computer Vision and Custom Vision APIs on Azure.

In this session, we will look at the basics of Cognitive Services Vision. First learn how to create your Cognitive Services model. Then you can see how to train and improve accuracy. Finally, we will step through python code in Azure Notebooks to call the APIs.

After this session, you will get up and running in Cognitive Services Vision in under an hour!

Prerequisites: Attendees who would like to follow along should have an Azure account, as well as an account on Azure Notebooks. Experience with coding in python is helpful, but not required.

SessionID: 91741

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

Back to calendar

Event Date: 01-06-2019 - Session time: 11:00: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 give someone who has never used Extended events before the skills to start using them!

SessionID: 92169

Implementing ETL solution for incremental data load

Back to calendar

Event Date: 01-06-2019 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ganesh Lohani

Title: Implementing ETL solution for incremental data load

Abstract:

ETL (Extract, Transform, and Load is an essential task of a Business Intelligence Professional, especially if someone is working in Data Warehouse environment. Are you excited to learn different techniques of loading incremental data in SQL environment? In this session, we will cover the appropriate scenarios and design patterns of Incremental data load using T-SQL join, SSIS look up, SQL Merge and Change Data Capture.

SessionID: 93141

Python in SQL Server 2017 and 2019

Back to calendar

Event Date: 01-06-2019 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Chris Hyde

Title: Python in SQL Server 2017 and 2019

Abstract:

SQL Server 2017 and 2019 have arrived, bringing with them a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!

In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!

SessionID: 93254

Modern Infrastructure Fundamentals for SQL Server

Back to calendar

Event Date: 01-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Allan Hirt

Title: Modern Infrastructure Fundamentals for SQL Server

Abstract:

Since we live in a world where physical deployments are more the exception than the rule, the infrastructure underneath our databases is similar, yet very different. There is still CPU, disk, and memory but what does that actually mean today?

This session will update the core infrastructure concepts anyone responsible for SQL Server should know whether you have physical, virtualized, public cloud, and container-based deployments. As a bonus, you will be able to work better with the other administrators back in the office now that you can speak their language.

If you want to ensure that your SQL Server deployments are available, reliable, and perform well, this is the session for you.

SessionID: 87867

T-SQL Tools: Simplicity for Synchronizing Changes

Back to calendar

Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Martin Perez

Title: T-SQL Tools: Simplicity for Synchronizing Changes

Abstract:

One of most common problems a DBA or database developer may face is finding and syncing data changes efficiently between multiple systems.

In this session we will look into different methods focusing on effective use of T-SQL and explore how these methods can mixed and matched in your ETL workflows:

SessionID: 87998

Feelings Quantified: Scoring and Storing Social Media Sentiment

Back to calendar

Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Analytics and Visualization

Speaker: Matt Gordon

Title: Feelings Quantified: Scoring and Storing Social Media Sentiment

Abstract:

The job of a data professional is evolving rapidly, driving many of us to platforms and technologies that were not on our radar screen a few months ago. I am certainly no exception to that trend. Most of us aren't just monitoring backups and tuning queries - we are collaborating with teams throughout the company to provide them data and insights that drive decisions. Cloud providers are democratizing technologies and techniques that were complicated and proprietary just a few months ago. This presentation walks you through how a silly idea from a football podcast got me thinking about how Azure Logic Apps, the Cognitive Services API, Azure SQL DB, and Power BI combine to provide potentially powerful insights to any company with a social media and sales presence. Join me as I walk you through building a solution that can impact your company's bottom line - and potentially yours too!

SessionID: 88112

A Map To Success: Functional Programming For Database Developers

Back to calendar

Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Kevin Feasel

Title: A Map To Success: Functional Programming For Database Developers

Abstract:

Over the past several years, we have seen a resurgence of interest in functional programming languages, particularly with the success of Scala and R in the marketplace. Although object-oriented (oo) design remains the dominant software development paradigm, even oo-first languages have seen a shift toward the functional mindset with the emphasis on LINQ in C# and lambdas in Java. This move toward a functional style should be particularly welcome for data platform specialists, who already have a leg up in understanding functional programming concepts thanks to their work with SQL.

In this talk, we will focus on one functional programming language, F#. We will look at some of the basics of the language and see how you can translate knowledge of SQL into a pipeline-driven functional programming language. We will also see areas where F# integrates smoothly with SQL, creating a powerful way to extend your SQL skills beyond queries.

SessionID: 88265

Azure SQL Managed Instance - Lessons learned from the trenches

Back to calendar

Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Cloud Application Development Deployment

Speaker: Roberto Cavalcanti

Title: Azure SQL Managed Instance - Lessons learned from the trenches

Abstract:

In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database Managed Instance on production environments. You will learn how to monitor and improve Azure SQL Database Managed Instance query performance in comparison to SQL Server and Azure SQL Database. I will cover how Microsoft Support has been using the Query Store, Extended Events, DMVs to help customers monitor and improve query response times when running their databases in this Azure PaaS offering. These learnings are fruit of Microsoft support cases, and customer field engagements. This session is mostly composed of demos.

SessionID: 89086

What's New in SQL Server 2019: 100% Demos

Back to calendar

Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Brent Ozar

Title: What's New in SQL Server 2019: 100% Demos

Abstract:

You haven't installed SQL Server 2019 yet, and you don't want to sit through a bunch of slides. You want to see a series of real-world demos focusing on the features of SQL Server 2019 that will make your users happier with as little work as possible on your part. You don't have time to rewrite all your queries or learn new languages - you just want the database to go faster.

I'm Brent Ozar, and I'll give you the whirlwind tour. I'll focus on just the features that make the biggest bang for the buck, things you can implement right away and see a noticeable difference. I'll show you what kinds of code will benefit the most so you can go back to the office and have an honest discussion with management about what to expect.

No slides here - not even an about-me slide. Let's dive into some queries!

SessionID: 90878

Backing up to Azure BLOB Storage

Back to calendar

Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Trevor Barkhouse

Title: Backing up to Azure BLOB Storage

Abstract:

As a DBA, you know the importance of having off-site database backups (in case of disaster in your data centers). Historically, the logistics for off-site database backups have been complex and expensive. Backing up to the cloud brought simplification and an economical option. In this session, we will introduce the functionality that is built-in to SQL Server for backing a database up to the Azure Cloud ("Backup to URL"). We will discuss some concepts around Azure BLOB storage, explain the process of configuring backups, and then discuss troubleshooting issues with Backup to URL.

SessionID: 91780

Introduction to Execution Plans

Back to calendar

Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Lance Tidwell

Title: Introduction to Execution Plans

Abstract:

In this session we will take a look at the basics of execution plans. We will discuss what they are, how they are made, and how they are used. We will explore some of the common operators seen in execution plans and their functions. Next we will look at the differences between estimated and actual execution plans. Throughout, you will be getting insight on how to read execution plans to help tune your queries. Also we will go through some of the recent changes in SQL Server that effect execution plans. Those being the new cardinality estimator, query store, and adaptive query processing.

SessionID: 92537

The True Story of Learning Biml

Back to calendar

Event Date: 01-06-2019 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Melissa Stein

Title: The True Story of Learning Biml

Abstract:

How do you learn Biml when you don't have years of SQL experience? Is Biml even worth my time and energy when I'm still working on perfecting my SSIS skills? It seems like a lot of work, what is in it for me?

In this session you will learn: Why Biml is worth your time and effort. How to identify ideal SSIS packages for conversion. How to convert those packages into Biml. How to troubleshoot your Biml build errors when Google fails you. How to automate SSIS package creation with BimlScript.

SessionID: 93063

SQL Security Principals and Permissions 101

Back to calendar

Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: William Assaf

Title: SQL Security Principals and Permissions 101

Abstract:

A ground-floor introduction to SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and much more. This session is perfect for junior DBAs, developers and system admins of on-prem and Azure-based SQL platforms.

SessionID: 93147

Moving Data with Azure Data Factory

Back to calendar

Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Cloud Application Development Deployment

Speaker: Andy Leonard

Title: Moving Data with Azure Data Factory

Abstract:

Azure Data Factory - ADF - is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical user interface) and supports the SSIS Integration Runtime (IR) - or "SSIS in the Cloud." Attend this session to learn: - How to build a "native ADF" pipeline; - How to lift and shift SSIS to the Azure Data Factory integration Runtime; and - ADF Design Patterns to execute and monitor pipelines and packages.

SessionID: 89036

Introduction to SQL Server Big Data Clusters

Back to calendar

Event Date: 01-06-2019 - Session time: 14:30:00 - Track: Advanced Analysis Techniques

Speaker: Buck Woody

Title: Introduction to SQL Server Big Data Clusters

Abstract:

In this session Buck Woody explains how Microsoft has implemented the SQL Server 2019 relational database engine in a big data cluster leverages an elastically scalable storage layer that integrates SQL Server and HDFS to scale to petabytes of data storage. You’ll see the three ways you can interact with massive amounts of data: Data Virtualization, Data Marts, and working with a complete Kubernetes Cluster in SQL Server.

You’ll also learn common use case scenarios that leverage big data and the SQL server 2019 Big Data Cluster on-premises, in the cloud, and in a hybrid architecture.

Learning Objectives:

SessionID: 89358

An (Advanced) Introduction to DAX

Back to calendar

Event Date: 01-06-2019 - Session time: 14:30:00 - Track: BI Information Delivery

Speaker: Eugene Meidinger

Title: An (Advanced) Introduction to DAX

Abstract:

Coming from the Excel world, DAX can look like Excel formulas on steroids. However, to be successful with DAX and Powerpivot, you'll need a completely different mental model. In this introduction to DAX, we won't spend too much time on the basics. Instead, we'll focus the concepts that make DAX unique. This will help you avoid the stumbling blocks of working with DAX. We will cover calculated columns, measures, aggregations, filtering, and iterators.

SessionID: 91602

Query Plan Deep Dive

Back to calendar

Event Date: 01-06-2019 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Kevin Boles

Title: Query Plan Deep Dive

Abstract:

Another in TheSQLGuru's Deep Dive series! Query plans - the roadmaps of how your query will be handled by the engine. TONs of information for the asute SQL Server user. Lets dig into them and see what we can learn from and about them and also talk about how they can be used to aid our query tuning efforts.

SessionID: 92032

T-SQL Window Function Performance in 2019

Back to calendar

Event Date: 01-06-2019 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Kathi Kellenberger

Title: T-SQL Window Function Performance in 2019

Abstract:

Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features and enhancements to SQL Server in 2019 that make performance even better. What you don’t know can hurt you when you are using window functions.

SessionID: 92433

Practical Container Scenarios in Azure

Back to calendar

Event Date: 01-06-2019 - Session time: 14:30:00 - Track: Cloud Application Development Deployment

Speaker: Anthony Nocentino

Title: Practical Container Scenarios in Azure

Abstract:

You’ve heard the buzz about containers and Kubernetes, now let’s start your journey towards rapidly deploying and scaling your container-based applications in Azure. In this session, we will introduce containers and the container orchestrator Kubernetes. Then we’ll dive into how to build a container image, push it into our Azure Container Registry and deploy it our Azure Kubernetes Services cluster. Once deployed, we’ll learn how to keep our applications available and how to scale them using Kubernetes.

Key topics introduced Publishing containers to Azure Container Registry Deploying Azure Kubernetes Services Clusters Scaling our container-based applications in Azure Kubernetes Services

SessionID: 92555

Raspberry Pi and SQL Server

Back to calendar

Event Date: 01-06-2019 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Mike Burek

Title: Raspberry Pi and SQL Server

Abstract:

You spend all your time working in the software world on a computer, where everything you do happens inside a virtual machine, inside a data center that you can never visit. Wouldn't it be fun to bring some of that into the physical world?

Come see some examples of how to connect SQL Server with the Raspberry Pi. We can make a noise when a job is done running. We can show a gauge of the system activity. We can even push a button to start T-SQL code running.

SessionID: 93068

Mastering your Resume Interview: Tips to Get Hired

Back to calendar

Event Date: 01-06-2019 - Session time: 14:30:00 - Track: Professional Development

Speaker: Christine Assaf

Title: Mastering your Resume Interview: Tips to Get Hired

Abstract:

Looking for a job? Learn trade secrets from a Recruiter! Resume blunders and interview tips, this session will focus on ten most important things you can do to get hired.

SessionID: 88089

Hackers move away, we are Always Encrypted

Back to calendar

Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Strategy and Architecture

Speaker: Reinaldo Kibel

Title: Hackers move away, we are Always Encrypted

Abstract:

Hands on presentation of a solution of managing SQL Server SA password on a central repository encrypted using SQL Server 2016/2017/2019 SQL on Linux Always Encrypted feature. Demonstrate how to rotate changing the password on a daily basis of the service account and update the internal tables. Show an end to end solution on how to implement Always Encrypted feature, the application requirement, changes. Using a Hardware Security module (HSM). How does it work with AlwaysOn high availability. We will go in details on how Always Encrypted works, the pros and cons of using this comparing to other technologies. And will briefly cover the 2 other security enhancements added to SQL Server 2016 (Row Level Security, Dynamic Data Masking). We will compare existing TDE and other encryption technologies to these ones on SQL Server.

SessionID: 88156

Be Part of the Solution with Automation

Back to calendar

Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Cloud Application Development Deployment

Speaker: Kellyn Pot'Vin-Gorman

Title: Be Part of the Solution with Automation

Abstract:

DevOps automation can be intriguing to learn and overwhelming to implement. This session will take a real life use case of a multi-tier and complex environments, with various stake holders to a successful conclusion. The session will demonstrate the reasons to automate, along with the steps required to make it possible, offering insight into concepts that are often too vague to employ. The attendee will see multi-platform and cloud tool demonstrations on how to take the DevOps methodology and continuous delivery to actuality in their own projects, no matter if small or large.

SessionID: 88267

SQL Server Security from the ground up

Back to calendar

Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Kenneth Fisher

Title: SQL Server Security from the ground up

Abstract:

In the modern age, data is a company's most valuable resource and, unfortunately, data crimes are common and laws to protect data are becoming more common and can have harsh punishments. Because of this, everyone that works with SQL Server should have a basic understanding of database security. Join me as we explore the what, how, and why of database security. Learn what permissions, securables, and principals are. Learn how to manage database security. Most importantly, learn what the best practices are and why they are important. Your company's data is your responsibility, and after attending this session you can step up and keep it safe.

SessionID: 88664

SQL in Azure 101

Back to calendar

Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Mark Moore

Title: SQL in Azure 101

Abstract:

Want to run SQL in Azure. This session will cover all of your options from running SQL in a Windows or Linux VM to Azure SQL PaaS offerings.

This is an introductory session. At the end of this session you will have a good understanding of what SQL options are available in Azure and how to create and manage each one.

SessionID: 89765

Indexing Like a Rocket Scientist

Back to calendar

Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: Indexing Like a Rocket Scientist

Abstract:

Performance is what your users care about, and indexes can both improve and decrease

performance. As a SQL Developer, do you understand the difference between a clustered and non-clustered index or what a covering index is? What is different between OLTP and data warehouse databases when it comes to indexing? This session is a deep dive into  Clustered indexes  Non-clustered indexes  B-Tree traversal  Primary Keys  Covering indexes

This session will feature live query demos illustrating index utilization and performance using statistics and query plans. Understand indexing like a rocket scientist by attending this session!

Some knowledge of T-SQL and Management Studio is recommended.

SessionID: 90386

Beginning Powershell for DBAs 1.0

Back to calendar

Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Beginning Powershell for DBAs 1.0

Abstract:

The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.

SessionID: 90728

Building measures in Power BI (and SQL Server Analysis Services tabular models)

Back to calendar

Event Date: 01-06-2019 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Mike Diehl

Title: Building measures in Power BI (and SQL Server Analysis Services tabular models)

Abstract:

In this sessions, we will create measures using the DAX language to support more sophisticated data analytics.

We'll look at measures for Time Intelligence, such as Year To Date, Previous Year, Year over Year, Moving Annual Total, Rolling Averages. We'll also look at measures that handle different dimensional granularities, like Forecast/Budget measures. The DAX language is designed to look like Excel functions, so if you don't have any Power BI experience, but you are an Excel wizard, you should be able to follow.

SessionID: 91634

Where should I store my database?

Back to calendar

Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Strategy and Architecture

Speaker: Paul Bell

Title: Where should I store my database?

Abstract:

For this presentation, I'll go through the Top 5 locations for where we can store a SQL database today: physical, virtual, IaaS (Azure VM and EC2), Managed Instances, or DBaaS (Azure SQL DB). We'll spend 5-10min on each offering going over pros/cons and several use cases. You'll know which avenue is a home run and which services will be horribly wrong for your database.

SessionID: 92013

Introduction to GitHub

Back to calendar

Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Joshua Higginbotham

Title: Introduction to GitHub

Abstract:

Getting started with GitHub can at times be overwhelming. Especially when you've been working with other source control and project management systems your whole career. In this session, we will overview the below tasks to ensure your success with GitHub.

SessionID: 93139

Are You Optimistic About Concurrency?

Back to calendar

Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Kalen Delaney

Title: Are You Optimistic About Concurrency?

Abstract:

What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012's SNAPSHOT Isolation optimistic? How can SQL Server 2016's In-Memory OLTP provide truly optimistic concurrency?

In this session, we'll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new technology added in SQL Server 2014 that allows the enormous benefits of having totally in-memory storage with no waiting!