sqlsathistory

Nr: 870

Back to Main list

SQLSaturday #870 - Memphis 2019

Start Time (24h)	Speaker	Track	Title
08:45:00	Kevin Wilkie	Cloud Application Development Deployment	Azure Data Factory V2
08:45:00	Brian Hansen	Enterprise Database Administration Deployment	Get Your Optimizer to Give up All Its Secrets
08:45:00	Kerry Tyler	Application Database Development	Managing Your Schema with Database Projects in Visual Studio
10:00:00	Paul Stanton	Application Database Development	SQL DevOps Simplified with Production Databases
10:00:00	Dustin Dorsey	Application Database Development	Exploring the latest T-SQL enhancements
10:00:00	Dan Evans	BI Platform Architecture, Development Administration	The Modern Power BI approach
11:15:00	Spencer Swindell	BI Platform Architecture, Development Administration	Goin' Fishin' on the Azure Data Lake
11:15:00	Tamera Clark	Professional Development	The Community Speaks: WIT, LGBTQ, diversity and inclusion.
11:15:00	Lena Winfree	Strategy and Architecture	D.R.E.A.M. (Data Rules Everything Around Me) - Creating a data-driven business culture
13:30:00	Pete Brown	Application Database Development	Intro to Graph Databases
13:30:00	Hilary Wilkie	Professional Development	User Experience Brilliance in Power BI Dashboards
13:30:00	Elizabeth Noble	Strategy and Architecture	Get your Git on with Source Control
13:30:00	Rob Volk	Application Database Development	That's So Metadata: Discover Your Database From The Inside
14:45:00	Peter Doyle	Analytics and Visualization	Become a T-SQL Pivoting Ninja in 59.5 Minutes Or Less
14:45:00	Steve Jones	Application Database Development	The Future of Database Development with Containers
14:45:00	Louis Davidson	Application Database Development	Relational Design Critique
14:45:00	John Deardurff	Application Database Development	Inside the Database Engine

SessionID: 91028

Azure Data Factory V2

Back to calendar

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

Speaker: Kevin Wilkie

Title: Azure Data Factory V2

Abstract:

Moving data around in On-Prem databases is easy.

Moving data around when involving Azure - may be not. Especially if you don't have a VM or an On-Prem server to move things around on.

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

SessionID: 95659

Get Your Optimizer to Give up All Its Secrets

Back to calendar

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

Speaker: Brian Hansen

Title: Get Your Optimizer to Give up All Its Secrets

Abstract:

You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated? In this session, we will examine details the query optimization process that are not very well known. We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient. Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos? We'll do just that, and then take it a step further with a unique visualization tool that I have created. With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn't do it as well as might be hoped), you can write more efficient SQL statements.

SessionID: 98172

Managing Your Schema with Database Projects in Visual Studio

Back to calendar

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

Speaker: Kerry Tyler

Title: Managing Your Schema with Database Projects in Visual Studio

Abstract:

Integrating databases schema changes into a Software Development Lifecycle Management (SDLC) process can be a daunting and often tedious proposition. Adding the complexity of version control to the mix complicates this scenario. Fortunately, Database Projects in Visual Studio add a bit of an "easy" button to this process. In this session, you will learn about the features and capabilities of VS Database Projects and how to use them to improve the lifecycle of your database structures, even if your organization does no code management.

SessionID: 91920

SQL DevOps Simplified with Production Databases

Back to calendar

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

Speaker: Paul Stanton

Title: SQL DevOps Simplified with Production Databases

Abstract:

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

SessionID: 94697

Exploring the latest T-SQL enhancements

Back to calendar

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

Speaker: Dustin Dorsey

Title: Exploring the latest T-SQL enhancements

Abstract:

With the most recent release of SQL Server 2017 and the upcoming release of SQL Server 2019, there are several enhancements that were introduced for the T-SQL language. This includes new string functions, bulk access options and approximate query processing among others that address several challenges that SQL developers have to confront.

In this demo heavy session, we will go over several of the new features, provide a demonstration of how you can use them, and share any considerations that you may need to consider before doing so. This session is intended for anyone interested in what’s new in the T-SQL language and will focus primarily just on enhancements to traditional T-SQL for the database engine.

SessionID: 95648

The Modern Power BI approach

Back to calendar

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

Speaker: Dan Evans

Title: The Modern Power BI approach

Abstract:

Power BI continues to become one of the best ways to report and analyze business data. With recent announcements in Power BI roadmap around Dataflows, Composite models, AI integration, Common Data Service and Power Suite integration there are many more ways to add value to your existing Power BI environment. Come learn about all the key new features in Power BI you should be using and what new features are coming down the roadmap so you can increase value and usage of Power BI across the organization.

SessionID: 91009

Goin' Fishin' on the Azure Data Lake

Back to calendar

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

Speaker: Spencer Swindell

Title: Goin' Fishin' on the Azure Data Lake

Abstract:

