SQLSaturday #920 - Oregon 2019

Event Date: 11/02/2019 00:00:00

Event Location:

University of Portland
5000 North Willamette Blvd
Portland, Oregon

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: Encrypting Data Within SQL Server

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

In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption, and Always Encrypted. While we look at the encryption options, we will review both on-premise and cloud offerings. This session will deep dive into setting up Always Encrypted encryption and share experiences implementing the encryption. Also, let’s learn how to classify data which should be protected and how to audit sensitive data usage.

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

Speaker(s):

Thomas Norman

Track and Room: DBDev: Development, Tools, Scalability, Query Tuning and Indexing - 214

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.

Speaker(s):

Rob Volk

Track and Room: DBDev: Development, Tools, Scalability, Query Tuning and Indexing - 214

Title: KingswaySoft - Supercharge your ETL Dev with Advanced SSIS Components

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

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

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

Speaker(s):

Daniel Cai

Track and Room: BI Arch/Admin: Design, ETL, SSIS, EDW - 006

Title: SQL on Docker 101

Abstract: In this session German Data Platform MVP Frank Geisler will explain the basics of Docker. He will explain what Docker is, how it works and most importantly how you can use Docker to run SQL Server within seconds on Windows, Linux or Mac. This demo packed session is the right session for you if you heard about Docker and want to get started. [Video]

Speaker(s):

Frank Geisler

Track and Room: DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR - 015

Title: Inside the Query Store. What Knowledge can You Gain?

Abstract: The Query Store houses valuable information on performance of your queries, as well as gives you great insights into your query workload and plan changes. This presentation will take a look at what’s new in the 2017 Query Store, the new adaptive query processing features, and how to incorporate Query Store queries into the new SQL Operation Studio for monitoring slow running queries and analyzing waits. You’ll learn how to use the Query Store to quickly find plan changes, analyze performance issues and find the waits that caused them. Both DBAs and developers can increase their performance-tuning skills by attending this session.

You will learn:

How to quickly find plan changes and analyze performance issues How to use the new wait classifications in order to get clues on how to tune your statements About the new adaptive query processing features and SQL Operation Studio

Speaker(s):

Janis Griffin

Track and Room: DBDev: Development, Tools, Scalability, Query Tuning and Indexing - 015

Title: Back to the Future with Temporal Tables

Abstract: Back to the Future is the greatest time travel movie ever. I’ll show you how temporal tables work, in both SQL Server and Azure SQL Database, without needing a DeLorean. We cover point in time analysis, reconstructing state at any time in the past, recovering from accidental data loss, calculating trends, and my personal favourite: auditing. There’s even a bit of In-Memory OLTP. There might even be time for demos!

Speaker(s):

Randolph West

Track and Room: DBDev: Development, Tools, Scalability, Query Tuning and Indexing - 231

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.

Speaker(s):

Kellyn Pot’Vin-Gorman

Track and Room: Cloud Data: Architecture, Platform, Managed vs. VM, CosmosDb, Azure, AWS, etc. - 223

Title: Power BI Premium: Just the Facts

Abstract: What is Power BI Premium and how is it different then Power BI and Power BI Pro? What do you get for the $5000/month that Power BI Premium costs and what are the alternatives (if any)? In this session, we will go over all the differences between the Power BI offerings from Microsoft and some of the features yet to come. With multiple demos we will walkthrough the features of Power BI Premium so that you can see if it provides value to your company. Come to this session if you have been thinking about Power BI Premium, but you have been unable to determine if it is right for your company. At the end of this session, you will be armed with all of the knowledge you will need to make the right decision.

Speaker(s):

Steve Wake

Track and Room: BI Arch/Admin: Design, ETL, SSIS, EDW - 006

Title: Common Data Model - Our new buddy for Data Governance

Abstract: Common Data Model as the foundation of Power BI Dataflows and as part of the Open Data Initiative with SAP and Adobe, seems to be a pretty good move from Microsoft. We want to take a closer look to this approach. In this session we show how the Common Data Model will allow you to combine Self-Service ETL and Corporate Data Engineering. We will show you how Power BI and more specialised tools like ADF, DataBricks etc. can work together on the Azure Data Lake with one common model. We than extend this and show, what opportunities this standard brings to you, when we unleash the possibilities you have on managing Data Quality and Governance. We also will have a look in how you integrate CDM in a DataOps Methodology.

Speaker(s):

Oliver Engels

Track and Room: BI Arch/Admin: Design, ETL, SSIS, EDW - 223

Title: The Jupyterian Snake Invasion: Intro to Jupyter Notebooks, Python, Azure and Beyond [VIDEO]

Abstract: Python and Jupyter Notebooks have become popular with data professionals and cloud platforms such as Azure and Google. With applications in data exploration, analysis, model training, visualization, and data sharing, they’ve transformed how data professionals work. In conjunction with the growth of these tools, data workflows are also utilizing cloud resources for easier collaboration, access to powerful hardware, and distributed storage/computation. Join us in this interactive session for an intro to Jupyter Notebooks and Python, where they came from, when you should use them and how they are being used on the cloud today. We will walk through a basic data project using some core data packages in Python to explore a dataset and see these tools in action. By the end of this session you will be ready to join the Jupyterian Snake Invasion in data questing!

To get a head start with Jupyter, explore your first notebook with Azure notebooks: https://notebooks.azure.com

Speaker(s):

Robby Boney

Track and Room: Data Science: Analytics; Machine Learning, Python, R, R Server, R Services, etc. - 026

Title: Data Privacy and Data Security in a Data-Driven world

Abstract: New advances in technology coupled with the rate of change in the data-driven world are placing the issue of Privacy and Ethics at the forefront of public consciousness – forcing a discussion around the ethical use of data within business and the role that each data professional must play in ensuring that the highest standards are reached, maintained, and constantly evaluated. Technologies such as machine learning, artificial Intelligence, and big data processing are providing new business opportunities that must also account for privacy and ethics issues while maintaining a balance with compliance, security, and integrity of data. But what are the issues that individual data professionals should be aware of to avoid reputational damage to their companies and themselves? And what are the tools that can help them in their endeavors?

This session will take a close look at some of these challenges and the tools that are available to help mitigate these issues and risks.

Speaker(s):

Martin Catherall

Track and Room: Professional Development: Career, Skills, Interviewing, Managing, WIT - 231

Title: Reporting Services Tips, Tricks, Templates and Considerations

Abstract: This session is an overview of some of the features and capabilities of Reporting Services. In it you will see a variety of reports styles and template considerations and get an understanding of the power of Linked Reports and Shared Data Sets along with a brief look at some of the Enterprise Edition capabilities with KPIs and Mobile Reports. We will also cover how to use the data in the ReportServer database to determine which reports are being utilized and determine which reports to migrate to a new implementation of SSRS. Come see how you can use PowerShell to extract the reports and datasets from the database in order to build a new solution for deployment to a new server.

Experience managing SSRS and ideally an understanding of the ReportServer database is useful but not required in order to benefit from this session.

