sqlsathistory

Nr: 962

SQLSaturday #962 – Richmond - Virtual 2020

Start Time (24h)	Speaker	Track	Title
09:00:00	Andy Leonard	Cloud Application Development Deployment	Azure DevOps and the SSIS Development Lifecycle
09:00:00	Wayne Sheffield	Internals Performance	Intelligent Query Processing in SQL Server 2019
09:00:00	Angela Henry	Application Database Development	Intro to Azure Data Catalog
09:00:00	Thomas Norman	Application Database Development	Encrypting Data within SQL Server
10:15:00	Mohammad Darab	Enterprise Database Administration Deployment	Big Data Clusters for the Absolute Beginner
10:15:00	Stephen Leonard	Enterprise Database Administration Deployment	Installing SQL Server on a Raspberry Pi
10:15:00	Taiob Ali	Enterprise Database Administration Deployment	Think like the Cardinality Estimator
10:15:00	Timothy McAliley	High Availability	Azure SQL Database: High Availability and Disaster Recovery Options
11:25:00	Rick Heiges	Enterprise Database Administration Deployment	Azure SQL DB Managed Instance: Today
11:25:00	Louis Davidson	Database Design Architecture	Relational Design Critique
11:25:00	Chris Bell	Enterprise Database Administration Deployment	Building Your First SQL Server Container Lab in Docker
11:25:00	Jason Brimhall	Master Level	Becoming Ever More Intimate with your Indexes
13:45:00	David Patrick	BI Platform Architecture, Development Administration	Microsoft and Big Data - An Overview of the Power Tools and more!
13:45:00	Steve Jones	Application Database Development	Adopting a Compliant Database DevOps Process
13:45:00	Louis Davidson	Application Database Development	Characteristics of a Great Relational Database
13:45:00	Kevin Feasel	Application Database Development	Data Virtualization with PolyBase
15:00:00	Sarah Patrick	Application Database Development	Case Study: How I used SharePoint, Flow, PowerApps, and Forms to build a Speaker Database
15:00:00	Kevin Kline	Application Database Development	Uncommon Techniques Every SQL Programmer Should Know
15:00:00	Travis Lawrence	Cloud Application Development Deployment	Git Ready to Reduce Errors and Deploy Faster with Azure DevOps and tSQL-t Unit Tests
15:00:00	Kevin Feasel	Enterprise Database Administration Deployment	Optimizing Backup Performance Using Data Science Techniques
16:10:00	George Walkey	Enterprise Database Administration Deployment	Centralized Alert Dashboarding
16:10:00	Tony McGovern	Azure / Cloud / Big Data	Choosing the Right Data Science Services in Azure: Scale, Automate, and Deploy with Ease
16:10:00	Kevin Kline	Internals Performance	An In-depth Look Inside SQL Server
16:10:00	Jason Brimhall	Application Database Development	Bare Naked Skinny on SQL Server
16:10:00	Jim Donahoe	Cloud Application Development Deployment	Getting started with Azure SQL Database: What You Need To Know!

SessionID: 102659

Azure DevOps and the SSIS Development Lifecycle

Back to calendar

Event Date: 25-04-2020 - Session time: 09:00:00 - Track: Cloud Application Development Deployment

Speaker: Andy Leonard

Title: Azure DevOps and the SSIS Development Lifecycle

Abstract:

Data Integration Lifecycle Management - or DILM - is challenging regardless of your chosen data integration platform.

The primary goal of this session is an explanation - via demonstration - of the production release of an SSIS Project. We will walk this project through lifecycle management using Azure DevOps - from initial development, through testing, to production.

SessionID: 104286

Intelligent Query Processing in SQL Server 2019

Back to calendar

Event Date: 25-04-2020 - Session time: 09:00:00 - Track: Internals Performance

Speaker: Wayne Sheffield

Title: Intelligent Query Processing in SQL Server 2019

Abstract:

