sqlsathistory

Nr: 877

Back to Main list

SQLSaturday #877 - Boston 2019

Start Time (24h) Speaker Track Title
08:45:00 Andrew Nielsen Sponsor/Other VMware Technologies and Microsoft SQL Server
10:00:00 Edward Pollack Development All About Temporary Objects
10:00:00 Chris Seferlis Administration Azure SQL Managed Instances - A mostly full-featured SQL Server in the Cloud
10:00:00 Deborah Melkin Development Back to the Basics: T-SQL 101
10:00:00 Grant Fritchey Development Introduction To SQL Server In Containers
10:00:00 Allan Hirt Administration Demystifying Always On Availability Groups
10:00:00 Surbhi Pokharna Administration Will Query Store fix all my Performance Issues?
10:00:00 Lowry Kozlowski Administration SQL Server Take Over:  Establishing a Baseline
11:15:00 Alex Grinberg Development Advanced T-SQL Development with latest features.
11:15:00 Andy Leonard Administration SSIS and Containers
11:15:00 Rahat Yasir Professional Development Journey from Software Developer to AI Developer
11:15:00 Andy Levy Development Keys to a Healthy Relationship with SQL Server
11:15:00 Bill Wilder Administration Running Azure SQL Database Securely
11:15:00 Sunil Kadimdiwan Analytics/BI Add Time Intelligence to Power BI
11:15:00 Chris Voss Development Should This Be Normalized? When Database Normalization Seems Abnormal
12:35:00 Daniel Cai Sponsor/Other Supercharge your ETL Development with Advanced SSIS Components
12:35:00 Jay Rajendran Sponsor/Other Running Windows and SQL Workloads on Google Cloud Platform
12:35:00 Deborah Melkin Sponsor/Other Women-In-Technology (Models and Mentors)
12:35:00 Andy Yun Sponsor/Other Going Beyond Monitoring With SentryOne
12:35:00 Oleg Ulyanov Sponsor/Other Successfully Virtualizing SQL Server on vSphere: Doing It Right
12:35:00 George Walters Sponsor/Other SQL 2019 new features
12:35:00 Allan Hirt Sponsor/Other Increasing SQL Server Availability Options Using SIOS DataKeeper
13:30:00 Joe Gavin Administration We Need To Talk Security
13:30:00 Hasan Savran Development Unexplored Features of SQL Server
13:30:00 Ganesh Lohani Analytics/BI Data Science 101: An Introduction to Data Science Using Python
13:30:00 Andy Yun Development Let's Dive Into SQL Server I/O To Improve T-SQL Performance
13:30:00 Rick Lowe Administration Why should I care about ... the plan cache?
13:30:00 Jack Corbett Administration dbatools - A PowerShell Toolkit for the DBA
13:30:00 Daniel Cai Administration Design for Flexibility and performance - ETL Patterns with SSIS and Beyond
14:45:00 Brent Ozar Development What's New in SQL Server 2019: 100% Demos
14:45:00 Kevin Feasel Development Approaching Zero: Minimizing Downtime During Deployments
14:45:00 Peter Doyle Analytics/BI Become a T-SQL Pivoting Ninja in 59.5 Minutes Or Less
14:45:00 Angela Tidwell Professional Development Become the Most Valuable Player: Soft Skills for the Hard Market
14:45:00 George Walters Administration Organizational Security Compliance with SQL 2012 through 2016/2017
14:45:00 Joshua Higginbotham Development Introduction to GitHub
14:45:00 MIKE DONNELLY Development Cosmic DBA - Cosmos DB for SQL Server Admins and Developers
16:00:00 Mike Walsh Administration Upgrading SQL Server - Prepare for Success!
16:00:00 Matthew Anderson Administration CYA for the DBA
16:00:00 Thomas Grohser Administration Persistent Memory and Hybrid Buffer Pool - The good, bad and ugly
16:00:00 Sergiy Lunyakin Analytics/BI Introduction into SQL Server 2019 Big Data Cluster
16:00:00 Eddy Djaja Administration What Is Clogging Your Database Performance?
16:00:00 John Miner Development How to audit and prevent unwanted user actions.
16:00:00 Adam Machanic Development Data Pipeline Best Practices for an Increasingly Cloudy World

SessionID: 98392

VMware Technologies and Microsoft SQL Server

Back to calendar

Event Date: 14-09-2019 - Session time: 08:45:00 - Track: Sponsor/Other

Speaker: Andrew Nielsen

Title: VMware Technologies and Microsoft SQL Server

Abstract:

Historically running Microsoft SQL Server on VMware vSphere has been a major benefit to all users of SQL Server. The tremendous capabilities both in resource management and mobility innate in the vSphere platform creates an application stack of unparalleled value. Now VMware has expanded its technology offerings into the full Software Defined Datacenter and the Hybrid Cloud. Starting with the VMware offering of the VMware Cloud on AWS, which we presented last year at this event, VMware Technologies through the umbrella idea of “VMware Cloud Foundation” runs on many pubic cloud offerings including Microsoft Azure. In this keynote the VMware Sr. Director of Cloud Platform Product Marketing Andrew Nielsen will discuss the present and future of MS SQL Server and VMware Technologies.

SessionID: 91605

All About Temporary Objects

Back to calendar

Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Development

Speaker: Edward Pollack

Title: All About Temporary Objects

Abstract:

Database development and administration require temporary objects for ETL, staging, data processing, and many other common tasks.

In this session, we will delve into temporary tables, table variables, and memory-optimized table variables, discussing their differences, how they work, and the optimal scenarios for using each of them.

SessionID: 91850

Azure SQL Managed Instances - A mostly full-featured SQL Server in the Cloud

Back to calendar

Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Administration

Speaker: Chris Seferlis

Abstract:

In this session we will compare the offerings of Azure SQL Databases, then dig in and show what separates SQL Managed Instances from the rest. We’ll take a look at challenges that previously prevented migrations to Azure, the current features available, some common architectures, and backup and restore options.

SessionID: 94857

Back to the Basics: T-SQL 101

Back to calendar

Event Date: 14-09-2019 - Session time: 10:00:00 - Track: 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: 95522

Introduction To SQL Server In Containers

Back to calendar

Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Development

Speaker: Grant Fritchey

Title: Introduction To SQL Server In Containers

Abstract:

Finally, it's become easy for SQL Server developers and DBAs to use containers to speed up software development and testing. Containers have been around for more than 30 years, and at last they have become a great tool for Microsoft data professionals. Join Grant Fritchey to learn how containers differ from virtual machines, and why containers make it incredibly fast to deploy new instances of SQL Server. Grant will use Docker containers to demo the process of spinning up a new SQL Server using the very latest version of the product -- without actually installing SQL Server! Finally, you'll learn how containers can be used in the software development lifecycle to speed up the process of developing, testing, and deploying changes.

SessionID: 95669

Demystifying Always On Availability Groups

Back to calendar

Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Administration

Speaker: Allan Hirt

Title: Demystifying Always On Availability Groups

Abstract:

Always On Availability Groups (AGs) have evolved since their introduction in SQL Server 2012. Not only is there the “classic” form of AGs, but now there are Basic Availability Groups, Distributed Availability Groups, Domain Independent Availability Groups, and Read Scale Groups. Also complicating the picture is virtualization, hyperconverged, the public cloud, Linux, as well as containers which is new to SQL Server 2019. Come to this session to learn what AGs are – and are not – today, the differences between the various AG and deployment options, and how you can harness the power of them in your environments.

SessionID: 96139

Will Query Store fix all my Performance Issues?

Back to calendar

Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Administration

Speaker: Surbhi Pokharna

Title: Will Query Store fix all my Performance Issues?

Abstract:

How many of you cross your fingers and hold your breath when a new upgrade or new code goes live in production? Well you can breathe now and relax your fingers because in SQL Server 2016 Microsoft released Query Store. Query Store is like a flight data recorder for SQL Server, the black box in an airplane captures everything that occurs on a flight. In this session we will deep dive to learn how to configure (yes – you need to configure this black box – or it could crash your “plane”), use Query Store to troubleshoot database performance issues. I will show you multiple demos to capture baseline, understand query regression and how to force good execution plan. You will walk away with the knowledge of how to configure and use Query Store to help fix performance issues.

SessionID: 96144

SQL Server Take Over:  Establishing a Baseline

Back to calendar

Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Administration

Speaker: Lowry Kozlowski

Title: SQL Server Take Over:  Establishing a Baseline

Abstract:

SQL Server Take Over:  Establishing a Baseline

Performance assessment and tuning for the beginner DBA   Have you ever inherited a group of servers with not a lot of documentation to accompany them?  Do you have a lot of undocumented or new servers in your environment and you want to establish some baseline configuration setting prior to making changes? You need up to date information on the system very quickly.    The server is running slowly... or is it? Slow compared to what?  Before you being digging into performance issues, there are some baseline metrics you should have established. Only after the information has been gathered, can a plan of attack be developed to help resolve issues with performance. Attendees in this session will learn how to quickly  gather information, review the results and get an action plan on the next step in performance tuning.

SessionID: 91608

Advanced T-SQL Development with latest features.

Back to calendar

Event Date: 14-09-2019 - Session time: 11:15:00 - Track: Development

Speaker: Alex Grinberg

Title: Advanced T-SQL Development with latest features.

Abstract:

In the last releases, SQL Server development was enriched with new T-SQL features, such as CTE (common table extension), array of Ranking and Windowing functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, EXCEPT and INTERSECT just to name a few. For various reasons some DBA/Developers do not utilize these new features. In this session, the audience will see demonstrations of the different practical use cases where these features can make T-SQL coding more efficient. This 100% code-based demo session highlights efficiency to utilize the latest T-SQL functions over conventional methods with the same functionality. The session will cover in depth live scenarios where these features have proven performance efficiency, code re

SessionID: 93215

SSIS and Containers

Back to calendar

Event Date: 14-09-2019 - Session time: 11:15:00 - Track: Administration

Speaker: Andy Leonard

Title: SSIS and Containers

Abstract:

It's possible to execute SSIS packages from an SSIS Catalog running in a Windows container. It's not easy, but it is possible. Join Microsoft Data Platform MVP and author Andy Leonard as he walks you through the steps.

SessionID: 95569

Journey from Software Developer to AI Developer

Back to calendar

Event Date: 14-09-2019 - Session time: 11:15:00 - Track: Professional Development

Speaker: Rahat Yasir

Title: Journey from Software Developer to AI Developer

Abstract:

Software developers are evolving as AI developers to full fill vacant positions in AI field. In this session we will talk about the journey of an AI developer from software development background. We will talk about the tools that they need to be familiar with, algorithms they need to know, AI application development life cycle, AI application development best practices, languages they should learn and things they need to keep in mind while developing an AI application.

SessionID: 95925

Keys to a Healthy Relationship with SQL Server

Back to calendar

Event Date: 14-09-2019 - Session time: 11:15:00 - Track: Development

Speaker: Andy Levy

Title: Keys to a Healthy Relationship with SQL Server

Abstract:

Developers and DBAs have had a long, sometimes strained relationship. Some developers see DBAs as roadblocks standing in the way of getting their work shipped; some DBAs see developers as agents of chaos bent on ruining their perfect database environments.

In this talk designed for application and database developers, we’ll talk about why SQL Server behaves the way it does, common database and query design pain points, and how we look for them. With real-world examples and tales of troublesome T-SQL, past and present, you’ll start to get a picture of what to do and not to do in your applications. Along the way, you’ll learn how to build a better relationship with both SQL Server and the DBAs responsible for it.

SessionID: 96080

Running Azure SQL Database Securely

Back to calendar

Event Date: 14-09-2019 - Session time: 11:15:00 - Track: Administration

Speaker: Bill Wilder