Speaker(s):

Ted Stathakis

Track and Room: BI Arch/Admin: Design, ETL, SSIS, EDW - 223

Title: Protect your Data by Design: Creating a Data Masking Strategy

Abstract: Data Breaches are seemingly neverending in today’s world with new ones coming to light every single day. To try and mitigate the fallout of a data breach we can implement a data masking strategy throughout our environments, so why haven’t we already? In this session, you’ll learn the traditional blockers to, and issues with masking data, how to overcome these, and how you can build your own masking plan to ensure the security of your data in pre-production.

Speaker(s):

Christopher Unwin

Track and Room: DevOps: Agile Processes between Dev and Ops - 034

Title: Enterprise Power BI - Development Lifecycle [VIDEO]

Abstract: When your development team is up to a certain size and often no matter what size it is you want to start following best development practices. These include things like source control, multiple environments, deployment processes and governance.

As Power BI content is developed using Power BI Desktop and not Visual Studio as most Microsoft BI solutions are these things can get tricky.

In this session we will look at what Power BI has to offer when it comes to development lifecycle. We will look at the different options available to the developer when it comes to source control, dev, test and production and deployment of Power BI content. We will then look at the different options when it comes to distribution of content to the end user. Lastly, we will look at governance and see how it is possible to secure the content and audit the usage of Power BI.

Speaker(s):

Asgeir Gunnarsson

Track and Room: BI Design: Delivery: Power BI, SSRS, Visualization - 026

Title: Certificates and EXECUTE AS - Putting Permissions Inside Stored Procedures

Abstract: The basic mechanism when we want to give users access to data or actions in SQL Server in a controlled way through stored procedure is ownership chaining. This is something we use everyday as SQL workers, although we may not be aware of it. Every once in a while, we run into situations where it seems that it is not sufficient to put a statement in a stored procedure, but that users need to be granted explicit permissions – something we may not always be comfortable with, because that would permit the users to do things we do not want them to be able to.

There are two additional mechanisms in SQL Server we can employ in these situations: certificate signing and the EXECUTE AS clause. In this session I will start by exploring how ownership chaining works and its limitations. I will then proceed to explore the other two options and I will particularly focus on certificate signing, as this is the preferred method. At first it may seem overly complex, but I will show how it easily can be automated. EXECUTE AS may seem simpler, but I will point out potential problems with it, not the least if you try to use it on server level and consider to set the database as TRUSTWORTHY.

This session is directed towards both developers and DBAs, as this session deals with problems you may face in either roles.

Speaker(s):

Erland Sommarskog

Track and Room: DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR - 026

Title: Grabbing the brass ring: tools for better self-advocacy in the tech workplace

Abstract: Have you ever felt passed up for a promotion or a stretch assignment because you identify as a woman, non-binary and/or as BIPOC (black, indigenous, or a person of color)? Have you ever had a chance to reach for the proverbial brass ring but did not or was prevented from doing so? Many workplaces endeavor to create an inclusive and equitable workplace but end up missing the mark by perpetuating systemic biases that impact the ability for folks to realize their fullest career potential, or even get access to the game at all. Join a panel of prolific speakers from PDX Women In Tech who will address topics like what to do when gender and/or race set the tone for the environment, and what to do when leadership doesn’t recognize an opportunity to promote equity. Audience (all are welcome) will be able to learn new ways to approach self-advocacy (or, in the case of allies, advocacy) and tips and techniques to further the conversation around equity and inclusion in their workplace.

Speaker(s):

Padmashree Koneti

Track and Room: Professional Development: Career, Skills, Interviewing, Managing, WIT - 231

Title: Essential Linux skills for SQL Server DBAs

Abstract: When Microsoft released SQL Server 2017 it allowed data professionals to run SQL Server on Linux and in containers, providing a wider and more open platform to deploy and run SQL Server.

This session will showcase both the differences of SQL Server on Linux and the things that will be familiar for DBAs. The top Linux commands that SQL Server DBAs should know will be discussed and demonstrated.

This session will incorporate a demonstration that will showcase the fundamentals of Linux management for SQL Server as well as s sneak peek at SQL Server on containers.

This session will help you understand the basics and will present the exciting future of SQL Server on Linux.

Speaker(s):

Hamish Watson

Track and Room: DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR - 034

Title: Enterprise Row Level Security in SQL Server and Power BI [VIDEO]

Abstract: The need for organizations to provide Row Level Security (RLS) in their applications is increasing every day, often in existing applications where code changes are not easy. Microsoft has addressed this need in SQL Server 2016/2017/2019 and Azure SQL DB/DW with predicate based RLS and in Power BI, as well. This session will show how organizational asset hierarchies are leveraged together to provide predicate-based RLS on tables in SQL Server 2016/2017, Azure SQL Database and Power BI without application changes. This session will go beyond the basic RLS setups and show a real-world production setup of RLS using a small number of security records to secure large and small organizations.

Attendees will leave with a complete working demo they can take to their work and begin to use immediately. The demo will walk completely through creating the database, creating the application tables and security related tables, loading demo and security data, setting up the RLS and testing the RLS.

Speaker(s):

Jamey Johnston

Track and Room: BI Design: Delivery: Power BI, SSRS, Visualization - 206

Title: Theory Driven Data Science: Cyber-security Improvement using SQL, R and machine learning [Video]

Abstract: Data science seeks to uncover actionable data relationships to solve pressing organizational needs e.g. improved cyber security behavior, and this talk presents three steps for doing just that. The aim is an exemplary theory driven approach to data evidence of better preparedness against cybersecurity threats. We will present a theory of cybersecurity behavior and how data was collected from training participants then stored in SQL server for analysis in R with a ML classifier. The ML random forest classifier implemented in R is used to analyze survey responses to theoretically-inspired questions. It creates a preferred multi-model integration that can be reused on future data to identify the individuals less likely to participate in the security training who may also be a higher security risk. The talk concludes by summarizing the three tips for actionable data science projects covered here. A short video will preview for SQLSaturday attendees.

Speaker(s):

Michael Curry

Track and Room: Data Science: Analytics; Machine Learning, Python, R, R Server, R Services, etc. - 206

Title: SQL for Product Mangers and Business Line Managers

Abstract: If you’re a product manager or business owner who’s relied on others, be it data analysts, DBAs, or other data professionals to pull data for you to analyze and visualize, then this is the session for you. This session will focus on real-world examples of how to use SQL to get the data you need to improve your product, speed up your innovation cycles, gain product insights faster, and generally become a leaner, more functional product manager through the use of data.

This session will focus on basic SQL queries that are common for product managers (date ranges, sorting, basic aggregate functions like SUM and COUNT) and useful tools to help make the process easier to implement (Azure Data Studio, Docker, Kitematic, MySQL, Azure SQL, PowerBI, and others). Attendees will come away from this session with a better understanding of SQL and how it can be used and applied for more product and business focused applications and testing.

Speaker(s):

Brian Ziff-Levine

Track and Room: Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips - 006

