sqlsathistory

Nr: 845

Back to Main list

SQLSaturday #845 - Atlanta 2019

Start Time (24h)	Speaker	Track	Title
08:00:00	Sean Forgatch	BI Platform Architecture, Development Administration	Azure Data Factory Ingestion Framework
08:00:00	Karlyn LeBlanc	Professional Development	Whipping Away Stress
08:00:00	Angela Tidwell	Machine Learning and Ethics	Data Collection and Usage: Illegal or Unethical?
08:00:00	Michael French	Cloud Application Development Deployment	Event Driven ELT
08:00:00	Ed Watson	BI Platform Architecture, Development Administration	A Beginner's Guide to Power BI
08:00:00	Monica Rathbun	Enterprise Database Administration Deployment	Performance Tuning, Getting the Biggest Bang for Your Buck
08:00:00	Samara Soucy	Analytics and Visualization	Real Time Anomaly Detection With Stream Analytics
08:00:00	John Welch	Strategy and Architecture	Data as an Asset: Patterns and Anti-Patterns for Testing Data
08:00:00	Rick Lowe	Application Database Development	Why is my DBA So Grumpy ... When I Use NOLOCK and Other Query Hints.
08:00:00	Paul Stanton	Cloud Application Development Deployment	SQL DevOps Simplified with Production Databases
08:00:00	Gilda Alvarez	Enterprise Database Administration Deployment	Migrations 101
08:00:00	Kevin Kline	Application Database Development	SQL Server Internals and Architecture
08:00:00	Amie Mason	Advanced Analysis Techniques	Real-World AI in Azure
08:00:00	Christina Wheeler	Application Database Development	Introduction to PowerApps
08:00:00	Robert Cain	PowerShell	PowerShell Core for Linux
09:15:00	Matt Gordon	Enterprise Database Administration Deployment	Azure-d Availability: Scaling SQL Server to the Cloud
09:15:00	Andy Leonard	Cloud Application Development Deployment	Moving Data with Azure Data Factory
09:15:00	Chris Hyde	Analytics and Visualization	Python in SQL Server 2017
09:15:00	Jose Chinchilla	Analytics and Visualization	Azure IoT: An interactive demo
09:15:00	Mohammad Darab	Professional Development	3 Keys to Successful Consulting
09:15:00	Jen Underwood	Analytics and Visualization	Storytelling for Machine Learning and Advanced Analytics
09:15:00	Stuart Ainsworth	Application Database Development	DBA's and DevOps: The Fundamentals
09:15:00	Jim Donahoe	Cloud Application Development Deployment	Getting started with Azure SQL Database: What You Need To Know!
09:15:00	Leslie Andrews	BI Platform Architecture, Development Administration	A Perfect Ten: The Data Model
09:15:00	Mark Tabladillo	Advanced Analysis Techniques	Azure Databricks for Machine Learning
09:15:00	Paul Waters	Application Database Development	SQL Server Data Tools (SSDT) = Awesome
09:15:00	Rie Irish	Application Database Development	Is My Bias Showing? Real World Implications of Application Machine Bias
09:15:00	Jamey Johnston	BI Platform Architecture, Development Administration	Power BI Dataflows and How to Leverage for Data Science
09:15:00	Patrick LeBlanc	Application Database Development	Using the Power platform to radically change your business
10:30:00	Fabiano Amorim	Enterprise Database Administration Deployment	13 reasons why my query is slow
10:30:00	Thomas Norman	Application Database Development	Encrypting Data within Sql Server
10:30:00	Kellyn Pot'Vin-Gorman	101 Beginner Level Sessions	Essential Linux Skills for the DBA
10:30:00	George Walters	Cloud Application Development Deployment	Re-Architect your Software as a Service Application for Azure: Tips and Tricks
10:30:00	Buck Woody	Advanced Analysis Techniques	Introduction to SQL Server Big Data Clusters
10:30:00	Kevin Wilkie	Cloud Application Development Deployment	Azure Data Factory V2
10:30:00	Samir Behara	Application Database Development	DevOps, Continuous Integration Automated Testing: Rule them all
10:30:00	Bill Anton	BI Platform Architecture, Development Administration	Level Up: Data Modeling for the Power BI Rockstar
10:30:00	Preston Mesarvey	BI Platform Architecture, Development Administration	Evolving Your BI Environment From SSRS To Power BI
10:30:00	Alicia Moniz	101 Beginner Level Sessions	AI Cognitive Services: Vision 101
10:30:00	Julie Smith	Advanced Analysis Techniques	Leveraging Python in SQL Server
10:30:00	Michael Fal	PowerShell	Managing SQL Server with Powershell
10:30:00	Paco Gonzalez	BI Platform Architecture, Development Administration	Power BI Architecture
11:45:00	Carl Sheffield	Application Database Development	Be a HERO and build powerful custom apps with Azure SQL Database and Skuid!
11:45:00	Steve Abraham	Cloud Application Development Deployment	Running SQL Server on AWS - High Availability and Reliability in the Cloud
11:45:00	Rie Irish	Professional Development	Women in Tech: Thriving Not Just Surviving
11:45:00	SQL Saturday Atlanta	Sponsor Session	Survival of the Fittest: Matching Approaches for Golden Record
11:45:00	Marsha Pierce	101 Beginner Level Sessions	How Fast Can You Restore Your Database?
11:45:00	SQL Saturday Atlanta	Sponsor Session	Profisee Sponsor Session
11:45:00	SQL Saturday Atlanta	Sponsor Session	Dell EMC Sponsor Session
11:45:00	SQL Saturday Atlanta	Sponsor Session	Successfully Virtualizing SQL Server on vSphere - Straight from t
11:45:00	SQL Saturday Atlanta	Sponsor Session	Improving - Atlanta
11:45:00	SQL Saturday Atlanta	Sponsor Session	SIOS -SANLess clustering for physical, virtual and cloud environm
13:00:00	Anthony Nocentino	Cloud Application Development Deployment	Containers - You Better Get on Board!
13:00:00	Hasan Savran	Strategy and Architecture	Not your Dad's SQL Server; Contemporary twist on a classic standby.
13:00:00	Geoff Hiten	BI Platform Architecture, Development Administration	Where the Heck in Azure is SSIS?
13:00:00	Bob Ward	Enterprise Database Administration Deployment	Inside SQL Server 2019
13:00:00	Teo Lachev	BI Platform Architecture, Development Administration	What's New for BI in SQL Server 2019
13:00:00	Armando Lacerda	Enterprise Database Administration Deployment	Unleashing Stretched Databases
13:00:00	David Klee	Strategy and Architecture	Modern CPU Architecture and SQL Server Performance
13:00:00	Vladimir Oselsky	Application Database Development	Performance Tuning for SQL Developer through Execution Plans
13:00:00	Sean McCown	Application Database Development	The Master Stored Procedure Workshop: Part 1
13:00:00	Jeremy Edmondson	101 Beginner Level Sessions	What is CosmosDB and should I care about it?
13:00:00	Tamera Clark	101 Beginner Level Sessions	How do you Azure?
13:00:00	Chris Voss	Professional Development	First Day on the Job: Getting to Know Your Database
13:00:00	Shabnam Watson	Cloud Application Development Deployment	Introduction to Azure Analysis Services
14:15:00	Tracy Boggiano	Enterprise Database Administration Deployment	Intro to Query Store
14:15:00	Louis Davidson	Application Database Development	Database Design Fundamentals
14:15:00	Jennifer Brocato	Strategy and Architecture	HA/DR Solutions Using Distributed Availability Groups (Read-Scalable AGs too!)
14:15:00	Kerry Tyler	BI Platform Architecture, Development Administration	45 Minutes to Your First Tabular Model
14:15:00	Andy Yun	Enterprise Database Administration Deployment	Uncovering Duplicate, Redundant, Missing Indexes
14:15:00	Andy Warren	Professional Development	A System for Managing Career Learning
14:15:00	Jennifer McCown	101 Beginner Level Sessions	Beginning Admin: The Care and Feeding of SQL Server
14:15:00	Amy Herold	PowerShell	PowerShell for the DBA
14:15:00	Janis Griffin	Application Database Development	Everything You Need to Know About SQL Server Indexes
14:15:00	George Govantes	Strategy and Architecture	Implementing IT and Data Governance using Azure Policy Management
14:15:00	Joseph D'Antoni	Enterprise Database Administration Deployment	Azure Managed Instances—Your Bridge to the Cloud
14:15:00	Shawn Melton	Enterprise Database Administration Deployment	Implementing dbatools with Azure Automation
14:15:00	Lance Tidwell	Application Database Development	New Features in SQL That Will Change the Way You Tune
14:15:00	Elizabeth Noble	Application Database Development	Overcoming Challenges with Source Control and Continuous Integration.
15:30:00	Shannon Lowder	Advanced Analysis Techniques	Becoming a Data Scientist
15:30:00	Bhakthi Liyanage	Analytics and Visualization	Getting started with Azure Machine Learning Services
15:30:00	David Maxwell	Application Database Development	Understanding and Implementing System-Versioned Temporal Tables
15:30:00	Trey Johnson	Analytics and Visualization	Ensuring Analytics Hit the Mark (and Get Used!)
15:30:00	Mindy Curnutt	Application Database Development	Parameters in SQL Server - Query Performance Makers or Breakers
15:30:00	Patrick LeBlanc	BI Platform Architecture, Development Administration	Creat Pixel Perfect Reports: The Story of Paginated Reports
15:30:00	Deborah Melkin	101 Beginner Level Sessions	Back to the Basics: T-SQL 101
15:30:00	Sven Aelterman	Cloud Application Development Deployment	The New Tool in Your Kit: Azure Data Studio
15:30:00	Shawn Wildermuth	Application Database Development	Optimizing Data Access: Mixing Entity Framework Core and Dapper
15:30:00	Marsha Pierce	Strategy and Architecture	SQL Server with Docker Containers
15:30:00	Nathan Boster	101 Beginner Level Sessions	Turbo-charging SSMS for Beginners
15:30:00	Ken Muse	Cloud Application Development Deployment	The Art of Data DevOps with SSDT
15:30:00	Jason Brimhall	Enterprise Database Administration Deployment	Extended Events - Better than Profiler
15:30:00	Mike Walsh	101 Beginner Level Sessions	HA/DR - Too Many Choices!

