SQLSaturday #978 - Los Angeles – Virtual 2020
Event Date: 06/13/2020 00:00:00
Event Location:
- Loyola Marymount University (“LMU”)
- 1 LMU Drive, Los Angeles, California
- Los Angeles, California
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Secure SQL Server Database Design: Tactics and Technology
Abstract: When we design and build an application, do we think about security first or is it an afterthought? As we read about more and more data breaches, it is clear that we need to think security-first when designing and building our applications.
Where does design start for an application? It starts with the database layer. In this talk, we will discuss strategies for designing a more secure SQL Server database. We will start with simple design decisions for tables, views, stored procedures, and database roles that can improve security before moving on to talk about built-in SQL Server security technologies such as Always Encrypted, Row-Level Security, Dynamic Data Masking, Transparent Data Encryption, and SQL Server Audit. Lastly, we will finish up with some tips on how to retrofit security features onto existing databases and look at how data access from the application may need to change.
Speaker(s):
- Dan Mallott
Track and Room: Database Administration, Deployment, and Development - https://tinyurl.com/2020sqlsatla-PureStorage
Title: Inside SQL Server on Kubernetes
Abstract: Containers are the new “virtual machines” and one of the hottest technologies in the industry. While containers compliment virtual machines and provide consistency, portability, performance, and availability, how do you deploy containers at scale? For many, Kubernetes, an open-source system for automating deployment, scaling, and management of containerized applications, is the answer.
In this session, we will dive deep into the Kubernetes platform and how SQL Server containers can be deployed, managed, and configured. You will see how SQL Server can take advantage of Kubernetes for “built-in” high availability, easy to deploy patching, and integration with Always On Availability groups. We will discuss deploying SQL Server in various popular Kubernetes distributions including but not limited to Azure Kubernetes Service, OpenShift, and kubeadm. This session assumes a fundamental knowledge of both SQL Server and containers. We will move fast, and go deep using demos as a method to lea
Speaker(s):
- Bob Ward
Track and Room: Database Administration, Deployment, and Development - https://tinyurl.com/2020sqlsatla-Microsoft
Title: Building your own million dollar SQL Practice
Abstract: Would you like to get to $1m annual revenue in 5 easy steps? Or, do you simply want to go from barely sustainable to profitable?
In this session I will touch on the 5 steps I considered when building and growing out a SQL Data Platform practice.
- Choose a specialty.
- How to decide what to do, and how to make it shine.
- Pick your partners.
- Why partnering is essential.
- Augmenting your capabilities.
- Defining services.
- What are the differences between Managed Service and Professional Service.
- How many services to offer.
- How to pick a service and price point.
- How long before you actually make money.
- Market your offerings.
- Yes, you have to sell, yourself.
- When to give things away for free
- The value of existing customers
- Build your team.
- You’re making it, now you need to manage it
- Bringing on the right people.
I’ll also touch on how long it took me to achieve each of these, and how I measure success.
Speaker(s):
- Adrian Sullivan
Track and Room: Other - https://tinyurl.com/2020sqlsatla-PureStorage
Title: Data Lake Design Patterns
Abstract: Data lakes have been around for several years and there is still much hype and hyperbole surrounding their use. This session covers the basic design patterns and architectural principles to make sure you are using the data lake and underlying technologies effectively. We will cover things like best practices for data ingestion and recommendations on file formats as well as designing effective zones and folder hierarchies to prevent the dreaded data swamp. We’ll also discuss how to consume and process data from a data lake. And we will cover the often overlooked areas of governance and security best practices. This session goes beyond corny puns and broken metaphors and provides real-world guidance from dozens of successful implementations in Azure.
Speaker(s):
- Jason Horner
Track and Room: Data Presentation, Visualization, and Analytics - https://tinyurl.com/2020sqlsatla-Blackline
Title: Data Lakes with Azure Databricks
Abstract: The world of analytics and data warehousing has evolved rapidly in the last 10 years with the Data Lake as the backbone of modern data environments. Data Lakes are best built leveraging unique services of the cloud provider to reduce operations complexity. This session will explain why everyone’s talking about data lakes, break down the best services in Azure to build a Data Lake, and walk through code for querying and loading with Azure Databricks.
Attendees will leave the session with a firm grasp of why we build data lakes and how Azure Databricks fits in for ETL and querying.
Agenda: - Why Data Lakes? - Data Lake best practices - Reference Architecture implemented with: ○ Azure Databricks ○ Azure Data Lake Storage (Gen 2) ○ Event Hubs for Apache Kafka
Speaker(s):
- Dustin Vannoy
Track and Room: Private and Public Cloud Architecture and Infrastructure - https://tinyurl.com/2020sqlsatla-Blackline
Title: Loading SQL Server Data with Powershell
Abstract: Powershell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting. This is a no holds barred session taught by an enterprise SQL Server scripting expert. You can’t afford to miss this session if you do any level of scripting in your shop.
Prerequisites: Basic understanding of Powershell syntax.
Speaker(s):
- Sean McCown
Track and Room: Database Administration, Deployment, and Development - https://tinyurl.com/2020sqlsatla-SentryOne
Title: DevOps for Azure SQL
Abstract: “But… it worked on my computer!” A good DevOps practice and implementation will help eliminate that unwelcome phrase! Come to this session to learn how to use tools and platforms like Visual Studio Code, Git, Azure DevOps, GitHub Actions for a modern, secure and easy-to-use database DevOps experience for Azure SQL. We will use demos to show and evaluate two approaches: first, a code-centric migration-based approach (using DbUp and GitHub Actions), and second, a more complex project/state-based approach (using Visual Studio SQL Projects and Azure DevOps and a locked-down Azure SQL DB) to understand some of the many possibilities for implementing DevOps for Azure SQL.
Speaker(s):
- Arvind Shyamsundar
Track and Room: Private and Public Cloud Architecture and Infrastructure - https://tinyurl.com/2020sqlsatla-Microsoft
Title: Synapse Analytics: Beyond the Basics
Abstract: Synapse Analytics, which is way beyond the former Azure SQL Data Warehouse, is focused on MPP, Multi Parallel Processing, being a very powerful environment for Data Warehouse processing.
It’s former name, Azure SQL Data Warehouse, usually pushed many DW and BI developers to use this powerful tool in order to build a Data Warehouse. However, just implementing the logical design of a Data Warehouse inside an MPP environment can be very deceiving, because many default settings for the MPP environment will not be at their best.
On this session you will see how to configure the MPP environment to achieve it’s best performance for your Data Warehouse. You will understand the importance to understand and control the distributions by compute nodes, how critical are the correct choice of resource classes and users, the benefits to correct manage workload classification and much more.
Speaker(s):
- Dennes Torres
Track and Room: Database Administration, Deployment, and Development - https://tinyurl.com/2020sqlsatla-PureStorage
Title: Get Your Optimizer to Give up All Its Secrets
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 of the query optimization process that are not very well known. We will discuss how SQL Server parses a T-SQL statement then 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 free 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. VMware Room - https://tinyurl.com/2020sqlsatla-vmware Feedback - https://tinyurl.com/2020sqlsatla-eval
Speaker(s):
- Brian Hansen
Track and Room: Database Administration, Deployment, and Development - https://tinyurl.com/2020sqlsatla-VMware
Title: Architecting SQL Server on VMware vSphere - Doing it Right!
Abstract: Let us connect DBAs and Infrastructure Admins providing to DBAs vital information how to get best SQL Server deployment on top of VMware virtual platform.
The session will cover both the design and the configuration of a SQL Server virtual machine with the special focus on:
vCPU allocation and deep dive in vNUMA
Memory allocation and configurations options
Storage configuration best practices including PMem/NFS/Snapshots
Network configuration myths and best practices
It all that you want to know about virtual platform configuration but hesitated to ask! Directly from the source with the tom of hands-on from the Professional Services VMware Room - https://tinyurl.com/2020sqlsatla-vmware Feedback - https://tinyurl.com/2020sqlsatla-eval
Speaker(s):
- Oleg Ulyanov
Track and Room: Private and Public Cloud Architecture and Infrastructure - https://tinyurl.com/2020sqlsatla-VMware
Title: Document Design for Document Oriented Databases
Abstract: When designing your documents for databases such as MongoDB, CosmosDB, or DocumentDB you should not be following old normalization rules. What rules it should your follow? This session will give you a good foundation for figuring this out. I’ll be surveying some common use cases and how to model them. We’ll discuss some rules of thumb, and discover both how and why certain designs work better than others. Relationships, entities, indexes, memory, working sets - all the familiar concepts in an all new light. VMware Room - https://tinyurl.com/2020sqlsatla-vmware Feedback - https://tinyurl.com/2020sqlsatla-eval
Speaker(s):
- Nuri Halperin
Track and Room: Database Administration, Deployment, and Development - https://tinyurl.com/2020sqlsatla-VMware
Title: Microsoft SQL Server workloads on VMware Cloud on AWS: Design, Migration and Configuration
Abstract: We provide architectural guidelines to plan migration of SQL Server workloads to VMware Cloud on AWS, technical deep dive into execution of migration of SQL Server workload, along with configuration recommendations for FCI and AG and performance tuning options. You will learn how to optimally use VMware Cloud on AWS to host mission critical SQL Server workloads
Speaker(s):
- Oleg Ulyanov
Track and Room: Private and Public Cloud Architecture and Infrastructure - VMware
Title: The Future of Containers Is Here!
Abstract: Spinning up a container is very simple but managing container infrastructure especially when it is on premises is quite complex. Learn about what it takes to mange an on premises deployment, Learn how Azure Arc can simplify your on premises container deployment, Leveraging containers with Arc can then allow you to quickly move back and forth between on Premises and Azure.
Speaker(s):
- Marsha Pierce
Track and Room: Database Administration, Deployment, and Development - https://tinyurl.com/2020sqlsatla-PureStorage
Title: Introduction to MongoDB
Abstract: Getting started with MongoDB is not always easy. This gentle introduction goes heavy on the demo to show you what it feels like to use MongoDB as a developer. Rather than relying on extra frameworks and such, we’ll access MongoDB directly from the shell and Node, and see how you achieve both simple and complex data manipulation tasks.
Along the way, we’ll cuts through some myths and misunderstandings surrounding MongoDB. You will learn what’s unique about this database, how best to leverage its capabilities, and be well positioned to decide if this is a good fit for application.
Speaker(s):
- Nuri Halperin
Track and Room: Private and Public Cloud Architecture and Infrastructure - https://tinyurl.com/2020sqlsatla-VMware
Title: Agile data preparation with ADF Wrangling data flow
Abstract: Data Wrangling is becoming more and more popular in BigData and Enterprise world. Data Lake stores tons of different data and it is not easy to get value from it. To prepare data we need to write and test code that could take a while. But, business requires to have results immediately and reduce time to market. In this session, I invite you together look at Self-Service Data Prep and show how to use Power Query Online in Azure Data Factory Wrangling data flows for code-free data transformations via spark execution. VMware Room - https://tinyurl.com/2020sqlsatla-vmware Feedback - https://tinyurl.com/2020sqlsatla-eval
Speaker(s):
- Sergiy Lunyakin
Track and Room: Data Presentation, Visualization, and Analytics - https://tinyurl.com/2020sqlsatla-VMware
Title: SQL Graph Databases: Beyond Relational
Abstract: Since SQL Server 2017 the Graph Database feature was released, enabling us to mix the relational model with a Graph model. Some existing flaws in this release are being fixed in SQL Server 2019, bringing graph objects closer to SQL Serve reality.
In this session, you will discover how Graph Databases in SQL Server works and what’s new for them in SQL Server 2019
Speaker(s):
- Dennes Torres
Track and Room: Database Administration, Deployment, and Development - Pure Storage
Title: How Intelligent Query Processing improves T-SQL performance
Abstract: Do you write T-SQL for a living and want to improve its performance? Do you wish your 3rd party vendor code would magically go faster? Then you need to learn about Intelligent Query Processing in SQL Server 2019. This collection of new features is a game changer that will improve performance across the board. Come to this overview session to learn more about how these capabilities will benefit you.
Speaker(s):
- Andy Yun
Track and Room: Database Administration, Deployment, and Development - https://tinyurl.com/2020sqlsatla-SentryOne
Title: Going Beyond Monitoring With SentryOne
Abstract: Hopefully, you are monitoring your SQL Servers using DIY scripts or a 3rd party tool. Active monitoring is invaluable to enable the operational DBA to identify and address issues quickly. But did you know that SentryOne offers capabilities beyond just monitoring? Join me and I’ll show you how SentryOne provides environment wide visibility and aids in managing cross-server activities. I’ll showcase how alerting can be tuned to be effective and not noise. And you’ll discover how SentryOne can give you both operational and business value to address your application challenges.
Speaker(s):
- Andy Yun
Track and Room: Other - https://tinyurl.com/2020sqlsatla-SentryOne
Title: Running SQL Server workload on AWS
Abstract: Amazon Relational Database Service (RDS) supports six different engines and MS SQL Server is one of them. Bring your SQL Server workload to RDS and have AWS manage your hardware, OS, database engine, backups, High-Availability and scalability amongst other things. So, you can focus on application tuning and development. VMware Room - https://tinyurl.com/2020sqlsatla-vmware Feedback - https://tinyurl.com/2020sqlsatla-eval
Speaker(s):
- Eugene Stepanov
Track and Room: Private and Public Cloud Architecture and Infrastructure - https://tinyurl.com/2020sqlsatla-VMware
Title: SQL Server 2019 is not your dad’s DBMS
Abstract: SQL Server 2019 is more than the database engine, it is a data solution platform. This release introduces multiple new features that will give you new ways to implement better and faster multi platform data solutions. Armando will demo many of these features on processing high data volume from multiple data sources and data formats without leaving SSMS.
Speaker(s):
- Armando Lacerda
Track and Room: Database Administration, Deployment, and Development - https://tinyurl.com/2020sqlsatla-Blackline
Title: Add JSON to the list of tools in your SQL Server tool-belt.
Abstract: If you are not sure why JSON is in SQL Server or how to use it, this is the session for you! We will start with the basics of what JSON is and learn all about extracting, querying, and even indexing JSON data. The goal of this session is to take the mystery out of working with JSON in SQL server and add JSON to the list of tools in your SQL Server tool-belt.
Speaker(s):
- Elaena Bakman
Track and Room: Data Presentation, Visualization, and Analytics - https://tinyurl.com/2020sqlsatla-Blackline
Title: Case Study: How I used SharePoint, Power Automate, Power Apps, and Forms to build a Speaker Database
Abstract: In this case study, I detail how I went about designing and implementing a Speaker Database for the Project Management Institute using SharePoint, Power Automate, Power Apps, and Microsoft Forms. We will do a brief intro of what each technology is and it’s pros and cons, and then dive into what I learned about each, each strengths and weaknesses, and how I was able to build a functional Speaker Database.
Speaker(s):
- Sarah Patrick
Track and Room: Data Presentation, Visualization, and Analytics - https://tinyurl.com/2020sqlsatla-Blackline
Title: 3 Ways for Getting Data from SharePoint : SSIS, Excel and Access
Abstract: Need to report on some data from SharePoint? We will look at three different techniques to pull data from a SharePoint Server. We will start with SSIS and the SharePoint List Source and Destinations. Next, We will use Excel to connect to various SharePoint lists (both online and on premise), and finally We will use Microsoft Access to do the same thing (and throw in the capability to do updates as well). At the end of the talk, We will have three different ways to get data from SharePoint.
Speaker(s):
- David Patrick
Track and Room: Database Administration, Deployment, and Development - https://tinyurl.com/2020sqlsatla-Blackline
Title: Implementing AI solutions using Azure Machine Learning Services
Abstract: Artificial Intelligence (AI) is bringing big changes in the way people and businesses relate to technology. As well as the arrival of the personal computer, the cloud computing, and smartphones, the AI is the artificial technology that takes you to where you’re going so much faster, intuitive and smart. In this session, we will discuss the basics of IA and how we can apply it in our business using the Azure Machine Learning Services
Speaker(s):
- Vitor Fava
Track and Room: Data Presentation, Visualization, and Analytics - https://tinyurl.com/2020sqlsatla-SentryOne
Title: Presentation Skills for the Technical Professional
Abstract: Whether you’re new to presenting or an accomplished professional, all of us need to learn more about presentation skills. In this real-world session, Buck Woody, a Data Scientist from Microsoft will show you how to:
- Choose and develop a topic that draws in an audience
- Create a story-line for your session
- Understand the technologies and tools for delivering your session effectively
- Deal with presentation disasters
Speaker(s):
- Buck Woody
Track and Room: Professional Development and Personal Branding - https://tinyurl.com/2020sqlsatla-Microsoft
Title: SQL SERVER 2019: top features that every DBA should know
Abstract: SQL SERVER 2019 is a game changer with the Big Data Clusters and all of its improvements! But what about the good old DBA features? There’s lots of them! And in this presentation, we’ll show some of them like: Memory Optimized Tempdb metadata, Transparent Database Encryption enhancements, Accelerated Database Recovery, Data virtualization and of course: SQL SERVER on your platform of choice!
Speaker(s):
- Marcelo Adade
Track and Room: Database Administration, Deployment, and Development - https://tinyurl.com/2020sqlsatla-PureStorage
Title: Faster Transactions: Query Tuning for Data Manipulation
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 examine common pitfalls for any SQL professional who manipulates large sets of data with INSERT, UPDATE, and DELETE statements. We discuss potential issues involving data pages, locks, and the transaction log, as well as techniques you can use to improve performance.
Speaker(s):
- Jeff Iannucci
Track and Room: Database Administration, Deployment, and Development - https://tinyurl.com/2020sqlsatla-SentryOne
Title: New SQL Server Features for Developers and Analysts
Abstract: Latest SQL Server versions added many new features and services to the database engine. I will cover the latest features of SQL Server 2017 and 2019 for developers in this session. Don’t miss it!
Here is the list of features I will cover in this session.
Using Graph Tables in SQL Server Temporal Tables for Auditing How to run R Script, Python and Java in SQL Server Using Clustered Columnstore Indexes Using Memory Optimized Tables jSON in SQL Server
Speaker(s):
- Hasan Savran
Track and Room: Database Administration, Deployment, and Development - https://tinyurl.com/2020sqlsatla-PureStorage
Title: Monitoring SQL Server using Community solutions (Free)
Abstract: In this session we will cover how to monitor and support any SQL Server Environment using free tools created by community members
Speaker(s):
- Javier Villegas
Track and Room: Database Administration, Deployment, and Development - https://tinyurl.com/2020sqlsatla-SentryOne
Title: Azure SQL: What to use when
Abstract: In this session, you’ll learn from the Microsoft Product Group about the different options for your SQL deployments in Azure. After this session, you should be able to: ○ Articulate the key differentiators between SQL Server on-prem, in Azure VM, in Azure SQL DB (Single database, Elastic Pools, and Managed instance) ○ Explain the different service tiers within Azure SQL DB, and evaluate what is best for your workloads and business requirements (Serverless, Hyperscale, General Purpose, Business Critical, etc)
Speaker(s):
- Anna Hoffman
Track and Room: Private and Public Cloud Architecture and Infrastructure - https://tinyurl.com/2020sqlsatla-Microsoft
Title: Google BigQuery ML: Machine Learning with SQL
Abstract: BigQuery is the data warehouse offering from Google Cloud Platform. It also has a powerful and increasingly growing machine learning integration. Using BQML, you can create, train, or import linear regression and classifier models directly into your dataset. You can then make predictions directly using SQL and integrate them into your reporting and dashboards. This session will cover BigQuery ML and a few example applications. VMware Room - https://tinyurl.com/2020sqlsatla-vmware Feedback - https://tinyurl.com/2020sqlsatla-eval
Speaker(s):
- Mark Mucchetti
Track and Room: Private and Public Cloud Architecture and Infrastructure - https://tinyurl.com/2020sqlsatla-VMware
Title: Basic Work-Flow with SQL Server Standard SSRS
Abstract: Many companies have small tasks that need to be accomplished regularly. Sometimes these tasks require a number of steps to be successful. Need a basic workflow app but aren’t a .Net developer? We have a solution for you.
This session will be demo intensive, focusing on how to use SSIS, SSRS, and SQL Server standard edition to stitch together a process that emulates a proper workflow.
Speaker(s):
- Brodie Brickey
Track and Room: Data Presentation, Visualization, and Analytics - https://tinyurl.com/2020sqlsatla-Microsoft
Title: Azure SQL Hyperscale Deep Dive
Abstract: The Azure SQL Database Hyperscale tier is SQL architected for the cloud and allows applications that encountered limits of prior tiers to be unshackled. Will deep dive into the architecture of Hyperscale and discuss the components of hyperscale and iteraction between each component and the internals of each component. We will cover scaling aspects and the new application patterns it enables. Last but not the least best practices during migration as well as new diagnostics introduced in Hyperscale that help in performance troubleshooting and bottleneck identification.
Speaker(s):
- Denzil Ribeiro
Track and Room: Database Administration, Deployment, and Development - https://tinyurl.com/2020sqlsatla-Microsoft
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Oleg Ulyanov
LinkedIn: Oleg Ulyanov
Contact: https://blogs.vmware.com/apps/
Oleg Ulyanov is a Sr. Solution Architect in VMware Technical Marketing focused on database virtualization and monitoring. He previously spend more than 6 years within VMware Professional Services (PSO) and have more than 15 years of experience in IT. He is a Subject Matter Expert in both monitoring and virtualization of business critical applications with tons of hands-on experience directly from customer sites. He holds a broad range of industry certificates including VMware VCP 4/5, VCAP5-DCD/DCA/CID/CIA, VCAP6-DCV, SNIA, Microsoft, and speaks regularly at the official events like VMworld, VMware User Group, SQLSaturdays.
Mark Mucchetti
LinkedIn: Mark Mucchetti
Contact: https://virtu.is
I am a technology leader with a strong focus on managing and mentoring talented teams to successful production of real business value. As a software engineer I learned the value of strong agile process methodology and disciplined enterprise architecture. I believe in services, platforms, and product-oriented delivery. As a leader, I strive to combine the technical and the personal to motivate people to do what they do best – focus, code, and release. When that falls into place, computers also get to do what they do best – keep running while we spend time with friends and family. My philosophy is that these two things need not be mutually unattainable!
Dennes Torres
Twitter: - Dennes
LinkedIn: Dennes Torres
Contact: https://www.red-gate.com/simple-talk/author/dennes-torres/
Dennes Torres is a Data Platform MVP with more than 25 years of experience in the IT area. He improves Data Platform Architectures and turns data into knowledge. As a Brazilian living in Malta, Dennes works as a software developer and leads the Malta MDP User Group. Having the MCSE Data Platform, Business Intelligence, and Microsoft Certified Trainer (MCT) certifications, Dennes has been in love with database servers since he was introduced to SQL Server 6.5, more years ago than he would like to admit.
Andy Yun
Twitter: - SQLBek
LinkedIn: Andy Yun
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, SQLSaturdays, 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 SQLSaturday Organizing Committee.
Hasan Savran
Twitter: - Savranweb
LinkedIn: Hasan Savran
Contact: http://h-savran.blogspot.com/
Hasan Savran is a BI Architect at Progressive Insurance Company. He spends his days architecting cutting edge business solutions by using the latest Web and Database technologies. He is a Microsoft Data Platform MVP, Microsoft Certified Solutions Developer. Hasan has spoken at many SQLSaturdays, Code Camps and User groups. He is an active member of the HTML5 and WebAssembly W3C groups. He likes to write about SQL, CosmosDB, C#, and Front End development on his blog.
Oleg Ulyanov
LinkedIn: Oleg Ulyanov
Contact: https://blogs.vmware.com/apps/
Oleg Ulyanov is a Sr. Solution Architect in VMware Technical Marketing focused on database virtualization and monitoring. He previously spend more than 6 years within VMware Professional Services (PSO) and have more than 15 years of experience in IT. He is a Subject Matter Expert in both monitoring and virtualization of business critical applications with tons of hands-on experience directly from customer sites. He holds a broad range of industry certificates including VMware VCP 4/5, VCAP5-DCD/DCA/CID/CIA, VCAP6-DCV, SNIA, Microsoft, and speaks regularly at the official events like VMworld, VMware User Group, SQLSaturdays.
Sergiy Lunyakin
Twitter: - slunyakin
LinkedIn: Sergiy Lunyakin
Contact: https://slunyakin.wordpress.com
Sergiy Lunyakin (MCSA, MCSE, MCTS) is a Big Data Architect at SoftServe, Inc. He has extensive experience in designing and developing Big Data Analytics, Data Warehouse, and BI solutions, using both on-premises and cloud products. In 2016, Sergiy became Microsoft Data Platform MVP and has since maintained his MVP status. Sharing knowledge is another one of his passions. He regularly speaks at international conferences such as SQLSaturday, SQLDay, SQLNexus, and SQLBits. He also runs the Lviv SQL Server User Group in Ukraine and organizes SQLSaturday Lviv.
Javier Villegas
Twitter: - https://www.twitter.com/javier_vill
LinkedIn: Javier Villegas
Contact: http://sql-javier-villegas.blogspot.com.ar/
Javier Villegas is a Database Administrator Manager for Mediterranean Shipping Company. Javier has more than 20 years working with SQL Server on every version from 6.5 to SQL Server 2019, Including SQL Azure Database and SQL Azure Managed Instance. His specialization is Administration, Performance Tuning and High Availability. He is a Microsoft MVP in Data Platform. Javier is a frequent speaker in conferences and events such as SQLSaturday , PASS Virtual Groups, 24 Hours SQL PASS , vOpen(NetConf), GroupBy and DataPlatformGeeks. @sqlargentina
Dennes Torres
Twitter: - Dennes
LinkedIn: Dennes Torres
Contact: https://www.red-gate.com/simple-talk/author/dennes-torres/
Dennes Torres is a Data Platform MVP with more than 25 years of experience in the IT area. He improves Data Platform Architectures and turns data into knowledge. As a Brazilian living in Malta, Dennes works as a software developer and leads the Malta MDP User Group. Having the MCSE Data Platform, Business Intelligence, and Microsoft Certified Trainer (MCT) certifications, Dennes has been in love with database servers since he was introduced to SQL Server 6.5, more years ago than he would like to admit.
Amit R S Bansal
Twitter: - A_Bansal
LinkedIn: Amit R S Bansal
Amit R. S. Bansal is a SQL Server Specialist at SQLMaestros. He leads the SQL Server practice with a focused team providing consulting, training, and content development services to more than 160+ SQL customers globally. He frequently speaks at international conferences on SQL Server performance tuning, which is his core expertise. Amit is also honored with Microsoft Regional Director status, MVP award, and Microsoft Certified Master of SQL Server credential. Amit has been working with SQL Server since 1999 and has been part of countless mission-critical SQL deployments. Performance Tuning in SQL Server is his core area of expertise. To learn more about Amit, visit http://sqlmaestros.com/amit-bansal.
Andy Yun
Twitter: - SQLBek
LinkedIn: Andy Yun
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, SQLSaturdays, 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 SQLSaturday Organizing Committee.
Denzil Ribeiro
Twitter: - denzilribeiro
LinkedIn: Denzil Ribeiro
Contact: http://blogs.msdn.com/b/sqlcat/
Denzil Ribeiro is a Principal Program Manager in the Azure SQL Database team. He is a Microsoft Certified Master (MCM) and has 15+ years of experience working with high scale SQL Server and Data pipeline architectures. Prior roles included stints in SQLCAT focusing on top tier customer scalability engagements across the data pipeline , SQL Server Escalation Engineer in CSS and Premier Field Engineer working with our top tier customers.
Adrian Sullivan
LinkedIn: Adrian Sullivan
For the last 12 years Adrian been helping companies through their SQL data estate and digital workplace journeys. Adrian is the Modern SQL Platform principal at Lexel, where he leads a Managed Services and Professional/Project Services capability. Most of Adrian’s work revolves around Data Estate design, Always On Availability Groups and Performance tuning.
David Patrick
Twitter: - DavidEPatrick
LinkedIn: David Patrick
Contact: http://www.madsharepoint.com
Dave has been developing database applications for over 25 years. An MCT since 2001, he has taught many classes from Intro to Visual Interdev to Advanced SharePoint Development. Dave runs two user groups, the Maryland and Pennsylvania Microsoft Developers User Group, www.mapamdug.com, and MAD SharePoint, www.madsharepoint.com. Dave does SharePoint training and development for DSA, Inc., a DoD contractor that does great work for the Army over at Aberdeen Proving Ground. Dave is also an MVP.
Arvind Shyamsundar
Twitter: - arvisam
LinkedIn: Arvind Shyamsundar
Contact: http://aka.ms/arvindsh
Arvind is a Principal Program Manager (Microsoft Azure Data) working on the Azure SQL DB and Hyperscale services. Arvind is passionate about sharing his knowledge and learnings - as well as automating troubleshooting and diagnostics as much as possible. Much of his work is available on GitHub (https://github.com/arvindshmicrosoft/) and his blog (http://aka.ms/arvindsh/). Arvind is also an #MCM4Life and has previously worked as a Principal PFE within Microsoft Services.
Marsha Pierce
Twitter: - MarshaPierceDBA
LinkedIn: Marsha Pierce
Marsha Pierce lives in Nashville, TN. She studied Computer Science, Mathematics, and French at Belmont University. She has 23 years of experience as a DBA, which means she has broken and fixed a lot of stuff. Before joining Pure Storage, she was an architect at HCA and Asurion. She is passionate about DevOps, Storage, Performance Tuning, and Standardization.
Sarah Patrick
Twitter: - sarahepatrick
LinkedIn: Sarah Patrick
Sarah has presented at several TechGirlz workshops for the Boys and Girls Club of Harford County, as an advocate for women in STEM. Sarah graduated from the Science and Mathematics Academy in Aberdeen, MD in May 2018, where she presented her senior capstone project “Engineering peer credibility via mastery of roles,” where she designed roles for an ad hoc team. She worked with an army professional from CERDEC. She is currently attending the University of Maryland - College Park to major in Information Science. Sarah completed an internship with the Project Management Institute, helping them with their Professional Development Event, and worked as at the SharePoint Intern at Smithsonian Institution’s Office of the Chief Information Officer.
Nuri Halperin
Twitter: - nurih
LinkedIn: Nuri Halperin
Contact: https://plusnconsulting.com/
Nuri Halperin is a software architect, speaker, and author. He helps companies develop scalable systems, websites, and business applications. He’s been turning projects into success stories for a variety clients for over 2 decades.
Nuri is an author of several Pluralsight courses. He’s also a Microsoft MVP, a MongoDB Master, and recipient of MongoDB’s William Zola Award for Community Excellence.
Eugene Stepanov
20+ years of development experience (web, desktop, middle tier and back-end) Focusing on RDBMS since 2005 Worked with SQL Server since version 7.0 Worked at number of companies big and small Joined AWS one and half years ago Prior to AWS worked at Microsoft Based in Seattle, WA
Elaena Bakman
Twitter: - https://twitter.com/Elaena_Bakman
LinkedIn: Elaena Bakman
For the first 15 years of my IT career I worked as a CRM Developer, but have been passionate about SQL since SQL Server 6.4. Five years ago I finally made the switch to the dark side and never looked back. I currently work as a Sr. Database Architect specializing in SSIS, SSRS, RDS, EC2 and enterprise level cloud migration.
Bob Ward
Twitter: - bobwardms
Contact: http://aka.ms/bobsql
Bob Ward is a Principal Architect for the Microsoft Azure Data SQL Server team, which owns the development for all SQL Server versions. Bob has worked for Microsoft for 26+ years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2019 including Azure SQL. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, and performance at events such as PASS Summit, Red Hat Summit, Microsoft Ready, SQLBits, SQLIntersection, Microsoft Inspire, and Microsoft Ignite. You can follow him at @bobwardms or linkedin.com/in/bobwardms. Bob is the author of the books Pro SQL Server on Linux and SQL Server 2019 Revealed available from Apress Media. Twitter: http://twitter.com/bobwardms.
Dennes Torres
Twitter: - Dennes
LinkedIn: Dennes Torres
Contact: https://www.red-gate.com/simple-talk/author/dennes-torres/
Dennes Torres is a Data Platform MVP with more than 25 years of experience in the IT area. He improves Data Platform Architectures and turns data into knowledge. As a Brazilian living in Malta, Dennes works as a software developer and leads the Malta MDP User Group. Having the MCSE Data Platform, Business Intelligence, and Microsoft Certified Trainer (MCT) certifications, Dennes has been in love with database servers since he was introduced to SQL Server 6.5, more years ago than he would like to admit.
Brian Hansen
Twitter: - tf3604
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.
Sean McCown
Twitter: - @KenpoDBA
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
Vitor Fava
Twitter: - sqlservermaniacs
LinkedIn: Vitor Fava
Contact: https://www.vitorfava.com
I’m a DBA with extensive experience in the areas of Database and Information Technology, working on planning, implementation, and maintenance of large corporate database servers. I have several professional certifications and good experience in development activities and management of entrepreneurial environments using SQL SERVER. I’m a speaker at various technology events such as SQLSaturday, The Developers Conference, InteropMix and also in various discussion groups focused on database technology. I teach advanced training in SQL Server and Azure SQL Database and also acting as MCT in Microsoft official training. I’m the Chapter Leader of SQLManiacs PASS chapter.
Marcelo Adade
Twitter: - @marceloadade
LinkedIn: Marcelo Adade
Contact: http://www.dbbits.com.br
Marcelo is a Database Consultant at The Pythian Group. He has more than 10 years of experience in several Companies from different branches and sizes. Like financial companies, consultant shops, datacenters and e-commerce sites. Currently holds the MCSE, MCT and MCSA Microsoft Certifications and also the Oracle OCP. Loves technology and enjoys sharing his Database knowledge delivering presentations and official Microsoft Training Courses. Currently he is also the co-leader of the SQLMANIACS PASS User Group, based in Sao Paulo, Brazil
Dan Mallott
Twitter: - https://twitter.com/DanielMallott
LinkedIn: Dan Mallott
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.
Nuri Halperin
Twitter: - nurih
LinkedIn: Nuri Halperin
Contact: https://plusnconsulting.com/
Nuri Halperin is a software architect, speaker, and author. He helps companies develop scalable systems, websites, and business applications. He’s been turning projects into success stories for a variety clients for over 2 decades.
Nuri is an author of several Pluralsight courses. He’s also a Microsoft MVP, a MongoDB Master, and recipient of MongoDB’s William Zola Award for Community Excellence.
Buck Woody
Twitter: - BuckWoodyMSFT
LinkedIn: Buck Woody
Contact: http://buckwoody.wordpress.com/
Born helpless, naked, and unable to provide for himself, Buck Woody overcame these amazing handicaps to become a software developer, data professional, teacher, and a productive invertebrate member of society.
Jeff Iannucci
Twitter: - DesertDBA
LinkedIn: 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.
Dustin Vannoy
Twitter: - dustinvannoy
LinkedIn: Dustin Vannoy
Contact: https://dustinvannoy.com
Dustin Vannoy has spent 14 years solving business problems with analytics and big data solutions. He is passionate about all aspects of data work, including modeling, building scalable data pipelines, and creating intuitive dashboards. He is experienced in transitioning legacy ETL jobs into streaming pipelines with Spark and Kafka. Dustin started his career with SQL Server Integrations Services, but currently focuses on using Python and Scala with cloud data services. He is a technical leader in San Diego and the co-founder of the San Diego Data Engineering Group. He now encourages others to grow their data skills by speaking at user groups and conferences, particularly around Southern California and Baja California.
Brodie Brickey
LinkedIn: Brodie Brickey
Over eighteen years in Information Technology developing solutions for companies. I specialize in integrating information from disparate systems for legal and financial firms. PMP ITIL certified.
Jason Horner
Twitter: - jasonhorner
LinkedIn: Jason Horner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.
I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.
In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
Brodie Brickey
LinkedIn: Brodie Brickey
Over eighteen years in Information Technology developing solutions for companies. I specialize in integrating information from disparate systems for legal and financial firms. PMP ITIL certified.
Armando Lacerda
Twitter: - arlacerda
LinkedIn: Armando Lacerda
Over 30 years in the computing field as a developer and system integrator; over 20 years working with SQL Server since version 6; cross platform experience with Oracle and IBM SQL/DS and DB2; Microsoft Certified Trainer for over 20 years.
Anna Hoffman
Twitter: - AnalyticAnna
LinkedIn: Anna Hoffman
Anna is a Data and Applied Scientist on the Azure Data (SQL) product team at Microsoft. In her time at Microsoft, Anna has worked in Microsoft Consulting Services, AI Engineering, and now SQL Engineering. She spends most of her time working on Azure SQL and participating in the community to democratize intelligence over all your data, from ground to cloud. You can follow her on Twitter at @AnalyticAnna.
Sponsors
The following is a list of sponsors that helped fund the event: