sqlsathistory

Nr: 825

Back to Main list

SQLSaturday #825 - Chicago 2019

Start Time (24h) Speaker Track Title
08:30:00 John Deardurff Application Database Development A Beginners Guide to Transactions
08:30:00 Farouq Abukhamireh BI Platform Architecture, Development Administration Building a Microsoft Business intelligence Solution step-by-step
08:30:00 Chirag Shah Enterprise Database Administration Deployment Troubleshooting AlwaysOn Availability Groups - Common Customer Scenarios
08:30:00 Thomas Norman Application Database Development Encrypting Data within Sql Server
08:30:00 Wylie Blanchard Professional Development Become a SQL Pro who’s in High Demand
08:30:00 H. Ross Reed Enterprise Database Administration Deployment SQL Server Auditing
08:30:00 Phillip Labry Cloud Application Development Deployment Analysis Services is in Azure? Seriously!? Let's build a model!
08:30:00 Joseph D'Antoni Enterprise Database Administration Deployment Containers, Pods, and Databases- The Future of Infrastructure
08:30:00 Pat Phelan Enterprise Database Administration Deployment PowerShell for the Reluctant Administrator
08:30:00 Arthur Daniels III Enterprise Database Administration Deployment Performance tuning with SQL Server memory grants
09:50:00 David Maxwell Enterprise Database Administration Deployment Using Extended Events for Wait Stats Analysis
09:50:00 Ross LoForte Enterprise Database Administration Deployment Azure SQL Database Managed Instance for DBAs
09:50:00 David Giard Cloud Application Development Deployment How Cloud Computing Empowers a Data Scientist
09:50:00 Jim Miller BI Platform Architecture, Development Administration Populating a Data Warehouse with SSIS and Biml Patterns
09:50:00 Andy Wickman Professional Development Lessons from Consulting: Third-Party Vendors
09:50:00 Joseph D'Antoni Application Database Development Automagic Tuning - SQL Server 2017 and Beyond
09:50:00 Ravi Kumar Analytics and Visualization Introduction to Azure Machine learning
09:50:00 Allan Hirt Enterprise Database Administration Deployment Top Tips for Deploying AGs and FCIs On Premises or In the Cloud
09:50:00 Chris Hyde Analytics and Visualization Python in SQL Server 2017
09:50:00 Kevin Kline Enterprise Database Administration Deployment SentryOne Tools for Productivity and Performance
11:10:00 Rob Volk Application Database Development That's So Metadata: Discover Your Database From The Inside
11:10:00 Jordan Anderson Analytics and Visualization Real-time Analytics with Azure
11:10:00 Jim Dorame Cloud Application Development Deployment COSMOS DB Develop Local Deploy Globally
11:10:00 Sean Forgatch BI Platform Architecture, Development Administration Azure Data Factory Ingestion Framework
11:10:00 Deborah Melkin Application Database Development Back to the Basics: T-SQL 101
11:10:00 David Klee Enterprise Database Administration Deployment Modern CPU Architecture and SQL Server Performance
11:10:00 Lonny Niederstadt Enterprise Database Administration Deployment Laying down the Law with SQL Server Resource Governor
11:10:00 Tyler Graham BI Platform Architecture, Development Administration Master Data Management: BI and Data Science’s Best Friend
11:10:00 David Bermingham Enterprise Database Administration Deployment Why Clustering for SQL Server High Availability?
11:10:00 Janis Griffin Enterprise Database Administration Deployment Database Performance Monitoring
12:40:00 Rob Volk Enterprise Database Administration Deployment Revenge: The SQL!
12:40:00 Neal Waterstreet BI Platform Architecture, Development Administration Master Data Management with SQL Server MDS
12:40:00 Anthony Nocentino Cloud Application Development Deployment Containers - You Better Get on Board!
12:40:00 Lynn Ballard Analytics and Visualization Beginner's Guide to Text Mining: What We Learn from SQL Saturday Presentation Abstracts
12:40:00 Brian Hansen Application Database Development The Amazing Utility of ROW_NUMBER()
12:40:00 John Eisbrener Professional Development Got the Consulting Itch? The Ins and Outs of being a Contractor for a Living
12:40:00 Jay Falck Enterprise Database Administration Deployment Introduction to Linux for SQL Server
12:40:00 Ola Hallengren Enterprise Database Administration Deployment Analyzing Performance Problems Using XEvents, DMVs Query Store
12:40:00 Deji Akomolafe Enterprise Database Administration Deployment Virtualizing SQL Server on vSphere - Straight from the Source
12:40:00 Allan Hirt Enterprise Database Administration Deployment Modern Infrastructure Fundamentals for Database Professionals
14:00:00 Jim Donahoe Enterprise Database Administration Deployment New Instance, Now what?
14:00:00 Angela Henry Application Database Development Profiling Your Data
14:00:00 Michael Johnson BI Platform Architecture, Development Administration Get started with Power BI Dataflows
14:00:00 Joe Obbish Application Database Development Improving Columnstore Load Scalability on Large Servers
14:00:00 John Sterrett Cloud Application Development Deployment Successfully Migrating Existing Databases to Azure SQL Database
14:00:00 Riley Major Application Database Development Refactoring Monolith Database Stored Procedures
14:00:00 Kevin Kline Application Database Development Ten Query Tuning Techniques Every SQL Programmer Should Know
14:00:00 Bryan Walsh Enterprise Database Administration Deployment #GetModern with Dell EMC
14:00:00 Marsha Pierce Enterprise Database Administration Deployment How To Talk To Your Storage Admin
14:00:00 Wylie Blanchard Professional Development You’re hired! Creating value before and after the interview to be
15:15:00 Hasan Savran Application Database Development Not your Dad's SQL Server; Contemporary twist on a classic standby.
15:15:00 Lucas Feiock Cloud Application Development Deployment Lambda architecture design using Azure Databricks for advanced analytics
15:15:00 Peter Shore Cloud Application Development Deployment Hello My Friends, Welcome to CosmosDB
15:15:00 David Bermingham Enterprise Database Administration Deployment High Availability and Disaster Recovery for SQL Server in Azure IaaS
15:15:00 Mike Byrd Application Database Development Climbing the SQL Server Index B-Tree
15:15:00 Dave Bland Enterprise Database Administration Deployment Is my SQL Server having Memory Pressure?
15:15:00 Jake Manske Application Database Development Diagnosing and fixing deadlocks in SQL Server
15:15:00 Amy Herold Enterprise Database Administration Deployment PowerShell for the DBA
15:15:00 Paul Stanton Application Database Development Azure SQL DevOps Simplified with Production Data
15:15:00 David Klee Professional Development My Brain Has Blue Screened - Let's Laugh