SessionID: 87797

Azure Data Factory Ingestion Framework

Back to calendar

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

Speaker: Sean Forgatch

Title: Azure Data Factory Ingestion Framework

Abstract:

In this session we will discuss Data Strategy around data lake ingestion and how that shapes the design of a framework to fuel Azure Data Factory. This session will take you through the development of a Metadata database designed using Data Vault modeling, the collection of the metadata, as well as building a fully automated Data Factory pipeline.

SessionID: 88515

Whipping Away Stress

Back to calendar

Event Date: 18-05-2019 - Session time: 08:00:00 - Track: Professional Development

Speaker: Karlyn LeBlanc

Title: Whipping Away Stress

Abstract:

Did you know stress releases chemicals into the blood? These chemicals give more energy and strength, which can be a positive if the stress is caused by physical danger. But this can also be a negative, if the stress is in response to something emotional and there is no way to release the extra energy and strength. Need stress management techniques? Stressed out? Learn how to cope and ultimately whip stress away.

SessionID: 89615

Data Collection and Usage: Illegal or Unethical?

Back to calendar

Event Date: 18-05-2019 - Session time: 08:00:00 - Track: Machine Learning and Ethics

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

Event Driven ELT

Back to calendar

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

Speaker: Michael French

Title: Event Driven ELT

Abstract:

An Azure based approach to Modern Data Movement. See a practical demonstration of how to move data from Azure Blob Storage to an Azure SQL Database using Azure Data Factory and Logic Apps.

SessionID: 89905

A Beginner's Guide to Power BI

Back to calendar

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

Speaker: Ed Watson

Title: A Beginner's Guide to Power BI

Abstract:

Are you new to Power BI? Do you want to learn what all the buzz is about and how to use it from a purely novice standpoint? Do you need to ramp up quickly to be able to build some great visualizations? This session is the session that you need! We will walk you through the basic architecture and nuances of Power BI all the while taking a fun adventure to building your first Power BI report. The attendee will leave the class ready to start using Power BI in the real world.

SessionID: 89911

Performance Tuning, Getting the Biggest Bang for Your Buck

Back to calendar

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

Speaker: Monica Rathbun

Title: Performance Tuning, Getting the Biggest Bang for Your Buck

Abstract:

Everyone wants to know if there are magic buttons you can push to make SQL Server run faster, better and more efficiently. In this session we will go over some of my go-to performance tricks that you can implement to get the biggest improvement with the least amount of change. When it comes to performance tuning, every second counts. We will cover memory optimization, isolation levels, trace flags, statistics, configuration changes and more. I’ll go over real life scenarios we come across as consultants and the changes we made to fix them.

SessionID: 90679

Real Time Anomaly Detection With Stream Analytics

Back to calendar

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

Speaker: Samara Soucy

Title: Real Time Anomaly Detection With Stream Analytics

Abstract:

One of the main goals of reporting is to spot issues. This is always useful in some fashion, but the best reports allow the user to find and correct problems before they have a chance to impact the business. Stream Analytics empowers you to analyze events as they happen and flag those that require intervention. We'll take a look at how the service can generate alerts or even take action automatically when a piece of equipment runs into trouble.

SessionID: 90716

Data as an Asset: Patterns and Anti-Patterns for Testing Data

Back to calendar

Event Date: 18-05-2019 - Session time: 08:00:00 - Track: Strategy and Architecture

Speaker: John Welch

Title: Data as an Asset: Patterns and Anti-Patterns for Testing Data

Abstract:

Learn common patterns for testing data, and the anti-patterns that trip developers up.

Data is a critical asset for many companies, but often it's not treated that way. During this session, we'll discuss common patterns for testing, validating, and monitoring your data to ensure that it is accurate and complete. This will include patterns for • data warehousing • data integration • data migration We will also discuss the common pitfalls that organizations encounter when they start treating their data as an asset, including: • treating data testing like application testing • testing the wrong things • not supporting your data testing initiatives for the long term Attend this session, and you will gain valuable information on ensuring your data is a real asset to your organization.

SessionID: 90978

Why is my DBA So Grumpy ... When I Use NOLOCK and Other Query Hints.

Back to calendar

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

Speaker: Rick Lowe

Title: Why is my DBA So Grumpy ... When I Use NOLOCK and Other Query Hints.

Abstract:

Most of us have heard that using the NOLOCK hint is not recommended. But why is this? What is it about NOLOCK that sends most DBAs into a tizzy? And how about other hints such as ROWLOCK and RECOMPILE - are they OK to use? Come hear a discussion on why exactly query hints cause problems when used excessively, and watch some demos of NOLOCK craziness in action.

SessionID: 91022

SQL DevOps Simplified with Production Databases

Back to calendar

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

Speaker: Paul Stanton

Title: SQL DevOps Simplified with Production Databases

Abstract:

DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process. In the case of SQL Server, however, a database is already in production, and isn’t simply replaced (as an app binary), but is upgraded. Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing. "Near production data" is used in Staging, and finally production is upgraded. This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process. Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages. Production database clones are delivered more quickly than "built" databases, are more easily integrated with source control, and produces higher fidelity outcomes. Learn how leading enterprises are simplifying SQL DevOps.

SessionID: 91030

Migrations 101

Back to calendar

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

Speaker: Gilda Alvarez

Title: Migrations 101

Abstract:

The only constant thing is change. As companies continue to migrate to newer versions or different data centers, we need to develop strategies and tools to make sure we can perform successful migrations. What if we had a checklist? Just like moving to a new home the success of the "move" relies on the preparation. This presentation will go over a checklist of steps needed to prepare for a database migration.

