sqlsathistory

Nr: 881

Back to Main list

SQLSaturday #881 - Chattanooga 2019

Start Time (24h) Speaker Track Title
08:30:00 Paul Southerland Professional Development A SQL table, CSV file, and an Excel spreadsheet walk into a bar chart...figuratively speaking.
08:30:00 Kevin Wilkie Application Database Development The function of Windowing Functions
08:30:00 Julie Smith Analytics and Visualization Leveraging Python in SQL Server
08:30:00 Kerry Tyler Application Database Development Managing Your Schema with Database Projects in Visual Studio
09:45:00 Vladimir Oselsky Application Database Development Performance Tuning for SQL Developer through Execution Plans
09:45:00 David Maxwell Application Database Development SQL Server Indexing - Practical Solutions
09:45:00 Daniel Glenn BI Platform Architecture, Development Administration Using Your On-prem Data in a Cloud World
09:45:00 Louis Davidson Application Database Development Relational Design Critique
09:45:00 Peter Doyle Professional Development How to become a SQLSaturday Presenter, Step-by-Step
11:00:00 Spencer Swindell BI Platform Architecture, Development Administration Applying Data Warehousing Principles
11:00:00 Simon Kingaby Application Database Development Moving Data to the Cloud (with Azure Data Factory)
11:00:00 Julie Smith Application Database Development Introduction to Azure Search
11:00:00 Dustin Dorsey Database Administration Using wait stats to determine why my server is slow
13:15:00 Bill Anton BI Platform Architecture, Development Administration What You Need To Know About Processing Tabular Models
13:15:00 Aaron Bertrand Application Database Development T-SQL : Bad Habits and Best Practices
13:15:00 Edwin M Sarmiento Database Administration What SQL Server DBAs Need To Know About Distributed Availability Groups
13:15:00 Tamera Clark Database Administration How do you Azure?
14:30:00 Samir Behara Application Database Development Introduction to Serverless Architecture
14:30:00 Brian Hansen Application Database Development Remember Back When? Temporal Tables in SQL Server 2016 and 2017
14:30:00 Dan Evans BI Platform Architecture, Development Administration The Modern Power BI approach
15:45:00 Ben Miller Database Administration Tips and Tricks for the PowerShell DBA
15:45:00 Peter Doyle Analytics and Visualization Become a T-SQL Pivoting Ninja in 60 Minutes Or Less
15:45:00 David Hiltenbrand Database Administration Adaptive Query Processing in SQL Server 2017
15:45:00 John Deardurff Application Database Development A Beginners Guide to Transactions

SessionID: 91029

A SQL table, CSV file, and an Excel spreadsheet walk into a bar chart...figuratively speaking.

Back to calendar

Event Date: 22-06-2019 - Session time: 08:30:00 - Track: Professional Development

Speaker: Paul Southerland

Title: A SQL table, CSV file, and an Excel spreadsheet walk into a bar chart...figuratively speaking.

Abstract:

"Get Data"; "Power Query"; "M Functional Language". No matter what you call it, Power Query is a game changer for business analysts who may require access to a variety of data sources for data analysis and reporting. Business users of Excel that have long used VLOOKUP and Pivot Tables to analyze data now have a frontend tool that can do much of the dirty work to ease the pain of connecting to different data sources and of transforming data prior to performing data analysis.

SessionID: 91145

The function of Windowing Functions

Back to calendar

Event Date: 22-06-2019 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Kevin Wilkie

Title: The function of Windowing Functions

Abstract:

What is a windowing function?

What do I do with them? Are they actually useful?

By the end of the class, you'll be asking yourself -

Why haven't I used these before? How can I use them more often?

Learn more about the class of functions that are known as "windowing functions" and why you should get to know them more!

SessionID: 91581

Leveraging Python in SQL Server

Back to calendar

Event Date: 22-06-2019 - Session time: 08:30:00 - Track: Analytics and Visualization

Speaker: Julie Smith

Title: Leveraging Python in SQL Server

Abstract:

SessionID: 93588

Managing Your Schema with Database Projects in Visual Studio

Back to calendar

Event Date: 22-06-2019 - Session time: 08:30: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: 91048

Performance Tuning for SQL Developer through Execution Plans

Back to calendar

Event Date: 22-06-2019 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Vladimir Oselsky

Title: Performance Tuning for SQL Developer through Execution Plans

Abstract:

Performance Tuning for SQL Developer session aims to provide essential building blocks to get starting with this challenging subject. When it comes to performance tuning the execution plan needs to be the first stop for every developer however many developers don’t know how to read and extract relevant information. When looking at execution plans in SSMS, there are many different ways of getting relevant information however it is not always simple to understand. The goal of this presentation is to provide tools and high-level overview of pertinent information to enable each developer to start optimizing their code.

SessionID: 91751

SQL Server Indexing - Practical Solutions

Back to calendar

Event Date: 22-06-2019 - Session time: 09:45:00 - Track: Application Database Development

Speaker: David Maxwell

Title: SQL Server Indexing - Practical Solutions

Abstract:

