Event Location:
Chandler-Gilbert Community College Pecos Campus
2626 East Pecos Road
Chandler, Arizona
Abstract:
For many of us data is scattered in many different systems. We almost all have data that someone wants to compare or track but can't without a lot of manual manipulation. So, how do you tie disparate systems together? With a Data Warehouse! In this presentation you will get the skills you need to start building your own. We will discuss the basics of what a Data Warehouse is, the tools needed to create, deploy and manage the Data Warehouse process, and the benefits of using the data you collect to manage operational processes and create data visualizations. After attending this session you will be able to return to your job and amaze people with your ability to show them the power of the data!
Speaker(s): Leslie Andrews,
Abstract:
Do you ever look at your data visualizations and feel that they are lackluster? Have you made a report using the latest chart types, but you still can’t gain adoption from your target audience? Lots of people feel this way, but they can’t quite identify what should be changed or how to change it. This session will help you identify signs that it’s time to give your data visualizations a makeover and provide practical tips for improving your reports and dashboards. We’ll discuss how simple changes in design choices related to color, chart types, chart formatting, and report layout can make a big difference in creating clear and engaging visualizations with common analysis tools like Power BI and Excel.
Speaker(s): Meagan Longoria,
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,
Abstract:
Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. quot;Virtualize Firstquot; is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too quot;criticalquot; to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Bring i
Speaker(s): Deji Akomolafe,
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,
Abstract:
Interested in becoming a consultant? Think it's too overwhelming? Want to be your own boss? Wish to expand your clientele? The hardest thing about being your own boss is getting in the right mindset and to truly understand that your past doesn’t equal your future. In this 60 minute session, I cover 3 keys to being a successful consultant. I share techniques used to help others get in the right mindset and tackle the mental blocks to achieving success in their entrepreneurial pursuits. Whether you are interested in starting your own business, or a consultant wanting to expand your clientele, this session will position you for future success as an entrepreneur.
Speaker(s): Mohammad Darab,
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:
When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment. Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls. In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!
Speaker(s): Jeff Mlakar,
Abstract:
Have you heard about these “Container” things? You may have questions like “What is a Container?”, Who is this “Docker?”, “Aren’t containers a Linux Thing?” and “As a DBA why do I care?” Sit back and listen as we cover these questions and many more. We will then take a closer look at leveraging Containers in a SQL world. We will review the published Microsoft SQL Server container images, what you can do with them and why you would want to use them. We will then show some examples of running MS SQL Server in a container on both a Windows host and a Linux host. This is a great introduction to Containers as well as what is possible with SQL Server in a container.
Speaker(s): Mark DeNeve,
Abstract:
If you're like me, you've attended PowerShell sessions before. However, much of the *practical* usage of PS comes with rolling back your sleeves and digging into the nuances of syntax and how to get things done. In this session, I'm assuming that you know the basics of PowerShell. What we're going to cover are some of the "gotchas" and nuances that I've run into when I've been working with the language, and particularly with SQL's flavor of PowerShell. And then we'll spend the bulk of our time looking at real-world, practical scripts that I use pretty much every day. PowerShell is an awesome way to automate so many processes and relieve some of the everyday monotony of SQL administration.
Speaker(s): Brian Hansen,
Abstract:
You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated? In this session, we will examine details the query optimization process that are not very well known. We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient. Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos? We'll do just that, and then take it a step further with a unique visualization tool that I have created. With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn't do it as well as might be hoped), you can write more efficient SQL statements.
Speaker(s): Brian Hansen,
Abstract:
Have you heard of NoSQL, but aren't really sure what it is? Are you wondering if you're missing out on something that could satisfy that complex data model problem you haven't found a good solution for? We'll learn about the flavors of NoSql and then dig down into MongoDB, the NoSQL database that drives many websites. Then we'll get an overview of JavaScript Object Notation (JSON) along with how and why it's used in NoSQL, focusing on its advantages and disadvantages. You'll see how the SQL table structure compares to the NoSQL data structure. After that, we'll look at examples of storing the same data in both systems and how that data flows to the web page. We'll discuss the factors that drive your choice of database along with the trade-offs involved. Then we'll wrap up by taking a look at Microsoft's on-premises and cloud efforts in the MongoDB NoSQL space.
Speaker(s): Eric Peterson,
Abstract:
At one of the non-profits (PCs for Refugees) I volunteer, we provide refugees with computers to help them learn English and other school subjects like Math, Science, etc. along with typical usage like ticket booking, navigation, communication, entertainment, etc. In this session, I'll try to explain the benefits of Microsoft for Nonprofits sponsorship and how any cost-effective organization can use MS Forms (or such), Power BI, PowerApps and MS Flow to not only build a full-fledged solution but also how easy and cost-efficient it is to implement, maintain and expand it as necessary. We will go over the implementation of a typical case management system which receives requests; visualize and plan logistics; take it through stages using mobile/web platforms; and keep everyone involved to be fully integrated and informed throughout the life-cycle of the request. We'll also touch upon the insights we used to shape up and optimize the delivery and effectiveness of the empowerment effo
Speaker(s): Yaseen Jamaludeen,
Abstract:
Azure Data Factory version 2 continues to grow and have new features. Today we will walk through Templates , a new feature that focuses on re usability of your pipelines,data sets and other ADF objects. Focus on the new Template Gallery has a lot of good examples. We will focus on showing why we would use each example and what else we have found in the use of ADF, whether it be pulling your data from on premise to the cloud or from cloud to cloud. Today's session will help you understand what you can and can't do for your next Cloud Data implementation.
Speaker(s): Joseph Barth,
Abstract:
Title: Website Analysis Using PowerBI and App Insights: Easier than you think Description: Recently, my company decided to turn on application insights. I was tasked with learning the data model, extracting meaningful data, and providing marketing any information that could increase revenue. The query language used in App Insights is SQL-like, and analyzing large amounts of data was easier than I expected. So, if you have an Azure subscription, a web site, and executives telling you that they don't have enough visibility into web metrics, please attend. During this talk after a brief overview of what App Insights does, I will demo how to run basic to intermediate queries against application insights data, and how to include that in a PowerBI report. You will come away with ideas that can be quickly implemented that will make you immensely popular with the upper management. This talk will be appropriate for DBAs and BI Developers alike. Level: 200 - 300
Speaker(s): Steve Williams,
Abstract:
You don't have to be super artistic to make professional looking Power BI reports. We'll walk through several design concepts borrowed from web design and cognitive psychology and then apply them to a Power BI report. You'll learn practical steps to enhance your reports that you can do today, even if you don't consider yourself artistic.
Speaker(s): Meagan Longoria,
Abstract:
Data Virtualization is becoming a key part of any data platform architecture that is built to enable users to unlock data insights. With so many tools available in the market it is important to understand the main goal of Data Virtualization. In this session, we will use one of the leading tools in the market (Denodo) to showcase how data virtualization empowers users to build Power-BI dashboards combining multiple on premise and cloud sources.
Speaker(s): Cristian Vasconez,
Abstract:
In today’s world reporting and analytics are no longer focused exclusively on internal data from transactional systems and the data warehouse. Mashups using data from partners, commercial and public sources are fast becoming the new normal. Do you have a csv file too big to open, is a non-windows format or generates errors on import or opening? Need to determine the quality of a file downloaded from the internet or supplied by another party? In this presentation we will review tools to examine/repair schema issues and explore Power BI Desktop features that provide insights into your datasets along with the M language for building mashups and data models.
Speaker(s): Phil Robinson,
Abstract:
Creating a Power BI data model is pretty easy, but sometimes we have to deal with more complex scenarios the require us to dig a little deeper. In this session we'll take your modeling skills to the next level as we explore a few advanced techniques that deal with displaying measures in the rows of a table (as opposed to the columns), dynamic currency conversions and an alternate approach to role-playing dimensions.
Speaker(s): Martin Schoombee,
Abstract:
Your server has dozens of CPUs, terabytes of RAM, and solid-state drives, and yet your UPDATE query still takes hours. Why? In this demo-filled session we will discuss common pitfalls for any SQL professional who is manipulating large sets of data with INSERT, UPDATE, and DELETE statements. Not only will you learn about potential issues involving data pages, locks, and the transaction log, but also what techniques you can use to improve performance.
Speaker(s): Jeff Iannucci,
Abstract:
In this session, I will take a use case to walk you through the process of training machine learning models in R and deploying the R models using Tableau, not as a traditional dashboard, but as an application that takes users’ input, calls R engine, and returns model predictions back to users.
Speaker(s): Yueying Li,
Abstract:
Power BI is constantly evolving - every month new features are added which can enhance your report user experience. Be the first to learn the secrets to leveraging newer features like bookmarks and object selection to transform your Power BI Report from an ordinary report to an extraordinary application.
Speaker(s): Andrea Letourneau,
Abstract:
Deploying to SQL Azure? What are the best ways to login/authenticate to SQL Azure? Learn about Azure AD Authentication methods: Integrated Windows authentication, Azure AD principal name and a password, Application token authentication, and additional Azure Active Directory methods Integrated, Universal with MFA, and Interactive
Speaker(s): David Lundell,
Abstract:
The Geography datatype has been a part of SQL Server since 2008. This session will explore the use of this datatype with 73 million acres of Arizona land and drill into performance troubleshooting related to SQL Server Spatial data. We'll look at applications consuming the data, maintenance plans, Python scripts, traditional and spatial indexes.
Speaker(s): Kevin Karns,
Abstract:
Using Databricks to develop and streamline an end-to-end process. Taking data from a raw discovery level, transforming and exploring the data to a dashboard to deliver clean and clear insights across all areas of data exploration and configuration.
Speaker(s): Alexander Brown,
Abstract:
In this presentation we will examine practices that combine and automate the processes between data science and IT teams, in order that they can build, test, and release models faster and more reliably. We will examine the Data Science Devops technology landscape, and demonstrate how Kubeflow can be used to achieve end to end Devops for Data Science.
Speaker(s): David Bess,
Abstract:
Have you been asked to begin querying data in SQL Server databases? Or are you just curious to try T-SQL? Great – let’s get started! In this session we’ll cover the basics of the SELECT statement, your T-SQL tool for getting that data. We’ll also show the individual parts of a query, discuss basic aggregation, and demonstrate common filtering options like parameters and functions. You’ll walk away with a solid foundation, ready to start your journey to become a T-SQL expert.
Speaker(s): Jeff Iannucci,
Abstract:
Almost all of us use SQL Server Management Studio to interact with SQL Server. But did you know there are so many tricks and shortcuts that hide just under the surface that can make working with SSMS feel like second nature? In this session, I will demonstrate these features and help you become more efficient at utilizing SSMS to it's fullest potential - a lot of the time without using the mouse. I will also show you how to customize SSMS to suit your needs, and even demonstrate some cool editing tricks that will take your SQL skills to a whole new level.
Speaker(s): Adrian Mee,
Abstract:
Learn about key tabular model features: date calculations options, many to many relationships, nested grouping, role playing, conditional formatting, granularity differences, direct query, and DAX functions. We'll be looking at the role of Microsoft's semantic layer in Azure Data Architectures, and how to make a big impact on reporting and analytics. If you are transitioning from multiD, I'll join you in a moment of silence, but then let's conquer this tabular model concept and make it work for your business.
Speaker(s): Delora Bradish,
Abstract:
In his book "SQL Antipatterns", Bill Karwin says, "An antipattern is a technique that is intended to solve a problem but that often leads to other problems." JT will explore a few of the SQL pitfalls detailed in Karwin's excellent book. Attendees will see how to identify the patterns, refactor them away, or learn to live with them. Speaker: JT Moree, System Architect, DBA, PMP
Speaker(s): JT Moree,
Abstract:
Please come join Paychex for an overview of Paychex, our history, stats, culture and values. We will also be providing some information on our total rewards and career opportunities. There will also be a couple of Amazon gifts cards raffled during this lunch session (Must be present to win). We look forward to connecting with you!”
Speaker(s): Kimberly StJacques,
Abstract:
This lunch session will introduce you to a very fast way to manage and infinitely scale your data in the cloud
Speaker(s): Ginger Grant,
Abstract:
More and more companies are starting to invest in multiple database platforms and DBAs are needing to develop a skillset to support a mixed-database environment. Database concepts are often the same between platforms, however, the “how” can be very different (and sometimes not different at all!). Starting with the basics and gradually moving into the more advanced; this session will show you how to perform the same task in SQL Server, Oracle, and Mongo. Take a leap and start your journey in to the multi-platform world!
Speaker(s): Kimberly StJacques,
Abstract:
The session aim is to get people excited and curious more about ML without digging in coding or deep concepts. We will explore ML Azure offering, Some ML concepts, ML Studio, create an experiment from Scratch and show how ML can target common business challenges like demand projection or price targeting Lots of hands-on
Speaker(s): Mohamed Mawla,
Abstract:
In this session, we will review the Azure Databricks Unified Analytics Platform and introduce best practices for development. When used together they can significantly accelerate your time to Analytic Insights, facilitate collaboration among Data Engineers, Data Analysts, and Data Scientists, and permit everyone on your project to work with any Data, at any Volume, any Velocity. We will cover best practices for data ingestion and movement of data through the zones of the data lake and data warehouse. Then we will show how you can use this platform for Exploratory Data Analysis (EDA) and Advanced Analytics.
Speaker(s): Eddie Edgeworth,
Abstract:
A common issue database administrators face is data auditing. Many use triggers, CDC, third-party tools, or roll their own type of auditing tool. In SQL Server 2016, a new feature called Temporal Tables was introduced and helps to simplify this common need. In this session, we will take a look at what temporal tables are, how they work and how you can implement them into your environment.
Speaker(s): John Morehouse,
Abstract:
This session will cover the following topics: 1) Walk through the steps SQL Server takes when executing a query 2) How to generate and read an execution plan 3) How to troubleshoot a query using the execution plan Session content assumes an ability to do basic queries against a database.
Speaker(s): Sean Brown,
Abstract:
Increase your T-SQL skills by familiarizing yourself with Window Functions. Learn to write these functions from the ground up and recognize common analytical scenarios where these functions come in handy.
Speaker(s): Phil Guevara,
Abstract:
Everyone wants to know if there are magic buttons you can push to make SQL Server run faster, better and more efficiently. In this session we will go over some of my go-to performance tricks that you can implement to get the biggest improvement with the least amount of change. When it comes to performance tuning, every second counts. We will cover memory optimization, isolation levels, trace flags, statistics, configuration changes and more. I’ll go over real life scenarios we come across as consultants and the changes we made to fix them.
Speaker(s): Monica Rathbun,
Abstract:
In this session we will explore Power BI Desktop configuration settings, Cross-industry process for data mining (CRISP-DM) based project strategies and related community resources. Simple team sharing ideas and tips for data exploration/cleanup will also be covered.
Speaker(s): Phil Robinson,
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,
Abstract:
Power BI security is probably one of the most critical aspects in Power BI implementations yet most often times it is overlooked. There are many aspects to consider when implementing security. We will be discussing many of these aspects as well diving into details of how data is stored within Power BI, where it is hosted and get into the details of governance and compliance aspects in the context of security.
Speaker(s): Suresh Datla,
Abstract:
We are going to review the Logisitics of SQL Saturday
Speaker(s): Ginger Grant,
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,
Abstract:
Do you know what makes a great data model? What does it mean to be Third Normal Form or a Star Schema? When would you use one over the other and why? How can you identify bad designs? In this presentation you will be exposed to good and bad models and learn what you should do in order to create a perfect ten model of your own!
Speaker(s): Leslie Andrews,
Abstract:
It's not a question of whether or not the landscape for the common DBA is changing. Without a doubt, it is. Azure offers up a new world of possibilities for DBA's and we should all strive to learn it. In this session, we'll cover some basic knowledge and terminology of Azure as well as how easy it is to incorporate Azure into your environment. We will stand up a new Azure virtual machine as well as a setup SQL DB. You will see how easy it is to accomplish this. This new-found knowledge will help propel your career into the new landscape.
Speaker(s): John Morehouse,
Abstract:
Azure Data Factory V2 is an Azure a Platform-as-a-Service with many SSIS-like features, but is it good enough to replace SSIS? In this session we will review some of the ETL and ELT features in Azure Data Factory, discuss design patterns for ADF pipelines, review useful activities in ADF and see how closely it compares to SSIS.
Speaker(s): Andrea Letourneau,
Abstract:
The Database Maintenance plans used to be a one size fits all tool that did a lot of unnecessary work, especially, when it came to indexing. So I have been recommending that clients use other tools such as Ola Hallengren’s award winning free SQL Server Maintenance Solution. So let’s have a showdown at high noon in the Arizona desert and see if Database Maintenance Plans in SQL 2016 and 2017 are now good enough or if we still need to turn to other solutions like Ola’s.
Speaker(s): David Lundell,
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,
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/ginger-grant-3a177b157/
Contact: http://www.DesertIsleSQL.com
Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.
LinkedIn: https://www.linkedin.com/pub/leslie-andrews-csm/9/491/b89
Contact: https://www.lace.technology/blog
Leslie Andrews is an IT professional with almost 20 years of experience working with databases, designing databases, as well as designing and developing applications against those databases. 2018-2019 Idera ACE.
For the last decade JT has wrestled heterogeneous DBMSs--bending them to his will--forcing Microsoft and Open Source databases to work together for the common good of man ... or the common good of his paycheck. Having diverse professional roles over the last 2 decades (including small business owner, systems administrator, and developer and more) aids him in understanding technical problems at multiple levels.
LinkedIn: https://www.linkedin.com/in/kimberly-stjacques
Contact: http://dbobserver.com
Kim StJacques is passionate about SQL Server and Community. She has worked in IT for 20+ years and 15 of those years working with SQL Server. Kim's experience as a DBA spans multiple database platforms, however, SQL Server is her passion. Kim is also an avid volunteer in the SQL Server community! She has served as a SQL Saturday organizer/volunteer/speaker, PASS Summit Program Committee, PASS Summit Ambassador, and PASS Summit buddy for first timers. As a recent empty nester, Kim has developed a thirst for learning new things such as Ansible and Docker, however, she still finds time for a few Overwatch matches and a splash of Netflix.
LinkedIn: https://www.linkedin.com/pub/leslie-andrews-csm/9/491/b89
Contact: https://www.lace.technology/blog
Leslie Andrews is an IT professional with almost 20 years of experience working with databases, designing databases, as well as designing and developing applications against those databases. 2018-2019 Idera ACE.
LinkedIn: https://www.linkedin.com/in/jeff-iannucci/
Contact: https://desertdba.com/
Jeff Iannucci is a Senior Database Administrator for DriveTime in Tempe, AZ. He has over 20 years of SQL Server experience as both a DBA and Developer in diverse environments such as health care, finance, retail sales, and government. He writes about solving problems for database professionals on both twitter (@DesertDBA) and his blog (desertdba.com), and has been chosen as an IDERA ACE for 2020.
LinkedIn: https://www.linkedin.com/in/jeffmlakar/
Contact: http://www.mlakartechtalk.com/
Jeff Mlakar is a database professional specializing in Microsoft SQL Server. He has worked the past 15 years as a database developer and administrator (admini-loper or develo-strator…take your pick), analyst, and with Business Intelligence. A technology enthusiast – he is interested in data security and privacy topics. Jeff lives in the Raleigh-Durham area of NC.
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/jeffmlakar/
Contact: http://www.mlakartechtalk.com/
Jeff Mlakar is a database professional specializing in Microsoft SQL Server. He has worked the past 15 years as a database developer and administrator (admini-loper or develo-strator…take your pick), analyst, and with Business Intelligence. A technology enthusiast – he is interested in data security and privacy topics. Jeff lives in the Raleigh-Durham area of NC.
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/eddieedgeworth/
I have 20 years experience with SQL Server and the Microsoft BI Stack and about 8 in Azure. I am a Databricks Champion, Certified Spark Developer and have been a part of multiple successful Databricks implementations for my clients.
LinkedIn: https://www.linkedin.com/in/andrealetourneau
Contact: http://ladyruna.blogspot.com/
Andie has worked as both a DBA and a developer supporting SQL-based applications on all versions of SQL server since version 6.0. Much of her work was focused on managing, debugging, customizing CRM and accounting software as well as integrating disparate systems. She enjoys creating elegant T-SQL code to solve complex problems and simplify business processes. Recently, she's been focused on Azure and Power BI. She's a life-long learner and has attended numerous SQL conferences and training events over the years.
LinkedIn: https://www.linkedin.com/in/sqlrus
Contact: http://www.sqlrus.com
John Morehouse is currently a Consultant with Denny Cherry Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member Community Ambassador, and 2016 Idera Ace. John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible. He is a user group leader, SQL Saturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQL Saturday’s as well as other conferences.
LinkedIn: http://www.linkedin.com/pub/vern-rabe/a/ba3/980
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.
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/sureshdatla/
Worked on the Microsoft stack for 19 years now. Built successful Data Analytics Practices before. Currently focused on Data Platform, Data Analytics, Power BI and ML. I do Dashboard in a day sessions at Irvine MTC once every month. I also, conduct OC power BI user group to build a strong Power BI Community. Worked with SQL Server product since it was version 7 and Power BI since its inception.
LinkedIn: https://www.linkedin.com/in/cristian-vasconez-a7791586
Business Intelligence, Cloud computing, Data Warehousing and Big Data development using Microsoft SQL Server application stack, Microsoft Azure, Amazon Web Services and other tools.
LinkedIn: https://www.linkedin.com/in/markdeneve
Not a DBA (but don't hold that against me). I have been working in the tech field for over 20 years in all areas of IT. My main focus is in Infrastructure from OS support to Hardware, Storage and now "Cloud" and "Platforms." Currently my main focus is finding the best way to deploy and leverage Kubernetes and Containerization. When I am not working with Kubernetes and Containerized apps I am working to teach myself the go programming language and looking for the next big IT trend.
LinkedIn: https://www.linkedin.com/in/joshuasivey/
Josh Sivey is a Microsoft Certified Professional with over fifteen years of experience delivering solutions using Microsoft technologies. He enjoys helping empower users to unlock the power of corporate data using the Microsoft BI stack. Josh is a Technology Solutions Professional with Microsoft. In his free time, he enjoys saving Hyrule from the clutches of Ganon with his son and playing My Little Ponies with his daughter.
LinkedIn: https://www.linkedin.com/pub/delora-bradish/1b/a16/698
Contact: http://www.delorabradish.com
Delora Bradish comes to SQL Saturday by way of Pragmatic Works. She has worked with SQL Server from 1999 with a primary career focus in MS BI since 2005. Delora has assisted companies of every size to implement SSIS, SSRS, SSAS and Sharepoint solutions. Some of her clients have included Hewlett-Packard, NASCAR, and General Motors, as well as state governments and prominent medical agencies. Delora is a MCSE in BI and Data Platform, and holds her MCSA in SQL 2012.
LinkedIn: https://www.linkedin.com/in/andrealetourneau
Contact: http://ladyruna.blogspot.com/
Andie has worked as both a DBA and a developer supporting SQL-based applications on all versions of SQL server since version 6.0. Much of her work was focused on managing, debugging, customizing CRM and accounting software as well as integrating disparate systems. She enjoys creating elegant T-SQL code to solve complex problems and simplify business processes. Recently, she's been focused on Azure and Power BI. She's a life-long learner and has attended numerous SQL conferences and training events over the years.
LinkedIn: https://www.linkedin.com/in/jeff-iannucci/
Contact: https://desertdba.com/
Jeff Iannucci is a Senior Database Administrator for DriveTime in Tempe, AZ. He has over 20 years of SQL Server experience as both a DBA and Developer in diverse environments such as health care, finance, retail sales, and government. He writes about solving problems for database professionals on both twitter (@DesertDBA) and his blog (desertdba.com), and has been chosen as an IDERA ACE for 2020.
LinkedIn: https://www.linkedin.com/in/yueying-li-21bb44a8
Advanced analytics consultant at Neudesic with 4+ years of experience modeling and analyzing data in various fields. Experienced in creating machine learning, data mining, and BI solutions including analyzing online marketing campaigns, predicting churning/fraudulence customers, leading ETL implementation of large retail data, developing Tableau and Power BI dashboards and a data warehouse, crawling data from websites, creating data visualizations, building econometric models, and utilizing Hadoop ecosystem tools.
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.
LinkedIn: https://www.linkedin.com/in/kevin-karns-8173772a
Contact: https://www.kkarnsdba.com
Kevin Karns is a Database Administrator for the State of New Mexico and a PASS community member at the Santa Fe, NM local group at santafesql.pass.org. He has worked with SQL Server since the 3.8 version on Solaris and Netware. His current work supports leasing activities on 13 million acres of georeferenced state land. In his free time, he tries not to break anything while trail running in Santa Fe and Payson, AZ. When back at the desk, he blogs about coding and about the databases he's broken at www.kkarnsdba.com. (he/him/his)
Eric Peterson is a consultant specializing in database architecture with experience in demanding Fortune 100 company environments. He has a Computer Science degree complemented with an MBA, which meshes well with his jobs integrating business information with the systems that process it. He has worked with SQL Server since its inception and was an instructor of SQL courses at a national technical training company. He also speaks are regional SQLSaturday events.
LinkedIn: http://www.linkedin.com/in/meaganlongoria/
Contact: http://datasavvy.me
Meagan Longoria is a business intelligence consultant with Denny Cherry Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).
Contact: http://blogs.vmware.com/apps
Deji Akomolafe (a member of the Office of the CTO Ambassador Program and Staff Solutions Architect within VMware#39;s Global Field and Partners Readiness Group) specializes in the virtualization of Microsoft Business Critical Applications on VMware#39;s vSphere platform. Deji is a regular speaker at VMworld, Partners Exchange Conference, VMUG, SQL Saturday and EMCWorld, presenting technical subject matters related to Microsoft Applications virtualization and providing technical guidance to help clients enhance their expertise and ability to optimally virtualize and operate their critical applications.
LinkedIn: https://www.linkedin.com/in/sqlrus
Contact: http://www.sqlrus.com
John Morehouse is currently a Consultant with Denny Cherry Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member Community Ambassador, and 2016 Idera Ace. John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible. He is a user group leader, SQL Saturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQL Saturday’s as well as other conferences.
LinkedIn: https://www.linkedin.com/in/sqlda/
Contact: http://sqlda.com
An eight year Microsoft SQL Server Specialist in SQL Server 2005-2016, Azure SQL DB, he has held many development positions, including SQL query tuner, SSIS and SSRS . Joseph's early focus as an SQL tuning professional, fixing long running queries by techniques; join order,use of temporary object, also implementing Index optimization, maintenance and design to fix slowness. Joseph has focused on ETL solutions using SSIS for the last 4 years, data warehousing and cloud architecture using Azure. Currently working on a Modern Data Warehouse project involving Azure Data Lake and Azure SQL DW using external tables. MCSE Data Management and Analytics 2016 MCSA: SQL Server 2012 Co-found CASSUG Albany NY 2 yrs AZSSUG Chapter Leader 3 yrs
LinkedIn: https://www.linkedin.com/in/ginger-grant-3a177b157/
Contact: http://www.DesertIsleSQL.com
Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.
LinkedIn: http://www.linkedin.com/in/amiemason33
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.
LinkedIn: http://www.linkedin.com/in/meaganlongoria/
Contact: http://datasavvy.me
Meagan Longoria is a business intelligence consultant with Denny Cherry Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).
LinkedIn: https://www.linkedin.com/in/kimberly-stjacques
Contact: http://dbobserver.com
Kim StJacques is passionate about SQL Server and Community. She has worked in IT for 20+ years and 15 of those years working with SQL Server. Kim's experience as a DBA spans multiple database platforms, however, SQL Server is her passion. Kim is also an avid volunteer in the SQL Server community! She has served as a SQL Saturday organizer/volunteer/speaker, PASS Summit Program Committee, PASS Summit Ambassador, and PASS Summit buddy for first timers. As a recent empty nester, Kim has developed a thirst for learning new things such as Ansible and Docker, however, she still finds time for a few Overwatch matches and a splash of Netflix.
LinkedIn: https://www.linkedin.com/in/yaseenj/
A seasoned BI professional with over 16 years of experience in consulting engagements building various solutions using Microsoft Data Platform tools and technologies. While it used to be that my daily agenda was to deal with SQL Server, SSIS, SSAS, SSRS, PPS, SharePoint, Dynamics 365, etc. these days it's all about Power BI, Azure Data Factory, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Lake, Azure Databricks, Azure Machine Learning, etc. in almost all my consulting engagements. As somebody proficient enough in hardware, software, systems, security and networking, I am a passionate teacher and a technology evangelist who simply lives by the principle "If you can't explain it simply, you don't understand it well enough."
LinkedIn: http://www.linkedin.com/in/meaganlongoria/
Contact: http://datasavvy.me
Meagan Longoria is a business intelligence consultant with Denny Cherry Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).
LinkedIn: https://www.linkedin.com/in/kimberly-stjacques
Contact: http://dbobserver.com
Kim StJacques is passionate about SQL Server and Community. She has worked in IT for 20+ years and 15 of those years working with SQL Server. Kim's experience as a DBA spans multiple database platforms, however, SQL Server is her passion. Kim is also an avid volunteer in the SQL Server community! She has served as a SQL Saturday organizer/volunteer/speaker, PASS Summit Program Committee, PASS Summit Ambassador, and PASS Summit buddy for first timers. As a recent empty nester, Kim has developed a thirst for learning new things such as Ansible and Docker, however, she still finds time for a few Overwatch matches and a splash of Netflix.
LinkedIn: https://www.linkedin.com/in/adrian-mee/
A native of Melbourne, Australia - Adrian currently works for Falling Colors Technology in Santa Fe, NM. In this role, he is responsible for Database administration, data security and infrastructure. Adrian has been working with SQL Server since the Enterprise Manager days of SQL Server 2000. Adrian is an Idera ACE, class of 2020, and in 2017 he founded the Santa Fe SQL Server User group. When out of the office, he loves biking and hiking the great outdoors.
TBD
Phil Robinson is an independent consultant focused on developing Business Intelligence solutions using Microsoft Reporting Services and Power BI. He is founder of the San Diego SQL Business Intelligence Group and co-founder of SQL Saturday – San Diego.
LinkedIn: https://www.linkedin.com/in/seanpbrown
Contact: http://seansdigs.com
Sean Brown has been working with SQL Server since 2005, mostly doing ETL work but more recently supporting the database layer of multilayered web applications and writing web services to support data transfer between systems. Sean has previously worked at Acxiom, Dell, Blackboard, and Grand Canyon University. He currently works at DriveTime in Database Engineering
Trilingual Principal Consultant amp; Team Tech lead at a global Tech Consulting Mohamed had worked with large SQL server environments such as financials and gov of hundreds of SQL server instances and enormous amounts of data. His favorite subjects are Cloud Analytics, performance tuning, High Availability, especially Replication and Disaster recovery. Certified Google Cloud and Azure Data Engineer. When not working, Mohamed carries his cameras and takes a trip somewhere.
Contact: http://www.tf3604.com
Brian is a database administrator at Children International in Kansas City. He has been working with SQL Server technologies since 1998, including roles in report development, application development and database administration.
LinkedIn: https://www.linkedin.com/in/phil-guevara-087204103/
Arizona native who's been involved in data and analytics for the past 3 years. I have experience working with SQL Server, SQL Server Analysis Services, as well as various ETL and reporting tools.
Contact: http://www.tf3604.com
Brian is a database administrator at Children International in Kansas City. He has been working with SQL Server technologies since 1998, including roles in report development, application development and database administration.
LinkedIn: https://www.linkedin.com/in/davidlunde11/
Contact: http://Blog.ilmbestpractices.com
Author of How to Be an MVP in Life, Author of FIM Best Practices Volume 1, Microsoft MVP, Speaker, Entrepreneur and Consultant. 20+ years in IT. MBA, BS Computer Engineering both at University of Arizona. Helped establish database care and feeding best practices among Microsoft Identity Management professionals. Created unique SSIS and SSAS based solutions to problems in the Identity Management area.
LinkedIn: https://www.linkedin.com/in/mdarab/
Contact: https://mohammaddarab.com
Mohammad Darab is a Microsoft Data Professional, speaker and blogger with over 19 years of IT professional experience, 10+ years of that working with SQL Server. Some areas of his focus are the database engine, HA/DR, and security. He is currently an MCITP, MCP, as well as an IDERA ACE Class of 2019.
Contact: http://www.tf3604.com
Brian is a database administrator at Children International in Kansas City. He has been working with SQL Server technologies since 1998, including roles in report development, application development and database administration.
LinkedIn: https://www.linkedin.com/in/davidlunde11/
Contact: http://Blog.ilmbestpractices.com
Author of How to Be an MVP in Life, Author of FIM Best Practices Volume 1, Microsoft MVP, Speaker, Entrepreneur and Consultant. 20+ years in IT. MBA, BS Computer Engineering both at University of Arizona. Helped establish database care and feeding best practices among Microsoft Identity Management professionals. Created unique SSIS and SSAS based solutions to problems in the Identity Management area.
LinkedIn: http://www.linkedin.com/pub/vern-rabe/a/ba3/980
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.
LinkedIn: http://www.linkedin.com/in/amiemason33
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.
LinkedIn: https://www.linkedin.com/in/davebess/
David Bess is Director of Predictive Enterprise with Neudesic, where he helps to lead solutions and delivery for data and analytics. His career has included leadership roles in data engineering, data science, enterprise architecture, and applications. David specializes in utilizing cutting edge technology to design and deliver end-to-end solutions existing at the convergence of data engineering, data science, and applications. He has a successful track record of designing and delivering intelligent applications at internet scale.
Phil Robinson is an independent consultant focused on developing Business Intelligence solutions using Microsoft Reporting Services and Power BI. He is founder of the San Diego SQL Business Intelligence Group and co-founder of SQL Saturday – San Diego.
LinkedIn: https://www.linkedin.com/in/steve-williams-0aa42844/
Steve is a data platform professional with 20 years of database and analytics experience. His work currently focuses on SQL Server, PowerBI, Data Warehousing, Azure, Application Insights, and Data Science. He began his technical career as a support desk person taking calls and investigating hotel software problems. Steve is currently the Vice President of data services at a software company in Phoenix. His hobbies include golf and camping.
LinkedIn: http://www.linkedin.com/in/martinschoombee
Contact: http://www.martinschoombee.com
Martin is an independent Business Intelligence Analytics consultant, helping customers make sense of their data for more than 15 years.
The following is a list of sponsors that helped fund the event.