SQLSaturday #807 - Redmond 2019

Event Date: 04/27/2019 00:00:00

Event Location:

Microsoft Building 92
15010 NE 36th St,
Redmond, Washington

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: Everlasting Issues with Temporary Tables and tempdb

Abstract: Tempdb has been a source of configuration confusion since the very first version of SQL Server. Each SQL Server instance only has one tempdb database used by all users in all databases. In this session, we’ll look at all the different uses of tempdb and how to configure your tempdb to support them. We’ll look at all the different kinds of temporary tables and see when you should use each type. We’ll talk about the difference between global and local temp tables, table variables and work tables. We’ll explore the various tools available that let you monitor the use (and abuse) of your tempdb database and we look at some best practice guidelines for how to keep your tempdb as healthy as possible.

Speaker(s):

Kalen Delaney

Track and Room: Application Database Development - Nexus 2340

Title: Why Solidity is Solid – Basics of Ethereum, Smart Contracts, and Blockchain.

Abstract: If you are into Ethereum or any latest Blockchain platform you may know the availability of “smart contract language (SCL)” comes easily. In this foundational quick talk, I will be introducing my audiences to a newer coding platform in Blockchain. We know that any RELATIONAL language/platform is legacy and solid when it comes to prevalence. But if you are open to experiment and broaden your understanding to a Blockchain world with the new-cutting-age-y languages, feel free to join my session. Topics that I will cover in this session –

What is Ethereum Blockchain (A, B, Cs of it.)
Overview of NEO platform Solidity language
What are ‘Smart Contracts’
Python, C++ Vs Solidity, Language of Smart Contract
Last but not least, if you attend my session and do NOT understand ‘a thing’ I am speaking; you will still get a ton of ‘reference materials’ that I have been gaining from many over-priced Blockchain courses conducted by multi-millionaires, geeks.

Speaker(s):

Swagatika Sarangi

Track and Room: Information Delivery - Stinger 2400

Title: Better Query Performance from Proper Statistics Management

Abstract: When the SQL Server optimizer evaluates a query to determine how best to execute it, the statistics are quite possibly the most important tool at its disposal. But SQL Server statistics objects aren’t perfect because they only contain estimated summary information. In this session, we’ll start with an overview of what the statistics objects are, how the optimizer uses them, and some general guidelines for their maintenance. Then we’ll look at some of the issues, how to find them, and how to solve them, that can arise due to their imperfection: ascending keys (the most prevalent statistics based performance killer?), skewed distribution, or downright bad summary information. There’ll be many examples, and even a stored procedure to help you find ascending keys. By applying the techniques we’ll discuss, you WILL see improved query performance.

Speaker(s):

Vern Rabe

Track and Room: Application Database Development - Normandy 2350

Title: Using Columnstore indexes in Azure DevOps Services. Lessons learned

Abstract: The Analytics service in Azure DevOps Services provides all-over insights to your DevOps data: work item tracking, CI/CD pipelines, testing process etc. Built on top of columnstore indexes, the Analytics service has to deal with 100s of millions records and daily growth in 10s of millions, only a few minutes delay from operation store, sub second query performance for in-product experiences as well as 3rd party extensions, Power BI integration and ad-hoc queries. Working on it, I’ve learned a lot of DOs and DON’Ts about columnstore indexes. Session covers how to:

partition columnstore indexes in a multitenant environment
maintain columnstore indexes in case of updates and/or purge to keep segment elimination possible
evolve database schema without downtimes and maintenance windows
design to benefit from predicate and aggregation pushdown
deal with edge case like ad-hoc queries for raw data and paging
choose between CCI and NCCI based on usage patterns

Speaker(s):

Konstantin Kosinsky

Track and Room: Application Database Development - Normandy 2350

Title: T-SQL Habits and Practices That Can Kill Performance

Abstract: All too often we are on a project or given a task where the time or financial constraints require us to develop T-SQL “quick-and-dirty”. Or maybe we have been tasked with quickly improving the performance of some existing T-SQL. These situations often lead to code that later needs to be tuned for better performance. Wouldn’t it be nice if we could satisfy those tight time constraints while also avoiding many of the pitfalls that later plague performance? In this session we will see ten common T-SQL writing habits that contribute to poor performance. We’ll see WHY each of these patterns can have such negative impact on performance, including examples, and we’ll see one or more alternatives for each that don’t have the same negative impact. Armed with this knowledge, you will definitely impress your boss with your ability to create fast T-SQL within tight time constraints, and also quickly fix existing T-SQL code. Enjoy the merit raise you’ll get due to your new tuning talents.

Speaker(s):

Vern Rabe