Title: Using Clustered Column Store Indexes at Scale

Abstract: Using a real world example that is in production this session will go though pitfalls I experienced and how to avoid these mistakes in the beginning which will save you lots of data wrangling over time.

Clustered Column Store Indexes are a great tool when used correctly. This session will explain on how to plan, configure, and operate Clustered Colum Store indexes to handle trillions of rows.

Speaker(s):

Thomas Grohser

Track and Room: DBDev: Development, Tools, Scalability, Query Tuning and Indexing - 214

Title: Windowing Functions: Shedding some light

Abstract: One of the simplest ways to enhance the value of the information we provide is to add context. Supplementing each data point with information from a larger data set is a common way of adding this context. In T-SQL, we achieve this by using Windowing Functions.

In this demo-heavy session, we will walk through the uses of Windowing Functions, from simple row orders to more complicated calculations like rolling averages. We’ll explore each keyword in turn, building more sophisticated functions as we do. Each concept is illustrated in a visual, and T-SQL example so it is clearly understood.

So whether it’s tracking a value against the previous row, creating running totals, or a rolling sum, when you walk out of this session, you’ll be able to write a windowing function to make it happen.

Speaker(s):

James McGillivray

Track and Room: DBDev: Development, Tools, Scalability, Query Tuning and Indexing - 206

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.

Speaker(s):

Diane Schuster

Track and Room: BI Arch/Admin: Design, ETL, SSIS, EDW - 034

Title: Talend - Delivering Trusted Data at Speed

Abstract: Data-driven strategies are now a competitive imperative to succeed in every business and industry. To support business objectives such as revenue growth, profitability, and customer satisfaction, organizations are increasingly reliant on data to make decisions.

Talend Data Fabric solves some of the most complex aspects of the data value chain from end to end. Users can collect data across systems, govern it to ensure proper use, transform it into new formats, and improve quality, and share it with internal and external stakeholders – all in a collaborative, multi-cloud data integration environment.•

A unified environment that provides access to all Talend capabilities Native code generation for better performance Self-service data access with governance for increased productivity Pervasive data quality for more confidence and less risk

Talend Data Fabric enables customers to deliver trusted data at speed, providing them with a complete solution for all data n

Speaker(s):

Karan Kumar

Track and Room: BI Arch/Admin: Design, ETL, SSIS, EDW - 015

Title: Locks? We don’t need no stinkin’ locks!

Abstract: “I’ve got a locking problem”, “I need to get rid of blocking,” and “deadlocks are normal behavior” are all things heard way too many times.

In this session targeted at the accidental or new DBA, we will walk through each of these items, what they are, what their causes are, which of them are normal behavior and which are not, and some common causes of deadlocks and excessive blocking.

Speaker(s):

Randy Knight

Track and Room: Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips - 231

Title: Lightning Talks Session 2

Abstract: Session Two : Melody Zacharias: Resumable Index Rebuild In Action! Ted Stathakis: Commenting your Code! Ted Stathakis: ProperCase - My Favorite UDF Janice Gerbrandt: Automate Tests in your Database with tSQLt.

Speaker(s):

Michael Wall

Track and Room: Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips - 120

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

Abstract: Data is everywhere and Data Science is a very popular topic among data analysts and BI professionals. In this session, I will cover the basic data science principles and methodologies using the Python programming language. I will also present some real-world data analysis case studies using the Python libraries, such as NumPy, pandas, Matplotlib, and SciPy. This session will benefit to anyone who is looking to get started in the data science/ Data Analytics field.

Speaker(s):

Ganesh Lohani

Track and Room: Data Science: Analytics; Machine Learning, Python, R, R Server, R Services, etc. - 015

Title: Lightning Talks - Session 4

Abstract: Session Four : William Assaf: I Was Once a Crappy Carpenter Jessica Aguilar: Purposeful Learning Jessica Aguilar: The Art of Documentation

Speaker(s):

Michael Wall

Track and Room: Professional Development: Career, Skills, Interviewing, Managing, WIT - 120

Title: Becoming Data-Driven with Snowflake

Abstract: To stay competitive in today’s world is to stay agile by making swift, intelligent, data-driven decisions. Join us to see how you can enable your organization to be data-driven with the fastest growing cloud-enabled data warehouse, Snowflake. Especially if any of the following interests you: • Escaping the constraints of legacy technology. • Delivering insight from all your data to all your business users. • Creating your own data sharing economy. You will also learn: • The ease of Snowflake’s intuitive user interface • How to easily load, integrate and query structured and semi-structured data • What it’s like to run large queries in a fraction of the time • How to effortlessly connect your BI/ETL tools

Speaker(s):

Brian Whittington

Track and Room: BI Arch/Admin: Design, ETL, SSIS, EDW - 026

Title: Tips and Tricks for the PowerShell DBA [VIDEO]

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.

Speaker(s):

Ben Miller

Track and Room: DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR - 206

Title: Code Your Report Environment

Abstract: You too can build a development Environment for Reporting Services and SQL Server with Azure completely in PowerShell without any GUI!! Additionally, Frank Geisler will be discussing the ReportingServicesTools in PowerShell.

Speaker(s):

Frank Geisler

Track and Room: BI Arch/Admin: Design, ETL, SSIS, EDW - 206

Title: Power BI - Ask Microsoft Anything

Abstract: “We are pleased to host a Power BI Ask Microsoft Anything (AMA) at SQLSaturday! This is your opportunity to ask and share feedback directly with Christopher Finlan, Principal Program Manager on the Power BI team. Chris owns the SSRS, Power BI Report Server, Paginated Reports and Power BI product areas along with related items like exporting and subscriptions all-up. Feel free to discuss these (or any) topic related to Power BI and hear the answers straight from the product team. Special guest appearance by Paginated Report Bear as well.”

Speaker(s):

Chris Finlan

Track and Room: BI Design: Delivery: Power BI, SSRS, Visualization - 120

Title: Lightning Talks - Session 5

Abstract: Session Five: Russ Loski: Parsing Fixed Width Files with Azure Data Factory Daniel Cai: Build Sophisticated Data Solution Using Adv. SSIS Components Hari Mahesh: Predicta

Speaker(s):

Michael Wall

Track and Room: BI Arch/Admin: Design, ETL, SSIS, EDW - 120

Title: SQL Server Management Studio - Beyond the basics

Abstract: Almost all of us use SQL Server Management Studio to interact with SQL Server, and thankfully it works right out of the box. But did you know there are so many tricks and shortcuts that hide just under the surface that can make working with SSMS feel like second nature?

In this session, I will take a fresh install of SSMS and step through customizing it. I will demonstrate features and help you become more efficient at utilizing SSMS to it’s fullest potential - a lot of the time without using the mouse. Finally, I’ll show you some cool text editing tricks that will take your SQL skills to a whole new level.

Speaker(s):

Adrian Mee

Track and Room: Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips - 214

Title: Lightning Talks Session 3

