sqlsathistory

Nr: 820

Back to Main list

SQLSaturday #820 - Jacksonville 2019

Start Time (24h) Speaker Track Title
09:00:00 Louis Davidson Application Database Development Database Design Fundamentals
09:00:00 Michael Antonovich BI Information Delivery Creating Reports and Dashboards with Power BI
09:00:00 Mike Byrd Application Database Development A Primer on SQL Server Clustered Index Architecture
09:00:00 Eddy Djaja Enterprise Database Administration Deployment What Is Clogging Your Database Performance?
09:00:00 Jose Chinchilla Analytics and Visualization Azure IoT: An interactive demo
09:00:00 Devin Knight Information Delivery Data Storytelling with Power BI
09:00:00 Nicholas Lee Analytics and Visualization Making Your Queries Dynamic in the Power Query Editor for Power BI
09:00:00 Dmitri Korotkevitch Enterprise Database Administration Deployment Five Availability Group Issues That May Ruin Your Day
09:00:00 Mitchell Pearson BI Platform Architecture, Development Administration Introduction to DAX
09:00:00 John Welch Application Database Development Automating the Data-Centric Deployment Pipeline
09:00:00 Kellyn Pot'Vin-Gorman Enterprise Database Administration Deployment Be Part of the Solution with Automation
10:15:00 Matt Gordon Enterprise Database Administration Deployment Azure-d Availability: Scaling SQL Server to the Cloud
10:15:00 Kevin Feasel Analytics and Visualization R For the SQL Server Developer
10:15:00 Dave Bland Enterprise Database Administration Deployment Extended Events: What are they and How do I use them
10:15:00 Eric Blinn Enterprise Database Administration Deployment Encryption: Not just for the NSA anymore
10:15:00 Troy Gallant Enterprise Database Administration Deployment In-Place vs Side-by-Side SQL Upgrades; Clearing the Confusion
10:15:00 Dustin Ryan BI Platform Architecture, Development Administration Power BI Governance 101
10:15:00 Devin Knight Application Database Development Introduction to PowerApps
10:15:00 Samir Behara Application Database Development DevOps, Continuous Integration Automated Testing: Rule them all
10:15:00 Adriano da Silva Analytics and Visualization An Introduction to Power BI for Data Science With Python
10:15:00 Susan Schneider BI Information Delivery T-SQL Dynamic Duo: Window Functions and Common Table Expressions (CTE)
10:15:00 Jonathon Moorman Cloud Application Development Deployment Azure Data Storage Options
11:30:00 Kellyn Pot'Vin-Gorman Professional Development Women in Technology Panel: Skip the Corporate Ladder and Still Win in a Tech Career
11:30:00 Diane Schuster BI Platform Architecture, Development Administration CozyRoc: Dynamic Data Flows in SSIS Without Programming
12:45:00 Matt Gordon Enterprise Database Administration Deployment Top 5 Tips to Keep Always On AGs Humming and Users Happy
12:45:00 Carl Roepe Enterprise Database Administration Deployment How to perform a health check
12:45:00 Michael Antonovich BI Information Delivery Accessibility Concerns of Reporting Style with Power BI
12:45:00 Trey Johnson BI Platform Architecture, Development Administration Your BI Workloads and How They Change in the Cloud (Azure)
12:45:00 Shawn Meyers Professional Development How to make a SQL Saturday Presentation
12:45:00 Dale Sullenberger Enterprise Database Administration Deployment Temporal Tables - Managing Large Data Sets and Their Effects on Performance
12:45:00 Travis Page Enterprise Database Administration Deployment Look, over there, your permissions are showing!
12:45:00 Valentin Iamandi Enterprise Database Administration Deployment Performance Tuning Magic
12:45:00 Steve Schneider Advanced Analysis Techniques Machine Learning: Using R and SQL together
12:45:00 Maximo Trinidad Application Database Development PowerShell Core - Fundamental on How-To Persist Data in a SQL Server Container
12:45:00 Belinda Allen BI Platform Architecture, Development Administration DAX 101 and 102
14:15:00 Kevin Feasel Advanced Analysis Techniques Classification With Naive Bayes
14:15:00 Louis Davidson Strategy and Architecture Relational Design Critique
14:15:00 Eric Blinn Application Database Development I have Indexes, but do I have the Right Indexes?
14:15:00 Jose Chinchilla BI Platform Architecture, Development Administration Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.
14:15:00 Ahmad Drshen Enterprise Database Administration Deployment Yes! Making Performance Tuning Easier with Query Store
14:15:00 Vishal Pawar BI Platform Architecture, Development Administration Learn Power BI Report Server Enterprise Architecture, Tools to publish reports and Best Practice
14:15:00 Elizabeth Noble Enterprise Database Administration Deployment Migrate Your Database with Distributed AGs
14:15:00 Steven Wheeler Enterprise Database Administration Deployment The Force of Management Data Warehouse
14:15:00 John Welch Application Database Development Data DevOps: Top 5 Blockers to Success
14:15:00 John Blackburn BI Information Delivery How to load a fact table really, really fast
14:15:00 Brandi Kiehl Professional Development Using Analytics to Optimize your Resume for Applicant Tracking System
15:30:00 Trey Johnson BI Information Delivery An Analysis Services Primer
15:30:00 Mike Byrd Application Database Development Climbing the SQL Server Index B-Tree
15:30:00 Dave Bland Enterprise Database Administration Deployment Is my SQL Server having Memory Pressure?
15:30:00 Deji Akomolafe Strategy and Architecture Successfully Virtualizing SQL Server on vSphere - Straight from the Source
15:30:00 Victor Ivantsov Application Database Development Lead, Lag, CTEs and other tricks
15:30:00 Dale Sullenberger Application Database Development Temporal Tables: Creation, Use, and Optimizing
15:30:00 Kellyn Pot'Vin-Gorman Information Delivery GDPR - The Buck Stops Here
15:30:00 Manuel Quintana BI Platform Architecture, Development Administration SSIS: Loading Dimension Tables
15:30:00 Shawn Meyers Enterprise Database Administration Deployment Top 10 lessons learned from the Death Star you can employ to save your database from failure
15:30:00 Belinda Allen BI Platform Architecture, Development Administration Why would I care about PowerApps and Flow?
15:30:00 Joshua Corrick Enterprise Database Administration Deployment Using Dbatools To Automate Database Migrations