Title: Running Azure SQL Database Securely

Abstract:

In this session we review the key differences around identity management and authentication (including multi-factor authentication), managing server credentials (or, even better, not needing to in some cases), how to audit logins (probably not what you expect), an overview of encryption and data masking options, and the supporting role of Azure Key Vault. We will also touch on compliance and disaster recovery to give the complete picture of powerful features you'll definitely want to know about to protect your data.

This talk will cover relevant capabilities for both traditional Azure SQL Databases and the newer Azure SQL Managed Instances.

This talk assumes you are already familiar with SQL Server or another enterprise database.

SessionID: 96092

Add Time Intelligence to Power BI

Back to calendar

Event Date: 14-09-2019 - Session time: 11:15:00 - Track: Analytics/BI

Speaker: Sunil Kadimdiwan

Title: Add Time Intelligence to Power BI

Abstract:

When is Time Period based calculations useful in Power BI? Quick answer - ALWAYS! Business users need to know measures such as: What was Sales, what was the change compared to last-year, year-to-date? Did our Expenses go down, compared to similar period last year? etc.

In this session you will learn how to use and apply DAX functions in Power BI, to develop Time and Date based dimensions and measures that will help answer such questions.

SessionID: 96140

Should This Be Normalized? When Database Normalization Seems Abnormal

Back to calendar

Event Date: 14-09-2019 - Session time: 11:15:00 - Track: Development

Speaker: Chris Voss

Title: Should This Be Normalized? When Database Normalization Seems Abnormal

Abstract:

Ever since database normalization was introduced as a concept by Edgar Codd, there has been continuous debate on how far we should go to eliminate data redundancy. A new developer may be asking why there is a need to create multiple tables, and a DBA may be concerned that performance is being sacrificed. In this discussion, we’ll cover 1st, 2nd, 3rd, and Boyce-Codd Normal Forms, evaluate the pros and cons of normalization and denormalization for integrity and performance, and run through some examples with various data models. All to answer the question, "should...this...be...normalized?"

SessionID: 96764

Supercharge your ETL Development with Advanced SSIS Components

Back to calendar

Event Date: 14-09-2019 - Session time: 12:35:00 - Track: Sponsor/Other

Speaker: Daniel Cai

Title: Supercharge your ETL Development with Advanced SSIS Components

Abstract:

Want to get more out of your SSIS development efforts? The SSIS Productivity Pack is a collection of premium SSIS components which enable an improved SSIS ETL development experience with greater potentials. These SSIS components for connectivity and productivity offer more features and bring new enhancements to SSIS to enable integration scenarios not once possible without custom scripting.

In this session, we will introduce you to our collection of 200 advanced SSIS components. We will demonstrate some of our most popular offerings including our JSON XML components for integrating with REST APIs, Premium Derived Column with over 225 functions, and unique components such as Duplicate Detector and Diff Detector.

In additional to performing advanced transformations you will also find codeless and feature-rich solutions for integrating with virtually any application or database system including leading enterprise applications such as Microsoft SharePoint, Dynamics 365 and more.

SessionID: 97993

Running Windows and SQL Workloads on Google Cloud Platform

Back to calendar

Event Date: 14-09-2019 - Session time: 12:35:00 - Track: Sponsor/Other

Speaker: Jay Rajendran

Title: Running Windows and SQL Workloads on Google Cloud Platform

Abstract:

Google Cloud Platform enables you to exit non-differentiating, capital intensive activities like hardware procurement and maintenance. Retire hardware, improve server utilization and deploy your Windows and SQL Workloads in an open cloud environment. Google enables extending your SQL database with advanced Server-less Analytics and AI/ML offerings. Deliver a complete platform without the burden of provisioning, scaling and upgrading infrastructure. This session will provide a walk-through of Google's approach to running Windows/SQL workloads in the Cloud and architectural patterns to address your needs.

SessionID: 97997

Women-In-Technology (Models and Mentors)

Back to calendar

Event Date: 14-09-2019 - Session time: 12:35:00 - Track: Sponsor/Other