Abstract: Session Three : Martin Cairney: Azure SQL Database – Building a Deployment Standard Martin Cairney: Data Governance and Protection in SQL Server Josh Smith: What Use is Data Catalog?

Speaker(s):

Michael Wall

Track and Room: Cloud Data: Architecture, Platform, Managed vs. VM, CosmosDb, Azure, AWS, etc. - 120

Title: Get Faster Queries with Better Statistics Management

Abstract: Statistics are key to the selection of a good execution play. But statistics aren’t perfect, and they often require management over and above what the default SQL Server configurations supply. In this session we’ll look into why statistics, and specifically the histogram, are so important to good query performance. We’ll see how they’re not perfect, and how that can result in an occasional bad execution plan (slow query). I’ll also present a few methods to resolve those statistics-caused performance issues. Of course there will be plenty of examples.

Speaker(s):

Vern Rabe

Track and Room: DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR - 034

Title: Azure SQL Database Edge - Tiny but mighty

Abstract: Have you ever thought what would it be like to run SQL Server engine in a small footprint? Well, wait no more.

Running on Arm and x64 architecture with a reduced footprint, the proven performant and most secure Microsoft SQL engine is coming to the Edge in interactive devices and edge gateways. Combining new capabilities on data streaming and time-series, with in-database machine learning (ML), Azure SQL Database Edge is optimized for low-latency analytics right on the Edge. This session will showcase the scenarios Azure SQL Database Edge can enable.

Speaker(s):

Julie Koesmarno

Track and Room: Cloud Data: Architecture, Platform, Managed vs. VM, CosmosDb, Azure, AWS, etc. - 006

Title: Power BI: From Zero to 101

Abstract: Power BI is already proven technology and everyone should know at least basics of it. That is elementary startup session at which you will learn:

How to use PowerBI Desktop application;
How to get source data, build reporting dashboards, manipulate with columns, present the data in forms of a table and different kinds of diagrams;
How to apply different formatting settings to the diagrams and setup interactions between them;
How to do comprehensive filtering, drill down and drill through of your data.

After this session you will be really able to work with Power BI on your own.

Speaker(s):

Slava Murygin

Track and Room: BI Design: Delivery: Power BI, SSRS, Visualization - 223

Title: Intro to Azure Data Studio

Abstract: Azure Data Studio, keeping in line with Microsoft’s ethos of tooling that works on many platforms this one runs on Windows, macOS and Linux.

This session is to give you an introduction to the product give you an idea of where/how it can be used in the Data Platform space. We will also cover some of the main features (code snippets, widgets, extensions) and time permitting Notebooks.

Hopefully by the end of the session you will be aware of Azure Data Studio and be ready to give it a go!

Level: Beginner Level 100

Speaker(s):

Heidi Hasting

Track and Room: Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips - 006

Title: What is Power BI?

Abstract: You’ve heard all the buzz about Power BI, but you have no idea what it is and how it works. This session explains what Power BI is, who can use it and why you would want to. It’s an introductory session that gives you the information you need to determine if Power BI is right for you and your organization.

Speaker(s):

Angela Henry

Track and Room: BI Design: Delivery: Power BI, SSRS, Visualization - 223

Title: Interject - Are you prepping for the Data Apocalypse?

Abstract: The era of unchecked data costs is about to end. Businesses are tired of initiatives that rely on unproven technology, unattainable talent, uncontrolled spending, and, most important, unsatisfactory data literacy. Gartner predicts 80% of the data workforce to be outsourced by 2021. What can we do, as data professionals, to prove our value? How can data literacy become an organizational imperative before it’s too late?

Speaker(s):

Elliott Whitling

Track and Room: Data Science: Analytics; Machine Learning, Python, R, R Server, R Services, etc. - 214

Title: PowerBI Model Designs Techniques

Abstract: Building effective PowerBI reports and dashboards requires a well-designed data model with the right relationships and measures. This session will tackle these design challenges head on and show how to approach this critical phase. With an example project to guide us through the design phase and the various stages as we progress to a completed working data model and have a template for reusing on other projects. Along the way we will show the DevOps approach to building the design model .

Speaker(s):

Neil Hambly

Track and Room: BI Design: Delivery: Power BI, SSRS, Visualization - 214

Title: OH22 - Data Quality in Action

Abstract: In this session we will discuss how you can get your data quality problems under control on the Microsoft Data Platform. We’ll show you how to quickly and easily integrate a duplicate search into your applications, how to migrate Microsoft SQL Server Data Quality Services to Azure, how to clean data with the SSIS-IR and how to improve your self-service processes in Power BI. All this with HEDDA.IO directly on Azure.

Speaker(s):

Tillmann Eitelberg

Track and Room: BI Arch/Admin: Design, ETL, SSIS, EDW - 231

Title: BI in Modern Excel: The value is in the Refresh

Abstract: 2 text transaction files, a pivoted excel budget file, 20 Power Queries, 6 dimensional tables, and one interactive Excel dashboard = mind blowing awesomeness in under 60 minutes. But while the analysis is important, the real value in the refresh. Can your model pull in another 22 text files and next year’s budgets in less than a minute? This model can. Come and see how Excel 2016 gives us the ability to not only rapidly create business intelligence, but also allows us to build engaging and interactive models that can be quickly updated and shared via Power BI.

Speaker(s):

Ken Puls

Track and Room: BI Arch/Admin: Design, ETL, SSIS, EDW - 034

Title: Mastering your Resume Interview: Tips to Get Hired

Abstract: Looking for a job? Learn trade secrets from an HR professional! Resume blunders and interview tips, this session will focus on the most important things you can do to get hired.

Speaker(s):

Christine Assaf

Track and Room: Professional Development: Career, Skills, Interviewing, Managing, WIT - 026

Title: Marquam - How to Make Beautiful Dashboards in Power BI

Abstract: Want to polish your Power BI dashboards and take them to the next level of design? In this presentation Jackie Wilushewski, a User Experience Designer at Marquam, will guide you through her methodology of User Experience Design. Then, starting with a typical “all-business” dashboard, Jackie will demo step-by-step how to implement simple changes to improve usability and aesthetics.

Speaker(s):

Jackie Wilushewski

Track and Room: BI Design: Delivery: Power BI, SSRS, Visualization - 223

Title: Lightning Talks Session 1

Abstract: Catherine Siverts: Diverse Voices in Analytics: Designing Case Studies Slava Murygin: SQL joins Slava Murygin: SSMS Shortcuts

Speaker(s):

Michael Wall

Track and Room: Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips - 120

Title: Continuous Intelligence… Is it all about automation?

Abstract: Continuous Intelligence is commonly used to describe approaches to constantly analyze data by applying machine-learning algorithms. But you can also understand it to be a combination of the terms of Continuous Integration and Business Intelligence. Support for BI projects in CI has been a field for improvement in even the near past. But why was that? BI offers some special challenges for CI processes that we want to discuss during this session.

Speaker(s):

Gabi Münster

Track and Room: DevOps: Agile Processes between Dev and Ops - 015

Title: Introduction to GitHub

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