SessionID: 87229

Database Design Fundamentals

Back to calendar

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

Speaker: Louis Davidson

Title: Database Design Fundamentals

Abstract:

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

SessionID: 87265

Creating Reports and Dashboards with Power BI

Back to calendar

Event Date: 04-05-2019 - Session time: 09:00:00 - Track: BI Information Delivery

Speaker: Michael Antonovich

Title: Creating Reports and Dashboards with Power BI

Abstract:

This session looks at both Power BI Desktop and Power BI.com to compare the advantages and capabilities of both platforms for creating and distributing data analysis within your organization. It will also touch a little on why you might choose Power BI over Power Pivot and why you might not. It will also look at how to create drill down detail screens to expose the details behind your visualizations. Finally, we will touch on how to publish your Power BI results for others in your organization to share. A basic understanding of database structures and referential integrity is an advantage to gain the most from this session, but as will be shown, not always necessary depending on the source of the data to be analyzed.

SessionID: 87714

A Primer on SQL Server Clustered Index Architecture

Back to calendar

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

Speaker: Mike Byrd

Title: A Primer on SQL Server Clustered Index Architecture

Abstract:

How often when creating a new table you just made the Clustered Index using an Integer column with Identity properties. Seems like that is all I have done for last many years. But, in the last two years I’ve really dove into indexes and finally with this presentation looked at what really makes a good Clustered Index with benchmarks and varying scenarios. In some scenarios a well-defined clustered index may out perform a covering non-clustered index. Results are very interesting and may surprise you.

SessionID: 89068

What Is Clogging Your Database Performance?

Back to calendar

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

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

Azure IoT: An interactive demo

Back to calendar

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

Speaker: Jose Chinchilla

Title: Azure IoT: An interactive demo

Abstract:

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

SessionID: 89895

Data Storytelling with Power BI

Back to calendar

Event Date: 04-05-2019 - Session time: 09:00:00 - Track: Information Delivery

Speaker: Devin Knight

Title: Data Storytelling with Power BI

Abstract:

Power BI has many features that are appealing but clearly the storytelling capabilities are what set it apart from other BI tools. Features like bookmarks, tooltip report pages, and drillthrough filters are just a few examples of how you can make dull reports a real interactive experience.

SessionID: 90250

Making Your Queries Dynamic in the Power Query Editor for Power BI

Back to calendar

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

Speaker: Nicholas Lee

Title: Making Your Queries Dynamic in the Power Query Editor for Power BI

Abstract:

Often times in data analytics, we have datasets that are changing. In order to fully leverage this changing of data, we need to make our queries that we are reporting on dynamic.

This session, we will be utilizing the inherit "M" programming language that inside of the Power Query Editor as well as using Parameters to make our queries dynamically work with our datasets!

SessionID: 90581

Five Availability Group Issues That May Ruin Your Day

Back to calendar

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

Speaker: Dmitri Korotkevitch

Title: Five Availability Group Issues That May Ruin Your Day

Abstract:

AlwaysOn Availability Groups have become the most common High Availability technology used with SQL Server. It provides protection at the database group level, and it stores a separate copy of each database on each node, eliminating storage from being a single point of failure.