Track and Room: Application Database Development - Normandy 2350

Title: RC, SI, and RCSI -It’s So Confusing. Which Should You Use?

Abstract: I’m just going to say it straight out. I’m pessimistically optimistic that most really understand transaction concurrency in SQL Server. There is often significant confusion about transaction concurrency and contention options available to Developers -is it ‘pessimistic’, or ‘optimistic’, or in between? Everyone ‘sort of’ understands READ COMMITTED (RC). But do you sometimes feel ‘dirty’ as you attempt to ‘repeatedly’ read that phantasma? In order to reduce locking and blocking conflicts, some folks adopt SNAPSHOT ISOLATION (SI). And a few hardy stalwarts have ventured into the new world of READ COMMITTED SNAPSHOT ISOLATION (RCSI). In this session, we will explore the differences between the three, including a discussion about the positives and negatives of each option. We will discuss the effects of ‘Dirty’, ‘Repeatable’ and ‘Phantom’ reads, and why you may want to know which may be buried in your code. There will be code examples demonstrating the benefits and traps of each option.

Speaker(s):

Arnie Rowland

Track and Room: Application Database Development - Stinger 2400

Title: Querying Semistructured Data in Azure Data Lake with USQL

Abstract: Data is exploding across enterprises. Much of it is semi-structured junk. Or is it junk? What are you going to do with it until you can find out? Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data. When you are ready, you can query that semi-structured data using an ANSI SQL language called U-SQL. In this session I will demonstrate the similarities and differences between U-SQL and T-SQL. I will demonstrate how easy it is to build a query against 21 GB of CSV files. Such queries can help you determine whether you have a gold mine in your data or a bunch of garbage before investing in a full data warehouse build.

Speaker(s):

Russel Loski

Track and Room: Cloud Application Development Deployment - Nexus 2340

Title: Large-scale graph querying and analytics with SQL Graph