SessionID: 86426

A Beginners Guide to Transactions

Back to calendar

Event Date: 23-03-2019 - Session time: 08:30:00 - Track: Application Database Development

Speaker: John Deardurff

Title: A Beginners Guide to Transactions

Abstract:

This session is for the absolute beginner to learn the basics of Transactions and will answer questions such as, What is a Transaction? What are the ACID properties of a Transaction? How does the Transaction Log work to provide consistency to a database? What is a checkpoint? Are dirty pages bad or good? What is a lock? The session is led by an expert Microsoft Certified Trainer (MCT) and former Microsoft MVP who regularly teaches SQL Server certification courses.

SessionID: 86490

Building a Microsoft Business intelligence Solution step-by-step

Back to calendar

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

Speaker: Farouq Abukhamireh

Title: Building a Microsoft Business intelligence Solution step-by-step

Abstract:

Overview of the Microsoft BI Technologies

BI Solution Topology BI solution requirements Data Modeling Relational Dimensional Data Warehouse ETL Tabular and Multidimensional Models. Insights and Visualization Agile methodologies Tips for success

SessionID: 86710

Troubleshooting AlwaysOn Availability Groups - Common Customer Scenarios

Back to calendar

Event Date: 23-03-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Chirag Shah

Title: Troubleshooting AlwaysOn Availability Groups - Common Customer Scenarios

Abstract:

Session will discuss troubleshooting

• Lease Timeout • Unplanned automatic failovers • Factors that prevents automatic failovers • Common configuration issues • Cannot join database to Availability Groups
• Listener Creation failure

SessionID: 87196

Encrypting Data within Sql Server

Back to calendar

Event Date: 23-03-2019 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Thomas Norman

Title: Encrypting Data within Sql Server

Abstract:

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

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

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

SessionID: 88004

Become a SQL Pro who’s in High Demand

Back to calendar

Event Date: 23-03-2019 - Session time: 08:30:00 - Track: Professional Development

Speaker: Wylie Blanchard

Title: Become a SQL Pro who’s in High Demand

Abstract:

Expertise in SQL is an in-demand IT skill. As demand continues to grow, so does the increase of SQL professionals entering your specific industry. Learn what's needed to ensure that you become a stronger technology authority in your industry and a SQL Pro who’s always in High Demand. You'll learn how to invest in growing your expertise, improve your social/people skills, how to effectively sell and market your talent, what is a “source of truth” and why is it extremely important and more.