SessionID: 91359

SQL Server Internals and Architecture

Back to calendar

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

Speaker: Kevin Kline

Title: SQL Server Internals and Architecture

Abstract:

Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:

•   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: 91683

Real-World AI in Azure

Back to calendar

Event Date: 18-05-2019 - Session time: 08:00:00 - Track: Advanced Analysis Techniques

Speaker: Amie Mason

Title: Real-World AI in Azure

Abstract:

Discover the ways Azure transforms AI and Predictive Analytics making it easier and more accessible through services like Azure Machine Learning and pre-built Cognitive Services, while also supporting custom development and deep-learning. Discussion of real-world scenarios and the tools used to solve them.

SessionID: 91690

Introduction to PowerApps

Back to calendar

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

Speaker: Christina Wheeler

Title: Introduction to PowerApps

Abstract:

PowerApps is an O365 service that lets you build business apps that can run in the browser, tablet, or phone. To build PowerApps, no coding experience is required since PowerApps combines visual drag-and-drop concepts with Excel-like expressions for building the logic and working with data. You can build PowerApps against a modern SharePoint list or other types of data such as SQL and Excel. PowerApps also provides templates and sample data you can use to quickly build an app that you can customize to better suit your needs. In this session, you will learn the basics to building a PowerApp using PowerApps Studio.

SessionID: 91852

PowerShell Core for Linux

Back to calendar

Event Date: 18-05-2019 - Session time: 08:00:00 - Track: PowerShell

Speaker: Robert Cain

Title: PowerShell Core for Linux

Abstract:

With the advent of SQL Server for Linux, you need a tool you can use to manage it. Sure, you could try to learn bash, python, or some other tool, but wouldn't it be nice to be able to use a scripting language you're familiar with? Or maybe you are a long time Linux admin, now having to work with all this new Microsoft technology. Wouldn't it be great to leverage tools that make your life even easier?

In this session you'll learn all about PowerShell Core for Linux. You'll see just how quick and easy it is to install PowerShell Core, then interact with it from the terminal. But wait, there's more! You'll want a good editor to compose your PowerShell Core scripts in, and that's where VSCode comes in. You'll see how easy it is to install VSCode, then work with your PowerShell Core project within it.

We'll wrap up the session showing how to install SQL Server in a Docker Container, all using PowerShell Core!

SessionID: 87496

Azure-d Availability: Scaling SQL Server to the Cloud

Back to calendar

Event Date: 18-05-2019 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Gordon

Title: Azure-d Availability: Scaling SQL Server to the Cloud

Abstract:

Has your manager come to you and said "I expect the SQL Server machines to have zero downtime?" Have you been told to make your environment "Always On" without any guidance (or budget) as to how to do that or what that means? This session will walk you through the high availability options in on-premises SQL Server, the high availability options in Azure SQL Database, and how those can be combined to enable you to achieve the ambitious goals of your management. Beyond the academic knowledge, we'll discuss real world case studies covering exactly how your on-premises environments and Azure services can work together to keep your phone quiet at night.

SessionID: 87504

Moving Data with Azure Data Factory

Back to calendar

Event Date: 18-05-2019 - Session time: 09: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: 87743

Python in SQL Server 2017

Back to calendar

Event Date: 18-05-2019 - Session time: 09:15:00 - Track: Analytics and Visualization

Speaker: Chris Hyde

Title: Python in SQL Server 2017

Abstract:

SQL Server 2017 has finally arrived, bringing with it 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: 89293

Azure IoT: An interactive demo

Back to calendar

Event Date: 18-05-2019 - Session time: 09:15:00 - Track: Analytics and Visualization

Speaker: Jose Chinchilla

Title: Azure IoT: An interactive demo

Abstract:

The Internet of Things (IoT) is one of the most talked about emerging technologies nowadays. But what is it and how can it help by business? Most importantly, how do I get started? In this presentation, we will do an interactive demo with a Raspberry PI and a Microsoft Sphere MCU along with several sensors and components to capture and analyze data from a connected device in Azure IoT Hub and IoT Central. Learn how to connect, monitor and manage connected devices using Azure IoT Hub. We will also discuss how Azure IoT Edge can simplify secure deployment of complex event processing, ML, and AI functionality to connected devices to reduce the latency of decision making.

SessionID: 89458

3 Keys to Successful Consulting

Back to calendar

Event Date: 18-05-2019 - Session time: 09:15: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: 89941

Storytelling for Machine Learning and Advanced Analytics

Back to calendar

Event Date: 18-05-2019 - Session time: 09:15:00 - Track: Analytics and Visualization

Speaker: Jen Underwood

Title: Storytelling for Machine Learning and Advanced Analytics

Abstract:

Storytelling and depiction of information has existed for hundreds of years in various forms and formats. In today’s era of artificial intelligence and machine-assisted analytics, accurately interpreting and effectively communicating findings is becoming a crucial skill to bridge the growing data literacy gap. To help decision makers get the most value from analytics projects to drive better outcomes, you need to help them make sense of the results.

Machine learning and advanced analytics can be difficult to understand and explain. Describing the problem, the model, the relationships among variables and the findings are often subtle, surprising and technically complex. Effectively translating quantitative insights and telling a compelling story requires planning, compelling design, and visualization choices. Successful analytical communicators use the entire process to communicate with stakeholders. Don't miss this fun demo-packed educational session.

SessionID: 89996

DBA's and DevOps: The Fundamentals

Back to calendar

Event Date: 18-05-2019 - Session time: 09:15:00 - Track: Application Database Development

Speaker: Stuart Ainsworth

Title: DBA's and DevOps: The Fundamentals

Abstract:

DevOps is a software delivery philosophy that focuses on delivering quality, faster. The purpose of this session is to cover some of the basic principles of DevOps and how they apply to database development and administration. Everyone's environment is different, but the strategies discussed within can be translated into basic tactical gains that are easy to implement.

Topics covered include:

• a (VERY) brief history of DevOps
• why DBA's make the best DevOps engineers
• what admins can teach developers, and what developers can teach admins

SessionID: 90056

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

Back to calendar

Event Date: 18-05-2019 - Session time: 09:15: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.

SessionID: 91413

A Perfect Ten: The Data Model

Back to calendar

Event Date: 18-05-2019 - Session time: 09:15: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: 91499

Azure Databricks for Machine Learning

Back to calendar

Event Date: 18-05-2019 - Session time: 09:15:00 - Track: Advanced Analysis Techniques

Speaker: Mark Tabladillo

Title: Azure Databricks for Machine Learning

Abstract:

This presentation focuses on the value proposition for Azure Databricks for Data Science. First, the talk includes an overview of the merits of Azure Databricks and Spark. Second, the talk includes demos of data science on Azure Databricks. Finally, the presentation includes some ideas for data science production.

SessionID: 91593

SQL Server Data Tools (SSDT) = Awesome

Back to calendar

Event Date: 18-05-2019 - Session time: 09:15:00 - Track: Application Database Development

Speaker: Paul Waters

Title: SQL Server Data Tools (SSDT) = Awesome

Abstract:

Visual Studio SQL Server Data Tools (SSDT) is awesome! Here are a few reasons why.

• Create and organize database objects more easily with the Database project template.
• Write SQL code faster with IntelliSense.
• Checks for errors in real-time to identify mistakes quickly.
• Makes refactoring database objects seem like magic.
• Includes powerful tools for comparing database schemas and data.
• Integrates with source control systems including GIT.
• Helps make team development easier and safer.
• Enables continuous integration and deployment for modern end-to-end application lifecycle (ALM) practices.

Best of all… It’s free! Also, it works with all versions of Visual Studio – including the free community edition. In this presentation, I will show you how to get started with SSDT, get some quick wins, and touch on some of the advanced features. By the end of the presentation, I hope to make you as excited about SSDT as I am.

SessionID: 91706

Is My Bias Showing? Real World Implications of Application Machine Bias

Back to calendar

Event Date: 18-05-2019 - Session time: 09:15:00 - Track: Application Database Development