Abstract: SQL Server 2017 and Azure SQL DB introduced capabilities to store and query directed graphs in the database, with further improvements in SQL Server 2019 and recent Azure SQL DB releases. As with any new feature, scalability is a top question. In this session, we will demonstrate the features and scalability of SQL Graph by using a publicly available graph dataset: the Open Academic Graph - OAG - (https://www.openacademic.ai/oag/). The OAG graph includes over 166 million academic publications and over 1 billion citations. We show you how to efficiently import such large-scale graphs into SQL and then fully leverage the SQL Graph features to accomplish common graph query tasks (finding citations) and advanced analytics (PageRank, Shortest Paths etc.) on this large-scale graph. After this session, you will be amazed by the functionality, performance and scalability of SQL Graph!

Speaker(s):

Arvind Shyamsundar

Track and Room: Application Database Development - Gandalf 2390

Title: Prevent Presentation Paralysis

Abstract: Stop fretting about giving presentations -you CAN decide to become more confident, come across more polished, and actually present with authority. In this session, you will learn and pick up some great tips about how to better prepare, and then present, technical material. You WILL leave with an improved sense of possibility!

Arnie will guide you with techniques to better understand and match the audience’s expectations to your presentation goals. You will gain a better understanding of how to prepare your presentation, as well as how to get, and hold the audience’s attention. And even how to be more relaxed with the inevitable critique from colleagues. Ramp up your career. Don’t miss this session!

Speaker(s):

Arnie Rowland

Track and Room: Professional Development - Stinger 2400

Title: Managing ETL Change using BIMLScript

Abstract: You develop an SSIS package to load a flat file. You meticulously identify each of the columns and map the columns to the target table. Your package runs fine for months. Then the file format changes. It is back to the drawing board, selecting each column, setting the data types (type, length, etc.). In many cases, you actually have the file structure in an electronic form. Wouldn’t it be nice to simply regenerate your SSIS package using that metadata?

In this session I will demonstrate how to automate the generation of SSIS packages using the open source BIML and BIMLScript.

I will then demonstrate how to use this technique to handle changes in file structure. I will generate an SSIS package from a simple Excel workbook I will represent the structure of a flat file and its relationship to a staging table.

Finally, I will use BIMLScript to handle changes from one version of SSIS to the next and from SSIS to Azure data factory.

Speaker(s):

Russel Loski

Track and Room: BI Platform Architecture, Development Administration - Nexus 2340

Title: Everything You Need to Know About SQL Server Indexes

Abstract: You probably already know that indexes make your queries go faster. But do you know all the different types of indexes in SQL Server and when to use them? Also with each new release of SQL Server, there are new features that can impact how indexes function and are maintained. Finally, knowing how the different types of indexes work can help you make better indexing choices when tuning your queries. This presentation will review current SQL Server index structures and options, discuss how they work, when they should be used and how to maintain them. Examples of all the index types such as hash, in-memory, columnstore, filtered, etc… will be shown. This presentation is a must see for DBAs, Developers, Application Architects and anyone else who is interesting in maintaining high performance SQL Server applications.

Speaker(s):

Janis Griffin

Track and Room: Application Database Development - Nexus 2340

Title: A Beginner’s Guide To Plan Guides

Abstract: Even with the increased simplicity of plan forcing using Query Data Store in SQL Server 2016 and above, plan guides remain a very powerful but often overlooked feature of SQL server. There is a misconception in the community that plan guides are really only useful for situations where the DBA “cannot change the code” but actually plan guides have much broader applicability than simply fixing problems with poorly designed ISV code. However, for the DBA, working with plan guides can often be a confusing and frustrating experience.

In this session we will cover what plan guides are, how they work and demonstrate scenarios where they can be successfully used to solve a number of problems DBAs experience on a day to day basis.

Speaker(s):

Brian Carrig

Track and Room: Enterprise Database Administration Deployment - Odyssey 2410

Title: Controlling Competing Workloads with SQL Server Resource Governor

Abstract: With heavily consolidated instances and competing workloads, the Enterprise only Resource Governor feature is an incredibly useful tool for any DBA to have in their toolbox. It allows for the effective throttling and control of CPU, memory and I/O consumed by multiple workloads running on a single SQL Server instance. In this session, we will cover the fundamental concepts of the SQL Server Resource Governor and provide demonstrations of practical scenarios where Resource Governor can control resources for specific workloads. Some of these demonstrations include how to limit the amount of memory consumed by memory-optimized tables and how to prevent poorly-written queries from overwhelming your storage subsystem. We will also discuss cases where Resource Governor can mitigate parameter sniffing problems. Finally, we will look at ways to leverage the useful information contained in the Resource Governor DMVs for monitoring and reporting.

Speaker(s):

Brian Carrig

Track and Room: Enterprise Database Administration Deployment - Normandy 2350

Title: Protect Your SQL Server Data with Static Data Masking

Abstract: Are you providing adequate protection to your sensitive and confidential data? I’m sure we all do our best to protect our confidential data in a production environment by allowing only approved methods to access production data. But how are you protecting your development and testing environments when they contain copies of production databases? In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by development and testing must not contain private and sensitive data from production databases. In this presentation, Greg will demonstrate using a new feature of SQL Server Management Studio (SSMS) called Static Data Masking to protect your sensitive/confidential data when copying production databases to your development and testing environments.

Speaker(s):

Greg Larsen

Track and Room: Application Database Development - Origami 2370

Title: Demystifying Chart Types and Report Design Principles in Power BI

Abstract: Failing to deliver a well-designed Power BI Report can be a common reporting pitfall. What good is quality data if it is not presented in a way that is meaningful or easily understood? Someone without any prior knowledge should be able to quickly understand a report without explanation and be quickly drawn to the key elements you want them to view. This talk will walk through many elements of bad report design. Learn about visual cues and how certain chart types can convey data more accurately than others. Also, learn about the basic dos and don’ts of report design and layout, using easy-to-learn techniques that bring data to life.

Speaker(s):

Reid Havens

Track and Room: Analytics and Visualization - Nexus 2340

Title: Real-World AI in Azure

Abstract: Discover the ways Azure transforms AI and Predictive Analytics making it easier and more accessible through services like Azure Machine Learning and pre-built Cognitive Services, while also supporting custom development and deep-learning. Discussion of real-world scenarios and the tools used to solve them.

Speaker(s):

Amie Mason

Track and Room: Advanced Analysis Techniques - Gandalf 2390

Title: Practical Visual Guidance for PowerBI

Abstract: Building data visualizations is about data-driven decision support or simply answering a business question. How do we make our report answer this question at a glance? When we are building the reports, how do we fit them to different platforms in PowerBI? Implementing UI/UX rules and best practices when designing a PowerBI report

Attendees are welcome to bring a laptop with PowerBI desktop installed and a sample Microsoft dataset downloaded - https://docs.microsoft.com/en-us/power-bi/sample-datasets Customer Profitability sample and HR sample

Speaker(s):

Yana Berkovich

Track and Room: BI Platform Architecture, Development Administration - Trident 2320

Title: Power BI Administration to Optimize your Premium Services

Abstract: In this session, attendees will learn a few things:

What is Premium Capacity
How to read use the Capacity Management App ( understand bad vs. good )
How to customize this App to highlight data-sets that are performing the worst!

If you are a premium user, a Power BI Service Admin, or just interested in premium capacity - you don’t want to miss this session!

Speaker(s):

DeNisha Malone

Track and Room: BI Platform Architecture, Development Administration - Trident 2320

Title: SQL Server 2019 Big Data Clusters

Abstract: This talk shows how to use Kubernetes to analyze both high-volume data on HDFS, and high-value, very recent relational data in SQL Server. In the demo, we’ll work with a time series dataset (1 billion rows) of 26,000 marine vessels in the Northwest from 2015 to 2017 to understand shipping patterns and improve safety. We’ll do data prep with Spark, spatiotemporal analysis with R, and model serving with SQL Server.

Speaker(s):

Rock Pereira

Track and Room: Advanced Analysis Techniques - Normandy 2350

Title: Azure SQL DW: Optimization Technics to Maximize Performance

Abstract: Azure SQL DW is powerful MPP cluster for processing a big amount of structured data. But, it still requires optimization to maximize performance and optimize resource usage. Some technics almost similar to what we do with our regular SQL Server, some of them not due to MPP architecture. In this session, I will cover next topics:

how to minimize the time of data loading
how to choose a right distribution type
data movement minimization
how scaling and resource class could help to improve data processing performance
maximize Column Store index performance
update statistics
partitioning strategy

Speaker(s):

Sergiy Lunyakin

Track and Room: Cloud Application Development Deployment - Stinger 2400

Title: Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!

Abstract: You’ve heard about Power BI, and you’ve seen it, but you haven’t yet rolled up your sleeves and got your hands dirty. It looks like it is really easy, but sometimes it helps to have someone step you through it the first time to help you hit the ground running. We will grab various public data sources, join them together in a model and build an interactive pièce de ré·sis·tance on the visual design surface!

Speaker(s):

Scott Stauffer

Track and Room: BI Information Delivery - Trident 2320

Title: PowerApps Power BI: Better Together

Abstract: Power Platform provides companies the ability to empower every employee to get insights into their data using Power BI, leveraging PowerApps to build apps to take actions and Microsoft Flow to automate their business process workflows. We will explore the wonderful ways Power BI and PowerApps can work together as part of a product. Industry related possibilities and the Power Platform on mobile will be reviewed. Examples and live demo of Power BI and PowerApps working together to support an end to end scenario for a live application.

Speaker(s):

Yana Berkovich

Track and Room: BI Platform Architecture, Development Administration - Trident 2320

Title: Predictive Analytics with R in Power BI

Abstract: Power BI reports are typically used for descriptive analysis: a historical look of what has happened. But what if your report could visualize what is likely to happen and recommend what you can do about it now? This session will cover how to shift from descriptive to predictive analysis and leverage the power of machine learning to enhance your business intelligence solutions. The basics and best practices of predictive modeling will be introduced, and these concepts will be applied to create three predictive models in R using three different techniques. We will then walk through the three different ways to integrate the predictive power of these models into a Power BI report.

Speaker(s):

Joseph Yeates

Track and Room: Advanced Analysis Techniques - Origami 2370

Title: Becoming a Master by Giving It All Away

Abstract: It has been said that “novices absorb knowledge like a sponge, intermediates hoard it for themselves, and masters just simply give it away.” The community spirit of PASS is for like-minded professionals to interact and share knowledge. But how do you do this in your own workplace? IT people are notorious about being siloed and not sharing their knowledge. That may be, but you have to move past all of that in order to truly move forward in your career and your life. There are many barriers in place to giving away your knowledge, but we will help you be ready to do so. The only way to truly become a master at your craft is to share your precious knowledge with your peers and workmates. We will discuss past and new trends in learning and knowledge transfer, the reasons why you should pass on knowledge, and methods for making this happen in your workplace and in your life. By passing on your knowledge, you are leaving behind a legacy that extends beyond your tenure at an organization

Speaker(s):

Michael Wall

Track and Room: Professional Development - Odyssey 2410

Title: Build a blog worth reading

Abstract: Creating a blog worth reading is no easy task. It’s a fine balance between consistency, topic choice, readability and SEO magic. Join marketing expert Blythe Morrow as we discuss how to build content for technical audiences that generates reads that connects you deeper into the SQL Server Community. Learn what it takes to eliminate confusion for your readers and connect people in a way that solves their problems. We’ll also have a cameo or two from SQL celebrity bloggers who can lend advice and tips.

Speaker(s):

Blythe Morrow

Track and Room: Professional Development - Odyssey 2410

Title: Managing Table Partitions at the Extremes

Abstract: SQL Server’s table partitioning gets interesting at the extremes: namely the initial (often “before”) partition, as well as the last (often “future”) partition. In this session you’ll learn how to manage partitioned tables at these extremes based on choices concerning the partition key, files and filegroups, archiving, and adding future partitions.

Speaker(s):

Ron Talmage

Track and Room: Enterprise Database Administration Deployment - Gandalf 2390

Title: SQL 101: A Very Good Place to Start

Abstract: We’ll use Azure Data Studio to dive into the basics of T-SQL queries. In this interactive, all-demo session I’ll take you on a tour of basic queries and filter operators as we build out some single table queries and multi-table joins. We’ll also cover some basic data aggregations and talk a little bit about what the SQL query optimizer is doing under the covers to return your results as quickly as possible.

Speaker(s):

josh smith

Track and Room: Enterprise Database Administration Deployment - Origami 2370

Title: Machine Learning – Classification

Abstract: As a data analyst, you need to analyze data and address business problems. In order to make your analysis have more impact, you can use machine learning to understand data correlation and predict business trends based on past patterns.

Through my presentation, I will talk about the classification problem in machine learning and how machine learning improves the business.

Speaker(s):

vinh vu

Track and Room: Analytics and Visualization - Gandalf 2390

Title: Azure SQL DWH: Tips and Tricks for developers

Abstract: Azure SQL DWH is based on MS SQL Server and supports T-SQL. It helps to DB/DWH developers start using it without many efforts. Unfortunately, there are several limitations that could bring difficulties in your job. For example, we can’t use MERGE statement for Upsert tasks in DWH, there is no IDENTITY or SEQUENCE, differences in implementing partition switching and so on. In this session, I’m going to cover several tips and tricks how we can handle with this limitations using available possibilities.

Speaker(s):

Sergiy Lunyakin

Track and Room: BI Platform Architecture, Development Administration - Stinger 2400

Title: Tell a Story with Data in Power BI

Abstract: Got lot’s of data, but not sure what to do with it?

This session will give you the steps to get the most insightful story from you dataset! We will also review Power BI Best Practices for everyday developers

Speaker(s):

DeNisha Malone

Track and Room: BI Information Delivery - Trident 2320

Title: How to write a Kicka** anything

Abstract: If you want to communicate your technical knowledge or want people to actually your emails, you’re going to need strong written communication skills. Writing is something most of us do every day, but it’s a difficult skill worth mastering. Join Blythe Morrow, Data Platform Marketer and life-long communicator, for a tips and tricks session that will take your written communication to the next level. We’ll review the most common business communication mistakes and learn a few tips to make your words stand out.

Speaker(s):

Blythe Morrow

Track and Room: Professional Development - Odyssey 2410

Title: Keys to Successfully Governing Power BI for your Organization

Abstract: Discussion of the best practices and considerations for security, governance, and administration of Power BI. Not only of the available options, but tips and tricks for how to navigate those options and set yourself and your organization up for success down the road.

Speaker(s):

Amie Mason

Track and Room: Analytics and Visualization - Gandalf 2390

Title: Master Data Management: BI and Data Science’s Best Friend

Abstract: No matter the complexity of your BI application, Master Data Management can provide your organization the tools needed to conform, manage and simplify your dimensions. Attend this session and learn how Analytical MDM can forge quicker and more valuable insights.

Speaker(s):

John McAllister

Track and Room: BI Platform Architecture, Development Administration - Origami 2370

Title: Build ETL Patterns in the Cloud with Azure Data Factory

Abstract: Modern Data Warehouse solution patterns require moving classic DW data, processes, and methods to the Cloud and to incorporate Big Data. In this session, I will demonstrate how to accomplish those goals using Azure Data Factory.

Speaker(s):

Mark Kromer

Track and Room: BI Information Delivery - Odyssey 2410

Title: Automated tests in your database: tSQLt

Abstract: tSQLt is a database unit testing framework for Microsoft SQL Server. tSQLt is ideal for the database developer because tests are written in TSQL and is easy to use.

In this session you’ll learn how to use tSQLt to add automated tests to your database to ensure your code produces desired results even after modifications.

Speaker(s):

Janice Gerbrandt

Track and Room: Application Database Development - Origami 2370

Speakers

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

Joseph Yeates

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

LinkedIn: Joseph Yeates

Contact: https://www.feathersanalytics.com

Joseph is a data enthusiast and blogs about all things Power BI on Feathers Analytics. He has a passion for crafting compelling data narratives and making insights accessible to a wider range of users through visualization. He holds the Certified Analytics Professional designation as well as a DBA certification with a focus on SQL Server Analysis Reporting Services. He uses R Studio, Power Query and Power BI to model, manipulate, analyze, and visualize data. He integrates R into Power BI to bring the power of predictive analytics into reports and dashboards. He is a member of the Vancouver Power BI User Group and has presented on Power BI Tips Tricks and Predictive Analytics with R in Power BI.

Sergiy Lunyakin

Twitter: - slunyakin

LinkedIn: Sergiy Lunyakin

Contact: https://slunyakin.wordpress.com

Sergiy Lunyakin (MCSA, MCSE, MCTS) is a Big Data Architect at SoftServe, Inc. He has extensive experience in designing and developing Big Data Analytics, Data Warehouse, and BI solutions, using both on-premises and cloud products. In 2016, Sergiy became Microsoft Data Platform MVP and has since maintained his MVP status. Sharing knowledge is another one of his passions. He regularly speaks at international conferences such as SQLSaturday, SQLDay, SQLNexus, and SQLBits. He also runs the Lviv SQL Server User Group in Ukraine and organizes SQLSaturday Lviv.

Scott Stauffer

Twitter: - @SQLSocialite

LinkedIn: Scott Stauffer

Contact: http://scottstauffer.ca

Scott Stauffer (@SQLSocialite) is very PASSionate about data and enjoys meeting with like-minded data geeks. He started the Vancouver PASS Chapter in 2004. In 2008, Scott was recognized by Microsoft with a SQL Server MVP award. In 2009, Scott started a PASS BI Chapter in Vancouver, and was also at one time the PASS Regional Chapter Mentor for Canada. For over 10 years he has been an independent consultant working with clients to solve their data woes and extract insight from their business data.

vinh vu

LinkedIn: vinh vu

I have 3 years of experience working in data science and business analyst. Throughout my experience, I have learned to use advanced analytics, standing up big-data analytical tools, data migration, creating and maintaining models, and onboarding compelling new data sets.

Currently, I work as a data support engineer, where I am working directly with enterprise clients to resolve BI problems, bugs, and testing on Microsoft Power BI. I am also responsible for analyzing monthly reports on Microsoft Power BI Products to support developers. I completed a data science boot camp last April and I am enrolling in Master of Computer Science program in order to enhance my skills in Data science and machine learning.

Yana Berkovich

Twitter: - @Yana_Berkovich

LinkedIn: Yana Berkovich

Contact: http://yanaberkovich.com

A people-oriented professional, aspiring Product Manager, with 11 years of process analysis, building solutions, customization, developing, managing and training experience. Working with Power Bi, Oracle SQL and SQL server for the past few years. Data enthusiast with international experience in many companies as a BA, Team Lead and everything SharePoint Office 365.

Greg Larsen

Twitter: - GregoryALarsen

LinkedIn: Greg Larsen

Greg Larsen has been working with SQL Server since 1999. He has authored 100’s of articles related to SQL Server. He holds a MCSE Data Management and Analytics. Greg also a SQL Server Consultant, adjunct professor and technical writer.

Blythe Morrow

Twitter: - blythemorrow

LinkedIn: Blythe Morrow

Contact: https://paperswordb2b.com/blog/

Blythe works with a team of people who love Data Platform and technology marketing. She started 10 years ago as the Community Manager for PASS and now spends her days helping companies that build products on the Microsoft Data Platform. She offers advice to CMOs and CEOs on how to competitively position their companies, create and manage their brands, enter the digital arena and maximize marketing and sales investments.

Arnie Rowland

Twitter: - @ArnieRowland

LinkedIn: Arnie Rowland

Contact: http://sqlblog.com/blogs/arnie_rowland/

Arnie long ago realized that most issues between Developer and DBA comes from incomplete communication and a misunderstanding of each other’s objectives. He is a frequent Trainer and Mentor for Developers and DBAs, bringing both sets of skills to better communicate with teams to create a working solution. For over a decade, Arnie has been a SQL Server MVP, Certified Trainer, technical editor for several publishers, including MOC, and has served as University and Community College adjunct faculty. Clients include Fortune 500 and Multi-Nationals, Federal and State agencies, Foreign governments, and local enterprises –both public and private.

josh smith

Twitter: - sqldeployhelmet

LinkedIn: josh smith

Contact: https://accitentionaldba.com

Josh Smith is the senior-most DBA at a mid-sized credit union and leader of the Spokane Area SQL Server Users Group. He is not the most fond of writing about himself in the third person but attempts to be good natured about it. He believes strongly in participating in and contributing to the SQL Server community as much as possible.

Arvind Shyamsundar

Twitter: - arvisam

LinkedIn: Arvind Shyamsundar

Contact: http://aka.ms/arvindsh

Arvind is a Principal Program Manager (Microsoft Azure Data) working on the Azure SQL DB and Hyperscale services. Arvind is passionate about sharing his knowledge and learnings - as well as automating troubleshooting and diagnostics as much as possible. Much of his work is available on GitHub (https://github.com/arvindshmicrosoft/) and his blog (http://aka.ms/arvindsh/). Arvind is also an #MCM4Life and has previously worked as a Principal PFE within Microsoft Services.

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.

Russel Loski

Twitter: - sqlmovers

LinkedIn: Russel Loski

Contact: http://www.sqlmovers.com

Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.

Reid Havens

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

LinkedIn: Reid Havens

Contact: http://www.havensconsulting.net/blog-and-media/

Reid Havens is the founder of Havens Consulting Inc. He has a formal background in technology and organizational management, having obtained separate Master’s Degrees in Organizational Development and Business Analytics. Reid has experience working with many of the Fortune 50, 100, and 500 companies. Reid is also an avid content developer, having authored numerous articles and videos on various blog sites and video platforms. He’s also written multiple training curriculums, online video courses, and college level classes. Additionally, he guest lectures at the University of Washington and other universities, teaching Business Intelligence, Reporting, and Data Visualization.

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.

Swagatika Sarangi

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

LinkedIn: Swagatika Sarangi

Contact: https://www.jazzintelligence.com/

** AWS - SA Informatica - MDM Certified, Solutions Architect **

I have had nearly a decade of experience in leading Data Governance, Master Data and Data Quality oriented efforts, strategizing business plan, implementing all phases of SDLC and Agile for clients/projects including Telecommunication, Oil Gas, Sporting goods, Logistics, Consulting, Insurance, Restaurant Education etc. domain. I have extensive experience with developing effective business roadmaps and business models across E-Commerce, B2C, B2B, B2B2C with a major focus in effectively evaluating/and aligning Business Intelligence Analytics Data Warehousing with the appropriate KPI’s.

Arnie Rowland

Twitter: - @ArnieRowland

LinkedIn: Arnie Rowland

Contact: http://sqlblog.com/blogs/arnie_rowland/

DeNisha Malone

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

LinkedIn: DeNisha Malone

Contact: https://www.denisham.com

DeNisha fell in love with data modeling and management while tutoring T-SQL Querying in college. She self-taught herself Power BI’s functionalities after a Business Intelligence internship in fall of 2015 - and has been sticking with the development of Microsoft’s BI suite ever since; growing tremendously as the application spreads through enterprises.

Outside of BI, her hobbies include mentoring and working with non-profits to enhance IT in the minority communities.

Ron Talmage

LinkedIn: Ron Talmage

Ron Talmage is database administrator with B3 Group, Inc, on a major healthcare data warehouse. He is also a mentor and co-founder with SolidQ. He is a former SQL Server MVP and chapter leader of the Pacific Northwest SQL Server Users Group. He has authored numerous SQL Server white papers and contributes to SQL Server technical publications.

Amie Mason

LinkedIn: Amie Mason

Consultant with a demonstrated history of working with clients across multiple verticals to leverage their data to improve reporting and decision making in their business. Able to quickly assess business requirements and skilled in report design and predictive analytics enabling a direct translation from those requirements to business impact. Broad background includes experience in the public sector, survey design, and grassroots campaign management.

Yana Berkovich

Twitter: - @Yana_Berkovich

LinkedIn: Yana Berkovich

Contact: http://yanaberkovich.com

Konstantin Kosinsky

Twitter: - kkosinsky

LinkedIn: Konstantin Kosinsky

Konstantin is an industry expert who loves optimizing the performance at least in 10x. More data - more fun. Konstantin is a Principal Software Engineer at Azure DevOps Services, where he works on moving the Analytics for software engineering to a completely new level.

Konstantin was born and had been working in Ukraine for a long time, passionately sharing his knowledge with Ukrainian and other European data communities. Before joining Microsoft in 2012, he was a Data Platform MVP for many years.

Sergiy Lunyakin

Twitter: - slunyakin

LinkedIn: Sergiy Lunyakin

Contact: https://slunyakin.wordpress.com

Brian Carrig

Twitter: - @briancarrig

Brian Carrig is a Microsoft Certified Master of SQL Server and is currently a Senior Program Manager on the SQL Server Tiger Team at Microsoft focusing primarily on persistent memory technology and replication. In a previous life, Brian spent some time as an academic and holds a PhD in Computer Science. He is a native of Dublin, Ireland but now lives with his wife and two daughters in Redmond, Washington. If he is not talking about, thinking about or working with technology you will usually find him watching Chelsea FC.

Brian Carrig

Twitter: - @briancarrig

Russel Loski

Twitter: - sqlmovers

LinkedIn: Russel Loski

Contact: http://www.sqlmovers.com

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

Blythe Morrow

Twitter: - blythemorrow

LinkedIn: Blythe Morrow

Contact: https://paperswordb2b.com/blog/

Janice Gerbrandt

Twitter: - @gerbyj

LinkedIn: Janice Gerbrandt

Contact: https://islandsql.com/

Janice has been designing and implementing database solutions to improve business functionality since 2001. She is an active PASS member and leads her local user group and a virtual group, as well as organizing SQLSaturday Victoria.

Amie Mason

LinkedIn: Amie Mason

John McAllister

LinkedIn: John McAllister

Contact: http://www.profisee.com

John McAllister co-founded Stratature, an Independent MDM software vendor, in 2001. Following Microsoft’s acquisition of Stratature in 2007 John served as Group Program Manager for MDS and oversaw the incorporation of MDM into SQL Server. John now serves as the Regional Sales Director for Profisee, Inc. which provides enterprise-class MDM Solutions built on top of Microsoft’s MDS offering. John has worked with 100’s of organizations around the world in all phases of MDM projects.

Kalen Delaney

Twitter: - sqlqueen

Kalen Delaney is a Data Platform MVP who has worked with SQL Server for more than 32 years. She has provided performance consulting services and taught advanced courses on SQL Server to thousands of people and organizations. In addition to her courseware development, Kalen has been writing about SQL Server for decades. She is the primary author of SQL Server Internals and the Inside SQL Server series. Kalen is also one of the primary editors for the Red Gate SQL Server Stairways tutorials.

Rock Pereira

Twitter: - _rockper

LinkedIn: Rock Pereira

Rock Pereira is a data scientist. He has worked in medical research, pharma finance. At Seattle CodeCamp he presented “Kubeflow - Machine Learning with Kubernetes”. He codes in Python, R and Julia and experience with Azure, AWS GCP.

DeNisha Malone

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

LinkedIn: DeNisha Malone

Contact: https://www.denisham.com

Outside of BI, her hobbies include mentoring and working with non-profits to enhance IT in the minority communities.

Vern Rabe

Twitter: - @VernRabe

LinkedIn: Vern Rabe

Contact: http://www.rabedata.com

Mark Kromer

Twitter: - @kromerbigdata

LinkedIn: Mark Kromer

Contact: http://www.kromerbigdata.com

Mark Kromer is a Microsoft Cloud Data Solution Architect with 20 years of experience in database applications, data warehouses, big data and business intelligence.

SQLSaturday #807 - Redmond 2019

Sessions

Title: Everlasting Issues with Temporary Tables and tempdb

Title: Why Solidity is Solid – Basics of Ethereum, Smart Contracts, and Blockchain.

Title: Better Query Performance from Proper Statistics Management

Title: Using Columnstore indexes in Azure DevOps Services. Lessons learned

Title: T-SQL Habits and Practices That Can Kill Performance

Title: RC, SI, and RCSI -It’s So Confusing. Which Should You Use?

Title: Querying Semistructured Data in Azure Data Lake with USQL

Title: Large-scale graph querying and analytics with SQL Graph

Title: Prevent Presentation Paralysis

Title: Managing ETL Change using BIMLScript

Title: Everything You Need to Know About SQL Server Indexes

Title: A Beginner’s Guide To Plan Guides

Title: Controlling Competing Workloads with SQL Server Resource Governor

Title: Protect Your SQL Server Data with Static Data Masking

Title: Demystifying Chart Types and Report Design Principles in Power BI

Title: Real-World AI in Azure

Title: Practical Visual Guidance for PowerBI

Title: Power BI Administration to Optimize your Premium Services

Title: SQL Server 2019 Big Data Clusters

Title: Azure SQL DW: Optimization Technics to Maximize Performance

Title: Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!

Title: PowerApps Power BI: Better Together

Title: Predictive Analytics with R in Power BI

Title: Becoming a Master by Giving It All Away

Title: Build a blog worth reading

Title: Managing Table Partitions at the Extremes

Title: SQL 101: A Very Good Place to Start

Title: Machine Learning – Classification

Title: Azure SQL DWH: Tips and Tricks for developers

Title: Tell a Story with Data in Power BI

Title: How to write a Kicka** anything

Title: Keys to Successfully Governing Power BI for your Organization

Title: Master Data Management: BI and Data Science’s Best Friend

Title: Build ETL Patterns in the Cloud with Azure Data Factory

Title: Automated tests in your database: tSQLt

Speakers

Sponsors