SessionID: 88034

SQL Server Auditing

Back to calendar

Event Date: 23-03-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: H. Ross Reed

Title: SQL Server Auditing

Abstract:

Most companies Database Administration Departments are audited by Internal, External, or some sort of Government Regulator Auditors. This presentation shows the types of Auditing available for SQL Server as well as some demos which will show how to process the audit data and present in a readable format.

SessionID: 88045

Analysis Services is in Azure? Seriously!? Let's build a model!

Back to calendar

Event Date: 23-03-2019 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Phillip Labry

Title: Analysis Services is in Azure? Seriously!? Let's build a model!

Abstract:

This demo heavy session will be focused on setting up Azure Analysis Services, deploying a model, loading the model with data and finally reporting from your Azure Analysis Services instance.

SessionID: 88261

Containers, Pods, and Databases- The Future of Infrastructure

Back to calendar

Event Date: 23-03-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Joseph D'Antoni

Title: Containers, Pods, and Databases- The Future of Infrastructure

Abstract:

Containers have quietly been taking over the world of infrastructure, especially amongst developers and CI/CD practitioners. However, in the database space, container adoption has been lower. SQL Server 2017 introduced the concept of deploying databases into Docker containers. In this session, you will learn the fundamentals of creating containers, learning about Kubernetes for management, and how to further your learning in this new and emerging space.

SessionID: 88507

PowerShell for the Reluctant Administrator

Back to calendar

Event Date: 23-03-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Pat Phelan

Title: PowerShell for the Reluctant Administrator

Abstract:

You've heard many people claim that PowerShell is fabulous, but you've never really felt the need for it. What's all the fuss? What is PowerShell and why should you even care, much less learn it? How will this new toy make your work easier?

This session will help you understand what PowerShell is, how it integrates into the tools you know and love, and how it can help make your everyday work go faster and more smoothly. Along with the background on PowerShell, you'll see some simple but useful tools and ideas for how you can use those tools and make your own tools too.

This session was designed for the non-PowerShell user and the new PowerShell user. It is intended to help people understand what PowerShell is and start to use PowerShell, and it will touch on advanced ideas but only assumes only basic scripting/coding experience like understanding a variable, a loop, etc.

SessionID: 89353

Performance tuning with SQL Server memory grants

Back to calendar

Event Date: 23-03-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Arthur Daniels III

Title: Performance tuning with SQL Server memory grants

Abstract:

When you're performance tuning queries with memory grants, you want to know where, how and why the memory is granted and used in your query.

In this session, we'll talk about analyzing requested and granted memory inside execution plans, the plan cache, and in currently running queries.

We'll also talk about troubleshooting your system when many queries have memory grants.

Prerequisites: General knowledge of execution plans and query writing

SessionID: 86449

Using Extended Events for Wait Stats Analysis

Back to calendar

Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Enterprise Database Administration Deployment

Speaker: David Maxwell

Title: Using Extended Events for Wait Stats Analysis

Abstract:

When troubleshooting overall server performance, wait statistics are a great place to start. But when your SQL Server hosts a complex set of workloads, it can be difficult to narrow down which queries are causing the most wait, and what types of wait they are causing. Fortunately, SQL Server provides easy ways for targeting which queries are causing you the most wait time. In this session, we’ll learn how to use both Extended Events, and Dynamic Management Views for examining wait statistics from the instance level to the database level, all the way down to the individual query level. We’ll analyze poorly performing queries using a combination of methods including T-SQL queries and SQL 2017’s new XEvent Profiler, and show how to quickly narrow down what SQL Server is waiting for, and why.

SessionID: 86658

Azure SQL Database Managed Instance for DBAs

Back to calendar

Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Ross LoForte

Title: Azure SQL Database Managed Instance for DBAs

Abstract:

Azure SQL Database Managed Instance is a deployment model of Azure SQL Database, providing near 100% compatibility with the latest SQL Server on-premises. Managed Instance allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes. At the same time, Managed Instance preserves all PaaS capabilities (automatic patching and version updates, automated backups, high-availability ), that drastically reduces management overhead and TCO.

In this session, learn:

  1. Lift and Shift - Features compatability
  2. Fully managed PaaS - what does the DBA need to manage
  3. Full isolation and security - VNet support and security
  4. Sizing and limitations
  5. Best practices from customer deployments
  6. Roadmap

SessionID: 86948