While Availability Groups help to achieve required High Availability, they may also introduce issues in the system. In this session, Dmitri will discuss several less known problems associated with them. You will learn how Availability Groups may impact transaction log truncation and contribute to the blocking in the system, how readable secondaries may increase CPU and I/O load on primaries among a few other things. Dmitri will also discuss how to properly setup monitoring for Availability Group infrastructure in your environment.

SessionID: 90598

Introduction to DAX

Back to calendar

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

Speaker: Mitchell Pearson

Title: Introduction to DAX

Abstract:

Data Analysis Expressions were specifically designed by Microsoft to be easy to learn and powerful, with just the basics of DAX you can significantly improve the analytical value of your data model. In this introductory to DAX session, you will learn the basics of using the DAX language to create calculated columns and calculated measures. In addition to the basics, this session will introduce you to creating aggregates, conditional functions, and time intelligence calculations.

SessionID: 90708

Automating the Data-Centric Deployment Pipeline

Back to calendar

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

Speaker: John Welch

Title: Automating the Data-Centric Deployment Pipeline

Abstract:

Continuous integration, delivery, and deployment are common elements of modern DevOps practices. However, it’s rare to see these practices put into place for data-centric applications, like databases, ETL, data warehouses, or reports. In this session, we’ll cover why these approaches are beneficial for the data organization and the pieces you need to have in place to be successful. We’ll also cover some of the prime trouble spots that organizations run into, as well as some tools that can help jump start your efforts.

SessionID: 90867

Be Part of the Solution with Automation

Back to calendar

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

Speaker: Kellyn Pot'Vin-Gorman

Title: Be Part of the Solution with Automation

Abstract:

DevOps automation can be intriguing to learn and overwhelming to implement. This session will take a real life use case of a multi-tier and complex environments, with various stake holders to a successful conclusion. Unlike a session on concepts, this session surrounds itself with a real-life situation and how automation was used with DevOps practices to build a solution.

The session will demonstrate the reasons to automate, along with the steps required to make it possible, offering insight into concepts that are often too vague to employ. The attendee will see multi-platform and cloud tool demonstrations on how to take the DevOps methodology and continuous delivery to actuality in their own projects, no matter if small or large.

SessionID: 86640

Azure-d Availability: Scaling SQL Server to the Cloud

Back to calendar

Event Date: 04-05-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Gordon

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

Abstract:

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

SessionID: 86767

R For the SQL Server Developer

Back to calendar

Event Date: 04-05-2019 - Session time: 10:15:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: R For the SQL Server Developer

Abstract:

R is the premiere language for data analysis. If the world of data science sounds fun and exciting, now is the time to get into R. We will walk through the core constructs of R, learn how to retrieve data from flat files and databases, and get a peek at the power behind R. This session will also give resources on where to go in order to become more familiar with statistics, R the language, and the R package ecosystem.

SessionID: 86810

Extended Events: What are they and How do I use them

Back to calendar

Event Date: 04-05-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Bland

Title: Extended Events: What are they and How do I use them

Abstract:

Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session. This session will give someone who has never used Extended events before the skills to start using them!

SessionID: 87292

Encryption: Not just for the NSA anymore

Back to calendar

Event Date: 04-05-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Blinn

Title: Encryption: Not just for the NSA anymore

Abstract:

Are you interested in data encryption? Do you store sensitive data in SQL Server databases? Does GDPR affect your company? If you answered yes to any of these questions then this session is for you. In this session we will introduce and implement 4 methods of encryption available in SQL Server --Backup encryption, Transparent Data Encryption, AlwaysEncrypted, and connection encryption.

SessionID: 87572

In-Place vs Side-by-Side SQL Upgrades; Clearing the Confusion

Back to calendar

Event Date: 04-05-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Troy Gallant

Title: In-Place vs Side-by-Side SQL Upgrades; Clearing the Confusion

Abstract:

Most of us are aware that when it comes to upgrading our SQL Servers, we have a couple different options when it comes to the methodology. Do we perform an In-Place upgrade or a Side-by-Side? Both options come with a myriad of pros and cons, and there's usually a "best" solution for every environment. This session will attempt to examine exactly which scenarios lend themselves best to each technique, and we'll provide a logical way of thinking about this critical step and how to accomplish this with the least stress.

SessionID: 89721

Power BI Governance 101

Back to calendar

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

Speaker: Dustin Ryan

Title: Power BI Governance 101

Abstract:

Deploying an enterprise business intelligence solution is no small task but one of the most important factors to consider in order to have a successful roll-out of a self-service analytics tool like Power BI is governance. In this session, we'll discuss why governance is so important for a successful Power BI deployment, what are the components of Power BI that require governance, and how to govern your Power BI environment. By the end of this session, the audience should have a clearer understanding of governance in the context of Power BI.