Initial setup of a Repository in GitHub.
Build Issue templates for new features, bugs, or custom tasks.
Securing the check-in/merge process to your root branch.
Integrating GitHub with other productivity tools to keep on top of changes.

Speaker(s):

Joshua Higginbotham

Track and Room: DBDev: Development, Tools, Scalability, Query Tuning and Indexing - 006

Title: What is DevOps and Why Should DBAs Care? [VIDEO]

Abstract: You may have heard the term “DevOps” a lot lately, but is this just one of those buzzwords that gets thrown around and means something different depending on who’s talking? While traditional software methodologies pit developers and operations folks like DBAs against each other, DevOps requires that they work together for a common goal. And, ultimately, shouldn’t the software project’s success be everyone’s goal? Attend this session to learn how DevOps is changing the DBAs world for the better.

Speaker(s):

Kathi Kellenberger

Track and Room: DevOps: Agile Processes between Dev and Ops - 231

Title: VMWare - Virtualizing SQL Server on vSphere

Abstract: For most DBAs virtualization is no longer a matter of “If” but “When”. This means it is critical for DBAs to understand how this technology works and how we can ensure we get the most performance and scalability out of it. In this session we will look at some of the best practices and gotchas when Designing Standalone and Highly Available SQL deployments in a vSphere environment. We’ll also cover how to troubleshoot performance issues when they arise.

Speaker(s):

Brandon Leach

Track and Room: DBAdmin: Administration, Deploy, Manage, Repair, Server and Database Configuration, HA/DR - 206

Abstract: You’re a DBA or Developer, and you’ve been using SQL Server for a few years.

You know there are different ways to make queries faster, but you’re not sure when to use them.

I’m Erik Darling, and I’ll be your sommelier for the evening.

Over several courses of delicious demos, I’ll show you the types of performance problems different tuning techniques pair well with, and which ones to avoid.

When we’re done, you’ll understand exactly what patterns to look for when you’re troubleshooting slow queries, and how to approach them.

You’ll have the secret recipe for gourmet queries.

Speaker(s):

Erik Darling

Track and Room: DBDev: Development, Tools, Scalability, Query Tuning and Indexing - 015

Title: Defining What’s Normal – The Basics of Database Normalization

Abstract: Determining how to efficiently design database structures for a given application has always relied on the same old answer: “It depends!” So, how do you determine what level of normalization your data requires? This session will review the principles of data normalization, show the impact that normalization can have on performance and data integrity, and just as importantly, show you when it’s OK to break the rules and denormalize. We will cover some case situations where it’s better not to be normal!

Speaker(s):

Aaron Cutshall

Track and Room: Essentials: SQL Basics: Object/Data types, Best Practices, Query Plans, Indexing, Maintenance, SSMS/SQLOps/SSDT tips - 034

Title: Introduction to AI

Abstract: What was AI in the past, what is it now and where will the future take us? Data Science, Azure Machine Learning, and Analytics are all becoming core pieces of a many successful businesses. What are people doing with it and how can it be used in all aspects of business. As data professionals, we need to know how these core pieces will affect what we do, and how we can use the Azure AI suite to help our clients. Using an easy to follow example, I will show the flow from problem to solution. A demonstration of AI used in the real world.

Speaker(s):

Melody Zacharias

Track and Room: Data Science: Analytics; Machine Learning, Python, R, R Server, R Services, etc. - 026

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Michael Curry

LinkedIn: Michael Curry

I am an academic, data professional and behavioral cybersecurity researcher and very active in the Portland and SW Washington community. I am passionate about increasing equity in the tech field and have made contributions to improving gender diversity. I am part of the Oregon SQL leadership and the organizing committee for Oregon SQLSaturday.

Ted Stathakis

Twitter: - fishheadted

LinkedIn: Ted Stathakis

Contact: http://fishheadted.com

Ted Stathakis is a data professional passionate about the presentation layer. He has worked with SQL Server since the turn of the century, has mastered Reporting Services since he began working with it when it was released in 2004, and is super excited about Mobile Reports and Power BI. Ted hosts the local PASS user group, is the organizer of SQLSaturday Orange County and presented on SSRS at Summit in 2019. As a 40+ year veteran of the restaurant industry, he is been an advisor, speaker and panelist at national trade shows. When he isn’t consulting on Business Intelligence projects he can be found presenting at a conference, enjoying some live music or teaching kids, both young and old, fishing and archery at a nearby Scout camp.

Christine Assaf

Twitter: - https://twitter.com/HRTact

LinkedIn: Christine Assaf

Contact: https://www.hrtact.com

Christine Assaf is an experienced HR pro who is passionate about the mental health of employees, leadership, and organizations. She is a leadership development professional with over 15 years experience in human resources and 20 years in business management. She holds a BS in Business Management, received her HRM certification at LSU, and is finishing up her master’s degree at Colorado State University in Industrial and Organizational Psychology. She is a certified DDI Trainer, experienced public speaker, and is dedicated to teaching others about ways to support a culture of “expressiveness” in the workplace that creates connectivity.

Diane Schuster

LinkedIn: Diane Schuster

Diane has worked with COZYROC since 2012. She has attended numerous SQLSaturdays to shine the light on the time-saving and capability-extending components and tasks that COZYROC offers in it’s SSIS+ library. Without even having a background in databases or SQL Server, Diane successfully configures packages in live demonstrations that use COZYROC components and tasks. She believes that, if the toolkit is this easy to use for a novice, then just imagine what a SQL Server expert can do with it!

In Diane’s data networking days, Diane performed a variety of development-related and customer-facing roles for IBM, Lucent Technologies, North Carolina State University and Connectware.

Christopher Unwin

Twitter: - RedG_Chris

LinkedIn: Christopher Unwin

Chris Unwin is a pre-sales engineer at Redgate Software, specialising in data protection with a keen focus on masking information in pre-production. He has been with Redgate since November 2015 and has most recently been working with a variety of companies to help them put in place a compliant DevOps pipeline for database development. He also records the Redgate ‘DBAle’ podcast with his colleague Chris Kerswell and has presented at IPExpo London, Manchester Agile Dev/Ops and PASS Marathon.

Gabi Münster

Twitter: - @SQLMissSunshine

LinkedIn: Gabi Münster

Gabi Münster is working as a Business Intelligence consultant and team lead and brings in her experience with SQL Server, data warehousing, relational and multidimensional database design and implementation, report and dashboard design, and Master Data Services, as well as project management into the community as a regional PASS Local Group lead. She is also passionate about motivating other women to start a technical career and therefore initiates and supports “Women in Technology” events. Apart from SQLSaturdays, she also spoke at SQLBits, SQL Nexus, Tuga IT, and 2015’s and 2017’s PASS Summit. In October 2017 Gabi received her first Data Platform MVP award.

Thomas Norman

Twitter: - ArmorDba

LinkedIn: Thomas Norman

Contact: https://armordba.com/

Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.

Martin Catherall

Twitter: - MartyCatherall

LinkedIn: Martin Catherall

Contact: http://martincatherall.com