How Cloud Computing Empowers a Data Scientist

Back to calendar

Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Cloud Application Development Deployment

Speaker: David Giard

Title: How Cloud Computing Empowers a Data Scientist

Abstract:

The last few years, we have seen an explosion in data science, artificial intelligence, and machine learning. The rise of cloud computing has been a major factor in this explosion. Cloud platforms, such as Microsoft Azure, enable users to quickly spin up clusters of computers to perform the high-performance calculations required by data science problems.

Azure offers a number of tools for building data science solutions: From a drag and drop interface to Jupyter Notebooks as a service to a Virtual Machine pre-configured with powerful Machine Learning tools. In this session, you will learn how the cloud has impacted data science, the most useful tools in Azure for a data scientist, and when it is appropriate to use each tool.

SessionID: 87371

Populating a Data Warehouse with SSIS and Biml Patterns

Back to calendar

Event Date: 23-03-2019 - Session time: 09:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jim Miller

Title: Populating a Data Warehouse with SSIS and Biml Patterns

Abstract:

This session will demonstrate how to leverage "Biml powered SSIS Patterns", to rapidly build SSIS packages. The focus of this session will be on populating a data warehouse, however the concepts presented could be applied to any ETL/ETL scenarios. The components used during this session: BimlSnap_v2 (an Open-Source, Biml integrated SQL Server database), and BimlExpress (a Visual Studio Add-in used to generate SSIS package) are both available at no charge. In addition, attendees will receive a 'SQL Server Metadata Manager' solution, along with a fully integrated SSIS Framework.

Attend to see how Biml can revolutionize your SSIS development!

SessionID: 87939

Lessons from Consulting: Third-Party Vendors

Back to calendar

Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Professional Development

Speaker: Andy Wickman

Title: Lessons from Consulting: Third-Party Vendors

Abstract:

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

SessionID: 88262

Automagic Tuning - SQL Server 2017 and Beyond

Back to calendar

Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Application Database Development

Speaker: Joseph D'Antoni

Title: Automagic Tuning - SQL Server 2017 and Beyond

Abstract:

Identifying and fixing problematic query plans got a lot easier in SQL Server 2016, with the introduction of the Query Store. SQL Server 2017 takes that power a few steps further. Have you ever:

• Had a query suddenly slow down at 2 AM when you were on call? • Seen a query that received a giant memory grant that brought the rest of the work on your server to a screeching halt? • Had the optimizer choose the wrong type of join and send your query off to never finish?

Don’t worry, you will still have your job, but the features introduced in SQL Server 2017 will make narrow your focus to the absolute worst queries in your environment. You will also get a sneak preview of what’s coming into future releases of SQL Server in terms of performance.

SessionID: 88323

Introduction to Azure Machine learning

Back to calendar

Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Analytics and Visualization

Speaker: Ravi Kumar

Title: Introduction to Azure Machine learning

Abstract:

Learn how to build a simple machine learning model. In this session we will:

  1. Create a model: Get data, Prepare the data, Define features
  2. Train the model: Choose and apply a learning algorithm
  3. Score and test the model

SessionID: 88326

Top Tips for Deploying AGs and FCIs On Premises or In the Cloud

Back to calendar

Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Allan Hirt

Title: Top Tips for Deploying AGs and FCIs On Premises or In the Cloud

Abstract:

There are three main ways to deploy Always On Availability Groups (AGs) and Always On Failover Cluster Instances (FCIs) - physical hardware, virtualized, and IaaS in the public cloud. Starting with SQL Server 2017, we now also have the ability to use Windows Server or Linux. While some things are the same, each of the possible permutations and combinations affect how you plan, deploy, and administer AGs and FCIs. This session cuts right to the chase and will give you top tips and tricks for successfully deploying and administering AGs and FCIs so you can be an availaility hero no matter where you are deploying or what operating system you are using.

SessionID: 88583

Python in SQL Server 2017

Back to calendar

Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Analytics and Visualization

Speaker: Chris Hyde

Title: Python in SQL Server 2017

Abstract:

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

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

SessionID: 89334

SentryOne Tools for Productivity and Performance

Back to calendar

Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Kline

Title: SentryOne Tools for Productivity and Performance

Abstract:

Whether you are hosting in your office, in a data center, or in the cloud, SentryOne covers monitoring, alerting, and tuning to help you get the most out of your servers – including servers that aren’t running SQL Server. In this session, your hosts will guide you through time saving strategies for managing performance across hybrid environments - whether you are running physical or virtual servers, or during the build, test, document, and optimization stage of the application lifecycle. You will see demonstrations of SentryOne software highlighting configuration and performance pitfalls and leave with a better understanding of performance problems you may be currently missing. SentryOne provides a unified management experience; it’s your ONE platform for physical, virtual, and cloud performance.