SessionID: 89894

Introduction to PowerApps

Back to calendar

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

Speaker: Devin Knight

Title: Introduction to PowerApps

Abstract:

In this session, you’ll learn how to create your first application using PowerApps. PowerApps is part of the Power Platform from Microsoft and provides a business-friendly way of creating applications quickly that can integrate with the Microsoft Power BI and Flow platforms for visualizing and moving data.This technology is one of the hottest new offerings from Microsoft and included in your Office 365 subscription.

SessionID: 89943

DevOps, Continuous Integration Automated Testing: Rule them all

Back to calendar

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

Speaker: Samir Behara

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

Abstract:

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

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

SessionID: 90235

An Introduction to Power BI for Data Science With Python

Back to calendar

Event Date: 04-05-2019 - Session time: 10:15:00 - Track: Analytics and Visualization

Speaker: Adriano da Silva

Title: An Introduction to Power BI for Data Science With Python

Abstract:

This session provides an introduction to the use of Power BI for Data Science. It covers the use of Power BI as part of the Data Science process; including EDA (Exploratory Data Analysis), Data Visualization along with its integration with Python, Scikit-Learn and SQL Server Machine Learning Services.

This is an introductory session designed for those with basic Power BI skills; as well as, minimal or no Python and/or Data Science experience. This is an applied session focusing on the utilization of the tools, technologies and machine learning libraries; such as Pandas, Numpy, Scipy, etc. The demos are centered around Power BI and its integration with Python, ML engine and Data Science processes.

SessionID: 90618

T-SQL Dynamic Duo: Window Functions and Common Table Expressions (CTE)

Back to calendar

Event Date: 04-05-2019 - Session time: 10:15:00 - Track: BI Information Delivery

Speaker: Susan Schneider

Title: T-SQL Dynamic Duo: Window Functions and Common Table Expressions (CTE)

Abstract:

Life and movies have great dynamic duos: Hans Solo and Chewy, Bogey and Bacall, Batman and Robin, Red Wine and Dark Chocolate (my personal favorite) to name a few; now let me introduce you to another Dynamic Duo: Window Functions and CTEs. Don’t confuse Window functions with the Windows operating system; Window functions are ANSI standard T-SQL functions used in writing queries. Common Table Expressions (CTE) specifies a temporary named result set and are leveraged as a way to filter Window functions.

Window functions supercharge your code to show detail and aggregate level data in the same SELECT statement without grouping, easily creates running totals, computes percentages, de-dups data and more. We’ll see how using the Offset functions enables you to include different values without using a self-join. There’s much to see and learn in this demo packed session, I hope you’ll join me for another adventure!

SessionID: 93694

Azure Data Storage Options

Back to calendar

Event Date: 04-05-2019 - Session time: 10:15:00 - Track: Cloud Application Development Deployment

Speaker: Jonathon Moorman

Title: Azure Data Storage Options

Abstract:

In this session we will investigate the various data storage options that are presented for developers in the Microsoft Azure Cloud. We will look at the various storage options for both strongly and loosely bound schema. Topics will include blob and table storage, Azure Search, CosmosDb, Azure Sql Database, and Azure Data Lake Analytics. We will also cover data movement options and security before doing a deeper dive into Azure Sql Database.

SessionID: 91087

Women in Technology Panel: Skip the Corporate Ladder and Still Win in a Tech Career

Back to calendar

Event Date: 04-05-2019 - Session time: 11:30:00 - Track: Professional Development

Speaker: Kellyn Pot'Vin-Gorman

Title: Women in Technology Panel: Skip the Corporate Ladder and Still Win in a Tech Career

Abstract:

Many of us have attended career advancement or women in technology panels where they only tell you how to become part of the C-level, (CTO, CIO, CDO or even CEO). Although these sessions may focus on valuable skills, they often require the individual to move away from technical work to advance.

What does it say about the world of tech if the only way up is to give up the part of tech you love the most? This panel session is for the women, (and men) who want to know how to make the most of the career they have and get ahead in technology without having to give up the technology they love.
The panel will be led by Kellyn Pot’Vin-Gorman, who’s made a career from deeply technical positions and rose to the top of the Oracle world as a Multi-platform Database Administrator/Developer, recently becoming a part of Microsoft as a Data Platform Architect. She will be joined by a group of panelists in various stages of their career to share their experiences, insight and advice.

SessionID: 93176

CozyRoc: Dynamic Data Flows in SSIS Without Programming

Back to calendar

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

Speaker: Diane Schuster

Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming

Abstract:

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.

SessionID: 86642

Top 5 Tips to Keep Always On AGs Humming and Users Happy