Speaker: Rie Irish

Title: Is My Bias Showing? Real World Implications of Application Machine Bias

Abstract:

Computers can't be biased, right? I mean, it's just lines of code. Yes or No. Ones Zeros. Those lines of code are written by people. People have life experiences that color how they see the world. Okay, let's be blunt. People have baggage. And that baggage is seeping into your application, surveys and web forms.

You've got an idea for a new app and it's going to change the world! Right? It's a brilliant idea no one has ever thought of it before. You're working on the GUI for your company's web portal and you know just what information to collect from the user. Are you sure about that? Odds are pretty good that the information you're going to collect is a reflection of your life your experiences.
Learn how to identify bias when it seeps in, how to code to be inclusive instead of exclusive , and some quick tips tricks to make sure you're accounting for all the users that will use YOUR application to change the world. Instead of just the ones that look like you.

SessionID: 91707

Power BI Dataflows and How to Leverage for Data Science

Back to calendar

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

Speaker: Jamey Johnston

Title: Power BI Dataflows and How to Leverage for Data Science

Abstract:

This session will give you an introduction to Power BI dataflows and how to leverage the data for data science. Power BI dataflows allow for self service data migration into Azure Data Lake Services gen 2 utilizing Power Query. This session will show how to user dataflows and how to connect to the resulting data in the Azure Data Lake Services gen 2 to do Data Science with tools like Azure Databricks.

SessionID: 91714

Using the Power platform to radically change your business

Back to calendar

Event Date: 18-05-2019 - Session time: 09:15:00 - Track: Application Database Development

Speaker: Patrick LeBlanc

Title: Using the Power platform to radically change your business

Abstract:

Follow us on a journey through the Power platform. This session uses business scenarios that span across Microsoft Flow and PowerApps, and then uses Microsoft Power BI to bring it all together. Using the Power platform can change the way you do business in your organization and we want to show you how!

SessionID: 87558

13 reasons why my query is slow

Back to calendar

Event Date: 18-05-2019 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Fabiano Amorim

Title: 13 reasons why my query is slow

Abstract:

What if we could analyze a single query with thirteen different performance problems? In this session we’ll explore a query, understand and fix all thirteen problems.

1- There is a nonsargable filter 2- An index is missing 3- It is a query optimizer mistake 4- The subquery is unnecessary 5- Query join order is incorrect 6- A filtered statistic is missing 7- Scalar functions are running twice per each row 8- High number of reads on worktable 9- An unknown syntax could be used 10- Memory grant wasn’t enough 11- Distributed query doesn't look good 12- Residual predicates 13- Avoid window spool ondisk

SessionID: 87635

Encrypting Data within Sql Server

Back to calendar

Event Date: 18-05-2019 - Session time: 10: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: 87672

Essential Linux Skills for the DBA

Back to calendar

Event Date: 18-05-2019 - Session time: 10:30:00 - Track: 101 Beginner Level Sessions

Speaker: Kellyn Pot'Vin-Gorman

Title: Essential Linux Skills for the DBA

Abstract:

Unlike many other DBAs, the SQL Server DBA is finding themselves managing databases running on Linux without the server support or knowledge of a local Linux Administrator.

This extended session will provide the attendee with a full immersion into the Linux world. You'll learn the history behind Linux, how to design an enterprise level Linux environment to support a SQL Server database and what tools, scripting and monitoring have served other database platforms running on Linux since it's inception. The session will provide an electronic handout that will serve as excellent reference material even after Summit is over, providing continued value to the DBA, the Architect and even the Database Developer.

SessionID: 88480

Re-Architect your Software as a Service Application for Azure: Tips and Tricks

Back to calendar

Event Date: 18-05-2019 - Session time: 10:30:00 - Track: Cloud Application Development Deployment

Speaker: George Walters

Title: Re-Architect your Software as a Service Application for Azure: Tips and Tricks

Abstract:

Considering a cloud architecture instead of on-premises? Come and walk through a Tier 1 Application with a heavy SQL on-premises footprint that was migrated to Azure. Considerations such as development changes, architecture, features required, reduced labor required, and people process to get this deployed.

SessionID: 89037

Introduction to SQL Server Big Data Clusters

Back to calendar

Event Date: 18-05-2019 - Session time: 10: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:

• Articulate the Big Data Landscape and the problems it addresses
• Present the technology approaches to analyzing large, heterogenous data sets to an audience
• Design a solution using SQL Server 2019’s Big Data Clusters architecture and programming model

SessionID: 89736

Azure Data Factory V2

Back to calendar

Event Date: 18-05-2019 - Session time: 10:30:00 - Track: Cloud Application Development Deployment

Speaker: Kevin Wilkie

Title: Azure Data Factory V2

Abstract:

Moving data around in On-Prem databases is fairly easy with SSIS.

Moving data around when involving Azure - may be not. Especially if you're just seeing ADF v2 for the first time.

We'll look at moving data around from On-Prem to Azure, moving files to Azure, and moving data between Azure databases.

SessionID: 89958

DevOps, Continuous Integration Automated Testing: Rule them all

Back to calendar

Event Date: 18-05-2019 - Session time: 10:30:00 - Track: Application Database Development

Speaker: Samir Behara

Title: DevOps, Continuous Integration Automated Testing: Rule them all

Abstract:

Do you want to make your deployments risk free? Do you want to deliver business values to your customers faster? Do you want to increase the efficiency of your Team? Are your application and database deployment separate processes? Do you encounter issues while deploying your database changes? Do you want to automate your testing process? Is your database slowing you down?

If the answer to any of the above questions is a Yes, then this presentation is for YOU. Come join me in this 60 min session to understand the problems with traditional database development, why organizations are moving towards achieving Continuous Integration and Database DevOps, the problems it tries to solve and learn about the toolsets which will assist you in this journey towards painless database deployments.

SessionID: 90948

Level Up: Data Modeling for the Power BI Rockstar

Back to calendar

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

Speaker: Bill Anton

Title: Level Up: Data Modeling for the Power BI Rockstar

Abstract:

In the world of Power BI, data modeling is what separates the Rockstars from the Rookies. Join Bill Anton to learn how dimensional modeling - a concept developed 20+ years ago - continues to be the best approach for delivering self-service BI to the masses.

You'll learn how to create flexible data models that can be expanded upon over time, unlock the power of the date table, and a variety of DAX patterns supporting common but complex business logic.

Good data modeling will result in better Power BI solutions that support a wider range of reporting requirements and are easier for the business users to understand.   If your Power BI solutions contain a single table, if you're frequently banging your head against the wall trying to figure out how to write a DAX calculation, or if you've never heard the term "dimensional model" this session is for you.

SessionID: 91021

Evolving Your BI Environment From SSRS To Power BI

Back to calendar

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

Speaker: Preston Mesarvey

Title: Evolving Your BI Environment From SSRS To Power BI

Abstract:

With Power BI becoming a leading BI tool over the last few years, a question arises… What does this mean for the existing SSRS environment? This session will explore an analysis plan on your existing reporting landscape to provide you options and considerations to be able to make an informed decision about how Power BI could best be used in your environment. You will learn how to get valuable SSRS usage metrics. You will understand the benefits and limitations between the two BI tools and what questions to ask your users. By Monday morning you will be able to provide an analysis plan on what is involved to introduce Power BI into the enterprise.

SessionID: 91177

AI Cognitive Services: Vision 101

Back to calendar

Event Date: 18-05-2019 - Session time: 10:30:00 - Track: 101 Beginner Level Sessions

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

Leveraging Python in SQL Server

Back to calendar

Event Date: 18-05-2019 - Session time: 10:30:00 - Track: Advanced Analysis Techniques

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.

SessionID: 91688

Managing SQL Server with Powershell

Back to calendar

Event Date: 18-05-2019 - Session time: 10:30:00 - Track: PowerShell

Speaker: Michael Fal

Title: Managing SQL Server with Powershell

Abstract:

Have you dipped your toe into the Powershell pool, but are still lost on how you can make it work for you? Maybe you're just looking for a few more tools to help you better manage SQL Server administration? In this session, we will cover a handful of useful scripts and patterns in Powershell that will ease your management of SQL Server. Backups, file management, instance configuration, and several other areas will be covered. By attending this session, you will learn more about how you can use Powershell effectively in your environment.

SessionID: 91721

Power BI Architecture

Back to calendar

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

Speaker: Paco Gonzalez

Title: Power BI Architecture

Abstract:

Having the right architecture is key to the adoption of Power BI, and to make the most of your business intelligence solution. This session guides you through different Power BI architectures, such as Direct Query, Import, Connect Live, Composite Models, and Embedded. We will analyze different techniques in data refresh, incremental extraction, integration and collaboration to provide a quick overview of the different approaches available.

SessionID: 90438

Be a HERO and build powerful custom apps with Azure SQL Database and Skuid!

Back to calendar

Event Date: 18-05-2019 - Session time: 11:45:00 - Track: Application Database Development

Speaker: Carl Sheffield

Title: Be a HERO and build powerful custom apps with Azure SQL Database and Skuid!

Abstract:

As an IT Pro, you don't enjoy saying "I can't do that" in response to the needs of your boss or business users. So I will introduce a tool to help you say "yes".

Discover how to build front-end apps in less time, and with less hassle than you might imagine... apss that that powerfully surface your SQL data for end users in an effective UX.

In this session you will learn how to:

• Get started with a free Skuid developer account
• Connect to Azure SQL DB
• Create Skuid pages
• Add components to enable end-users to interact with your data

Leave the session empowered with a new tool in your toolkit to get things done better and faster for all of your end-users’ needs.

SessionID: 91680

Running SQL Server on AWS - High Availability and Reliability in the Cloud

Back to calendar

Event Date: 18-05-2019 - Session time: 11:45:00 - Track: Cloud Application Development Deployment

Speaker: Steve Abraham

Title: Running SQL Server on AWS - High Availability and Reliability in the Cloud

Abstract:

Amazon Web Services offers the ability to run SQL Server as part of its relational database service for managed databases, as well as hosting Windows/SQL Server installations via EC2. This session will compare/contrast these two options, discuss automation, monitoring, scaling, performance, and specifically address how to implement High Availability and Disaster Recovery options with both types of implementations.

SessionID: 91708

Women in Tech: Thriving Not Just Surviving

Back to calendar

Event Date: 18-05-2019 - Session time: 11:45:00 - Track: Professional Development

Speaker: Rie Irish

Title: Women in Tech: Thriving Not Just Surviving

Abstract:

Join us for a panel discussion where we'll talk about succeeding as a woman in tech. It's hard. We get it. We've been there before. We'll be there again. Sometimes it's hard, throwing yourself into that brick wall. All day. Every day. But you can do it. I know you can.

But it's about more than just living in a man's world. Let's talk tech, Where we've been Where it's going. How we keep our skills sharp. How we mentor other women. How YOU can mentor other women.

SessionID: 93786

Survival of the Fittest: Matching Approaches for Golden Record

Back to calendar

Event Date: 18-05-2019 - Session time: 11:45:00 - Track: Sponsor Session

Speaker: SQL Saturday Atlanta

Title: Survival of the Fittest: Matching Approaches for Golden Record

Abstract:

There is no debate – duplicate data is unwanted data. But, issues behind duplicate data detection persist, such as sound-al-like matches, misspellings, abbreviations, nicknames and other variants of fuzzy matching records. So how do you overcome those challenges? Join us for a lunch and learn presentation where we’ll cover all of that and more!

Key takeaways:

Problems and implications of duplicate data Real-world applications of deduplication within SQL Server What makes a golden record and how data survives the process Improved fuzzy matching in SSIS

Amanda Nguyen with Melissa Data

SessionID: 93787

How Fast Can You Restore Your Database?

Back to calendar

Event Date: 18-05-2019 - Session time: 11:45:00 - Track: 101 Beginner Level Sessions

Speaker: Marsha Pierce

Title: How Fast Can You Restore Your Database?

Abstract:

Availability Groups and Clustering are great but they only protect you against hardware failures. DBA's still need to rely on backups to set up AGs, initialize replication, recover from data corruption and more. Join us to discuss how you can restore your database in minutes and not hours.

MARSHA PIERCE Database Architect Pure Storage, Inc.

SessionID: 93848

Profisee Sponsor Session

Back to calendar

Event Date: 18-05-2019 - Session time: 11:45:00 - Track: Sponsor Session

Speaker: SQL Saturday Atlanta

Title: Profisee Sponsor Session

Abstract:

Topic Pending

SessionID: 93850

Dell EMC Sponsor Session

Back to calendar

Event Date: 18-05-2019 - Session time: 11:45:00 - Track: Sponsor Session

Speaker: SQL Saturday Atlanta

Title: Dell EMC Sponsor Session

Abstract:

Topic Pending

SessionID: 93851

Successfully Virtualizing SQL Server on vSphere - Straight from t

Back to calendar

Event Date: 18-05-2019 - Session time: 11:45:00 - Track: Sponsor Session

Speaker: SQL Saturday Atlanta

Title: Successfully Virtualizing SQL Server on vSphere - Straight from t

Abstract:

VMware Sponsor Session

Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. “Virtualize First” is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too “critical” to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Br

SessionID: 93853

Improving - Atlanta

Back to calendar

Event Date: 18-05-2019 - Session time: 11:45:00 - Track: Sponsor Session

Speaker: SQL Saturday Atlanta

Title: Improving - Atlanta

Abstract:

Topic Pending

SessionID: 93855

SIOS -SANLess clustering for physical, virtual and cloud environm

Back to calendar

Event Date: 18-05-2019 - Session time: 11:45:00 - Track: Sponsor Session

Speaker: SQL Saturday Atlanta

Title: SIOS -SANLess clustering for physical, virtual and cloud environm

Abstract:

Join this session to learn how to create SANLess clusters in environments where traditional shared storage clusters are impractical or impossible. We will discuss high-performance clusters leveraging SSD and Flash-based PCIe storage for faster SQL application response times - no SAN (or SAN Admin required). We will also touch on methods for providing HA protection and native Windows Failover Clustering in Windows Azure or the Amazon Cloud. -- Topics covered -- High-performance storage and accelerating SQL Server without sacrificing availability; AlwaysOn Failover Clustering vs. AlwaysOn Availability Groups; HA and DR strategy for SQL Server in Amazon EC2 and Azure instances; Fast, cost-effective strategies to get HA and DR protection without a SAN.

SessionID: 87539

Containers - You Better Get on Board!

Back to calendar

Event Date: 18-05-2019 - Session time: 13:00:00 - Track: Cloud Application Development Deployment

Speaker: Anthony Nocentino

Title: Containers - You Better Get on Board!

Abstract:

Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get you started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes.

In this session we’ll look at Container Fundamentals with Docker Common Container Scenarios Automation with Kubernetes

SessionID: 88320

Not your Dad's SQL Server; Contemporary twist on a classic standby.

Back to calendar

Event Date: 18-05-2019 - Session time: 13:00:00 - Track: Strategy and Architecture

Speaker: Hasan Savran

Title: Not your Dad's SQL Server; Contemporary twist on a classic standby.

Abstract:

New versions of SQL Server have great new additions and features. I will cover the following features in this session.