SessionID: 86405

That's So Metadata: Discover Your Database From The Inside

Back to calendar

Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Application Database Development

Speaker: Rob Volk

Title: That's So Metadata: Discover Your Database From The Inside

Abstract:

Have you ever needed to learn a new database design and don't know where to begin? Or are trying to find out why a query doesn't perform well? Or need to provide security information to auditors or your security team?

SQL Server has numerous metadata facilities available to help you with these tasks and more. Functions, dynamic management views, and system stored procedures can illuminate details from a single column up through an entire SQL Server instance. We will demonstrate metadata techniques to help you:

We will also cover the official Microsoft documentation on these features and other resources on how to use them.

SessionID: 86508

Real-time Analytics with Azure

Back to calendar

Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Analytics and Visualization

Speaker: Jordan Anderson

Title: Real-time Analytics with Azure

Abstract:

Ever wanted to analyze data as it happens? Azure provides an impressive suite of services to

enable real-time analytics. We begin our session with an overview of real-time analytics and its role in business today, then we dive into streaming data architecture on Azure, followed by a demo where we build a fully-functional streaming data pipeline with Azure Stream Analytics and present insights in real-time with Power BI.

SessionID: 86588

COSMOS DB Develop Local Deploy Globally

Back to calendar

Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Cloud Application Development Deployment

Speaker: Jim Dorame

Title: COSMOS DB Develop Local Deploy Globally

Abstract:

CosmosDB is Microsoft’s globally distributed, massively scalable, cloud based database that is hosted in AZURE. Who cares? You should if you need to support thousands of transactions a second, global distribution and redundancy, and different consistencies.

Do you need to support JSON, Graph, et al? Done. Join me and see how easy it is to get started. We will set up a local instance of CosmosDB, load JSON data and build a PowerBI visualization. Along the way I’ll point out a couple of things to watch out for. At the end of the session you will then learn how, with a couple of commands, to switch your visualization to the cloud.

SessionID: 87492

Azure Data Factory Ingestion Framework

Back to calendar

Event Date: 23-03-2019 - Session time: 11:10: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: 88133

Back to the Basics: T-SQL 101

Back to calendar

Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Application Database Development

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

Modern CPU Architecture and SQL Server Performance

Back to calendar

Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment

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

Laying down the Law with SQL Server Resource Governor

Back to calendar

Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Lonny Niederstadt

Title: Laying down the Law with SQL Server Resource Governor

Abstract:

Busy SQL Servers may host multiple concurrent workloads, including interactive end users, batch workloads and administrator activity.

This session will detail use of the Resource Governor to distinguish resource utilization among the different workloads. We'll explore the resource limits and controls available in Resource Pool and Workload Group configuration, and how they relate to resource limits at other levels. We'll also cover potential performance and scaling effects of Resource Governor, and how to monitor and evaluate behavior under a given set of configurations. Real-world examples will detail how greater query concurrency and better performance was achieved for the most important work on systems.

SessionID: 90947

Master Data Management: BI and Data Science’s Best Friend

Back to calendar

Event Date: 23-03-2019 - Session time: 11:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Tyler Graham

Title: Master Data Management: BI and Data Science’s Best Friend

Abstract:

No matter the complexity of your BI application, Master Data Management can provide your organization the tools needed to conform, manage and simplify your dimensions. Attend this session and learn how Analytical MDM can forge quicker and more valuable insights by managing dimensions and hierarchies for your Enterprise.

SessionID: 91336

Why Clustering for SQL Server High Availability?

Back to calendar

Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment

Speaker: David Bermingham

Title: Why Clustering for SQL Server High Availability?

Abstract:

When it comes to SQL Server high availability (HA), SQL Server Failover Cluster Instance (FCI) has been the standard since 1998 with the release of SQL Server 7. Dave Bermingham, Microsoft Cloud and Datacenter MVP and former Cluster MVP, reviews what clusters are, why you should use them for high availability, discusses SQL Server FCI concepts and why it is an important part of your Mission Critical SQL Server deployment whether you run on-premises, in the cloud or in a hybrid cloud configuration.

SessionID: 91379

Database Performance Monitoring

Back to calendar

Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Database Performance Monitoring

Abstract:

Are you struggling with performance issues and your current tools are not providing answers? This presentation will show several solutions from Quest Software that will give you real-time performance alerts and bring together all of your critical database metrics into a single dashboard, with color-coded alerts for problem severity which are clickable for rapid diagnostics. You’ll also learn how wait time and workload analysis can enable you to quickly focus on the worst queries causing the most issues currently and historically in your databases.

SessionID: 86404

Revenge: The SQL!

Back to calendar

Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Volk

Title: Revenge: The SQL!

Abstract:

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

Hint: You attend Revenge: The SQL! This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * in ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge! Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.

SessionID: 86968

Master Data Management with SQL Server MDS

Back to calendar

Event Date: 23-03-2019 - Session time: 12:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Neal Waterstreet

Title: Master Data Management with SQL Server MDS

Abstract:

Want to know the position Master Data Management and MDS play in an organization's overall data strategy? We'll review the key concepts and the different roles and responsibilities to help you get your organization moving forward with MDM. We'll then take a look at the features of SQL Server MDS that make it an excellent tool for MDM. This demo-packed presentation will cover architecture and installation, different ways of processing data, hierarchies, security and many other features that will get you up and running with MDS.

SessionID: 88028

Containers - You Better Get on Board!

Back to calendar

Event Date: 23-03-2019 - Session time: 12:40: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: 88031

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

Back to calendar

Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Analytics and Visualization

Speaker: Lynn Ballard

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

Abstract:

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

SessionID: 88408

The Amazing Utility of ROW_NUMBER()

Back to calendar

Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Application Database Development

Speaker: Brian Hansen

Title: The Amazing Utility of ROW_NUMBER()

Abstract:

When it was introduced way back in SQL Server 2005, the lowly ROW_NUMBER() function at first seemed to have little functionality other than simply counting rows. However, over time we have come to see this humble function is actually surprisingly useful in often unexpected ways. In this session we will discover the creative uses of ROW_NUMBER() in ways that you may likely not have yet considered. This session will be filled with little goodies that can you can use, whether you are a writing SQL for application code or for administrative functionality.

SessionID: 88482

Got the Consulting Itch? The Ins and Outs of being a Contractor for a Living

Back to calendar

Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Professional Development

Speaker: John Eisbrener

Title: Got the Consulting Itch? The Ins and Outs of being a Contractor for a Living

Abstract:

Have you ever thought about becoming a Consultant, but just didn't know if it was the right fit for you? In this session, I touch on various aspects of what being a consultant means, be it working for a consulting firm or independently for yourself. I'll cover some skills that are necessary to succeed in this field, touch on aspects of owning your own business, discuss ways to build up a network, and draw attention to some questions you should be asking yourself and others before you make the leap. By the end of the session, I hope you have enough information to know if becoming a consultant is the right choice for you or not.

SessionID: 88607

Introduction to Linux for SQL Server

Back to calendar

Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Jay Falck

Title: Introduction to Linux for SQL Server

Abstract:

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

SessionID: 90929

Analyzing Performance Problems Using XEvents, DMVs Query Store

Back to calendar

Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Ola Hallengren

Title: Analyzing Performance Problems Using XEvents, DMVs Query Store

Abstract:

Extended Events, Dynamic Management Views, and Query Store are highly useful tools that give you a lot of data when analyzing performance problems. The challenge is which tool to use for which problems and how to correlate the data.

You are troubleshooting a performance problem in a business-critical database, a query is not completing, the users are complaining, and you are trying to understand what is happening. You have data from Extended Events, you are looking in the execution related DMVs, and now you are trying to find the query in Query Store. How do you put it all together?

In this session, we will look at how the tools work in different scenarios, how to correlate the data, and how you can use them in your performance troubleshooting.

SessionID: 91234

Virtualizing SQL Server on vSphere - Straight from the Source

Back to calendar

Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Deji Akomolafe

Title: Virtualizing SQL Server on vSphere - Straight from the Source

Abstract:

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? Bring it!

SessionID: 91543

Modern Infrastructure Fundamentals for Database Professionals

Back to calendar

Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Allan Hirt

Title: Modern Infrastructure Fundamentals for Database Professionals

Abstract:

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

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

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

SessionID: 86416

New Instance, Now what?

Back to calendar

Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jim Donahoe

Title: New Instance, Now what?

Abstract:

Congratulations, you’re now our DBA! A new SQL instance is like a blank canvas, you stare at it and wonder where to start. As an accidental dba, this session will help you learn how to survive in your new role.

In this session, you will be supplied with the beginning brush strokes to make your server a master piece. To do so, we will review best practices for standard configurations, backups, maintenance, and disaster recovery.