Back to calendar

Event Date: 04-05-2019 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Gordon

Title: Top 5 Tips to Keep Always On AGs Humming and Users Happy

Abstract:

Have you ever wondered what it takes to keep an Always On availability group running and the users and administrators who depend on it happy? Let my experience maintaining several production Always On Availability Groups provide you some battle-tested information and hopefully save you some sleepless nights. From security tips to maintenance advice, come hear about some less than obvious tips that will keep users happy and the DBA’s phone quiet.

SessionID: 86908

How to perform a health check

Back to calendar

Event Date: 04-05-2019 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Carl Roepe

Title: How to perform a health check

Abstract:

Are you uncertain about the health and capacity of your SQL Server? Are you taking over a new server and need to get a better understanding of the health of the server? Are you uncertain if your servers are following industry best practices?

In this session we will start by discussing the importance of performing a Health Check. We will then show how to run the popular Blitz script by Brent Ozar. After that we will review the other key areas to check like the VM configuration, Windows Configuration, SQL Configuration, Security configuration, and Database configuration. Finally, we’ll show how to save the results for capacity and trending analysis

At the end of the session you will be able to: (1) Perform a Health Check on a server; (2) List the key areas for improvement; (3) Save the results for capacity and trending analysis.

SessionID: 87266

Accessibility Concerns of Reporting Style with Power BI

Back to calendar

Event Date: 04-05-2019 - Session time: 12:45:00 - Track: BI Information Delivery

Speaker: Michael Antonovich

Title: Accessibility Concerns of Reporting Style with Power BI

Abstract:

Reports are no longer just black and white columns and rows of numbers. Reports combine tables with charts, KPIs and more. There is a lot to be concerned about when designing reports to provide information to your audience. Today, your company can face lawsuits if your reports are not accessible to all users. You must consider the way you display your data, the amount of data displayed, the use of color and maybe even the use of animation. Creating attractive reports is not just about making them pretty. It is about grabbing your audience's attention. It is making sure you don't inadvertently introduce accessibility problems that limit who can receive your message, your data. This session while looking at some reporting best practices will also give you information to steer you clear of accessibility concerns to insure access to your results by all consumers of your report. (Note: Accessibility is governed through the guidelines of the American Disabilities Act)

SessionID: 87475

Your BI Workloads and How They Change in the Cloud (Azure)

Back to calendar

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

Speaker: Trey Johnson

Title: Your BI Workloads and How They Change in the Cloud (Azure)

Abstract:

Your organization has made a conscious choice that everything should move to the cloud! You own the current BI workloads for your business and you are not sure what that means?

If so, this session is for you where we explore in depth the workloads around ETL/ELT, Data Management, Analysis Services to support BI for your users. We’ll also talk data security, governance managing your data outside of your 4 walls.

With plenty of ground to cover and an expected level of participation from the audience, this will be a fast paced session with insights into how you can retain aspects of what you have while pursuing the greater opportunities delivering BI on the Cloud affords you.

Attendees will understand what workloads are similar as they move to the cloud Attendees will develop an appreciation for the benefits the cloud can offer to their BI deployment Attendees should have the confidence to map out their own plans for making the most of the workloads they’ll change when they move.

SessionID: 89899

How to make a SQL Saturday Presentation

Back to calendar

Event Date: 04-05-2019 - Session time: 12:45:00 - Track: Professional Development

Speaker: Shawn Meyers

Title: How to make a SQL Saturday Presentation

Abstract:

Nearly everyone one who attends a SQL Saturday has something to share, which others can learn from. This session covers how to take your knowledge and ideas and turn them into a presentation. Most of the focus will be on content generation and organization of your idea into a presentation and demonstrations, to allow you to present.

SessionID: 90299

Temporal Tables - Managing Large Data Sets and Their Effects on Performance

Back to calendar

Event Date: 04-05-2019 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Dale Sullenberger

Title: Temporal Tables - Managing Large Data Sets and Their Effects on Performance

Abstract:

So, you installed SQL 2016 (or newer) and implemented Temporal Tables for some of your data. Everything is running well, but now what? In this session we will look at the effects of adding various indexes to both the main and the history table and discuss what that might mean to the front end performance. We will go into data management scenarios, for when you do not want to keep all the data in that table forever.

SessionID: 90684

Look, over there, your permissions are showing!

Back to calendar

Event Date: 04-05-2019 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Travis Page

Title: Look, over there, your permissions are showing!

Abstract:

You just walked into that fancy new gig, and you're getting your first cup of coffee. Your boss walks up and asks, "Who has access to that prod server?", do you know how to get the answers in the next hour? More importantly, do you know what these permissions mean, what an attacker could do with these permissions? In this session we'll start from scratch assuming that you have no experience with an audit with this question in mind. We'll work back from here to develop a strategy of how to harden your server.