Speaker: Deborah Melkin

Title: Women-In-Technology (Models and Mentors)

Abstract:

Join our panelists as we discuss "Models and Mentors".

SessionID: 98356

Going Beyond Monitoring With SentryOne

Back to calendar

Event Date: 14-09-2019 - Session time: 12:35:00 - Track: Sponsor/Other

Speaker: Andy Yun

Title: Going Beyond Monitoring With SentryOne

Abstract:

Hopefully you are monitoring your SQL Servers using DIY scripts or a 3rd party tool. Active monitoring is invaluable to enable the operational DBA to identify and address issues quickly. But did you know that SentryOne offers capabilities beyond just monitoring? Join me and I'll show you how SentryOne provides environment wide visibility and aids in managing cross-server activities. I'll showcase how alerting can be tuned to be effective and not noise. And you'll discover how SentryOne can give you both operational and business value to address your application challenges.

SessionID: 98382

Successfully Virtualizing SQL Server on vSphere: Doing It Right

Back to calendar

Event Date: 14-09-2019 - Session time: 12:35:00 - Track: Sponsor/Other

Speaker: Oleg Ulyanov

Title: Successfully Virtualizing SQL Server on vSphere: Doing It Right

Abstract:

Let us connect DBAs and Infrastructure Admins providing to DBAs vital information how to get best SQL Server deployment on top of VMware virtual platform. The session will cover both the design and the configuration of a SQL Server virtual machine with the special focus on:

• vCPU allocation and deep dive in vNUMA • Memory allocation and configurations options • Storage configuration best practices including PMem/NFS/Snapshots • Network configuration myths and best practices

It all that you want to know about virtual platform configuration but hesitated to ask! Directly from the source with the ton of hands-on from VMware Professional Services.

SessionID: 98500

SQL 2019 new features

Back to calendar

Event Date: 14-09-2019 - Session time: 12:35:00 - Track: Sponsor/Other

Speaker: George Walters

Title: SQL 2019 new features

Abstract:

SQL Server 2019 - new features

SessionID: 98548

Increasing SQL Server Availability Options Using SIOS DataKeeper

Back to calendar

Event Date: 14-09-2019 - Session time: 12:35:00 - Track: Sponsor/Other

Speaker: Allan Hirt

Title: Increasing SQL Server Availability Options Using SIOS DataKeeper

Abstract:

Whether you are deploying on premises (physical or virtual) or up in a public cloud (Amazon Web Services, Microsoft Azure, or Google Cloud Platform), your SQL Server databases and instances need to be highly available. Some options, such as Always On Failover Cluster Instances (FCIs), are not easy to deploy when you need some form of shared storage and traditional storage methods are not accessible. Other times you have storage performance requirements in addition to availability that cannot be met by traditional solutions such as a SAN. Come to this session to learn how SIOS DataKeeper Cluster Edition can enhance your SQL Server deployments to help you achieve high availability, disaster recovery, and storage performance goals.

SessionID: 93553

We Need To Talk Security

Back to calendar

Event Date: 14-09-2019 - Session time: 13:30:00 - Track: Administration

Speaker: Joe Gavin

Title: We Need To Talk Security

Abstract:

Unless you've been stranded on a deserted island for years you've heard about all the data breaches that seem to happen every day.

This means data security has never been more important which means SQL Server security has never been more important.

We'll take a high level look at security starting with physical security, see the two authentication modes, differences between logins and users, troubleshooting some common login issues, see how to gain access to a SQL Server and wrap up with security similarities and differences between on premise SQL Server and Azure SQL Database.

SessionID: 93751

Unexplored Features of SQL Server

Back to calendar

Event Date: 14-09-2019 - Session time: 13:30:00 - Track: Development

Speaker: Hasan Savran

Title: Unexplored Features of SQL Server

Abstract:

Every new version of SQL Server adds new features, some of these features are rarely talked about. Join me in this practical session to learn about some of the uncommon but useful features and data types of SQL Server.