By the end of this session, you will have developed a pallet of tools to help you create your SQL Server Masterpiece and be able to use it as a print for others.

SessionID: 86547

Profiling Your Data

Back to calendar

Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Angela Henry

Title: Profiling Your Data

Abstract:

Have you ever started a warehouse or ETL project and realized that the data wasn't as "clean" as you were told? If only you had profiled your data before you started then you wouldn't have to rework design elements, change code or redesign your database. In this session we will talk about what data profiling is, why you should do it and how you can do it with tools that are already included in the SQL Server BI stack.

SessionID: 87985

Get started with Power BI Dataflows

Back to calendar

Event Date: 23-03-2019 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Michael Johnson

Title: Get started with Power BI Dataflows

Abstract:

Data preparation is often the most labour-intensive component of any analytics project yet getting this right is vital if outcomes are to be accurate. While the growth of self-service BI empowers users to explore their data, the task of collecting and cleansing this data often requires more experienced hands.

Dataflows are an extension of the Power BI ecosystem, providing a low code approach using Power Query to create curated datasets that can quickly be consumed by business analysts, improving the speed at which business value is delivered. Dataflows can also be used to provide the single version of the truth that has traditionally been provided by data warehouses.

During this talk, we will demonstrate the creation of a dataflow using multiple data sources and also have a look at how you can get started for free using your Power BI Pro subscription.

SessionID: 88503

Improving Columnstore Load Scalability on Large Servers

Back to calendar

Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Joe Obbish

Title: Improving Columnstore Load Scalability on Large Servers

Abstract:

Clustered Columnstore indexes can be a great solution for data warehousing workloads, but loading lots of data as quickly as possible is still an arcane art. We will walk through how to improve scalability of two common loading patterns using lessons learned from production workloads involving billions of rows. Come to this session to improve your Columnstore load times, to learn about scalability on large servers, or simply to be challenged.

SessionID: 88604

Successfully Migrating Existing Databases to Azure SQL Database

Back to calendar

Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Cloud Application Development Deployment

Speaker: John Sterrett

Title: Successfully Migrating Existing Databases to Azure SQL Database

Abstract:

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

SessionID: 88609

Refactoring Monolith Database Stored Procedures

Back to calendar

Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Riley Major

Title: Refactoring Monolith Database Stored Procedures

Abstract:

We get it. Move fast and break things. Just ship it! But what's left a giant stored procedure with cursors, temp tables, and mystery calculations. It's a big black box that nobody wants to touch. Let's fix that. We'll open the lid on an example monolith and do major surgery. What's left will perform better, be easier to understand, encourage code reuse, and be easier to test.

SessionID: 89333

Ten Query Tuning Techniques Every SQL Programmer Should Know

Back to calendar

Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Kevin Kline

Title: Ten Query Tuning 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.

Goal 1: Implement a reusable Transact-SQL test harness for reliable query results. Goal 2: Learn ten patterns that kill the performance of SELECT statements and how to avoid them. Goal 3: Discover the high-impact metadata that shows how a SELECT statement behaves … or misbehaves.

Attend this session to take your query writing and query tuning skills to the next level!

SessionID: 91360

#GetModern with Dell EMC

Back to calendar

Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Bryan Walsh

Title: #GetModern with Dell EMC

Abstract:

Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged… we have you covered.

SessionID: 91855

How To Talk To Your Storage Admin

Back to calendar

Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Marsha Pierce

Title: How To Talk To Your Storage Admin

Abstract:

A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.

SessionID: 91857

You’re hired! Creating value before and after the interview to be

Back to calendar

Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Professional Development

Speaker: Wylie Blanchard

Title: You’re hired! Creating value before and after the interview to be

Abstract:

Landing a gig as an employee, consultant or contractor has become highly competitive. You need to differentiate yourself in a way that tells the hiring manager that you are more valuable than everyone else. In this session, I'll share 3 things that I've learned from my experience as an employee, hiring manager and consultant that will help you market your expertise, create new opportunities and get them saying "you're hired".

SessionID: 86445

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

Back to calendar

Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Application Database Development

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

Lambda architecture design using Azure Databricks for advanced analytics

Back to calendar

Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Cloud Application Development Deployment

Speaker: Lucas Feiock

Title: Lambda architecture design using Azure Databricks for advanced analytics

Abstract:

In this session, we will review the history of Azure Databricks, world records it broke, and how to accelerate your data platform solutions. We will cover lambda architecture, Azure Databricks components, and how to integrate other Microsoft Azure services. Then we will see a demonstration on creating clusters, notebooks, team collaboration, and advanced analytics. Finally, we will take a look at additional information on how to further utilize Azure Databricks.