Have you ever created an index on your database to improve performance, and nothing changed? Have you created indexes suggested by the Missing Index DMV or Database Tuning Advisor, and query performance actually got worse? Are you constantly rebuilding your indexes or updating statistics, just for minor, temporary gains in performance? If so, then this session is for you.

In this session, we’ll discuss how SQL Server selects and uses indexes to improve query performance. We’ll look at how SQL Server chooses a Scan vs. a Seek, why the Missing Index DMVs don’t always give good advice, and how to tell when your databases are over-indexed. We’ll review DMVs and stored procedures that will quickly show how your indexes are being used, and where they can be improved. After this session, you’ll have the knowledge and tools to properly optimize your indexing strategy and create significant performance gains for your important queries.

SessionID: 93451

Using Your On-prem Data in a Cloud World

Back to calendar

Event Date: 22-06-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Daniel Glenn

Title: Using Your On-prem Data in a Cloud World

Abstract:

Microsoft Power BI, Flow, and PowerApps are powerful cloud tools that can take your on-premises data to new heights. Using your data where it is now gives you the ability to invest in improving processes, instead of focusing on a data migration strategy.

In this session, we will discover the benefits of using the cloud tools, how those benefits translate to being on-prem, and how we can use the data in Office 365 as well. We will setup a data gateway, connect to on-prem data sources, and use that data in Office 365 and SharePoint Server 2019.

SessionID: 95440

Relational Design Critique

Back to calendar

Event Date: 22-06-2019 - Session time: 09: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: 95529

How to become a SQLSaturday Presenter, Step-by-Step

Back to calendar

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

Speaker: Peter Doyle

Title: How to become a SQLSaturday Presenter, Step-by-Step

Abstract:

In this hands-on interactive presentation, you will learn how to plan and execute the strategies and tactics to become a SQL Saturday presenter sooner than you think.

SessionID: 91049

Applying Data Warehousing Principles

Back to calendar

Event Date: 22-06-2019 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Spencer Swindell

Title: Applying Data Warehousing Principles

Abstract:

Many data analysts typically begin to work with data as a single flat table. While this works for small datasets, as the size of the data grows these naive methods do not scale. Processing records takes longer, queries become more complex, and introducing new datasets is inconsistent at best. In order to solve these problems, we must take into account the underlying architecture of our data and how it should be modeled. During this talk we will discuss key concepts, patterns, and techniques for designing a data model that is simple to query, scales with your data, and is extendable to new datasets.

SessionID: 91053

Moving Data to the Cloud (with Azure Data Factory)

Back to calendar

Event Date: 22-06-2019 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Simon Kingaby

Title: Moving Data to the Cloud (with Azure Data Factory)

Abstract:

You need to move data. A lot of data. To the cloud. You’ve got data in a variety of on- and off-site data sources. There are several ways to do it. Some of them can be quite easily implemented using Azure Data Factory. Learn how to use variables and looping in your Data Factory pipelines. Use the Integration Runtime to pull directly from on-site sources. See how to upload files to blob storage and import them. Learn how to trigger Data Factory activities. And, learn how to keep all those connection strings and passwords secret in Azure Vault. After this session, you will have tools that you can readily implement in your own data migrations.

SessionID: 91579

Introduction to Azure Search

Back to calendar

Event Date: 22-06-2019 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Julie Smith

Abstract:

Search engines are NOSQL database management systems dedicated to the search for data content. Other industry examples include Elasticsearch, Splunk, and Solr.

In this session I will introduce the features and use cases for Azure Search, based on an implementation by Innovative Architects. Learn how IA leveraged Azure Search to quickly and easily implement a sophisticated search experience in a web application using our client's product catalog. Topics covered: Creating an Azure Search, Indexes, documents, natural language ability, scoring profiles, facets, and lucene queries.

SessionID: 93313

Using wait stats to determine why my server is slow

Back to calendar

Event Date: 22-06-2019 - Session time: 11:00:00 - Track: Database Administration

Speaker: Dustin Dorsey

Title: Using wait stats to determine why my server is slow

Abstract:

Server wait stats are a powerful tool that SQL Server gives us that provides insight into why our servers may be running slow. In this session, I will show you what role server resources (CPU, Memory, Network and Disks) play in the big picture of query processing and show you how you can use server wait stats to identify bottlenecks with these. We will also review common server waits that can occur at each crossroads of a query, reasons you may be having them and what you can do to solve the problem. The goal for this session is that you walk away with a better understanding of what wait stats are and how you can put them to use immediately.

SessionID: 91350

What You Need To Know About Processing Tabular Models

Back to calendar

Event Date: 22-06-2019 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Bill Anton

Title: What You Need To Know About Processing Tabular Models

Abstract:

Ever wondered what's happening under the covers when processing a tabular model? Why is it such a resource intensive process? How can I make it run faster? Am I running into a resource bottleneck?

Processing a tabular model can be a very resource-intensive workload and depending on your specific goals (e.g. speed, availability, etc) it may not always be feasible to process the entire model.

In this session, you'll learn what actually happens and in what order during model processing, the difference between the various processing types, performance considerations and most common resource bottlenecks. We'll also cover the most common processing patterns and the associated trade-offs.