SQL Server has evolved many times over the years. SQL Server 2019 introduces “Intelligent Query Processing”, greatly enhancing the “Adaptive Query Processing” which was introduced in SQL Server 2017. Intelligent Query Processing allows your queries to operate more efficiently (resulting in better query performance) – without needing to make changes to the code or the application. In this session we will explore all the Intelligent Query Processing features in SQL Server 2019. Time permitting, we will go into other changes in recent versions of SQL Server (such as execution plan changes and new Dynamic Management Objects) that will help improve your efficiency at troubleshooting and tuning SQL Server. Coming away from this session, you will have plenty of reasons to want to upgrade to SQL Server 2019 immediately!

SessionID: 104534

Intro to Azure Data Catalog

Back to calendar

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

Speaker: Angela Henry

Title: Intro to Azure Data Catalog

Abstract:

Your company has amassed more data than it can possibly use, yet no one can find the data they need. This is more common than you think. With Azure Data Catalog, anyone can find the data they are looking for, no matter the data source. This session will introduce you to Azure Data Catalog, what it is, how you can use it and why everyone should be using it.

SessionID: 104556

Encrypting Data within SQL Server

Back to calendar

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

Speaker: Thomas Norman

Title: Encrypting Data within SQL Server

Abstract:

Data breaches abound! Do you want to keep your company out of the headlines? 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. While we look at the encryption options, we will review both on-premise and cloud offerings. This session will deep dive into setting up Always Encrypted encryption and share experiences implementing the encryption.

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

SessionID: 101139

Big Data Clusters for the Absolute Beginner

Back to calendar

Event Date: 25-04-2020 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Mohammad Darab

Title: Big Data Clusters for the Absolute Beginner

Abstract:

Are you a DBA or data professional working with out-dated technology or feel your skills are quickly becoming irrelevant? Stay ahead in today's ever changing tech space and take your career to the next level.

Join Mohammad Darab this session to explore the cutting-edge technology that SQL Server 2019 has to offer: Big Data Clusters.

Topics include: -Big Data Cluster architecture and its components such as: Containers, Kubernetes and the newly enhanced Polybase -Unique advantage of SQL Server Big Data Clusters -Data Virtualization, Scale-out Data Marts, and Data Hub concepts

SessionID: 103805

Installing SQL Server on a Raspberry Pi

Back to calendar

Event Date: 25-04-2020 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Stephen Leonard

Title: Installing SQL Server on a Raspberry Pi

Abstract:

The Raspberry Pi is a series of small single-board computers developed in the United Kingdom by the Raspberry Pi Foundation to promote the teaching of basic computer science in schools and developing countries. It is a multi-faceted device that can be used for many functions, one of which being Internet of Things, or IoT, applications. In our case, SQL Server. The primary goal of this session is a walkthrough tutorial on how to properly install SQL Server on a Raspberry Pi.

SessionID: 104539

Think like the Cardinality Estimator

Back to calendar

Event Date: 25-04-2020 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Taiob Ali

Title: Think like the Cardinality Estimator

Abstract:

SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates bases on the statistics as to how many rows flow from one query plan iterator to the next. Knowing how CE generates these numbers will enable you to write better TSQL code and, in turn, influence the type of physical operations during query execution. Based on that estimated rows, the query processor decides how to access an object, which physical join to use, how to sort the data. Do you know how the CE generates these numbers? What happens when you have multiple predicates, range predicates, variable values that are “NOT KNOWN” to the optimizer, or you have predicate values increasing in ascending order? Do you know what will happen if your predicate is using a value that is outside of the histogram range?

In this session, I will show you how CE estimates in all of these scenarios, and you will walk out better equipped to tackle those nasty, hard to solve query p

SessionID: 104540

Azure SQL Database: High Availability and Disaster Recovery Options

Back to calendar

Event Date: 25-04-2020 - Session time: 10:15:00 - Track: High Availability

Speaker: Timothy McAliley

Title: Azure SQL Database: High Availability and Disaster Recovery Options