SessionID: 90719

Performance Tuning Magic

Back to calendar

Event Date: 04-05-2019 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Valentin Iamandi

Title: Performance Tuning Magic

Abstract:

When your server becomes unresponsive, the performance goes down the drain and the CPUs are at 100%. You asks yourself: I wish I knew what and how to do it.

-- How to configure your Sql Server for maximum performance -- Big databases issues and solutions -- Indexes or Statistics updates, what and where: Rebuild or Reorg -- Sql code tricks to increase code performance -- What to do when in maximum performance pain

SessionID: 90833

Machine Learning: Using R and SQL together

Back to calendar

Event Date: 04-05-2019 - Session time: 12:45:00 - Track: Advanced Analysis Techniques

Speaker: Steve Schneider

Title: Machine Learning: Using R and SQL together

Abstract:

Is “R” worth the time to learn? What tools will enable me to start? What can I do with “R” if I learn it? How much “R” do I have to know before I can use it? This session will begin to answer these questions. Almost exclusively demo, we will walk through the use of several visualization techniques to understand and shape data for the purpose of applying Machine Learning Models to make predictions. Focused on “Binary classification” we will use two predictive algorithms: rxFastLinear and a Gradient Boosting Machine to model Florida Traffic accidents. MS Visual Studio is the tool of choice utilizing Microsoft’s R client.

SessionID: 93565

PowerShell Core - Fundamental on How-To Persist Data in a SQL Server Container

Back to calendar

Event Date: 04-05-2019 - Session time: 12:45:00 - Track: Application Database Development

Speaker: Maximo Trinidad

Title: PowerShell Core - Fundamental on How-To Persist Data in a SQL Server Container

Abstract:

This session will give you the necesary knowledge on how to work with container(s) disk data. As a Database Developer and Admininstrator, it's important to protect that information stored on our Database Servers. I'll be showing how easy it is to start build a solution and how to make data persist in a container using Docker CLI only as a starting point.

SessionID: 93718

DAX 101 and 102

Back to calendar

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

Speaker: Belinda Allen

Title: DAX 101 and 102

Abstract:

In this breakout session, you'll learn the basics of the DAX language, Power BI’s modeling language. Belinda will introduce you to the concept of calculated columns, measures, and basic data modeling, with some practical examples. This introduction will cover basic calculations and an overview of scalar and table functions. This session has practical examples of business analytics and users. To the Developer, DAX feels like a programming language; to the user, DAX feels like Excel formulas.

  1. Define DAX and understand where it fits and why it is important
  2. Perform and Review some basic DAX commands
  3. Differentiate modeling with DAX versus the Power BI Query Editor
  4. Build a Date Table to allow for the use of Time Intelligence DAX calculations
  5. Overview of CALCULATE in DAX functions.

SessionID: 86764

Classification With Naive Bayes

Back to calendar

Event Date: 04-05-2019 - Session time: 14:15:00 - Track: Advanced Analysis Techniques

Speaker: Kevin Feasel

Title: Classification With Naive Bayes

Abstract:

The Naïve Bayes series of algorithms are some of the simplest classification algorithms, but they tend to offer reasonably good results very quickly for a number of problems, including Natural Language Processing problems such as spam classification, as well as more classical feature-driven classification. In this talk, we will look at the math behind Naïve Bayes classification, solving problems by hand before looking at a package in R which solves the problem for us. By the end of this talk, you should be able to apply Naïve Bayes to existing problems. No experience with statistics is required, although there will be a small amount of math.

SessionID: 87231

Relational Design Critique

Back to calendar

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

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

I have Indexes, but do I have the Right Indexes?

Back to calendar

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

Speaker: Eric Blinn

Title: I have Indexes, but do I have the Right Indexes?

Abstract:

SQL Server indexes come in multiple types: clustered, non-clustered, full text and column store. In this session, you’ll get an understanding of what these types are and when each is an appropriate solution. We will explain and demonstrate each type, and you’ll leave this class with a repeatable indexing methodology you can use to improve your database performance.

SessionID: 89294

Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.

Back to calendar

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

Speaker: Jose Chinchilla

Title: Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.

Abstract:

Thinking about migrating your data warehouse to the cloud? What about all those SSIS packages executing ETLs against your on-prem data sources? In this presentation we will discuss how to successfully "lift and shift" your ETL workloads to the Azure cloud. You will l learn how to configure and deploy an Integration Runtime, deploy and execute SSIS packages in an Azure Data Factory pipeline, and how to monitor and troubleshoot your ETL executions in the cloud. Attendees will walk-away with an understanding of the features, capabilities and limitations of Azure Data Factory and the Integration Runtime and a strategy to leverage your existing SSIS package development efforts to the cloud.