Get yer queries ready we're goin' fishin' on the Azure Data Lake. Azure Data Lake is hyper-scale storage service that serves as the foundation for a Modern Data Warehouse. We'll explore what makes this service unique, the pricing structure, and how to start storing data. Then we'll open our tackle boxes to learn how to use tools such as HDInsight, Azure SQL DW, and Data Lake Analytics (U-SQL) to access data for processing, analytics, and machine learning.

SessionID: 96921

The Community Speaks: WIT, LGBTQ, diversity and inclusion.

Back to calendar

Event Date: 05-10-2019 - Session time: 11:15:00 - Track: Professional Development

Speaker: Tamera Clark

Title: The Community Speaks: WIT, LGBTQ, diversity and inclusion.

Abstract:

Join us as we (yes, including attendees) discuss incidents and look for ways as victims, as by-standers and as event host to react. Let’s enable each other to do what is right, speak up and support one another. It’s time for the community to come together, make their voice be heard and share ways and tools to deal with these difficult situations. Although some stores are inspired in part by a true incident, they are fictional and do not depict any actual person or event.

SessionID: 97955

D.R.E.A.M. (Data Rules Everything Around Me) - Creating a data-driven business culture

Back to calendar

Event Date: 05-10-2019 - Session time: 11:15:00 - Track: Strategy and Architecture

Speaker: Lena Winfree

Title: D.R.E.A.M. (Data Rules Everything Around Me) - Creating a data-driven business culture

Abstract:

Deploying a new Big Data initiative is a daunting undertaking in it's own right, which can lead many business leaders to forget a crucial piece of the puzzle - changing company culture. What good is new technology if it does not align with the way the organization actually makes decisions? This session dives into strategies to obtain stakeholder buy-in and get organization members not just tolerant of, but EXCITED about new technology initiatives.

SessionID: 91496

Intro to Graph Databases

Back to calendar

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

Speaker: Pete Brown

Title: Intro to Graph Databases

Abstract:

Recent years have seen an uptick in the adoption of alternative data storage methods. While the traditional RDBMS is still the de-facto Swiss Army knife for backing applications, technologies such as NoSQL and time series databases are increasingly used due to their performance and usability characteristics in certain use cases.

One of the latest entrants on the scene is the graph database. In this session we’ll discuss what they are and how they are used. The introduction of graph database support in MSSQL 2017 provides us with a convenient mechanism for presenting our existing data through a graph.

• What is a Graph Database? • Basic Graph Theory • Relational vs Graph data models • Graph Databases in MSSQL • Use cases

SessionID: 93792

User Experience Brilliance in Power BI Dashboards

Back to calendar

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

Speaker: Hilary Wilkie

Title: User Experience Brilliance in Power BI Dashboards

Abstract:

User Experience (UX) and Design Thinking are common buzz words around the office. What do these words have to do with BI and Dashboards, anyway?

Sure, Power BI itself is intuitive and user friendly, but are YOU building dashboards that give the best user experience? In this session we will explore in a hands-on exercise what UX and Design thinking is, how to apply the methodologies to our daily work and then how we could apply it to BI to make kick ass dashboards and reporting for our internal and external customers.

SessionID: 95093

Get your Git on with Source Control

Back to calendar

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

Speaker: Elizabeth Noble

Title: Get your Git on with Source Control

Abstract:

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

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

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

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

SessionID: 96814

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

Back to calendar

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

• Document your database schema objects such as procedures, functions, tables, columns and indexes
• Investigate performance and look for bottlenecks and tuning opportunities
• Discover metadata to administer your databases backups, index maintenance, and security
• Apply your own metadata using extended properties

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

SessionID: 93659

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

Back to calendar

Event Date: 05-10-2019 - Session time: 14:45:00 - Track: Analytics and Visualization

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

The Future of Database Development with Containers

Back to calendar

Event Date: 05-10-2019 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Steve Jones

Title: The Future of Database Development with Containers

Abstract:

Containers are dramatically changing the way that application developers design and build their systems. Databases will need to be a part of this revolution as every application needs a data store. Come see a future vision of how full stack application development might look in the next few years.

SessionID: 95887

Relational Design Critique

Back to calendar

Event Date: 05-10-2019 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Louis Davidson

Title: Relational Design Critique

Abstract:

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

SessionID: 96800

Inside the Database Engine

Back to calendar

Event Date: 05-10-2019 - Session time: 14:45:00 - Track: Application Database Development

Speaker: John Deardurff

Title: Inside the Database Engine

Abstract:

This session is for the absolute beginner to learn the basic components of the Database Engine (Relational Engine, Storage Engine, and SQLOS) and what is the purpose of each of these three components in the execution of a simple query. The relational engine to process a query, the storage engine to access data and the SQLOS to manage resource access. The session is led by an expert Microsoft Certified Trainer (MCT) and former Microsoft MVP who regularly teaches SQL Server certification courses.

This site is open source. Improve this page.