Keywords: Analysis Services, SSAS, Power BI

SessionID: 93410

T-SQL : Bad Habits and Best Practices

Back to calendar

Event Date: 22-06-2019 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Aaron Bertrand

Title: T-SQL : Bad Habits and Best Practices

Abstract:

Whether you are a developer, DBA, or anything in between, chances are you might skip some best practices when you write T-SQL. Unfortunately, many so-called “bad habits” aren’t always obvious, but can lead to poor performance, maintainability issues, and compatibility problems.

In this session, you will learn about several bad habits, how they develop, and how you can avoid them. While we will briefly discuss advice you’ve probably heard before, like avoid SELECT * and be careful with NOLOCK, you will also learn some subtleties in SQL Server that might surprise you, how some shorthand can bite you in the long run, and a very easy way to improve cursor performance.

By changing your techniques and ditching some of these bad habits for best practices, you will take new techniques back to your environment that will lead to more efficient code, a more productive workflow, or both.

SessionID: 93413

What SQL Server DBAs Need To Know About Distributed Availability Groups

Back to calendar

Event Date: 22-06-2019 - Session time: 13:15:00 - Track: Database Administration

Speaker: Edwin M Sarmiento

Title: What SQL Server DBAs Need To Know About Distributed Availability Groups

Abstract:

With the introduction of Distributed Availability Groups in SQL Server 2016, it is becoming even more confusing to decide on the appropriate high availability and disaster recovery architecture to implement. In this session, we will cover how Distributed Availability Groups work, how you need to think about them in a possible deployment scenario and how you can combine them with the other high availability and disaster recovery features to meet your database recovery objectives and service level agreements.

SessionID: 93441

How do you Azure?

Back to calendar

Event Date: 22-06-2019 - Session time: 13:15:00 - Track: Database Administration

Speaker: Tamera Clark

Title: How do you Azure?

Abstract:

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

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

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

SessionID: 91546

Introduction to Serverless Architecture

Back to calendar

Event Date: 22-06-2019 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Samir Behara

Title: Introduction to Serverless Architecture

Abstract:

Serverless Architecture is a huge paradigm shift and allows you to build and run applications without the need for provisioning or managing servers. Organizations are rapidly moving towards public cloud providers and adapting serverless to reduce their operational costs and have the ability to scale their workload with high availability.

If you are a software developer, IT Pro or an Architect, come join me in this session to learn more about the serverless concepts, understand the use cases of serverless architectures, look at few of the real world implementations which I have worked on and evaluate its effectiveness within your organization.

SessionID: 93335

Remember Back When? Temporal Tables in SQL Server 2016 and 2017

Back to calendar

Event Date: 22-06-2019 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Brian Hansen

Title: Remember Back When? Temporal Tables in SQL Server 2016 and 2017

Abstract:

SQL Server 2016 and 2017 come with their own version of a Wayback Machine: temporal tables. With this new feature, it is easy to store and query the history of changes to data. We will discuss the fundamentals and creating, storing data in, querying from, and maintaining these tables. We will also take a quick look under the hood to see how they work. And yes, this is a version 1 (and 2) product, so we'll also consider the current limitations that are in place. Find out how temporal tables can benefit your system!

SessionID: 95065

The Modern Power BI approach

Back to calendar

Event Date: 22-06-2019 - Session time: 14:30: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: 93373

Tips and Tricks for the PowerShell DBA

Back to calendar

Event Date: 22-06-2019 - Session time: 15:45:00 - Track: Database Administration

Speaker: Ben Miller

Title: Tips and Tricks for the PowerShell DBA

Abstract:

Do you have more than 1 server that you manage? More than 1 database? Then this session is for you. PowerShell interest is on the rise and it is one of the coolest tools you can learn as a DBA. Learn tips and tricks using PowerShell that will help you manage SQL Servers and get more done with less effort. From getting started in PowerShell to getting information about your servers/databases to making changes to your SQL Servers all using PowerShell. This is one tool you will want in your toolbelt to help sharpen your skills.

SessionID: 93425

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

Back to calendar

Event Date: 22-06-2019 - Session time: 15:45:00 - Track: Analytics and Visualization

Speaker: Peter Doyle

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

Abstract:

Stop wasting time using Excel Pivot Tables when you can create them with 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 with ease. In this demo-heavy presentation, you will learn how to build 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: 93426

Adaptive Query Processing in SQL Server 2017

Back to calendar

Event Date: 22-06-2019 - Session time: 15:45:00 - Track: Database Administration

Speaker: David Hiltenbrand

Title: Adaptive Query Processing in SQL Server 2017

Abstract:

The Adaptive Query Processing feature family was introduced in SQL Server 2017. With little to no changes, execution plans can take advantage of batch mode adaptive joins, batch mode memory grant feedback, and interleaved execution for multi-statement table valued functions. We will walk through demos of how the 3 features are implemented during query optimization. Attendees will leave with an understanding of how these features can help their own workloads and how to enable or disable them as needed.

SessionID: 93566

A Beginners Guide to Transactions

Back to calendar

Event Date: 22-06-2019 - Session time: 15:45: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.