We will start with exploring the hierarchyid, geometry and geography data types of SQL Server. We will look at the Temp tables and find a way to cache Temp tables for a better performance. We will cover sparse, rowversion columns and finish the session by showing a way to remove ORM from web applications by using JSON functions of SQL Server.

SessionID: 94843

Data Science 101: An Introduction to Data Science Using Python

Back to calendar

Event Date: 14-09-2019 - Session time: 13:30:00 - Track: Analytics/BI

Speaker: Ganesh Lohani

Title: Data Science 101: An Introduction to Data Science Using Python

Abstract:

SessionID: 95500

Let's Dive Into SQL Server I/O To Improve T-SQL Performance

Back to calendar

Event Date: 14-09-2019 - Session time: 13:30:00 - Track: Development

Speaker: Andy Yun

Title: Let's Dive Into SQL Server I/O To Improve T-SQL Performance

Abstract:

Do you understand how SQL Server handles I/O? If not, you should. Understanding I/O is more important than ever with increasing cloud adoption, due to cloud costing models. But even on-premises, I/O has a direct impact on T-SQL performance.

Join me for a deep dive into the storage engine to understand how SQL Server handles I/O. Concepts will be paired with T-SQL examples to illustrate the practical impacts.

When you leave, you'll be able to optimize your T-SQL reduce I/O and improve performance across the board.

SessionID: 96102

Why should I care about ... the plan cache?

Back to calendar

Event Date: 14-09-2019 - Session time: 13:30:00 - Track: Administration

Speaker: Rick Lowe

Title: Why should I care about ... the plan cache?

Abstract:

SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this installment of Rick's "Why should I care" series, he lays out a case for why working knowledge of the plan cache is critical for performance tuning efforts in real world environments. A review of relevant views and functions is included for the (newly?) motivated audience.

Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs often seem so frazzled. This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.

SessionID: 96425

dbatools - A PowerShell Toolkit for the DBA

Back to calendar

Event Date: 14-09-2019 - Session time: 13:30:00 - Track: Administration

Speaker: Jack Corbett

Title: dbatools - A PowerShell Toolkit for the DBA

Abstract:

In this demo driven session you will learn how to: prepare your computer for installation of the dbatools module, install dbatools and pre-requisites, use dbatools commands to automate routine tasks such as migrating logins and jobs, setup log shipping, and add databases to availability groups. At the end of the session, you will be able to return to your office with dbatools as a new tool in your toolkit to help you manage your SQL Server estate in a more efficient manner.

Prerequisites: Basic PowerShell knowledge. Some SQL Server Administration experience

SessionID: 98023

Design for Flexibility and performance - ETL Patterns with SSIS and Beyond

Back to calendar

Event Date: 14-09-2019 - Session time: 13:30:00 - Track: Administration

Speaker: Daniel Cai

Title: Design for Flexibility and performance - ETL Patterns with SSIS and Beyond

Abstract:

Ever wonder about becoming an ETL master using SSIS platform? Come to this session to learn some advanced techniques and design patterns that can be used in solving some day-to-day integration development challenges.

SessionID: 91659

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

Back to calendar

Event Date: 14-09-2019 - Session time: 14:45:00 - Track: Development

Speaker: Brent Ozar

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

Abstract:

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

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

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

SessionID: 93279

Approaching Zero: Minimizing Downtime During Deployments

Back to calendar

Event Date: 14-09-2019 - Session time: 14:45:00 - Track: Development

Speaker: Kevin Feasel

Title: Approaching Zero: Minimizing Downtime During Deployments

Abstract:

Negotiating a downtime for a release can be difficult in this modern, 24x7 world. When downtime means lost revenue, the price of taking a downtime to deploy code can run up quickly. This talk will show you a way to reduce the cost of deployment by reducing or even eliminating required downtime for database code deployment. We will show how to release new database code, update existing stored procedures, refactor and restructure tables, and even perform systemic re-architecture with no downtime and minimal blocking. We will use as a case study one release in which we modified the primary key column on 180 tables and updated over 550 stored procedures without end users noticing a thing. If you want to hit that three nines (or better) service-level agreement, this talk will help get you on the road to reduced downtime.