SessionID: 89346

Yes! Making Performance Tuning Easier with Query Store

Back to calendar

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

Speaker: Ahmad Drshen

Title: Yes! Making Performance Tuning Easier with Query Store

Abstract:

In our day-to-day struggles with performance issues we use built-in and third-party tools to discover and analyze what went wrong with a particular query or stored procedure and then we try to fix them. However, sometimes we wish that there would be a way to keep a good historical baseline for comparison. Microsoft introduced query store in SQL Server 2016 to help with these challenges and answers some of the obvious performance questions. In this session, we will demonstrate how to use query store to characterize your workload and more easily find and fix some of the problem you may have with your unruly queries and gigantic store procedures.

SessionID: 89613

Learn Power BI Report Server Enterprise Architecture, Tools to publish reports and Best Practice

Back to calendar

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

Speaker: Vishal Pawar

Title: Learn Power BI Report Server Enterprise Architecture, Tools to publish reports and Best Practice

Abstract:

To improve the performance, sustainability, security and scalability of enterprise-grade Power BI implementations with constant velocity, we need to adhere best practices

In this session Vishal will go over Power BI Ecosystem with Example, PBI RS evolution from its inception Architecture of Enterprise Power BI Report Server and usage through various tool available to publish -SSDT SSRS, Power BI Desktop(Optimized Version), Report Builder and mobile report builder and various Best Practices for PBI Report Server.

SessionID: 89940

Migrate Your Database with Distributed AGs

Back to calendar

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

Speaker: Elizabeth Noble

Title: Migrate Your Database with Distributed AGs

Abstract:

You find yourself needing to migrate to new hardware or new operating system. If you're running SQL Server 2016+, you're in luck! Distributed Availability Groups (AGs) may just be the solution you want.

In this session I will explain the purpose and usages of Distributed AGs, create a Distributed AG and the associated AGs, and perform a mock data center migration.

NOTE: This session expects that attendees are already familiar with Availability Groups.

SessionID: 90701

The Force of Management Data Warehouse

Back to calendar

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

Speaker: Steven Wheeler

Title: The Force of Management Data Warehouse

Abstract:

DBA’s, Did you know that SQL Server has a built-in way of collecting system and performance information on your SQL servers in one central location? Leave the Darkside and take this journey to see how the Management Data Warehouse (MDW) is created, Data Collectors are setup, and looking at the included reports to answer your questions like What are my most expensive queries (CPU, IO, or duration)? What is my SQL Server waiting on? Which are the fastest growing databases? Knowledge is power of the force where the MDW can help with proactive query tuning, historical query analysis, performance baselining, database growth forecasting, and storage planning.

SessionID: 90712

Data DevOps: Top 5 Blockers to Success

Back to calendar

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

Speaker: John Welch

Title: Data DevOps: Top 5 Blockers to Success

Abstract:

Implementing DevOps for data isn’t easy. The tools, technologies, and practices are still evolving, and organizations often struggle to make the transition to more agile ways of delivering data-centric solutions. During this session, we’ll discuss the top 5 issues that impact successfully moving to a Data DevOps approach, including challenges with people, processes, and technology. Since one size does not fit all, we will also cover multiple potential solutions to these blockers.

SessionID: 90937

How to load a fact table really, really fast

Back to calendar

Event Date: 04-05-2019 - Session time: 14:15:00 - Track: BI Information Delivery

Speaker: John Blackburn

Title: How to load a fact table really, really fast

Abstract:

We will discuss various techniques for loading many rows into tables in a data warehouse at once. We will explore the different statagies, and quanitify each one in terms of rows/minute.

SessionID: 90940

Using Analytics to Optimize your Resume for Applicant Tracking System

Back to calendar

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

Speaker: Brandi Kiehl

Title: Using Analytics to Optimize your Resume for Applicant Tracking System

Abstract:

Ever wonder why your resume ends up in a black hole when you submit it online? You know what your resume looks like, but do you ever wonder how a computer sees your resume? Let us show you how to use analytics to make your resume stand out not only to HR, but also to the computer. Guaranteed to be a light bulb moment for your career search efforts! Beneficial for all levels including those transitioning fields, trying to enter the industry or trying to make a career move.

SessionID: 87472

An Analysis Services Primer

Back to calendar

Event Date: 04-05-2019 - Session time: 15:30:00 - Track: BI Information Delivery

Speaker: Trey Johnson

Title: An Analysis Services Primer

Abstract:

So you have heard about Cubes and (analysis) Models but maybe have never gotten fully “into” them? Or maybe, you have built Cubes and Models but just feel the results did not match with your expectations?

Analysis Services is a broadening platform with offerings On-Premises, in the Cloud, On Azure and everywhere in between.

