Event Location:
Saint Paul College
235 Marshall Avenue
Saint Paul, Minnesota
Abstract:
Your application developers benefit from Continuous Integration and Continuous Deployment practices to accelerate feature deployment and catch regression issues up front, but your database deployments are still stuck in the proverbial dark ages. The build scripts might be in source control or even an SSDT project already, but deploying is still an exercise in creating the perfect script, and don't even think about making a data (or data type) change! SSDT and Azure DevOps can solve some of these problems, and even give us a window into the world of automated testing. In this talk, we will explore how to automate your database builds and deployments using SSDT and Azure DevOps, and we will explore automated testing using tSQLt and Docker. Lastly, we will check up on some tasks that you cannot (or should not) automate and talk about how to make sure your application developers are not left behind.
Speaker(s): Dan Mallott,
Abstract:
Have you tried implementing source control? How has your continuous integration (CI) process gone? This session is for developers, database administrators, database engineers, and data architects that want to automate their database deployments. Particularly for those individuals that have hit roadblocks along that way. We will discuss the differences between migration and stated-based deployment methods. We will also discuss options with branching and merging. At the end of the session, attendees will know how to select the best deployment method for their environment. In addition, attendees will be familiar with branching and merging strategies that can be used as part of their continuous integration strategy. Attendees should be familiar with general concepts about source control and be comfortable with Visual Studio or VS Code.
Speaker(s): Elizabeth Noble,
Abstract:
Security, cost, and capabilities are the key questions for any Azure project. Nothing should be implemented today without a tested security surface. Creating a strong and flexible identity perimeter will allow for secure access. Platform security will create a secured perimeter for all of your cloud resources from Virtual Machines and Networks to resource locks and permissions. Manage customized security alerts, and configure a playbook for specific threats. Configure security for data infrastructure, and data encryption at rest. Implement security for applications such as certs, monitoring, and security baselines. Data and applications will not last long if costs are not managed from the beginning. You will need to monitor and analyze the cost of your Azure resources as soon as development begins. Azure Cost Management allows you to create a budget. The biggest factor in security, and cost management is implementing the right capabilities to support your business requirements.
Speaker(s): Ross McNeely,
Abstract:
Do your users complain about slow reports? Are your database servers overwhelmed during times of high usage? Every SQL Server environment can benefit from performance tuning whether your environment has one server or thousands. In this full-day session you will learn about how identify problems using a wide variety of tools and scripts and how to implement best practices across your environment. Additionally, you will learn how to begin reading execution plans and how to tune queries to improve your performance within SQL Server. You will walk away with a list of items to evaluate in your environments and ways to resolve common issues. This session will guide you through real-life performance problems which can be solved by best practices and practical skills. Taught on a level anyone can understand, this session will focus on Microsoft SQL Server 2016 and forward.
Speaker(s): Monica Rathbun,
Abstract:
If your boss asked you for the list of the five most CPU-hungry databases in your environment six months from now for an upcoming licensing review, do you have an answer? Performance data can be overwhelming, but this session can help you make sense of the mess. Twisting your brain and looking at the data in different ways can help you identify resource bottlenecks that are limiting your SQL Server performance today. Trending this data over time will help you project how much resource consumption you will have months away. Come learn how to extract meaning from your performance trends and how to use it to proactively manage the resource consumption from your SQL Servers.
Speaker(s): David Klee,
Abstract:
Automated machine learning simplifies the traditional machine learning process () by creating models with applying hyperparameter settings, and different algorithms. Also, choosing the best models among them based on the performance of each algorithm. Moreover, it provides more detail about the experiment and how much time has been spent to run each iteration and so forth. In this one hour session, an overview of what is Automated Azure ML will be provided, the latest updates of this products will be shown and the audience will learn how to set up the environment and how to use the mode in Power BI services and SQL Server.
Speaker(s): Leila Etaati,
Abstract:
There is a huge need to use AI and ML in Power Platform to get more insight from data, create smart applications and so forth. In a one day workshop, the process of using AI and ML in Power BI desktop and Power BI Service using Cognitive services, Azure ML Studio, AutoML will be discussed. Next, AUdience will learn how to use AI and ML inside Power Apps and Microsoft Flow to access more insight from the data they have and to create smart applications. In general, new features and tools in Microsoft Machine learning in Power BI, Microsoft Power Apps, and Flow will be shown. Some parts of this workshop are hands-on.
Speaker(s): Leila Etaati,
Abstract:
With the smorgasbord of Azure service available, how do you approach building a modern enterprise data warehouse? In this pre-con we will be covering both architecture patterns from Microsoft and actual implementations in the industry on how to move to Azure for your data warehousing needs. We'll cover the various offerings of Azure including storage, data ingestion and orchestration, databases , NoSQL, and streaming. We'll also cover how to analyze all of this data with tools and services like Power BI and Databricks. Finally, we'll cover strategies on how you get there; Lift-and-shift, hybrid, or brand new implementations will all be discussed. By the end of this pre-con you should have a thorough understanding of architecting a modern enterprise data warehouse in Azure including getting those services to work together and how to use that data effectively!
Speaker(s): Matt Stenzel,
Abstract:
Environment setup in some organizations can take days and even then it is not consistent and has components missing or configured incorrectly. These problems can be solved and this session will cover several techniques for doing just that. In this session we will use Docker to create 3 SQL environments. The first is a production like environment for UAT. In the second environment will redact the confidential data and in the third environment reduce the dataset by 90%. This three tiered environment setup can work with or without Docker. In this session we will also cover using Chocolatey NuGet's, which sounds tasty, but it is also a very powerful method of installing software on Windows.
Speaker(s): Adam Anderson,
Abstract:
Large tables in SQL Server present challenges on several fronts. For query performance, avoiding accessing data unnecessarily becomes more important. For ETL, loading and modifying data while utilizing compute resource and avoiding lock contention becomes more difficult. For maintenance, making efficient use of resources and time presents challenges. In this session, we will introduce the core concepts of partitioning in SQL Server -- partitioning columns, partition schemes, and partition functions. We will configure heaps, rowstores, and columnstores as partitioned tables, and execute queries to compare how they access data. Finally, we will work with the requirements for switching partitions in and out of tables. After this session, you will be able to configure partitioned tables, explain how partitioning affects query execution, and switch partitions in and out of tables.
Speaker(s): Kevin Krenz,
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,
Abstract:
In this one day workshop, you will learn Power BI modeling and data preparation from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about using Power Query and the formula language (M) for data preparation and transformation. You will also learn about relationships, and modeling in Power BI, and DAX which is the calculation engine for Power BI. This course is full of live demos of real-world challenges of data modeling and how to solve it using Power BI. Modules include, but not limited to: Module 1: Data preparation using Power Query Module 2: Advanced Data transformations Module 3: M: Power Query formula language Module 4: Data Modelling in Power BI, Everything you need to know about Relationships Module 5: DAX and Calculations in Power BI This is a data modeling module of the world-famous Power BI training from Rookie to Rock Star by the book author; Reza Rad.
Speaker(s): Reza Rad,
Abstract:
Data systems administrators pride themselves on their ability to dig deep into the weeds of their systems and get to the root of problems. However, when it comes time to explain a complex or intermittent issue, we find that others don’t enjoy those weeds. Ever wish you could draw a better picture of what’s going on? Enter Power BI! This tool is beloved by many analysts and developers but it can transform more than just OLTP data. Attend this session to learn how you can use quick models in Power BI against administrative data such as the SSRS execution log, SQL Server Extended Events, XML JSON files, query performance data, and even those random Excel files you get from vendors. You’ll leave this session with the skills you need to survey your domain from a new angle and communicate what you learn to your organization.
Speaker(s): Gina Meronek,
Abstract:
Are you new to Power BI? Are you looking to extract insights from your Google Analytics and Google Ad Words data? I will walk you through the underlying architecture of Power BI and basic Dax all the while in building a Power BI marketing report for your Ad Words and website data. The attendee will leave the class ready to start using Power BI for their Marketing Dashboards.
Speaker(s): Craig Johnson,
Abstract:
Implementing a Power BI solution is not just about the report development, dashboard design and DAX queries. Designing the right architecture is an essential part of a Power BI implementation. There are many areas to consider when you are designing a Power BI architecture. From sharing reports and security to the type of connection and usage of other components such as Dataflow. Come to this session to learn about important things you need to know about the architecture of a Power BI solution. You will learn some blueprints of what are key things to consider and how to design the architecture for your solution.
Speaker(s): Reza Rad,
Abstract:
In this session, geared toward beginner level users, attendees will be introduced to SQL Server Reporting Services (SSRS) as a tool for customized reporting. We will first review the SSRS workspace in Visual Studio 2017 to familiarize users with the various components that can be used when building reports. We will then look at a few examples of reports to see some of those components in action, focusing on the usage of parameters and expressions to provide flexibility, before finally building a sample report together. We will conclude by walking through the deployment process and discussing both basic and data-driven subscription options for automated report delivery. This session is designed for users with little to no familiarity with SSRS who are looking for a baseline understanding of the tool, who want to begin working more with SSRS development, or who need to support SSRS in their current role but do not know where to begin.
Speaker(s): Ashley Day,
Abstract:
DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process. In the case of SQL Server, however, a database is already in production, and isn’t simply replaced (as an app binary), but is upgraded. Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing. "Near production data" is used in Staging, and finally production is upgraded. This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process. Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages. Production database clones are delivered more quickly than "built" databases, are more easily integrated with source control, and produces higher fidelity outcomes. Learn how leading enterprises are simplifying SQL DevOps.
Speaker(s): Paul Stanton,
Abstract:
The Serverless compute tier is a new feature of Azure SQL DB. I will cover the new features that Serverless includes and go over the concepts it is built upon. There will be several demos and interactive sessions. Come excited to learn!
Speaker(s): Matt Stenzel,
Abstract:
Cross-platform and approachably extensible, Azure Data Studio is a new application for database development and management. Azure Data Studio extensions can create efficiencies by automating a workflow or integrating with an external system. This session will take the audience through the fundamentals of extension development for Azure Data Studio with Typescript and other open source tools. Our discussion will include available internal APIs, hosting your extension on GitHub, and sharing your work through the extension marketplace. By demonstrating each concept through building an extension in the session, we will end with a working extension utilizing functionality released recently in Azure Data Studio.
Speaker(s): Drew Skwiers-Koballa,
Abstract:
You know query plans can help you fix T-SQL performance issues, but maybe you aren’t sure of all the ways query plans can help. Maybe you use index suggestions, but you wonder if you could do better. Maybe you’ve never used a query plan at all. Come to this workshop and learn! Let’s roll up our sleeves and dig into some T-SQL performance work. We’ll work together to examine query plans and enhance query performance. Feel encouraged to take part in the conversation, no matter your experience level. We’re all here to learn! You’ll get even more out of the session if you bring a device that can use OpenVPN (if you have SQL Server Management Studio or another client) or remote desktop (if you don’t). You can then experiment on your own to discover suggestions for the group and see improvements for yourself. When you leave the session, you’ll have more practical ways to fix slow T-SQL the next time you run into a real-world performance problem.
Speaker(s): Andrew Brobston,
Abstract:
You know you’ve done it. Maybe it was the lucky number 7. Maybe it was an enigmatic X. Maybe you smooshed some words together in ALLCAPS. That should be easier to spot, right? Because some day you might need to change it—in every stored procedure, function, and view. Magic numbers, codes, identifiers, constants, enumerations. Whatever you call them, all applications have them. Sure it’s quick and easy to sprinkle the values throughout your code, but that breeds mistakes, rigidity, and obfuscation. There has to be a better way! Other languages give us real constants and enums—with IntelliSense and compilation-level enforcement. Well guess what-- SQL Server does too, sort of. Join us and learn to write clearer, easier to maintain code without sacrificing performance.
Speaker(s): Riley Major,
Abstract:
As DBAs, we are asked all sorts of impossible questions. Who dropped that important table last month? Why was everything slow last week? Who made that user a sysadmin? You’d have to be a mind reader to know the answers to some of those, right? Not necessarily! SQL Server can help you find information about these and other common problems with its default trace and system_health Extended Events session, but you have to know how to collect and interpret the data they provide. In this session, we’ll explore what system_health and the default trace are, what information they contain, and how to use them to find the answers you’re searching for.
Speaker(s): Ed Leighton-Dick,
Abstract:
SQL Server 2019 is in Public preview for almost 1 year. Microsoft promises that it is going to be released for consumption this year. Like previous versions, SQL Server 2019 comes with a plethora of new features as well as with enhancements to the existing features. In this session, I will discuss new features such as Accelerated Database Recovery, PMEM (persistent memory device), Hybrid Buffer pool, In-memory Optimized Tempdb, etc. This is an introductory session to introduce you to these new features. There will not be enough time to do any meaningful demo but there will be plenty of time to ask questions. You will leave this session with a solid understanding of some of the best new features of SQL Server 2019 which will help you and your company make decisions such as when and why to upgrade your database platform.
Speaker(s): Ameena Lalani,
Abstract:
Microsoft is pulling out all the stops when it comes to SQL Server 2019 integration with "Big Data" solutions. With the expansion of PolyBase to handle external data in MongoDB, moving data from "unstructured" documents into relational tables in SQL Server is theoretically simple. However, MongoDB is designed to allow for spontaneous schema changes. Our fussy SQL Server won't like such sloppiness! In this session, we will explore SQL Server 2019 features, such as PolyBase, SQL Server Integration Services (SSIS), and T-SQL features such as JSON support, that facilitate integration with MongoDB. The demonstration will include moving data between our Odd Couple of database paradigms, and building in safeguards to keep the two systems from having issues. Can two incompatible databases share data without driving each other crazy?
Speaker(s): Peter Kral,
Abstract:
Protected Health Information (PHI) and other forms of sensitive data are an area of concern in all industries. Highly regulated industries such as Healthcare and Financial Services have a great deal of person-specific information in their systems, and often restrict the use of self-service Business Intelligence (BI) to prevent the wrong people from seeing the wrong data. This presentation will review new ways to safely enable self-service BI for an enterprise without introducing additional risk of PHI or sensitive data violations. I'll review strategies and architectures that include Power BI DataFlows with Azure Data Lake to eliminate sensitive data from a self-service BI environment. An infrastructure leveraging these tools can still have highly controlled and governed enterprise Power BI reports that carefully distribute PHI and sensitive data to targeted users, while also enabling self-service BI without an increased risk of sensitive data violations.
Speaker(s): Greg Beaumont,
Abstract:
Change is constant, especially with source files. Health care claims data files change at least yearly. You develop an SSIS package to load the source file. You meticulously identify each of the columns and map them to the targets. Your package runs fine for months. Then the file format changes. Again, you tediously select each column, etc. Wouldn't it be nice to simply document the structure of the file, the file's metadata, and generate the SSIS from that metadata? Your users demand the documentation anyway. If the file changes, you simply change the metadata. To demonstrate such an approach, I import some US census data. I create the SSIS package using BIMLScript and metadata. When the format changes, I change the metadata and generate a whole new package. And if your whole ETL approach changes to say Azure Data Factory? I will demonstrate how to generate an Azure Data Factory pipeline from the same metadata.
Speaker(s): Russel Loski,
Abstract:
SQL DB Hyperscale is a cost effective VLDB, fully managed SQL PaaS option. It shares the same Azure SQL Server engine, retaining compatibility for application, the storage is fundamentally redesigned from the ground up to be cloud-born with cache-miss reads of under 2ms. The Hyperscale architecture supports separation of compute and storage, allows for dynamic scaling of CPU, memory, and compute nodes in constant time, regardless of database size. Database backup and restore also in constant time, regardless of database size (RPO 0 minutes, RTO less than 10 minutes). High availability supports one primary read/write, up to four read-only replicas, which also serve as hot-standy in case of automatic failover. Come find out more about this exciting, optimized for OLTP and HTAP database option.
Speaker(s): Huy Ly,
Abstract:
Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you'll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.
Speaker(s): Monica Rathbun,
Abstract:
Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed and managed, silent and seemingly random performance killers can strike and significantly hurt your database performance. This session is packed with many tips and tricks gained from years of experience for getting the most performance from your VMware-based SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.
Speaker(s): David Klee,
Abstract:
As the velocity of device data increases, the promise of the Cloud is often limited by the latency of the office Internet connection. Leveraging the power of Azure, we will deploy real-time analytics at the edge and illustrate how performing high-frequency analysis is possible. In this session, we will cover the basics of Azure Internet-of-Things (IoT) and Stream Analytics, then we will deploy Stream Analytics at the edge using a Raspberry Pi device connected to the Azure IoT ecosystem. No prior Azure IoT or Azure Stream Analytics knowledge is required to benefit from this session.
Speaker(s): Jordan Anderson,
Abstract:
In this session we will go over and talk about what it means to build your own brand and cover the following topics listed below. We plan for this to be a highly interactive discussion. - Discussing value of community events Meetups - Importance of an active social profile - Investing in professional development training - Give back to the local data community
Speaker(s): Joshuha Owen,
Abstract:
Most people do not realize that we can thank women for many of the technical innovations we enjoy today. In fact, Ida Lovelace wrote computer code 100 years before the first computer existed! From space travel to encryption, women’s contributions have made a big difference in our lives. Those who have gone before us are also responsible for the opportunities we have today. In today’s WIT session, you’ll hear how our panel of successful technical women have been inspired by computing pioneers and their own mentors. You’ll also have a chance to win a copy of Melinda Gates’ new book! Panel will include: Gina Meronek, Theresa Heroff, Monica Rathbun, Ashley Day
Speaker(s): Kathi Kellenberger,
Abstract:
CosmosDB is Microsoft’s globally distributed, massively scalable, cloud based database that is hosted in AZURE. Who cares? You should if you need to support thousands of transactions a second, global distribution and redundancy, and different consistencies. Do you need to support JSON, Graph, et al? Done. Join me and see how easy it is to get started. We will set up a local instance of CosmosDB, load JSON data and build a PowerBI visualization. Along the way I’ll point out a couple of things to watch out for. At the end of the session you will then learn how, with a couple of commands, to switch your visualization to the cloud.
Speaker(s): Jim Dorame,
Abstract:
Text/CSV. JSON. AVRO. XML. Parquet. ORC. In this "Sounds-boring-but-should-be-extra-practical" session we will do a deep dive into these 6 different file formats. We will discuss: * Design and Layout * Differences between formats * Pros and Cons * Performance Characteristics * Applicability to Azure/SQL Server * Optimizing for Cloud Object Storage * Common Use Cases in the Real World In the end, you will understand How, When, Where, and Why to optimally use each particular file format in your Enterprise Data Architecture.
Speaker(s): Bill Preachuk,
Abstract:
Let me share with you the some of the secrets to successful Leadership. We will cover Team Building, Employee Retention, Motivation, How to discover toxic situations and Success for the short and long term. Each one of these topics is derived from my own experiences in leading teams and organizations. Hint: I didn't get it all right the first time so stop on by for some horror stories too.
Speaker(s): James Phillips,
Abstract:
Power BI Dataflows are an emerging technology from Microsoft in the Power BI space (not to be confused with Azure Data Factory Dataflows, of course). Power BI Dataflows are emerging as some features are still in preview. The part that is not clear in the name is that this is not purely and ETL function. Power BI dataflows allow you to store data in Azure Data Lake. Depending on how you configure your solution, you can use the Common Data Model as well. Let's dig in an create a dataflow using native Power BI functionality then we will look at using an existing ADLS as well.
Speaker(s): Steve Hughes,
Abstract:
You know how locking works in SQL Server, but now you are tasked with diagnosing and fixing deadlocks. How do you take the knowledge you have and apply it to address deadlocks in your production database? In this session, we will discuss how you can use free tools to detect and analyze deadlocks in your system. We will do a deep dive on deadlock XML with an eye toward interpreting the information automatically collected by SQL Server when the free tools fall short. Attendees will leave with the understanding they need to develop solutions to deadlocks in their systems.
Speaker(s): Jake Manske,
Abstract:
The language commonly known as "M" (or Power Query to some) has grown in prevalence over the last 5 years to where it has evolved into a fully integrated language in various tools from far in the front end to way in the back end. Power BI uses it heavily. Cubes can call directly to it. Come along and learn how the language works and some proposed best practices. With a focus on Power BI optimization but watch as I delve into Data Lake ingestion to Azure Analysis Services and so forth.
Speaker(s): George Bryant,
Abstract:
Dell EMC Storage and SQL Server 2019 are changing the game for big data and data analytics. In this session come learn how Dell EMC Storage is enabling SQL Server 2019 Big Data Clusters. We’ll also discuss some architecture options for deploying Big Data Clusters and talk about the latest integrations from Dell EMC Storage for SQL Server 2019. Finally, I’ll leave some dedicated time for QA to answer your SQL Server storage related questions.
Speaker(s): Doug Bernhardt,
Abstract:
This session will provide an introduction to Microsoft PowerApps and Flow. PowerApps and Flow are both useful tools for enabling end users with the ability to rapidly create and deploy low-code solutions to add value to their organizations by enabling rapid application development with PowerApps and workflow process automation with Flow.
Speaker(s): Kurt Hagedorn,
Abstract:
Databricks is the tool of choice for performing data transformation in Azure. This session gives an overview of Apache Spark and Databricks. We will also perform a non trivial data transformation, publish the resulting data frame to the HIVE metastore, and query it directly from Power BI. Come see what is possible in the Modern Data Platform.
Speaker(s): Jared Zagelbaum,
Abstract:
SQL Server 2019 Big Data Clusters introduce Kubernetes as whole new deployment platform. For those coming from prior versions of SQL Server on Windows, this can be daunting. This session will walk through how to do the deployment step-by-step so you can understand how it’s done, the components involved, and what you might need to learn more about as you take the journey to SQL Server 2019 and Big Data Clusters.
Speaker(s): Doug Bernhardt,
Abstract:
Are you a relative newcomer to SQL Server and want to get into performance tuning? Or maybe you just want to expand your knowledge of hidden performance killers? Then join me for a survey of seven worst practices that kill performance in SQL Server. In this demo-filled session, we will cover a mix of administrative and T-SQL development practices, making this session suitable for DBAs and developers alike! Topics include server configuration mistakes, T-SQL parallelism, and TempDB headaches. When you leave, you'll be armed with knowledge and tools to tackle your current workloads and hit the ground running.
Speaker(s): Andy Yun,
Abstract:
In this session we'll discuss modern data integration and analytics in the cloud. We'll walk through how to create an Azure Data Lake by using Azure Data Factory as our ELT tool. We'll then use Databricks to load our data into Snowflake for better analysis. Finally, we'll connect Power BI to our data. No prior experience will be needed for this session.
Speaker(s): Frank Matteson,
Abstract:
Data engineering architectures in recent years have been centralized around large cloud Data Lakes like Azure Data Lake, Azure Blob, S3, and HDFS. These Data Lakes have provided organizations with cheap and easy to use storage of critical and sometimes... very inconsistent data. Using Delta Lake, in tandem with Azure Databricks, we'll walkthrough bottling your Azure Data Lake data into clean, validated, and consumable tables for personas from Business Analysts to Data Scientists. All without changing where you keep your data!
Speaker(s): JD Braun,
Abstract:
Let's talk about Managed Instance, the newest member of the Azure SQL Database family. It's a WHOLE lot closer to out-of-the-box SQL Server than other flavors of Azure SQL DB. But it's still got some differences. Do those matter for you? What exactly is it? What is it good for (or not)? How much does it cost? Just how compatible is it with existing systems? How can I move data in and out of it? How is my data protected, for HA, DR, and backups? What else do I need to know about it? Bottom line: Does Managed Instance make sense for me?
Speaker(s): Tim Plas,
Abstract:
In this session we will give an overview of what Table Partitioning is, how can it be used to move large amounts of data quickly and how can it be used with a data archiving strategy to quickly and easily drop archived data from a table. We will discuss the practical applications of table partitioning using scripts to generate new table partitions, move a partition to another table and discussion on how this can benefit you. In this demo heavy session, attendees will be provided with scripts to get setup quickly so they can begin using the strategies to take control of rapid data archival
Speaker(s): Eric Zierdt,
Abstract:
Are you excited to know about the MSBI tools and work as a Business Intelligence Professional, a dynamic and rewarding career in Information Technology? If yes, this is the right time and place for you. In this session, I will give you the overview of the MSBI tools (SSIS, SSRS, SSAS, Power BI, Azure Analytics). I will also provide you some insights to build the MSBI career and to leverage the learning curve in Microsoft Data Platform, based on my knowledge and experience, the proven strategies and techniques.
Speaker(s): Ganesh Lohani,
Abstract:
To get the most from our SSAS Tabular and Power BI models, we must be able to create robust DAX expressions. This requires the right interplay of filtering, context and the myriad of DAX functions. This session will provide a solid working understanding of all three, giving you a firm foundation for fulfilling those demanding user requirements. This session will include examples using some of the most recent additions to the ever-expanding DAX language.
Speaker(s): Brian Larson,
Abstract:
Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session. This session will focus on how to use Extended Events as part of your performance troubleshooting process.
Speaker(s): Dave Bland,
Abstract:
Docker and Kubernetes are revolutionizing the way software is being developed and deployed. Faster deployments, easier setup and consistency benefits are now reaching us with SQL Server running in Docker containers on Kubernetes. Come and find out what's new with SQL Server 2019 running in Docker/Kubernetes. We'll go over Docker/Kubernetes basics as well as some demos of SQL Server 2019 running on containers.
Speaker(s): Chris Kramer,
Abstract:
Data privacy has never been more relevant than the last few years. Are you doing all you can to protect your data? In this session we will look at different methods to encrypt data and what those methods protect against as well as what they do not protect. I will also demonstrate enabling Transparent Data Encryption (TDE), column level encryption and the new Always Encrypted along with how to encrypt and decrypt your data….no decoder ring needed.
Speaker(s): Marcus Hopfinger,
Abstract:
Do you see curly brackets stored in your database and wonder what that is? Are you a DBA, with developers storing JSON in your database? As a database administrator or developer, it's important to understand JSON today. This session will explain what JSON is, where it came from, and why it is showing up all over the place. When you leave this session you will understand how to investigate, manipulate, and validate JSON in your database. You will walk away with example code of how to use Microsoft’s additions to SQL Server to use this data.
Speaker(s): Jim Dorame,
Abstract:
Ever considered giving a presentation of your own? Pondered how your favorite speakers got their start? Contemplated whether you could ever do that too, but were not sure where to begin? In this session I will show you how to get started. We will go over how to develop your idea, create session content, and share my favorite tips tricks. You will leave armed with a wealth of resources (and hopefully some inspiration) to venture forth and develop your first presentation.
Speaker(s): Andy Yun,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/gregbeaumont
As a Technology Solutions Professional at Microsoft I am constantly working to both inspire and create Digital Transformation using Analytics. Architecting solutions, training technologists, and never passing up an opportunity to design something new using Microsoft tools such as Power BI, Azure, SQL Server, Streaming Data and Azure Machine Learning.
LinkedIn: https://www.linkedin.com/in/tplas
Tim is a Principal Consultant at Virteva, in Mpls MN. His current focus areas are cloud architecture / engineering / migration, operational-DBA services (esp. HA/DR), server migrations, server virtualization, and storage. His experience over the past 25+ years has been primarily with server / data-center infrastructure, including being CTO / co-founder of a successful hosting company. Tim has held a variety of MS certifications since 1994.
LinkedIn: https://www.linkedin.com/in/frankmatteson
I am a Solution Architect for Tail Wind with over a decade of experience in Business Intelligence and Data Analytics with a current focus on Cloud Technologies. I current hold certifications in both Microsoft and Snowflake and have worked in many different industries from manufacturing, medical, retail, and more.
LinkedIn: https://www.linkedin.com/in/mrgbryant
George has over a decade of experience in the Business Intelligence industry and is an active member of the BI community across the Midwest. His knowledge spans multiple industries including, retail, manufacturing, finance, and medical, however recent years has seen him focus on the analytics in sports. George specializes in BI architecture and end to end development in order to deliver advanced analytics and metrics to multiple organizations across the country. In recent years George has focused on and worked primarily in the Azure cloud, utilizing both established and recent offerings.
LinkedIn: http://www.linkedin.com/in/brianlarsonscs
Contact: http://sqlmag.com/author/brian-larson
Brian Larson is Chief Creative Officer/Partner at Superior Consulting Services and has presented at SQL Server Connections, PASS Summit, and the Microsoft BI Conference. As a consultant to Microsoft, Brian contributed to the original code base of Reporting Services. Brian is the author of “Microsoft SQL Server 2016 Reporting Services: 5th Edition” and “Delivering Business Intelligence with SQL Server 2016: 4th Edition”, as well as the forthcoming “Data Analysis with Microsoft Power BI.”
James Phillips is the VP Technology for Mizuho Americas and has over 20 years of experience with SQL technologies with the last 10 years focused on Business Intelligence. He is a past Leader of the Northern NJ SQL Server User group and current Leader for SQL Saturday NYC. He has worked in a wide array of industries including finance and insurance. Regularly speaks about Database Performance Tuning, SSIS and Power BI topics. Also an avid softball player and father to 5 beautiful children.
LinkedIn: https://www.linkedin.com/in/peterkral
Peter Kral is a Premier Field Engineer (Data AI) at Microsoft. He holds SQL Server MCSA 2012/2014/2016 and Data Platform MCSE certifications, and was the winner of the Speaker Idol Award at PASS Summit 2016. Peter lives in the San Diego area where he is an active member of the local PASS chapter. He has spoken at many SQLSaturdays, SoCal Code Camps, and at PASS Summit 2017 and 2018.
LinkedIn: https://www.linkedin.com/in/kramer1007/
Chris Kramer is a Senior Database Administrator at Digi-Key Electronics in Thief River Falls, MN. He started working with SQL Server in 2009 dealing with SQL 2000 and up dealing with clustering, architecture, backups, and virtualization. He mainly focuses on performance and architecture but also deals with other technology stacks including Hadoop, MongoDB and MemSQL. He graduated from North Dakota State University with a BS in Computer Science. In his free time, he enjoys golf, video games, watching football, and riding motorcycles.
LinkedIn: https://www.linkedin.com/in/ameena
Ameena Lalani is a SQL Server veteran and started her journey with SQL Server 2000. She is a Microsoft Certified Solution Associate on SQL Server 2016 and also hold Azure Administrator Associate certification. Ameena works at Microsoft as a Premier Field engineer. She has implemented numerous High Availability and Disaster Recovery solutions at various companies. Ameena loves to share her technical knowledge and speaks at local user groups and SQL Saturday events throughout the United States.
LinkedIn: http://www.linkedin.com/in/kathikellenberger
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.
LinkedIn: https://www.linkedin.com/in/marcus-hopfinger-69728121?
Contact: http://dakotadatawrangler.blogspot.com/
Marcus has been with Daktronics, Inc. since 2001 where he started doing ColdFusion development and some SQL Server 7 database administration. In late 2003 he was activated and deployed in early 2004 to Iraq with the South Dakota Army National Guard. During this time, he served as a Battalion Communications Officer where he was responsible for redundant voice and data networks including satellite internet and secure internet routing protocol networks. Upon returning to Daktronics in 2005 he moved in into a fulltime database administration position where he gets to work on SQL Server instances on three continents. He is also a Sci-Fi Fan, History buff, Amateur Radio Operator (call sign KA0SQL), but most importantly husband and father.
LinkedIn: https://www.linkedin.com/in/rossmcneely
Contact: https://rossmcneely.com
Ross McNeely is a Tail Wind Principal Consultant in Data Management, and the Practice Manager of Business Intelligence. He works with external vendors, customers, and partners to integrate disperse data sources. Throughout most of his 15 year career he has been specializing in Information Management, and implementing solutions for Information Strategy, Information Asset Management, Enterprise Data Management, and Business Intelligence.
LinkedIn: https://www.linkedin.com/in/rileymajor
Contact: http://www.Scribnasium.com/
Riley Major is an Enterprise Architect based in the Twin Cities, MN metro area who enjoys collaborating with business leaders to design technical solutions and working with technology professionals to build them. He's been programming and designing databases since he was a kid and doing so professionally for 20 years. He has a special place in his heart for T-SQL in SQL Server and loves to share that enthusiasm.
LinkedIn: https://www.linkedin.com/in/dave-bland-sql-server
Contact: https://www.davebland.com
Over 20 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET. Dave currently is the Manager of the DBA team at Stericycle. Dave is a Friend of Red-Gate for 2019. He is a frequent presenter at SQL Saturday events and user groups around the country. Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL. Current certifications include: • Microsoft Certified Trainer • MCTS: SQL Server 2008, Implementation and Maintenance • MCTS: SQL Server 2008, BI Development and Maintenance • MCSA: SQL Server 2008 • MCSA: SQL Server 2016 • MCSE: SQL Server 2016 - BI • MCDBA: SQL Server 2000 • MCSD • MCSE: Data Management and Analytics
LinkedIn: https://www.linkedin.com/in/sqlespresso
Contact: http://www.sqlespresso.com
Monica Rathbun lives in Virginia, is a Microsoft MVP for Data Platform and Microsoft Certified Solutions Expert. She has nearly two decades of experience working with a wide variety of database platforms with a focus on SQL Server and the Microsoft Data Platform. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group and a Mid‐Atlantic PASS Regional Mentor. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back. Monica can always be found on Twitter (@sqlespresso) handing out helpful tips. You can find Monica blogging at sqlespresso.com
LinkedIn: http://www.linkedin.com/in/sqlbek
Contact: http://sqlbek.wordpress.com
Andy Yun is a SentryOne Principal Solutions Engineer and a former Microsoft MVP. He has been working with SQL Server for nearly 20 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQL Saturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQL Saturday Organizing Committee.
LinkedIn: https://www.linkedin.com/in/danielmallott/
Contact: https://www.danielmallott.com
Dan Mallott is a Chicago-based consultant for West Monroe Partners in their Technology Practice. His passion is for service-layer development, particularly database technologies, including Microsoft SQL Server and Apache Cassandra. Recent projects have included designing a new integration architecture for a mid-sized health insurer, designing a full technical architecture for a large health insurer, building a new member portal for a healthcare-related association, and developing threat hunting software for use by West Monroe. In his spare time, Dan can be found writing his own libraries instead of using package solutions, or on the ice as a hockey player and referee.
LinkedIn: http://www.linkedin.com/in/dataonwheels
Contact: http://www.dataonwheels.com
Steve Hughes is the Director of Consulting at Pragmatic Works. In his current role, Steve manages the consultant team at Pragmatic Works and directs implementation of our cloud practices for customers. He focuses on team development and company growth with this role. In his previous role as a Principal Consultant Lead, he focused designing solutions for customers on Microsoft technologies including SQL Server, Power BI, and Azure. He has been working with technology for over 20 years with much of that time spent on creating business intelligence solutions and helping customers implement leading BI and cloud solutions. He is passionate about using data effectively and helping customers understand that data is valuable and profitable.
LinkedIn: https://nz.linkedin.com/pub/leila-etaati/36/46/b03
Contact: http://blog.radacad.com
Leila Etaati is the First Microsoft AI MVP in New Zealand and Australia, as well as a Data Platform MVP. She has a Ph.D. from the University of Auckland and is the co-director and data scientist in RADACAD company with many clients around the world. Additionally, she is the co-organizer of Microsoft Business Intelligence and Power BI Use group in Auckland with more than 1300 members. Leila has also co-organized 3 main conferences in Auckland: SQL Saturday Auckland (from 2015), Difinity (from 2017) and Global AI Bootcamp. She is a data scientist, BI consultant, trainer, and speaker. She is a well-known International speaker to many conferences such as MS Ignite, SQL PASS, Data Platform Summit, SQL Saturday, Power BI World Tour and in Europe, USA, Asia, Australia, and NZ. She has over 10 years’ experience with databases and software systems. Leila is an active Technical Microsoft AI blogger in RADACAD.
LinkedIn: https://www.linkedin.com/in/stenzelmatt
Matt Stenzel is a Data Platform Technical Specialist at Microsoft. He has been using Microsoft tools for over 10 years. He is a Microsoft Certified Solutions Associate and has held positions as a Developer, DBA and Architect with several Fortune 500 companies before joining Microsoft. He now works with customers across the North Central District to implement data platform solutions that will provide business value. Matt is passionate about helping businesses turn data into insights and realizing the value of their data. He has helped numerous customers realize value from on-prem and cloud solutions dealing with structured and unstructured data using the Microsoft Data Platform and Azure.
LinkedIn: http://www.linkedin.com/in/eleightondick
Contact: http://www.edleightondick.com
Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.
LinkedIn: https://www.linkedin.com/in/andersonjordan/
Contact: http://blogs.talavant.com/
Jordan has over 10 years of experience as a consultant, analyst, and developer of business intelligence and analytics solutions. He has a proven background in business process analysis, planning, and strategic alignment across numerous business functional areas in a wide range of industries. Jordan is proficient in cross-functional team facilitation, organization, leadership, and cultivating cooperative relationships with project sponsors and stakeholders. Jordan brings an extensive track record of delivering successful technology solutions that align with the business, engage people, and produce value. Jordan drives teams with a focus on creativity, relevance, quality, and high performance.
LinkedIn: https://www.linkedin.com/in/paulstan/
Contact: https://www.windocks.com/blog-2
Co-founder of Windocks, Paul is a former Microsoft engineer who is focused on delivering solutions for SQL Server development and test, including SQL Server containers and database cloning.
Huy is a solution architect at Microsoft, he claims expertise in data AI, 50% of the time, he is right every time.
LinkedIn: https://www.linkedin.com/in/kurt-hagedorn-3a448b2/
Kurt is an experienced BI professional who has executed multiple projects delivering Business Intelligence capabilities to clients with the Microsoft data and BI stack. In addition to on-premises solutions, he is also experienced with Azure cloud-based solutions. He has a passionate interest in enabling organizations to operate more effectively through tools to better understand and visualize their data.
LinkedIn: https://www.linkedin.com/in/elizabeth-a-noble
Elizabeth Noble is a Director of Database Development in the metro Atlanta area. When she was introduced to her first database over 10 years ago, it was love at first sight. Her passion is to help others improve the quality and speed of deploying database changes through automation. When she is not trying to automate all of the things, she can be found spending time with her dogs, playing disc golf, or taking a walk at the gym.
LinkedIn: http://www.linkedin.com/in/russloski
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.
LinkedIn: https://www.linkedin.com/in/joshuha
A Data and AI Premier Field Engineer by day and tech geek at all times. I enjoy working with data technologies as well as dabbling in other areas such as VR programming.
Contact: https://concurrencyexchange.com
Jake has been a T-SQL developer since 2013, starting after he jumped ship from an academic life as a mathematics professor to the software industry. He focuses on solving difficult concurrency problems, large scale data warehouse ETL processes, data conversions, and understanding SQL Server optimizer behavior.
LinkedIn: http://www.linkedin.com/in/davidaklee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQL Saturday events, and many SQL Server User Groups.
LinkedIn: http://www.linkedin.com/in/kathikellenberger
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.
LinkedIn: http://nz.linkedin.com/in/rezarad/
Contact: http://radacad.com/blog
Reza Rad is a Microsoft Regional Director, MVP, author, trainer, speaker and consultant. He is a Microsoft Data Platform MVP for nine years from 2011. Reza wrote many books on Power BI subjects including the Power BI from Rookie to Rock Star, and Pro Power BI Architecture. Reza is the invited speaker at the world's well-known conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Ignite Tour, PASS Summit, and many other conferences. Reza is an active blogger and writes regularly about Power BI at https://radacad.com.
LinkedIn: https://www.linkedin.com/in/ganesh-lohani-6275a716
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.
LinkedIn: https://www.linkedin.com/in/kevin-krenz-62024925/
Kevin started working with SQL Server in 2015 as a technical services engineer for a large healthcare software vendor. During that time, he has worked on the data warehouse product, helped with server and database performance investigations, and led internal training for SQL Server. He enjoys working on issues that improve his understanding of the entire system, spanning hardware, hypervisor, OS, database, and application. In his spare time, Kevin enjoys spending time with his wife and son in Madison, playing watching soccer, brewing an occasional batch of beer, and looking up at the stars.
LinkedIn: https://www.linkedin.com/in/digitalcraig/
Data-Driven Marketing Professional. Using Power BI to measure marketing and business outcomes.
LinkedIn: https://www.linkedin.com/in/ginameronek
Contact: http://ginameronek.com
Gina Meronek is a Business Intelligence, Application Architecture, and IT Management professional with 18 years of experience applying the right people and tools to produce genuinely useful technology. She is dedicated to transforming data into information that solves problems via the right system architecture and interactive data visualizations. Gina has been active in the SQL PASS Community for a number of years and is passionate about sharing knowledge with other data geeks in her community. When not glorying in all that Power BI can do, she loves reading, riding her horse, or attending theater with her husband.
LinkedIn: https://www.linkedin.com/in/sqlespresso
Contact: http://www.sqlespresso.com
Monica Rathbun lives in Virginia, is a Microsoft MVP for Data Platform and Microsoft Certified Solutions Expert. She has nearly two decades of experience working with a wide variety of database platforms with a focus on SQL Server and the Microsoft Data Platform. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group and a Mid‐Atlantic PASS Regional Mentor. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back. Monica can always be found on Twitter (@sqlespresso) handing out helpful tips. You can find Monica blogging at sqlespresso.com
LinkedIn: https://www.linkedin.com/in/adam-anderson-dba/
Contact: https://sqlpioneer.wordpress.com/
Adam Anderson is a Microsoft Certified Solutions Associate in Database Development, and an ICAgile Certified Agile and DevOps professional with over 2 decades of experience in IT processes. Currently, he works at American AgCredit in Santa Rosa California on their software integrations team.
LinkedIn: http://www.linkedin.com/in/sqlbek
Contact: http://sqlbek.wordpress.com
Andy Yun is a SentryOne Principal Solutions Engineer and a former Microsoft MVP. He has been working with SQL Server for nearly 20 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQL Saturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQL Saturday Organizing Committee.
LinkedIn: http://www.linkedin.com/in/ericzierdt
Contact: http://ericemployed.blogspot.com
Eric is a level 70 Data Slayer, who has worked with SQL Server since 2000. Eric has worked with benefit systems, real estate data, marketing, game data, and medical device data. Eric enjoys performance tuning, T-SQL programming, and SQL Server Administration.
LinkedIn: http://www.linkedin.com/in/davidaklee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQL Saturday events, and many SQL Server User Groups.
LinkedIn: https://www.linkedin.com/in/ashley-day-a007a430/
Ashley found the world of data analytics and business intelligence after a supervisor saw her potential and introduced her to SQL and report writing. Her analytical mindset and thirst for knowledge quickly turned that opportunity into a career, and she has spent the past five years working within the sphere of data management and business intelligence. She has experience working with data from a number of industries, including manufacturing, distribution, benefits administration, and the financial sector. Ashley is very passionate about working with data and helping others gain access to the clean and reliable data they need to make informed business decisions.
LinkedIn: https://www.linkedin.com/in/doug-bernhardt-9a43323
SQL Server professional since 1995. Over the course of my career I've worked in various roles including reporting, dev, DBA, architect, troubleshooter, etc. Currently I work at Dell EMC where I develop and test storage solutions for SQL Server in terms of white papers, best practices, and reference architectures for running SQL Server on Dell EMC storage. In my spare time I like to unplug and play with muscle cars, do some cycling, or throw weights around at the gym.
LinkedIn: https://www.linkedin.com/in/jaredzagelbaum?
Contact: https://jaredzagelbaum.wordpress.com
With over 10 years of experience using the Microsoft Data Platform suite, Jared’s main areas of focus include data lake architecture, machine learning, and application embedded analytics. Jared regularly speaks at user groups and events across the Midwest, as well as blogs and provides technical review for SQL Server publications.
LinkedIn: https://www.linkedin.com/in/drew-skwiers-koballa
Contact: https://www.drewsk.tech/
Drew Skwiers-Koballa is a program manager for SQL tools at Microsoft and an open source advocate. He spent nearly a decade as a database administrator and developer, building several extensions for Azure Data Studio prior to joining Microsoft. He is currently working on experiences for DBAs and database developers.
LinkedIn: https://nz.linkedin.com/pub/leila-etaati/36/46/b03
Contact: http://blog.radacad.com
Leila Etaati is the First Microsoft AI MVP in New Zealand and Australia, as well as a Data Platform MVP. She has a Ph.D. from the University of Auckland and is the co-director and data scientist in RADACAD company with many clients around the world. Additionally, she is the co-organizer of Microsoft Business Intelligence and Power BI Use group in Auckland with more than 1300 members. Leila has also co-organized 3 main conferences in Auckland: SQL Saturday Auckland (from 2015), Difinity (from 2017) and Global AI Bootcamp. She is a data scientist, BI consultant, trainer, and speaker. She is a well-known International speaker to many conferences such as MS Ignite, SQL PASS, Data Platform Summit, SQL Saturday, Power BI World Tour and in Europe, USA, Asia, Australia, and NZ. She has over 10 years’ experience with databases and software systems. Leila is an active Technical Microsoft AI blogger in RADACAD.
LinkedIn: https://www.linkedin.com/in/stenzelmatt
Matt Stenzel is a Data Platform Technical Specialist at Microsoft. He has been using Microsoft tools for over 10 years. He is a Microsoft Certified Solutions Associate and has held positions as a Developer, DBA and Architect with several Fortune 500 companies before joining Microsoft. He now works with customers across the North Central District to implement data platform solutions that will provide business value. Matt is passionate about helping businesses turn data into insights and realizing the value of their data. He has helped numerous customers realize value from on-prem and cloud solutions dealing with structured and unstructured data using the Microsoft Data Platform and Azure.
LinkedIn: http://nz.linkedin.com/in/rezarad/
Contact: http://radacad.com/blog
Reza Rad is a Microsoft Regional Director, MVP, author, trainer, speaker and consultant. He is a Microsoft Data Platform MVP for nine years from 2011. Reza wrote many books on Power BI subjects including the Power BI from Rookie to Rock Star, and Pro Power BI Architecture. Reza is the invited speaker at the world's well-known conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Ignite Tour, PASS Summit, and many other conferences. Reza is an active blogger and writes regularly about Power BI at https://radacad.com.
LinkedIn: https://www.linkedin.com/in/doug-bernhardt-9a43323
SQL Server professional since 1995. Over the course of my career I've worked in various roles including reporting, dev, DBA, architect, troubleshooter, etc. Currently I work at Dell EMC where I develop and test storage solutions for SQL Server in terms of white papers, best practices, and reference architectures for running SQL Server on Dell EMC storage. In my spare time I like to unplug and play with muscle cars, do some cycling, or throw weights around at the gym.
LinkedIn: https://www.linkedin.com/in/andrew-brobston-a18b8713
Contact: https://brobston.com/
Andrew Brobston is a senior full-stack software developer at SJV Associates, an Atlanta-area company specializing in background checks. Previously, he was a full-stack developer with Stack Overflow. His Microsoft SQL Server experience started with SQL Server 2000, and he has worked with every version since then.
LinkedIn: https://www.linkedin.com/in/jamesdorame
Contact: http://www.jamesdorame.com/
Jim Dorame has been working with SQL Server for over 20 years. Over those years he has learned a great deal from the SQL community. He has also given back to the community in the hopes that he may help someone in their career. He is always looking for something to learn and luckily Microsoft keeps adding to SQL Server.
LinkedIn: https://www.linkedin.com/in/jamesdorame
Contact: http://www.jamesdorame.com/
Jim Dorame has been working with SQL Server for over 20 years. Over those years he has learned a great deal from the SQL community. He has also given back to the community in the hopes that he may help someone in their career. He is always looking for something to learn and luckily Microsoft keeps adding to SQL Server.
LinkedIn: https://www.linkedin.com/in/billpreachuk/
Bill is a Data Architect with almost 3 decades of experience doing all forms of large-scale Data Architecture and Data Design work – EDW, Hadoop, SQL Server Development DBA, Performance Tuning, and Technical Architecture planning. Bill has presented at the PASS Summit, many SQL Saturdays, and PASS/Hadoop/Analytics user group meetings in the Twin Cities, Wisconsin, Iowa, Winnipeg, and Ukraine. He also served 2 years on the Board of PASSMN - The Minnesota SQL Server User Group.
LinkedIn: https://www.linkedin.com/in/jdbraun1/
JD is a data engineering consultant at Slalom where he helps organizations design and implement modern data architectures to deliver value to their internal external customers. He holds certifications such as; Databricks Certified Developer, AWS Solutions Architect - Associate, and Microsoft Certified Solutions Expert (MCSE) - Data Management Analytics.
The following is a list of sponsors that helped fund the event.
New Horizons Computer Learning Center - Minnesota