SessionID: 93658

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

Back to calendar

Event Date: 14-09-2019 - Session time: 14:45:00 - Track: Analytics/BI

Speaker: Peter Doyle

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

Abstract:

Would you like to create Pivot Tables in SQL with ease?

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

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

SessionID: 93684

Become the Most Valuable Player: Soft Skills for the Hard Market

Back to calendar

Event Date: 14-09-2019 - Session time: 14:45:00 - Track: Professional Development

Speaker: Angela Tidwell

Title: Become the Most Valuable Player: Soft Skills for the Hard Market

Abstract:

Whether you are just starting a career, advancing into senior leadership, or trying to woo a potential client, soft skills can be your ticket to success. Often times we focus on showing how smart we are instead of showing what a good team member we can be. We will discuss the role and types of soft skills needed to showcase your X-factor. Need to hone your skills? We will explore innovative and fun ways in which to do just that!

SessionID: 94526

Organizational Security Compliance with SQL 2012 through 2016/2017

Back to calendar

Event Date: 14-09-2019 - Session time: 14:45:00 - Track: Administration

Speaker: George Walters

Title: Organizational Security Compliance with SQL 2012 through 2016/2017

Abstract:

You need to deal with more security requirements in your role. How can SQL Server features help you comply? We will delve into Audit, Compliance, and Encryption. SQL 2016/2017 features like Always Encrypted will be detailed at the end.

SessionID: 94565

Introduction to GitHub

Back to calendar

Event Date: 14-09-2019 - Session time: 14:45:00 - Track: Development

Speaker: Joshua Higginbotham

Title: Introduction to GitHub

Abstract:

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

SessionID: 96004

Cosmic DBA - Cosmos DB for SQL Server Admins and Developers

Back to calendar

Event Date: 14-09-2019 - Session time: 14:45:00 - Track: Development

Speaker: MIKE DONNELLY

Title: Cosmic DBA - Cosmos DB for SQL Server Admins and Developers

Abstract:

NoSQL is not just about having eventual consistency. Switching from a relational database to a NoSQL data store like Cosmos DB is a mind shift for SQL DBAs and developers used to thinking in terms of tables. Schema-free doesn’t mean you don’t have to think about the schema, but it does allow for faster changes and some interesting design patterns.

This session will include a quick outline of Cosmos DB. Then it will move on to describe how indexing works, what the consistency levels all mean, and how your JSON should be designed based on your query patterns. And, I will toss in a high-level overview of the JavaScript triggers, stored procedures, and user defined functions for free. All of this will be presented using examples that are informed by my experience trying to convert a global application from SQL Server to Cosmos DB using the document model.

SessionID: 91736

Upgrading SQL Server - Prepare for Success!

Back to calendar

Event Date: 14-09-2019 - Session time: 16:00:00 - Track: Administration

Speaker: Mike Walsh

Title: Upgrading SQL Server - Prepare for Success!

Abstract:

It's (past) time to upgrade your SQL Server(s)! Where do you start? What version should you pick? How do you migrate? What about the downtime? ARGH!

Come to this session and take the stress out of your SQL Server upgrade project. In this session, we'll walk through all you need to think about and do before, during, and after your upgrade for success. We'll answer your upgrade questions, but you'll also leave with the right questions to ask everyone else as you prepare for a successful SQL Server upgrade project.

We'll talk about successful upgrade checklists, best practices, why roulette is better than in-place upgrades, and how to minimize the strain on your users and teams during the upgrade. You'll leave with a working start on your upgrade checklist and plans, too!

Come on! Ditch those SQL Server 2008, 2012, and 2014 instances! Also, yes, we'll chat about the cloud some, too.

SessionID: 92341

CYA for the DBA

Back to calendar

Event Date: 14-09-2019 - Session time: 16:00:00 - Track: Administration