Martin is a data consultant in Melbourne, Australia, a Microsoft Data Platform MVP, and PASS Regional Mentor for the Asia Pacific (APAC) region. Martin founded the Christchurch, New Zealand PASS Local Group and lead the group for a number of years before relocating to Melbourne. He has been using SQL Server in various roles since 2000. In addition to anything data related, he enjoys playing the guitar and having fun with his family.

Melody Zacharias

Twitter: - SQLMelody

LinkedIn: Melody Zacharias

Contact: http://sqlmelody.com

Melody is the Sr. Microsoft Solutions Manager at Pure and has been in love with data since 1991. She has been sharing her passion with the community in technical sessions and blogs since 2014. She has been a Microsoft MVP since 2016, including winning Rookie of the year for Canada that year. This last year, she was elected to the board of directors for PASS.org, the professional association for SQL Server and was awarded Regional Director by Microsoft. She has co-authored 3 books, including, SQL Server 2019 Administration inside out by Microsoft Press.

Ben Miller

Twitter: - DBAduck

LinkedIn: Ben Miller

Contact: https://dbaduck.com

Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.

Slava Murygin

Twitter: - SlavaSQL

LinkedIn: Slava Murygin

Contact: http://slavasql.blogspot.com/

Started working with SQL Server 7.0 as DBA and Developer. Since then went through all SQL Server versions, migrations and multiple companies of different sizes and industries. Currently working as a contractor with all aspects of SQL Server, including, but not limited to: troubleshooting performance, designing/developing: databases, systems, processes, data warehouses, cubes, reports, ETLs; Refactoring old code; Migrating data from other systems to SQL Server; Securing the data on enterprise level.

Jamey Johnston

Twitter: - STATCowboy

LinkedIn: Jamey Johnston

Contact: http://STATCowboy.com

Jamey Johnston is a Senior Data Scientist/Engineer for a large independent OG company. For over 25 years, he has worked for Fortune 500 companies architecting successful platforms in the cloud, on the edge, and on-premises for BI reporting, statistical analysis, ML, and AI. Lately, he spends his time in Azure, Python, R, Power BI, MS SQL, and SAS JMP. He holds a BS in Spatial Analysis from LSU and a Masters of Science in Analytics from Texas AM. He is a professor at the Mays Business School at Texas AM in the MS Analytics program. He is active in his PASS Local Group in Houston, co-leader of the local Power BI users group and data analytics group. He regularly speaks and volunteers at PASS events. He is also a Microsoft Data Platform MVP.

Robby Boney

Twitter: - https://twitter.com/RobbyBoney

LinkedIn: Robby Boney

Robby Boney is a software engineer at Interject. He is a Python enthusiast, with a background in bioinformatics research in hearing loss regeneration and computer science at Washington State University Vancouver. He is now leading product design initiatives for Interject focussed on scalable cloud data solutions and python based web applications.

Randolph West

Twitter: - _randolph_west

LinkedIn: Randolph West

Contact: https://bornsql.ca/blog/

Randolph West (they / them), founder of Born SQL, is an independent IT consultant, speaker, Calgary PASS user group leader, Microsoft Data Platform MVP, and lead author of “SQL Server 2019 Administration Inside Out”.

Randolph specialises in SQL Server performance tuning, disaster recovery, and migrations from really old versions, with an emphasis on implementing best practices.

Randolph has presented at PASS Summit, SQLBits, SQLSaturdays, and user groups. You can also find Randolph acting and directing on screen or the stage, or annoying people on Twitter.

Do not trust Randolph around chocolate.

Kellyn Pot’Vin-Gorman

Twitter: - DBAKevlar

LinkedIn: Kellyn Pot’Vin-Gorman

Contact: http://dbakevlar.com

Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Idera ACE and Oracle ACE Director alumnus. She is a Data Platform Architect in Power BI with AI in the EdTech group at Microsoft. Kellyn is known for her extensive work with multi-database platforms, DevOps, cloud migrations, virtualization, visualizations, scripting, environment optimization tuning, automation, and architecture design.