Linux Support Graph Tables Intelligent Query Processing Resumable Online Index Rebuild How to run R/Python with Machine Learning Services In-Memory Tables (Let's create NoSQL DB in SQL Server)

SessionID: 88466

Where the Heck in Azure is SSIS?

Back to calendar

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

Speaker: Geoff Hiten

Title: Where the Heck in Azure is SSIS?

Abstract:

Microsoft finally has a good migration target for on-premise SQL workloads with Azure SQL Managed Instance. But the SQL Server database engine is only one component in the whole SQL Server product toolkit. SQL Server Integration Services is used with almost every SQL Server deployment. This session will discuss and demonstrate how to migrate existing SSIS packages to Azure.

SessionID: 89034

Inside SQL Server 2019

Back to calendar

Event Date: 18-05-2019 - Session time: 13:00: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: 89282

What's New for BI in SQL Server 2019

Back to calendar

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

Speaker: Teo Lachev

Title: What's New for BI in SQL Server 2019

Abstract:

SQL Server 2019 delivers important data analytics features and enhancements. Join this session to discover what BI features are coming up in Database Engine, SSIS, SSAS, SSRS (Power BI Report Server), and MDS, and to see some of these preview features in action.

SessionID: 89310

Unleashing Stretched Databases

Back to calendar

Event Date: 18-05-2019 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Armando Lacerda

Title: Unleashing Stretched Databases

Abstract:

This is a deep dive session full of demos about SQL 2016 stretched databases feature. It will go from pre-reqs and blocking factor through deployment and disaster recovery. Everything you need to know and when to use this new cloud-based exciting capability.

SessionID: 90074

Modern CPU Architecture and SQL Server Performance

Back to calendar

Event Date: 18-05-2019 - Session time: 13:00:00 - Track: Strategy and Architecture

Speaker: David Klee

Title: Modern CPU Architecture and SQL Server Performance

Abstract:

Modern CPU architectures are complex and misunderstood, especially as they relate to SQL Server instance configuration and database usage patterns. Default values in virtualization and the SQL Server instance can cause misalignments and improper balance in the way the SQL Server lines up with the CPUs and memory, which results in an immediate (and silent) performance penalty. Come learn as we discuss topics such as physical and virtual NUMA, hyperthreading, query parallelism, and instance settings, and show you how to validate your SQL Server architecture and improve the performance of your critical SQL Servers.

SessionID: 90182

Performance Tuning for SQL Developer through Execution Plans

Back to calendar

Event Date: 18-05-2019 - Session time: 13:00: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: 90384

The Master Stored Procedure Workshop: Part 1

Back to calendar

Event Date: 18-05-2019 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Sean McCown

Title: The Master Stored Procedure Workshop: Part 1

Abstract:

Your job includes designing and writing stored procedures, but you haven’t had a lot of actual training on the subject, right? I will show you how to write stored procedures from scratch, using the design advice I’ve accumulated in my 20+ years of experience.

Here are a few of the things you’ll learn: When and how to use stored procedures The benefits and basics of contractual programming How to write stored procedures from scratch How to structure and organize stored procedures Key techniques for ideal stored procedure management Troubleshooting and debugging stored procedures The session will be packed with tons of code examples, with plenty of labs to reinforce key concepts. Beginner and experienced T-SQL programmers both will walk away with a greater understanding of how to design, manage, and troubleshoot stored procedures. Join mefor one fun session of SQL Server programming!

SessionID: 91684

What is CosmosDB and should I care about it?

Back to calendar

Event Date: 18-05-2019 - Session time: 13:00:00 - Track: 101 Beginner Level Sessions

Speaker: Jeremy Edmondson

Title: What is CosmosDB and should I care about it?

Abstract:

These days, NoSQL and CosmoDB is all the rage. I've even heard a technology professional say "no one uses joins any longer". Is CosmosDB really able to solve all the worlds problems?

In this session, we will explore the following questions:

What is CosmosDB? What are the benefits of CosmosDB? How do I use CosmosDB? Should I use CosmosDB?

SessionID: 91701

How do you Azure?

Back to calendar

Event Date: 18-05-2019 - Session time: 13:00:00 - Track: 101 Beginner Level Sessions

Speaker: Tamera Clark

Title: How do you Azure?

Abstract:

Most are talking about it, some have migrated to it and others are just overwhelmed. If you thought Azure was the color of the sky and you are wanting to learn about MS Azure then this is the session for you.

Join me for a fun journey to learn the very basics of Azure. Some how-tos, some whys, and some demos.

This is a level 0 session, #N00b, #Imabeginner

SessionID: 91745

First Day on the Job: Getting to Know Your Database

Back to calendar

Event Date: 18-05-2019 - Session time: 13:00:00 - Track: Professional Development

Speaker: Chris Voss

Title: First Day on the Job: Getting to Know Your Database

Abstract:

You're starting a new job as one of the database people, whether it is an analyst, developer, DBA, or other role. You are dealing with a new system and new practices versus your previous gig or four. Now you're already getting tasks to make changes on the development server or run some reports on data in production, but aren't sure where everything is or how they do it. So what's the best way to get up to speed? In this session, we discuss good ways to get familiar with the servers and databases, the potential architecture surrounding them (transactional and analytical), any source control, and other aspects to keep an eye on. You can start delivering the goods and swim in your new database environment without drowning!

SessionID: 93022

Introduction to Azure Analysis Services

Back to calendar

Event Date: 18-05-2019 - Session time: 13:00:00 - Track: Cloud Application Development Deployment

Speaker: Shabnam Watson

Title: Introduction to Azure Analysis Services

Abstract:

In this session you will learn about the basic concepts of Azure Analysis Services (AAS) and the role it plays in the Azure BI platform. You will learn how to build a simple model based on data in an Azure SQL Server database, deploy it to AAS, build a simple report with Power BI Desktop, and deploy the report to Power BI Service to share. You will also learn about the cost model of AAS servers and production considerations to take into account after a model has been deployed.

SessionID: 87534

Intro to Query Store

Back to calendar

Event Date: 18-05-2019 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Intro to Query Store

Abstract:

In this session, we will look at the new Query Store feature in SQL Server 2016 and 2017. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse in 2016.

Then in 2017, Microsoft added wait stats per query plan and Automatic Tuning capabilities. Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.

In this session, we will walk through the features of Query Store, so you can understand how to use them in SQL Server 2016 and 2017.

SessionID: 87575

Database Design Fundamentals

Back to calendar

Event Date: 18-05-2019 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Louis Davidson

Title: Database Design Fundamentals

Abstract:

Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.

SessionID: 87833

HA/DR Solutions Using Distributed Availability Groups (Read-Scalable AGs too!)

Back to calendar

Event Date: 18-05-2019 - Session time: 14:15:00 - Track: Strategy and Architecture

Speaker: Jennifer Brocato

Title: HA/DR Solutions Using Distributed Availability Groups (Read-Scalable AGs too!)

Abstract:

When designing your HA/DR solution, you need to consider all the possible options SQL Server has to offer to implement what is right for you. You will see how to use Failover Cluster Instances, Standalone Instances, Clusters, Availability Groups and Distributed Availability Groups.

We will walk through how to set up and configure an HA/DR solution from beginning to end, review possible alerts, and how to monitor. We will take a look at the new SQL2017 Read-scale Availability Groups and why to use them. We will architect one of many possible VM solutions to host your HA/DR implementation.

Finally, we will see Automatic Failover and see how to perform a Manual Failover.

SessionID: 89151

45 Minutes to Your First Tabular Model

Back to calendar

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

Speaker: Kerry Tyler

Title: 45 Minutes to Your First Tabular Model

Abstract:

Have you been watching SSAS Tabular develop? What about the Azure Analysis Services product? Power BI's data modeling? These technologies are all effectively the same, but live in different places and can serve different roles. Now's the time to dive in and figure all of this out.

In this session, we will talk about what Tabular is and what it does, in addition to the various "flavors" it comes in. We'll explore development processes and will wind up with a model ready for ad-hoc querying through Excel or Power BI.

SessionID: 89286

Uncovering Duplicate, Redundant, Missing Indexes

Back to calendar

Event Date: 18-05-2019 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Andy Yun

Title: Uncovering Duplicate, Redundant, Missing Indexes

Abstract:

Do you know if your database's indexes are really being used to their fullest potential? And do you know if SQL Server needs other indexes to improve performance?

Attend this session and learn how SQL Server tracks actual index usage, and how you can make use of that information to improve the state of indexes in your database. We will use this data to identify wasteful, unused, redundant indexes, and explore performance penalties you pay for not addressing these inefficient indexes. Finally, we will dive into the Missing Index DMV and explore the art of evaluating its recommendations to make proper indexing decisions.

SessionID: 90085

A System for Managing Career Learning

Back to calendar

Event Date: 18-05-2019 - Session time: 14:15:00 - Track: Professional Development

Speaker: Andy Warren

Title: A System for Managing Career Learning

Abstract:

Are you investing enough time and in right place when it comes to learning new stuff? Or do you feel like you're spending too much time? Or, more commonly, that you're setting goals and then falling off track? All of us struggle to manage learning while sustaining a career and family. But it IS possible! This session is designed to give you a prescriptive solution to the challenges of managing learning; identifying what you need to learn, how much time to invest in learning each topic, scheduling and tracking your learning, and recovering from the interruptions that life throws at us. My system won't make you rich, but it will make you feel in control of your career learning goals.

SessionID: 90377

Beginning Admin: The Care and Feeding of SQL Server

Back to calendar

Event Date: 18-05-2019 - Session time: 14:15:00 - Track: 101 Beginner Level Sessions

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:

• Backups – You must set up regular backups, to keep copies of your databases...just in case something breaks, or someone makes a bad, bad mistake.
• Integrity checks – Regularly and automatically check databases for corruption, which is when bits get scrambled, lost, and ruined.
• Index maintenance – Databases need regular upkeep so they'll continue to run well.
• Disk management – It's actually your job to find out about full disks before they happen. After all, databases grow!
• Alerting – Alerts tell you what's wrong, so you don't have to go looking for problems.

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

SessionID: 90397

PowerShell for the DBA

Back to calendar

Event Date: 18-05-2019 - Session time: 14:15:00 - Track: PowerShell

Speaker: Amy Herold

Title: PowerShell for the DBA

Abstract:

PowerShell is a tool used by many people in DevOps and Infrastructure. Should the DBA get on board with using PowerShell? The answer is yes - as a DBA, PowerShell can have a significant impact on tasks that would be long and tedious with just T-SQL alone. Today there are specific modules that can be incorporated into PowerShell to help in automating every-day DBA tasks. Beyond that, PowerShell can be used to do things like automate deployments and audit permissions.

In this session we will explore real-world examples and demonstrate how PowerShell can be leveraged by the DBA to not only improve efficiency but also streamline processes across an enterprise environment.

SessionID: 90511

Everything You Need to Know About SQL Server Indexes

Back to calendar

Event Date: 18-05-2019 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Janis Griffin

Title: Everything You Need to Know About SQL Server Indexes

Abstract:

You probably already know that indexes make your queries go faster. But do you know all the different types of indexes in SQL Server and when to use them? Also with each new release of SQL Server, there are new features that can impact how indexes function and are maintained. Finally, knowing how the different types of indexes work can help you make better indexing choices when tuning your queries.

This presentation will review current SQL Server index structures and options, discuss how they work, when they should be used and how to maintain them. Examples of all the index types such as hash, in-memory, columnstore, filtered, etc… will be shown. This presentation is a must see for DBAs, Developers, Application Architects and anyone else who is interesting in maintaining high performance SQL Server applications.

SessionID: 90607

Implementing IT and Data Governance using Azure Policy Management

Back to calendar

Event Date: 18-05-2019 - Session time: 14:15:00 - Track: Strategy and Architecture

Speaker: George Govantes

Title: Implementing IT and Data Governance using Azure Policy Management

Abstract:

This session will cover the importance of IT and Data Governance and how it relates to protecting information, standardizing your computing environment, and controlling cost on Azure. By using Azure Policy Management one can quickly setup controls to meet you business and data protection requirements.

SessionID: 91352

Azure Managed Instances—Your Bridge to the Cloud

Back to calendar

Event Date: 18-05-2019 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Joseph D'Antoni

Title: Azure Managed Instances—Your Bridge to the Cloud

Abstract:

Many organizations would like to take advantage of the benefits of using a platform as a service database like Azure SQL Database. Automated backups, patching, and costs are just some of the benefits. However, Azure SQL Database is not a 100% feature compatible with SQL Server—features like SQL Agent, CLR and Filestream are not supported. Migration to Azure SQL Database is also a challenge, as backup and restore and log shipping are not supported methods.

Microsoft recently introduced Managed Instances—a new option that provides a bridge between on-premises or Azure VM implementations of SQL Server and Azure SQL Database. Managed Instances provide full SQL Server surface compatibility and support database sizes up to 35 TB.

In this session, you will learn about migrating your databases to Managed Instances, developing applications for managed instances. You will also learn about the underlying high availability and disaster recovery options for the solution.

SessionID: 91687

Implementing dbatools with Azure Automation

Back to calendar

Event Date: 18-05-2019 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Shawn Melton

Title: Implementing dbatools with Azure Automation

Abstract:

Azure Automation opens up a plethora of opportunity for organizations both in the cloud and on-premises. The ability to centralize code and execution schedules from one central place is breathtaking and beautiful as will be demonstrated in this session.

During this feature-rich demo, we will walk-through getting started with Azure Automation accounts, including account creation, runbook management and implementing custom modules. We'll also cover how the Az PowerShell commands can be used to automate these same actions. And finally, we will go through code using dbatools that demonstrates how easy it is to perform tasks against Azure VMs and on-premises environments.

SessionID: 91694

New Features in SQL That Will Change the Way You Tune

Back to calendar

Event Date: 18-05-2019 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Lance Tidwell

Title: New Features in SQL That Will Change the Way You Tune

Abstract:

Since the new cardinality estimator was released in SQL Server 2014, every version on SQL has introduced new great features design to help your queries run at max performance. In 2016, it was Query Store; in 2017, Adaptive Query Processing and Automatic Tuning have been introduced.

In this session we will explore these new features and how they can make your life easier. We will also look at some of the pitfalls and potential issues that can arise from these new features.

SessionID: 91730

Overcoming Challenges with Source Control and Continuous Integration.

Back to calendar

Event Date: 18-05-2019 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Elizabeth Noble

Title: Overcoming Challenges with Source Control and Continuous Integration.

Abstract:

Have you tried implementing source control? How has your continuous integration (CI) process gone?

This session is for developers, database administrators, database engineers, and data architects that want to automate their database deployments. Particularly for those individuals that have hit roadblocks along that way. We will discuss the differences between migration and stated-based deployment methods. We will also discuss options with branching and merging.

At the end of the session, attendees will know how to select the best deployment method for their environment. In addition, attendees will be familiar with branching and merging strategies that can be used as part of their continuous integration strategy.

Attendees should be familiar with general concepts about source control and be comfortable with Visual Studio or VS Code.

SessionID: 87512

Becoming a Data Scientist

Back to calendar

Event Date: 18-05-2019 - Session time: 15:30:00 - Track: Advanced Analysis Techniques

Speaker: Shannon Lowder

Title: Becoming a Data Scientist

Abstract:

You’ve all heard about data scientists, and seen job postings for them. But what is the job like, really? Let me share the story of my first official data science project. While sharing the story I’ll stop to point out the skills used that many DBAs, PowerShell junkies, BI developers and architects already have. There may be a few new topics you’ll want to pick up. This is a show and tell session. It’s my hope that you come away with a better understanding of what a data scientist is, and be able to measure how far between where you are and your own first project.

SessionID: 87554

Getting started with Azure Machine Learning Services

Back to calendar

Event Date: 18-05-2019 - Session time: 15:30:00 - Track: Analytics and Visualization

Speaker: Bhakthi Liyanage

Title: Getting started with Azure Machine Learning Services

Abstract:

Azure Machine Learning services is an integrated, end-to-end data science and advanced analytics solution that provides professional data scientists and data engineers with tools not only to develop ML models, but also tools for data preparation and wrangling, data visualization, model deployment and model management at cloud scale. The session will teach the attendees how to get their hands on each tool in the stack.

SessionID: 87847

Understanding and Implementing System-Versioned Temporal Tables

Back to calendar

Event Date: 18-05-2019 - Session time: 15:30:00 - Track: Application Database Development

Speaker: David Maxwell

Title: Understanding and Implementing System-Versioned Temporal Tables

Abstract:

In many industries, it is necessary for data professionals to be able to show what a data set looked like at a previous point in time. Whether it's calculating tax or insurance rates based on a contract date, quickly comparing data changes over time for trend analysis or just recovering from an accidental data change, it's useful to be able to look back in time through our data. Starting in SQL Server 2016, system-versioned temporal tables provide a solution that tracks data through time with far less overhead than previously offered solutions. This session will cover the basics of temporal tables, how SQL Server manages data within those tables, and how to query data at a specific point in time using several real-world examples. We will also cover the mechanics of data retention and storage and archival of historical data. Attendees will leave with a fundamental understanding of practical use cases for temporal tables and the knowledge required to implement them successfully.

SessionID: 88421

Ensuring Analytics Hit the Mark (and Get Used!)

Back to calendar

Event Date: 18-05-2019 - Session time: 15:30:00 - Track: Analytics and Visualization

Speaker: Trey Johnson

Title: Ensuring Analytics Hit the Mark (and Get Used!)

Abstract:

Dashboards, Reports, Charts and all ways to structure data for analysis is failing! Sound familiar? If so, the adoption dilemma is present and needs to be solved.

If users would rather get data dumped to them, rather than work with what they’ve been given, this session is for you! We’ll give you techniques to solve the adoption dilemma and make analytics the hero of your organization without having to endure the pain of further purchasing, added frustration or the ongoing angst for something your organization simply does not have. This session will talk to the culture of analytics and the ways you might marry the best work of those who prepare the data (often IT) with the work those should be doing to explore the data (everyone else)!

SessionID: 88648

Parameters in SQL Server - Query Performance Makers or Breakers

Back to calendar

Event Date: 18-05-2019 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Mindy Curnutt

Title: Parameters in SQL Server - Query Performance Makers or Breakers

Abstract:

T-SQL programming makes wide use of parameterization in stored procedures, dynamic statements and ad-hoc queries. Many developers aren’t aware of the significant influence they have on query performance. Incorrect use or lack of parameters is a common reason for query performance issues.

Have you experienced a query that always ran fast, suddenly (and for "no reason") become slow? And with nothing changing? Yep!

• In this session we will learn about how the plan cache deals with queries that are (and are not) parameterized.
• You'll learn about parameter sniffing, what it is, and how it's handled in the older and newest versions of SQL.
• We will explore the problem of mismatched data types and implicit conversions - and how that ties in with ORM generated code.
• Lastly, we'll take a peek at value list handling from applications, and how using a table valued parameter as an input instead. If this is a new topic to you, you'll leave this session with takeaways galore.

SessionID: 89060

Creat Pixel Perfect Reports: The Story of Paginated Reports

Back to calendar

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

Speaker: Patrick LeBlanc

Title: Creat Pixel Perfect Reports: The Story of Paginated Reports

Abstract:

Back in 2003 Microsoft released an addition to SQL Server 2000 named SQL Server Reporting Services (SSRS). This is a story of the journey of the BI Engine that could. From updates, to periods or rest and updates again. Not only has it been updated, but new features, capabilities and event a new project has been born from its humble beginnings. Now, paginated reports, the only type of report that was available when SSRS was initially released, are available in both on-premises and cloud-based solutions. Join this session to experience the journey of SSRS and how to create and deploy reports across all the different products available in the Microsoft Ecosystem.

SessionID: 89385

Back to the Basics: T-SQL 101

Back to calendar

Event Date: 18-05-2019 - Session time: 15:30:00 - Track: 101 Beginner Level Sessions

Speaker: Deborah Melkin

Title: Back to the Basics: T-SQL 101

Abstract:

Do you consider yourself a beginner to T-SQL? This session will go over the basic T-SQL syntax for querying data. We'll break down the fundamental statements to look at the different parts to see how they work together.

This session is designed for the junior DBA or developer who is looking for a better foundation of the basics. The goal is to feel more confident with how to write queries and understand how to build on that knowledge.

SessionID: 90038

The New Tool in Your Kit: Azure Data Studio

Back to calendar

Event Date: 18-05-2019 - Session time: 15:30:00 - Track: Cloud Application Development Deployment

Speaker: Sven Aelterman

Title: The New Tool in Your Kit: Azure Data Studio

Abstract:

Azure Data Studio is a newer tool in the database developer and DBA's toolkit. It's a cross-platform and extensible application for connecting to on-premises and cloud data. Does it replace SSMS? How is it different? Can it really check if my Diet Coke needs replenishing? Come and find out in this demo-driven session, that will hopefully have you convinced to install Azure Data Studio before 60 minutes are up.

SessionID: 90149

Optimizing Data Access: Mixing Entity Framework Core and Dapper

Back to calendar

Event Date: 18-05-2019 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Shawn Wildermuth

Title: Optimizing Data Access: Mixing Entity Framework Core and Dapper

Abstract:

Entity Framework Core is a great way to quickly access database data in many applications. But during optimization of certain queries, Entity Framework Core can be a hinderance. In this talk, Shawn Wildermuth will show you how to mix Entity Framework Core with Stack Overflow’s Dapper project to find performance bottlenecks and address them with the control you get from Dapper.

SessionID: 91392

SQL Server with Docker Containers

Back to calendar

Event Date: 18-05-2019 - Session time: 15:30:00 - Track: Strategy and Architecture

Speaker: Marsha Pierce

Title: SQL Server with Docker Containers

Abstract:

An overview of creating SQL Server Containers and how you can clone your databases to Linux Containers. Containers are the future of DEVOPS!

SessionID: 91519

Turbo-charging SSMS for Beginners

Back to calendar

Event Date: 18-05-2019 - Session time: 15:30:00 - Track: 101 Beginner Level Sessions

Speaker: Nathan Boster

Title: Turbo-charging SSMS for Beginners

Abstract:

This session is for SQL Server Management Studio (SSMS) rookies who want to work like veterans. Nathan will share lots of "tips and tricks" he's learned in his 15 years of SQL Server administration and development.

SessionID: 91677

The Art of Data DevOps with SSDT

Back to calendar

Event Date: 18-05-2019 - Session time: 15:30:00 - Track: Cloud Application Development Deployment

Speaker: Ken Muse

Title: The Art of Data DevOps with SSDT

Abstract:

The heart of software systems today is data storage. As software development cycles get shorter, database development is being forced adapt the same pace. It’s increasingly important to be able to combine Agile practices with SQL Server database development. Learn how to take advantage of SQL Server Data Tools and Azure DevOps to enable rapid, iterative development.

SessionID: 91697

Extended Events - Better than Profiler

Back to calendar

Event Date: 18-05-2019 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Brimhall

Title: Extended Events - Better than Profiler

Abstract:

Extended Events was introduced in SQL Server 2008. Every release since then, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.

SessionID: 91727

HA/DR - Too Many Choices!

Back to calendar

Event Date: 18-05-2019 - Session time: 15:30:00 - Track: 101 Beginner Level Sessions

Speaker: Mike Walsh

Title: HA/DR - Too Many Choices!

Abstract:

Your company needs to achieve high availability and disaster recovery, but there are many choices nowadays (More than a few ways inside of SQL Server, third-party options, on-prem, cloud, VM based technologies, oh my!). How do you choose what's right for YOU and your company?

In this session, you'll wade through all of the choices and understand the pros and cons of each. You'll also learn which questions you should be asking of the business. Find your needs. Then the right solution. Not the other way around!

You'll leave more informed about the choices, have some guides to help you pick, and you'll be on your way to the right choice! This session is for SQL Server technologists who "get SQL," but are looking to weigh their HA/DR options out and want to level up their knowledge and go back to the office prepared to be a consultant to your company and tackle those HA/DR needs.

This site is open source. Improve this page.