Speaker: Matthew Anderson

Title: CYA for the DBA

Abstract:

Do you practice restores on a regular basis, but others in your organization do not? Are you worried that a restore may not be complete? As a DBA you are responsible for much more than simply backup and recovery of databases. This session will go over how to backup some SQL Server objects like Alerts, DBMail, LinkedServers, SQL Agent properties, and others with PowerShell.

I have not always trusted others to be able to restore a machine. This talk walks through how to CYA in the event of an emergency by backing up SQL objects other than just the databases.

SessionID: 93476

Persistent Memory and Hybrid Buffer Pool - The good, bad and ugly

Back to calendar

Event Date: 14-09-2019 - Session time: 16:00:00 - Track: Administration

Speaker: Thomas Grohser

Title: Persistent Memory and Hybrid Buffer Pool - The good, bad and ugly

Abstract:

SQL Server 2019 will introduce us to a new feature called Hybrid Buffer Pool. The ability of placing database files into "Memory" that does not lose its content in case of a power outage. This session will explore when it makes sense to use this feature and when not to use it.

SessionID: 95547

Introduction into SQL Server 2019 Big Data Cluster

Back to calendar

Event Date: 14-09-2019 - Session time: 16:00:00 - Track: Analytics/BI

Speaker: Sergiy Lunyakin

Title: Introduction into SQL Server 2019 Big Data Cluster

Abstract:

SQL Server 2019 allows you to deploy a scalable cluster of SQL Server, HDFS and Spark in Kubernetes. It brings you new capabilities to integrate structured and non-structured data, create data virtualization on top of it and integrate AI with it. Sounds amazing, right?

Join me in this session and I show you how it is easy to deploy this cluster and start using it, capabilities it provides and how to manage it. We also review some use cases that are relevant to this solution.

SessionID: 95570

What Is Clogging Your Database Performance?

Back to calendar

Event Date: 14-09-2019 - Session time: 16:00:00 - Track: Administration

Speaker: Eddy Djaja

Title: What Is Clogging Your Database Performance?

Abstract:

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

SessionID: 95698

How to audit and prevent unwanted user actions.

Back to calendar

Event Date: 14-09-2019 - Session time: 16:00:00 - Track: Development

Speaker: John Miner

Title: How to audit and prevent unwanted user actions.

Abstract:

Abstract:

Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes.

Coverage:

1 – Granting correct user access is vital. 2 – DML triggers to keep a DATA audit trail. 3 – DDL triggers to keep a SCHEMA audit trail. 4 – Preventing unwanted DATA modifications. 5 – Preventing unwanted SCHEMA changes. 6 – Preventing table TRUNCATIONS. 7 – LOGIN triggers to control who, what, and when. 8 – Change data capture (CDC) an alternative to triggers. 9 - Which of these techniques apply to an Azure SQL database?

SessionID: 96721

Data Pipeline Best Practices for an Increasingly Cloudy World

Back to calendar

Event Date: 14-09-2019 - Session time: 16:00:00 - Track: Development

Speaker: Adam Machanic

Title: Data Pipeline Best Practices for an Increasingly Cloudy World

Abstract:

The cloud continues to become ever more prevalent in corporations around the world, disrupting traditional IT and forcing either adoption or early retirement. All too often, companies attempt a simple "lift and shift" approach that doesn't really net anything more than the Same Old App, now just running on someone else's server (and probably more slowly than it did in its old on-prem home). But the cloud does in fact have a large number of advantages for those of us doing complex data processing. To truly take advantage of its silver lining, you must go beyond lift-and-shift and fully embrace nativity. This session focuses on core concepts, combined with a heavy dose of real-world lessons gleaned while working to build cloud-based data platforms from the ground up. You'll learn why cloud storage and local storage can't be thought of as equivalent, why queues are the basis for pretty much everything in all of computing, and why you must start thinking about applications from the perspective of elasticity and eventual consistency rather than simple transactional functionality. You’ll leave this session with a fuller understanding of what it really takes to build a successful cloud application.