Kellyn has spoken at numerous technical conferences for Oracle, Big Data, DevOps, testing, and SQL Server. Her blog (http://dbakevlar.com) and social media activity under her handle, DBAKevlar, is well respected for her insight and content.

Brian Ziff-Levine

LinkedIn: Brian Ziff-Levine

Brian is currently the Senior Product Manager at Springbrook Software, a leading provider of government and public-sector ERP solutions. He oversees the growth and success of Springbrook’s CivicPay payments platform with a focus on usability, profitability, and reliability. Brian is a ten-plus-year veteran of the consumer banking industry, having worked for large financial institutions such as US Bank and Navy Federal Credit Union in a product management capacity. Brian began his career in political consulting. He holds a bachelor’s degree in political science from the University of Wisconsin – Madison and an MBA in Data and Analytics from Southern Oregon University.

Brian Whittington

LinkedIn: Brian Whittington

Brian has 20 years of experience working in the IT field, primarily focused on technologies supporting data science. He has worked on projects as diverse as fraud detection, marketing, population health, supply chain optimization, child safety, IoT and others in both the commercial and government sector. He currently works as a technical evangelist for Snowflake Computing helping organizations efficiently leverage their data assets to solve all types of business challenges and opportunities. Brian lives in West Linn with his wife, two teenage children and two dogs.

Heidi Hasting

Twitter: - heidihasting

LinkedIn: Heidi Hasting

Heidi Hasting is a Business Intelligence professional and former software developer with over seven years experience in Microsoft products. She is an ALM/DLM enthusiast and Azure DevOps fan and co-founder and organiser of the Adelaide Power BI User Group. Heidi is a regular attendee at tech events including Azure Bootcamps, DevOps days, SQLSaturdays, Difinity and PASS Summit.

Daniel Cai

Twitter: - danielcai

LinkedIn: Daniel Cai

Daniel Cai is a software developer specialized in SQL Server-based ETL integration development with various APIs and methodologies such as Microsoft Dynamics 365, data warehouse, etc. Daniel was a Dynamics 365 MVP for consecutive 8 years.

Tillmann Eitelberg

Twitter: - @_Tillmann

LinkedIn: Tillmann Eitelberg

Contact: http://www.ssis-components.net

Tillmann Eitelberg is CEO and co-founder of oh22information services GmbH, which specializes in data integration and data management. Tillmann is an active blogger at www.ssis-components.net, writing regularly about data quality topics and his passion: spatial data. In addition, he has published several SSIS components on Codeplex and GitHub. Tillmann is a Data Platform MVP, a board member of PASS Germany e.V., a PASS CL for the Cologne/Bonn region, and a PASS RM.

Erik Darling

Twitter: - https://twitter.com/erikdarlingdata

Contact: https://erikdarlingdata.com/blog/

Erik Darling started using SQL Server after a dispute with Excel over a vlookup. He enjoys public arguments with the optimizer and wine photography.

Steve Wake

Twitter: - stevewake

LinkedIn: Steve Wake

Contact: http://blog.wakebi.com

Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.

Brandon Leach

Twitter: - SQLServerNerd

LinkedIn: Brandon Leach

A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.

Aaron Cutshall

Twitter: - sqlrv

LinkedIn: Aaron Cutshall

Contact: http://sqlrv.com

Aaron N. Cutshall is an Enterprise Data Architect with 20 years of experience in analysis, design and development for applications and databases in manufacturing and warehousing plus over 15 years in the Healthcare Informatics field. His primary focus is in designing and developing solutions for extremely large data sets that perform quite well in SQL Server. He is active in the SQL Server community and speaks at SQLSaturday sessions across the country.

Ken Puls

Twitter: - @kpuls

LinkedIn: Ken Puls

Contact: https://www.excelguru.ca/blog

Ken Puls, FCPA, FCMA is a Chartered Professional Accountant, author, and trainer. With over 20 years of experience as a corporate controller and business owner, he has been exposed to many business systems, databases, and analysis tools, leading to a career of building Excel and Power BI-driven applications to harness data and turn it into management information.

A Microsoft Excel/Data Platform MVP since 2006 and author of 2 books, Ken has also been recognized as a Fellow of CPA Canada.

Thomas Grohser

LinkedIn: Thomas Grohser

Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.

James McGillivray

Twitter: - JamesMcG_MSBI

LinkedIn: James McGillivray

Contact: https://jimbabwe.co.za/blog-posts/

James McGillivray, Data Management and Analytics MCSE, has been working in Business Intelligence for over a decade. He spends his working hours building solutions that allow people to make informed decisions quickly and accurately. James is a director at Cobalt Analytics.

Before his career in data, James was an avid musical theatre student and musician. This love for performance has developed into a passion for developing and delivering presentations that are informative and enjoyable. James speaks frequently at the Johannesburg SQL User Group, and has delivered sessions at numerous SQLSaturdays, PASS Summit, Power BI World Tour and SQL Bits.

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.

Erland Sommarskog

Contact: http://www.sommarskog.se

Erland Sommarskog is an independent consultant based in Stockholm, working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.

Michael Wall

Twitter: - michaelDwall1

LinkedIn: Michael Wall

Contact: http://www.becomingamaster.com

Michael Wall has been an IT professional going back to when he had his own software store and worked with his customers with their “dose” problems. Originally hired by a small consulting firm to write web pages, he was thrust into the SysAdmin world when their lead consultant changed the passwords of all of the servers at a major pulp and paper company’s systems to 100%s$%t and walked out the door. He was sent down with a copy of UNIX for Dummies and 50 cents for the bus ride back. Fast forward a few years, he was asked if he wanted to be a DBA after successfully managing a fifty server Y2K upgrade. Since then, he’s never looked back and has survived a number of data and system challenges. When not wrangling cats at home, he currently

Angela Henry

Twitter: - SQLSwimmer

LinkedIn: Angela Henry

Contact: http://SQLSwimmer.com

Angela is a Solution Architect, living in High Point, NC and loves what she does. She’s worked with all versions of SQL Server worn all the hats that come with dealing with SQL Server throughout the years: developer, administrator, data architect and BI developer. She has her MSCE in Data and Analytics (f.k.a., Business Intelligence), is a Data Platform MVP, and a Microsoft Certified Trainer (MCT). She is the former chapter leader for the PASS Triad SQL User Group in Greensboro, NC. In her spare time you can probably find her in or at the pool, she’s an avid US Masters Swimmer, Coach and Instructor.

Chris Finlan

Twitter: - @cmfinlan

LinkedIn: Chris Finlan

Contact: http://www.christopherfinlan.com

Since joining Microsoft in 2013, Chris Finlan is a leading evangelist for business intelligence. As the lead Business Intelligence Technology Solution Professional in the Mid-Atlantic Region, he was responsible for helping over 140 enterprise customers align their specific requirements to the Microsoft Cloud and Data Platform. His unique presentation style and background in “shadow IT” has made him a highly sought-after speaker for customer presentations and allows him a unique perspective on a variety of BI-related topics and trends. A Senior Program Manager on the Power BI Report Server Team, Chris has been working in the software industry for over a decade in various roles, from technical training, database administration and sales.

Ganesh Lohani

LinkedIn: Ganesh Lohani

Ganesh Lohani has 10 years of experience working with Business Intelligence platform and Data Analytics, with over 8 years of experience with MS BI tools and Business Intelligence processes. He is currently working for Stericycle as a senior Business Intelligence Developer. He also enjoy his evening and weekend time in providing online training, coaching and mentoring individuals who want to learn MSBI (T – SQL, SSIS, SSRS, SSAS, and Power BI ) products. He holds MSIS degree from University of Texas at Arlington.

Frank Geisler

Twitter: - @Frank Geisler

LinkedIn: Frank Geisler

Contact: http://www.gdsbi.de

Frank Geisler is owner and CEO of GDS Business Intelligence GmbH. He is SQL Server MVP, MCT, MCSE – Business Intelligence, MCSE – Data Plattform and MCSE - Azure Solutions Architect. In his Job he is building Business Intelligence Systems based on Microsoft Technology, mainly on SQL Server and SharePoint.

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.

Michael Wall

Twitter: - michaelDwall1

LinkedIn: Michael Wall

Contact: http://www.becomingamaster.com

Jackie Wilushewski

Twitter: - eyebelieveJW

LinkedIn: Jackie Wilushewski

Power BI User Experience Designer at Marquam with 10+ years designing User Experience in SharePoint and other Microsoft technologies.

Neil Hambly

Twitter: - Neil_Hambly

LinkedIn: Neil Hambly

Contact: http://dataidol.com/NeilHambly

Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.

Karan Kumar

Twitter: - mr_karankumar

LinkedIn: Karan Kumar

In my role as Talend Corporate Sales Leader, I get to interact with lot of next-gen companies that are trying to challenge how things have been done traditionally and disrupt the legacy.

Asgeir Gunnarsson

Twitter: - bidgeir

LinkedIn: Asgeir Gunnarsson

Ásgeir Gunnarsson is a Data Platform MVP and Chief Consultant at Datheos in Denmark. He works on Business Intelligence solutions using the whole of the Microsoft BI stack. Ásgeir has been working in BI since 2007 both as a consultant and internal employee. Before turning to BI, Ásgeir worked as a technical trainer and currently teaches BI courses at the Continuing Education Department of the University of Iceland.

Ásgeir speaks regularly at events both domestically and internationally, and is the group leader of the Icelandic PASS Group, as well as the Icelandic Power BI User Group.

Ásgeir is passionate about data and loves solving problems with BI.

Padmashree Koneti

Twitter: - pkoneti

LinkedIn: Padmashree Koneti

I am a seasoned technology professional and have spent my entire career developing managing and leading teams that deliver world class enterprise software applications. I am now also a volunteer at PDX Women in Tech, a local nonprofit in Portland that is focused on helping women and other minorities enter, stay and thrive in tech.

Michael Wall

Twitter: - michaelDwall1

LinkedIn: Michael Wall

Contact: http://www.becomingamaster.com

Hamish Watson

Twitter: - theHybridDBA

LinkedIn: Hamish Watson

Contact: http://www.sqlservercentral.com/blogs/the-hybrid-dbas-blog/

Hamish Watson is a Microsoft Data Platform MVP and VMware Expert with a passion for efficient database and application deployment using DevOps methodologies.

He has 20+ years of IT experience in managing and deploying large scale databases on SQL Server technologies.

He has been managing SQL Server since SQL Server 2000, and pragmatic approaches to delivering business value to clients is his career passion.

Educating and helping others learn is a driver for Hamish. He is a Director-At-Large on the PASS Board, international speaker, and a repeat guest lecturer at a local university.

Michael Wall

Twitter: - michaelDwall1

LinkedIn: Michael Wall

Contact: http://www.becomingamaster.com

Oliver Engels

Twitter: - @oengels

Contact: http://www.ssis-components.net

Oliver Engels is CEO of oh22data AG, a Microsoft Gold Partner in Germany specializing in CRM and BI. His special interests are Azure, Data Governance and Integration, Visualisation Tools like SSRS, Power BI, Tableau, R, and SharePoint. He has worked with SQL Server since version 6.5 and is a founder and Board member of PASS Germany, a PASS Regional Mentor, and runs the Frankfurt PASS Local Group. For more than seven years he is a Microsoft Data Platform MVP and a Microsoft pTSP.

Rob Volk

Twitter: - sql_r

LinkedIn: Rob Volk

Contact: http://weblogs.sqlteam.com/robv/

Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.

Joshua Higginbotham

Twitter: - codenamesql

LinkedIn: Joshua Higginbotham

Contact: https://codenamesql.blog/

Joshua Higginbotham is a Data Services Manager at Republic Bank based out of Louisville, KY. He’s worked in various roles including Software Development, Database Administration, and Business Intelligence. He’s an active speaker within the SQL community and the Co-Chapter leader of the Louisville SQL Server and Power BI User Group.

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

Contact: http://www.sqlsolutionsgroup.com/blog

Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.

Julie Koesmarno

Twitter: - @mssqlgirl

LinkedIn: Julie Koesmarno

Contact: http://www.mssqlgirl.com

Julie Koesmarno, MCSE Data Platform, and MCSE Business Intelligence, MCT, is a Senior Program Manager at Microsoft, with a Bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her past projects include delivering a SQL Server 2012 data warehouse and BI solutions in the US and Australia. She now works with hybrid, cloud and on-prem SQL projects.

Vern Rabe

Twitter: - @VernRabe

LinkedIn: Vern Rabe

Contact: http://www.rabedata.com

Vern Rabe is an independent SQL Server consultant and contract trainer in Portland, OR, and leader of the Oregon Data Community user group, formerly OregonSQL. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been passionate about databases since 1992 and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server knowledge gained from the mixture of academic and practical experiences acquired from his classroom instructing and varied consulting contracts. Vern regularly presents technical sessions at SQL Server user group meetings, SQLSaturdays, and PASS Summit.

Michael Wall

Twitter: - michaelDwall1

LinkedIn: Michael Wall

Contact: http://www.becomingamaster.com

Elliott Whitling

Elliott is a Data Scientist at Interject Data Systems with a background in detecting randomness, differential privacy and building high-quality data products. In his spare time, he plots revenge on octopuses.

Adrian Mee

Twitter: - https://twitter.com/SqlNoodle

LinkedIn: Adrian Mee

A native of Melbourne, Australia - Adrian currently works for Falling Colors Technology in Santa Fe, NM. In this role, he is responsible for Database administration, data security and infrastructure. Adrian has been working with SQL Server since the Enterprise Manager days of SQL Server 2000.

Adrian is an Idera ACE, class of 2020, and in 2017 he founded the Santa Fe SQL Server User group. When out of the office, he loves biking and hiking the great outdoors.

Frank Geisler

Twitter: - @Frank Geisler

LinkedIn: Frank Geisler

Contact: http://www.gdsbi.de

SQLSaturday #920 - Oregon 2019

Sessions

Title: Encrypting Data Within SQL Server

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

Title: KingswaySoft - Supercharge your ETL Dev with Advanced SSIS Components

Title: SQL on Docker 101

Title: Inside the Query Store. What Knowledge can You Gain?

Title: Back to the Future with Temporal Tables

Title: Be Part of the Solution with Automation

Title: Power BI Premium: Just the Facts

Title: Common Data Model - Our new buddy for Data Governance

Title: The Jupyterian Snake Invasion: Intro to Jupyter Notebooks, Python, Azure and Beyond [VIDEO]

Title: Data Privacy and Data Security in a Data-Driven world

Title: Reporting Services Tips, Tricks, Templates and Considerations

Title: Protect your Data by Design: Creating a Data Masking Strategy

Title: Enterprise Power BI - Development Lifecycle [VIDEO]

Title: Certificates and EXECUTE AS - Putting Permissions Inside Stored Procedures

Title: Grabbing the brass ring: tools for better self-advocacy in the tech workplace

Title: Essential Linux skills for SQL Server DBAs

Title: Enterprise Row Level Security in SQL Server and Power BI [VIDEO]

Title: Theory Driven Data Science: Cyber-security Improvement using SQL, R and machine learning [Video]

Title: SQL for Product Mangers and Business Line Managers

Title: Using Clustered Column Store Indexes at Scale

Title: Windowing Functions: Shedding some light

Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming

Title: Talend - Delivering Trusted Data at Speed

Title: Locks? We don’t need no stinkin’ locks!

Title: Lightning Talks Session 2

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

Title: Lightning Talks - Session 4

Title: Becoming Data-Driven with Snowflake

Title: Tips and Tricks for the PowerShell DBA [VIDEO]

Title: Code Your Report Environment

Title: Power BI - Ask Microsoft Anything

Title: Lightning Talks - Session 5

Title: SQL Server Management Studio - Beyond the basics

Title: Lightning Talks Session 3

Title: Get Faster Queries with Better Statistics Management

Title: Azure SQL Database Edge - Tiny but mighty

Title: Power BI: From Zero to 101

Title: Intro to Azure Data Studio

Title: What is Power BI?

Title: Interject - Are you prepping for the Data Apocalypse?

Title: PowerBI Model Designs Techniques

Title: OH22 - Data Quality in Action

Title: BI in Modern Excel: The value is in the Refresh

Title: Mastering your Resume Interview: Tips to Get Hired

Title: Marquam - How to Make Beautiful Dashboards in Power BI

Title: Lightning Talks Session 1

Title: Continuous Intelligence… Is it all about automation?

Title: Introduction to GitHub

Title: What is DevOps and Why Should DBAs Care? [VIDEO]

Title: VMWare - Virtualizing SQL Server on vSphere

Title: The SQL Server Performance Tasting Menu

Title: Defining What’s Normal – The Basics of Database Normalization

Title: Introduction to AI

Speakers

Sponsors