Abstract:

In this session we will review options for high availability and disaster recovery for Azure SQL Databases. We will delve into high availability and back up/restore options for singleton databases, elastics pools and managed instances. We will discuss the pros and cons and best practices for each high availability and disaster recovery option (from an operations perspective and the all important cost perspective).

SessionID: 102454

Azure SQL DB Managed Instance: Today

Back to calendar

Event Date: 25-04-2020 - Session time: 11:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Rick Heiges

Title: Azure SQL DB Managed Instance: Today

Abstract:

It has been about a year since Azure SQL DB Managed Instance has been released. What is it? Where does it fit? What limitations does it have? What has changed? What changes should I see next? These questions will be addressed and more. Will we see Managed Instance in action? We can, but it is just SQL Server presented in a different wrapper. Along with Managed Instance, a discussion of Serverless and Hyperscale options will also be included.

SessionID: 103681

Relational Design Critique

Back to calendar

Event Date: 25-04-2020 - Session time: 11:25:00 - Track: Database Design Architecture

Speaker: Louis Davidson

Title: Relational Design Critique

Abstract:

The process of designing a relational database is not overly complex, and may be done by almost anyone on the development team. The process requires one to take the time to understand the requirements, when they exist, and apply a straightforward set of transforms to produce table structures that meets the needs. The tough part is that the process requires time and experience, neither of which anyone has enough of. In this session, to help the attendee differentiate right-enough designs from overly simple or overly complex designs, we will look at a variety of database snippets, each inspired from a real life design. We will discuss the pros and cons of the approach taken, and consider possible remediations to learn from a failure that was made by someone else.

SessionID: 103729

Building Your First SQL Server Container Lab in Docker

Back to calendar

Event Date: 25-04-2020 - Session time: 11:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Bell

Title: Building Your First SQL Server Container Lab in Docker

Abstract:

A few years back, virtualization changed the way to work with SQL and infrastructure. Now, the next chapter is opening and it’s all about containers. Containers can make the DBA’s job of creating and deploying servers much easier freeing them up for other tasks such as performance tuning and security.

In this session, we will go over the concepts of containers, their general capabilities, and then build, connect, and configure a SQL Server in a container for use as a private lab.

SessionID: 104467

Becoming Ever More Intimate with your Indexes

Back to calendar

Event Date: 25-04-2020 - Session time: 11:25:00 - Track: Master Level

Speaker: Jason Brimhall

Title: Becoming Ever More Intimate with your Indexes

Abstract:

Among the many critical and basic concepts to understand within SQL Server comes the concept of indexes. Indexes can be a significant asset or a scary detriment to your environment. During this session we will work through the basics of indexing within SQL Server and then explore some of the more interesting misconceptions I have encountered.

Do you know how useful your indexes are? Do you know if your indexes might be a bit piggy? Do you know the impact of the indexes on your execution plans? These are just a few of the many questions that I will cover throughout the session as we move quickly through this important topic.

SessionID: 101119

Microsoft and Big Data - An Overview of the Power Tools and more!

Back to calendar

Event Date: 25-04-2020 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: David Patrick

Title: Microsoft and Big Data - An Overview of the Power Tools and more!

Abstract:

Come see Microsoft's Power tools demonstrated for advanced analytics and hear about Microsoft's embrace of Open Source and the Hadoop platform. We'll also present on Microsoft's tools for handling Big Data, such as the Parallel Data Warehouse and HDInsights.

SessionID: 103519

Adopting a Compliant Database DevOps Process

Back to calendar

Event Date: 25-04-2020 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Steve Jones

Title: Adopting a Compliant Database DevOps Process

Abstract:

SessionID: 103679

Characteristics of a Great Relational Database

Back to calendar

Event Date: 25-04-2020 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Louis Davidson

Title: Characteristics of a Great Relational Database

Abstract:

When queried, most database professionals would mention normalized as one of the most important characteristics that tell the difference between a good and bad relational database design (whether they know what the term "normalized" means or not.) Normalization is a key to great relational designs, but there is so much more to be considered. A normalized database that suffers from poor naming, too many or too few indexes, terrible interfaces, and so on can derail your design's value to the user. In this session I will present primary characteristics of a design that differentiates between an ugly design that will have your colleagues nitpicking you to death and one that will have them singing your praises. Characteristics such as comprehendible, documented, secure, well performing, and more (including normalized, naturally) will be discussed.

SessionID: 104521

Data Virtualization with PolyBase

Back to calendar

Event Date: 25-04-2020 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Kevin Feasel

Title: Data Virtualization with PolyBase

Abstract:

PolyBase is Microsoft's data virtualization technology, allowing you to integrate SQL Server with external systems such as Hadoop and Azure Blob Storage. As of SQL Server 2019, PolyBase also allows you to connect to diverse systems such as Oracle, MongoDB, Cosmos DB, Teradata, Apache Spark, and even other SQL Server instances. In this talk, we will walk through the mechanics of PolyBase, showing how we can write T-SQL queries to access data from heterogeneous sources. We will investigate the Dynamic Management Views (DMVs) and other resources needed to tease out what the PolyBase engine is doing behind the scenes and where to go when things break down. Finally, we will look at several interesting use cases for PolyBase in the modern data environment.

SessionID: 102282

Case Study: How I used SharePoint, Flow, PowerApps, and Forms to build a Speaker Database

Back to calendar

Event Date: 25-04-2020 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Sarah Patrick

Title: Case Study: How I used SharePoint, Flow, PowerApps, and Forms to build a Speaker Database

Abstract:

In this case study, I detail how I went about designing and implementing a Speaker Database for the Project Management Institute using SharePoint, Flow, Power Apps, and Microsoft Forms. We will do a brief intro of what each technology is and it's pros and cons, and then dive into what I learned about each, each strengths and weaknesses, and how I was able to build a functional Speaker Database.

SessionID: 103787

Uncommon Techniques Every SQL Programmer Should Know

Back to calendar

Event Date: 25-04-2020 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Kevin Kline

Title: Uncommon Techniques Every SQL Programmer Should Know

Abstract:

SELECT statements have a reputation for being very easy to write, but hard to write very well. This session will take you through ten of the most problematic patterns and anti-patterns when writing queries and how to deal with them all. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.

You'll learn things like a T-SQL code test harness, the value of clone databases, which temporary object is best, why CTE's don't help performance and can sometimes hurt, which cursors are good for performance, how data type inconsistencies can bring your server to a screeching halt, what single line of T-SQL code can provide double-digit percentage increase in performance, and much more. Attend this session to take your query writing and query tuning skills to the next level!

SessionID: 103790

Git Ready to Reduce Errors and Deploy Faster with Azure DevOps and tSQL-t Unit Tests

Back to calendar

Event Date: 25-04-2020 - Session time: 15:00:00 - Track: Cloud Application Development Deployment

Speaker: Travis Lawrence

Title: Git Ready to Reduce Errors and Deploy Faster with Azure DevOps and tSQL-t Unit Tests

Abstract:

DataOps is becoming increasingly important to keep pace with application development in a manageable way. With Azure DevOps and tSQL-t unit test, data professionals can set up data-friendly CI/CD pipelines that will reduce errors and decrease deployment time.

In this session, we will explore the following: • Challenges of implementing DataOps • Creating the Visual Studio database solution project • Integration with source control • Creating tSQL-t unit tests for the database • Creating Azure DevOps Pipelines • Deploying Changes

Join this session and reduce your stress the next time you deploy your DB. After this session you will have the foundational knowledge for implementing DataOps on your project.

SessionID: 104522

Optimizing Backup Performance Using Data Science Techniques

Back to calendar

Event Date: 25-04-2020 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Feasel

Title: Optimizing Backup Performance Using Data Science Techniques

Abstract:

One of the most important tasks for a database administrator is taking (and testing!) backups. As databases get larger and larger, the amount of time it takes to perform a backup can grow as well, to the point where your backups take longer than your available backup window. There are several settings we can use to optimize backup performance, such as buffer counts, maximum transfer size, and the number of files, but trying every combination of settings on a single production-sized database could take weeks or even months. In this talk, we will apply data science techniques to the problem of backup settings optimization and look at different models for approaching the problem and analyzing data. Some statistics background would be helpful, but is not required; the big requirement is a desire to speed up backups.

SessionID: 101121

Centralized Alert Dashboarding

Back to calendar

Event Date: 25-04-2020 - Session time: 16:10:00 - Track: Enterprise Database Administration Deployment

Speaker: George Walkey

Title: Centralized Alert Dashboarding

Abstract:

Its easy to build a Centralized Dashboard for all your Server's Agent Alerts that can monitor all your Servers. In 60 minutes we will create a Dashboard using SQL Agent, Powershell and SSRS that is easy-to-maintain and deploy.

SessionID: 101167

Choosing the Right Data Science Services in Azure: Scale, Automate, and Deploy with Ease

Back to calendar

Event Date: 25-04-2020 - Session time: 16:10:00 - Track: Azure / Cloud / Big Data

Speaker: Tony McGovern

Title: Choosing the Right Data Science Services in Azure: Scale, Automate, and Deploy with Ease

Abstract:

Microsoft Azure offers a multitude of cloud-based products that simplify the data science workflow in unique ways. Together these products each have different purposes that help the data science team with various aspects of the machine learning process.

In this session, we'll unpack the challenge in determining which product is best suited for each task. We'll explore the most popular machine learning products on Azure and describe how each fit into a typical data science workflow.

We'll also explore how to right-size your data science team to best utilize each Azure machine learning product so you’re efficiently solving problems as quickly and cheaply as possible.

By the end of this session, you'll understand how to choose the set of Azure machine learning products that fit your data science team within a typical data science workflow, allowing them to scale, automate, and deploy a machine learning process with ease.

SessionID: 103785

An In-depth Look Inside SQL Server

Back to calendar

Event Date: 25-04-2020 - Session time: 16:10:00 - Track: Internals Performance

Speaker: Kevin Kline

Title: An In-depth Look Inside SQL Server

Abstract:

  What are the various areas of memory inside of SQL Server?

  How are queries handled behind the scenes?

  What does SQL Server do with procedural code, like functions, procedures, and triggers?

  What happens during checkpoints?  Lazywrites?

  How are IOs handled with regards to transaction logs and database?

  What happens when transaction logs and databases grow or shrinks?

SessionID: 104470

Bare Naked Skinny on SQL Server

Back to calendar

Event Date: 25-04-2020 - Session time: 16:10:00 - Track: Application Database Development

Speaker: Jason Brimhall

Title: Bare Naked Skinny on SQL Server

Abstract:

Ever feel like there are just too many layers with SQL Server? You peel off a layer and behold there is yet another layer. SQL Server is rather complex. The complexities can be rather frustrating from time to time.

Join this NSFW (not safe for whining) session as we strip SQL down to the bare bones. I will help you undress the complexities of a few of the basic SQL Server concepts. These concepts will include locks, principals, query directives and deadlocks.

In this session I will disrobe misunderstandings related to the aforementioned topics. I will show the different types of principals in SQL Server. I will also show various scenarios involving locks and deadlocks along with some of their effects with and without query directives. The goal is to better understand these topics and to hopefully stop using and perpetuating common mis-uses of terminology and common misconceptions about the technology.

SessionID: 104525

Getting started with Azure SQL Database: What You Need To Know!

Back to calendar

Event Date: 25-04-2020 - Session time: 16:10:00 - Track: Cloud Application Development Deployment

Speaker: Jim Donahoe

Title: Getting started with Azure SQL Database: What You Need To Know!

Abstract:

Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore. In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.

This site is open source. Improve this page.