With more than 20 years experience on Analysis Services, the speaker will help you make the most of your NEXT efforts at Analysis Services by delivering an example heavy session leaving no doubt about the types of solutions you can achieve with Analysis Services!

Learning Objective 1: Attendees will learn the fundamentals of WHY they should leverage Analysis Services

Learning Objective 2: Attendees will be provided guidance on how to start simply with Cubes/Models that can be grown as needs develop

Learning Objective 3: Attendees should expect to be able to identify more easily the most relevant data for a Cube/Model

SessionID: 87715

Climbing the SQL Server Index B-Tree

Back to calendar

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

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

Is my SQL Server having Memory Pressure?

Back to calendar

Event Date: 04-05-2019 - Session time: 15:30: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: 89244

Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Back to calendar

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

Speaker: Deji Akomolafe

Title: Successfully 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. quot;Virtualize Firstquot; 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 quot;criticalquot; 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 i

SessionID: 89375

Lead, Lag, CTEs and other tricks

Back to calendar

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

Speaker: Victor Ivantsov

Title: Lead, Lag, CTEs and other tricks

Abstract:

Simplify your complex queries with cross apply, lead/lag and other great new stuff. No more dynamic SQL!

SessionID: 90298

Temporal Tables: Creation, Use, and Optimizing

Back to calendar

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

Speaker: Dale Sullenberger

Title: Temporal Tables: Creation, Use, and Optimizing

Abstract:

With SQL 2016, Microsoft introduced Temporal tables. In this session we will learn what a Temporal table is, and discuss uses in current environments. We will learn how to create the tables, query the data from the tables for different scenarios, and optimize them for query performance allowing simplicity for the consumers of the data.

SessionID: 90881

GDPR - The Buck Stops Here

Back to calendar

Event Date: 04-05-2019 - Session time: 15:30:00 - Track: Information Delivery

Speaker: Kellyn Pot'Vin-Gorman

Title: GDPR - The Buck Stops Here

Abstract:

The General Data Protection Regulations went into effect in the EU in 2014, giving the rest of the world till May 2018 to become compliant. Comprehending the intricate facets of this complex law of EU personal data, what it covers and the demands to change how many of us have managed our data is the center of this talk. Encryption and masking is only a very small part of the DBA and developer's role in being compliant and saving the business from huge fines that could make or break a company.

SessionID: 91051

SSIS: Loading Dimension Tables

Back to calendar

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

Speaker: Manuel Quintana

Title: SSIS: Loading Dimension Tables

Abstract:

In this session we will look at what options are available to developers within SSIS to load and maintain our Dimension tables within the Data Warehouse. As well we will explore alternate design patterns that could improve performance

SessionID: 93539

Top 10 lessons learned from the Death Star you can employ to save your database from failure

Back to calendar

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

Speaker: Shawn Meyers

Title: Top 10 lessons learned from the Death Star you can employ to save your database from failure

Abstract:

You built an awesome database but all of a sudden it explodes in a ball of fire like the Death Star. In this session, we will use lessons learned from the dark side to ensure you database does not suffer the same fate. Performance is not the only criteria for a successful database, we will look at many of the rest. This session will have many Star Wars based themes and will be a place to geek about it.

SessionID: 93712

Why would I care about PowerApps and Flow?

Back to calendar

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

Speaker: Belinda Allen

Title: Why would I care about PowerApps and Flow?

Abstract:

Why is PowerApps a big deal? What are some good practical uses for it? Is it really easy to use? Is it a tool I would want to use?

What about Flow? What are some good practical uses for it? Should I care about it? Attend this session and see Belinda use PowerApps and Flow with Microsoft Office and Power BI. Here is your opportunity to see some very real and very practical uses of these two amazing products. This session will leave you excited by how the opportunities, that these two products can provide, will improve your business life.

  1. See some PowerApps in action using Microsoft Office that might blow your mind.
  2. See some PowerApps and Flow in use with Power BI that changes the Power BI game.
  3. See Flow used in interesting ways.

SessionID: 93788

Using Dbatools To Automate Database Migrations

Back to calendar

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

Speaker: Joshua Corrick

Title: Using Dbatools To Automate Database Migrations

Abstract:

Migrations can be time consuming and painful. They must be completed with zero down time, and you need to remember databases, logins, agent jobs, linked servers, oh and those random credentials that no one has the password for anymore. If you have faced this situation or are facing migrating from 2008 to 2017 Instances this process can be made easier by using the PowerShell module Dbatools. This session will overview how to get Dbatools, overview of the cmdlets, and demonstrations of migrating from a 2008 instance to 2017. Basic knowledge of PowerShell is encouraged, but not required for this session.

This site is open source. Improve this page.