SessionID: 87221

Hello My Friends, Welcome to CosmosDB

Back to calendar

Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Cloud Application Development Deployment

Speaker: Peter Shore

Title: Hello My Friends, Welcome to CosmosDB

Abstract:

Microsoft says Azure Cosmos DB is a globally distributed, multi-model database. Your reaction might be something like, “what the heck is it”, “why would I use it”, or “how do I use it”. The fundamental purpose of this session is to answer those very questions. After briefly discussing what CosmosDB is, we’ll take some time to discuss why you might use CosmosDB instead of SQL Server or another platform, and finally touch on some basics to get you started with CosmosDB. Upon completion of this session you will be better equipped to discuss the value of CosmosDB to your organization.

SessionID: 87509

High Availability and Disaster Recovery for SQL Server in Azure IaaS

Back to calendar

Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: David Bermingham

Title: High Availability and Disaster Recovery for SQL Server in Azure IaaS

Abstract:

The CEO just tasked you with moving all the SQL Server instances to Azure, or maybe you are deploying a brand new application and want to leverage Azure IaaS to host SQL Server. Beyond security and performance, your most pressing concern might be ensuring SQL Server running in Azure is highly available.

While on-prem high availability and disaster recovery options for SQL Server are well defined, moving those instances to Azure immediately presents some questions and challenges. Can I simply lift and shift my SQL Server Failover Cluster Instance to the cloud? Do I need to upgrade to SQL Server Enterprise Edition and us Always On Availability Groups? What about shared storage and failover clustering? What about disaster recovery, what are my options there? Load Balancers, Fault Domains, Availability Zones, Azure Site Recovery and Region Pairs, what are these things and why do they matter to me?

Cloud Datacenter MVP David Bermingham takes explains all this and more in the session.

SessionID: 87713

Climbing the SQL Server Index B-Tree

Back to calendar

Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: Climbing the SQL Server Index B-Tree

Abstract:

You’ll find a lot of Word of Mouth (WOM) advice out there about SQL Server performance, especially when it comes to indexes. Some of the things you have probably heard are:

 keep clustered index width small  unique indexes perform better  keep non-clustered index width small  compressed indexes have fewer logical reads  add one index for each column

But how do you know if this advice is good or bad? Did you know that there is a way to look under the hood at the actual index pages to see how the data is stored, and how it’s stored differently when data is compressed? Using this information, you can prove or disprove the WOM advice. Attend this demo-heavy session to learn how the SQL Server optimizer uses indexes. It’s all about performance, and the right indexes will give your application a big performance advantage.

SessionID: 87978

Is my SQL Server having Memory Pressure?

Back to calendar

Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Bland

Title: Is my SQL Server having Memory Pressure?

Abstract:

As we all know, SQL Server loves memory and will use as much as it can get. However, when there is memory pressure we need to use our DBA skills to identify what is causing the pressure. During this session we will explore how SQL Server uses memory and how to properly configure memory settings. We will discuss the use of DMVs and other tools to help us find what is consuming the most memory and some potential solutions.

SessionID: 88502

Diagnosing and fixing deadlocks in SQL Server

Back to calendar

Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Application Database Development

Speaker: Jake Manske

Title: Diagnosing and fixing deadlocks in SQL Server

Abstract:

You know how locking works in SQL Server, but now you are tasked with diagnosing and fixing deadlocks. How do you take the knowledge you have and apply it to address deadlocks in your production database?

In this session, we will discuss how you can use free tools to detect and analyze deadlocks in your system. We will do a deep dive on deadlock XML with an eye toward interpreting the information automatically collected by SQL Server when the free tools fall short.

Attendees will leave with the understanding they need to develop solutions to deadlocks in their systems.

SessionID: 88958

PowerShell for the DBA

Back to calendar

Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

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

Azure SQL DevOps Simplified with Production Data

Back to calendar

Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Application Database Development

Speaker: Paul Stanton

Title: Azure SQL DevOps Simplified with Production Data

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

My Brain Has Blue Screened - Let's Laugh

Back to calendar

Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Professional Development

Speaker: David Klee

Title: My Brain Has Blue Screened - Let's Laugh

Abstract:

Is your brain mush from too much technical content, but you just need a break before the next session or the raffle? Come share your IT war stories with the group and laugh for an hour. This open panel session is guaranteed to at least get a chuckle as we all relax and share our experiences.