Event Location:
UNC - Charlotte - Cone Center
9025 University Rd, Charlotte, NC
Charlotte, North Carolina
Abstract:
Ever wondered what's happening under the covers when processing a tabular model or a Power BI dataset? Why is it taking so much memory? How can I make it run faster? Am I running into a resource bottleneck? Processing a tabular model can be a very resource-intensive workload and depending on your specific goals (e.g. speed, availability, etc) it may not always be feasible to process the entire model. In this session, you'll learn what actually happens and in what order during model processing, the difference between the various processing types, performance considerations and most common resource bottlenecks. We'll also cover the most common processing patterns and the associated trade-offs. Keywords: Analysis Services, SSAS, Power BI
Speaker(s): Bill Anton,
Abstract:
Power BI is a business analytics solution that lets you visualize your data and share insights across your organization or embed them in your app or website. This session is for users are who want to automate Power BI row-level security by replicating the security of another data source such as corporate ERP. Many organizations maintain tight data security within their organization. Row-level security needs to be defined within Power BI. This can be difficult if you have many users and security changes happen quite often. If you are using a corporate ERP system that has security built into it, you would end up doing redundant work of managing security at two places, in ERP as well as in Power BI. DAX query can be used to filter out rows based on user ID/user name. We will go over the demo of the entire process starting from bringing data into SSAS, creating data model, applying row level security publish the report. Never again you will have to manually manage roles within Power BI.
Speaker(s): Ashwini Jain,
Abstract:
One of the most important tasks for a database administrator is taking (and testing!) backups. As databases get larger and larger, the amount of time it takes to perform a backup can grow as well, to the point where your backups take longer than your available backup window. There are several settings we can use to optimize backup performance, such as buffer counts, maximum transfer size, and the number of files, but trying every combination of settings on a single production-sized database could take weeks or even months. In this talk, we will apply data science techniques to the problem of backup settings optimization and look at different models for approaching the problem and analyzing data. Some statistics background would be helpful, but is not required; the big requirement is a desire to speed up backups.
Speaker(s): Kevin Feasel,
Abstract:
Applications often integrate with APIs for the purpose of retrieving data from a disk-based storage system like SQL Server. This poses challenges due slow queries and amount of data sent down the wire. In this presentation, we discuss the performance concerns with this type of architecture especially for big data scenarios. Oscar Garcia shows how to address those concerns by following a series of steps in which an application is refactored with minimum changes to support an in-memory data store and data streaming. We start by discussing the challenges when using data queries. We structure the data for in in-memory storage. We replace the API requests with real-time data streaming. Learning Objectives: SQL Server Query Challenges Redis Cache Basic Operations and Structure Angular App with Socket.io integration Node.js Backend with Socket.io and Redis support Real-time data integration
Speaker(s): oscar garcia,
Abstract:
Stop wasting time using Excel Pivot Tables. Create Pivot Tables in SQL with ease. Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight. In this demo-heavy presentation, you will learn how to create pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator. Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris. *Not Possible
Speaker(s): Peter Doyle,
Abstract:
You need to move data. A lot of data. To the cloud. You’ve got data in a variety of on- and off-site data sources. There are several ways to do it. Some of them can be quite easily implemented using Azure Data Factory. Learn how to use variables and looping in your Data Factory pipelines. Use the Integration Runtime to pull directly from on-site sources. See how to upload files to blob storage and import them. Learn how to trigger Data Factory activities. And, learn how to keep all those connection strings and passwords secret in Azure Vault. After this session, you will have tools that you can readily implement in your own data migrations.
Speaker(s): Simon Kingaby,
Abstract:
We often need to grant a higher-than-ideal level of permissions to a Login or Role so that someone can: start a SQL Agent job (but you don't want them to edit anything), get data from a DMV that requires "VIEW SERVER STATE" permission (but that permission gives access to too much data), query across databases, TRUNCATE a table, etc. These problems are usually solved with some combination of: EXECUTE AS (i.e. Impersonation), cross-DB ownership chaining, or TRUSTWORTHY ON. Unfortunately, those options are all security risks. Module Signing — https://ModuleSigning.info/ — is more flexible and secure, but requires a Certificate or Asymmetric Key. Those can be confusing to work with, and the security mechanism isn't intuitive. However, that confusion ends here. Come learn how to have more secure, granular permissions that handle cross-DB tasks, Dynamic SQL, and SQLCLR. See what module signing can do, how certificates and asymmetric keys work, and realize it's not as hard as you thought.
Speaker(s): Solomon Rutzky,
Abstract:
Data breaches abound! Do you want to keep your company out of the headlines? What are some of the data privacy laws affecting you? How will encrypting data affect your database performance? What data fields should you encrypt? What else can you do to protect your sensitive data? In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption and Always Encrypted. While we look at the encryption options, we will review both on-premise and cloud offerings. This session will deep dive into setting up Always Encrypted encryption and share experiences implementing the encryption. You will leave this session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance. Also, you will gather information on how to fully protect and review your sensitive data usage.
Speaker(s): Thomas Norman,
Abstract:
In 2005, Linus Torvalds developed the version control system (VCS) git. Since then, it has become as platform agnostic and ubiquitous as the internet. Microsoft has fully embraced Git. It powers modern on premise and cloud versions of TFS (now know as Azure Devops) as well GitHub, which Microsoft recently acquired. What does this mean to a DBA? Whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in version control. In my session. We'll cover: How do I use SSDT to help prevent developers from using code first ORMs? What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? We will be covering using git from both the command line and Visual Studio.
Speaker(s): Justin Dearing,
Abstract:
Imagine you have a new employee with valuable SQL experience, but from a different DBMS platform. Or imagine you’ve been assigned to a project that involves a DBMS other than SQL Server. What do you need to know? In this high-level presentation, Sandra will highlight differences between default Windows installations of Oracle, Postgres, DB2, SQLite, MySQL, and SQL Server. She’ll share her experience moving from one platform to another and what she has found to be the most important thing to keep in mind when working with a new DBMS or working with a new employee who comes from another DBMS environment. This presentation is for anyone with a basic knowledge of SQL. It was co-produced with Stéphane Faroult, author of The Art of SQL, SQL Success and other technical books. The presentation uses techniques found in his latest book, Getting the Message Across: Using Slideware Effectively for Technical Presentations.
Speaker(s): Sandra Peele,
Abstract:
The job of a data professional is evolving rapidly, driving many of us to platforms and technologies that were not on our radar screen a few months ago. I am certainly no exception to that trend. Most of us aren't just monitoring backups and tuning queries - we are collaborating with teams throughout the company to provide them data and insights that drive decisions. Cloud providers are democratizing technologies and techniques that were complicated and proprietary just a few months ago. This presentation walks you through how a silly idea from a football podcast got me thinking about how Azure Logic Apps, the Cognitive Services API, Azure SQL DB, and Power BI combine to provide potentially powerful insights to any company with a social media and sales presence. Join me as I walk you through building a solution that can impact your company's bottom line - and potentially yours too!
Speaker(s): Matt Gordon,
Abstract:
Source Control is a wonderful resource to improve team collaboration, reduce the risk of problems from lone wolf development and track change efficiently. Developers are already familiar with source control, but ANY Analysts or Operations teams can benefit! If you are struggling to use source control, are frustrated with not understanding the what, why, and how, or want to start using source control then look no further! We will cover using source control for code in stored procedures and queries for SSMS, SSIS packages, SSAS models and cubes, and SSRS reports. With this session, you will learn the foundational knowledge to not only to apply to your workplace right away but to lay the groundwork to continue building your skills in Git. We will cover basic terms/concepts of how Git works, understanding the process flow, executing some basic commands in Git, understanding why a merge conflict happens and how to solve it, and using different GUIs if the command line isn't your thing.
Speaker(s): Marc Bushong,
Abstract:
Aggregations are one of the most important optimization methods for managing big datasets in Power BI. Combined with Direct Query storage mode, they allow big datasets to be analyzed efficiently by answering high level analytical queries quickly from memory while sending more detailed queries back to the source database. In this session, you will learn about the concept of aggregations, different table storage modes in Power BI, how to set up aggregation tables and configure them to improve query performance. You will also learn how to use DAX Studio to determine if the aggregations are being used. Prerequisite: Basic knowledge of data modeling in Power BI Desktop.
Speaker(s): Shabnam Watson,
Abstract:
In this course we identify some common mistakes that we see in the business world using Power BI. We will identify the psychology behind the reporting techniques needed to create powerful and effective reports. The attendee will leave the class ready to write better reports using Power BI in the real world.
Speaker(s): Ed Watson,
Abstract:
Mental illness is more common than you think. One in four Americans suffers from a mental illness each year. In the tech community, this is often not talked about. Many times, people feel alone and isolated in the tech community with us mostly being introverted people. It is time to start talking about mental illness out in the open and honestly about how it affects us and those around us. In this session, we will talk about what mental illness is and what it is not. How my mental illness has affected me. How it effects the tech industry. How mental illness can affect you and how you can tell if you are starting to have issues. What to say and what not to say to people you know that are affected by mental illness. Finally, how to get help and where reach out for help.
Speaker(s): Tracy Boggiano,
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:
Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like: - What are the various areas of memory inside of SQL Server? - How are queries handled behind the scenes? - What does SQL Server do with procedural code, like functions, procedures, and triggers? - What happens during checkpoints? Lazywrites? - How are IOs handled with regards to transaction logs and database? - What happens when transaction logs and databases grow or shrinks?
Speaker(s): Kevin Kline,
Abstract:
In this demo-heavy session, we will discuss best practices when it comes to data normalization, why it's important to normalize your data, and to go about getting started. We will take a look at a set of data and discuss the best way to bring it into Third Normal Form. We will focus on The Key (1NF), The Whole Key (2NF), and Nothing but The Key (3NF)!
Speaker(s): Johnathan Sluder,
Abstract:
Take your company’s BI reporting to the next level with the Power BI Report Builder. We will cover: • How Report Builder differs/complements Power BI • Importing your Power BI dataset • Building a Paginated Report • Best Practices for Business Reports for max ROI The Report Builder is to Power BI as the Lasagna Pasta Accessory is to the Kitchen Aid. It works with the same data set and transforms sections of your report into perfect sheets! (and did I mention there is no export row limit?!?!?)
Speaker(s): Erika Haase Nalley,
Abstract:
Accessibility is catering for your whole audience, including those with disabilities. According to the US Census Bureau, 19 percent of the of the population had a disability in 2010. Do you know if your reports are designed in an inclusive way? In this session, we'll discuss accessibility standards and regulations of which you may want to be aware, how users with disabilities can consume Power BI reports, and guidance and pitfalls when designing inclusive reports.
Speaker(s): Meagan Longoria,
Abstract:
Have you ever needed to learn a new database design and don't know where to begin? Or are trying to find out why a query doesn't perform well? Or need to provide security information to auditors or your security team? SQL Server has numerous metadata facilities available to help you with these tasks and more. Functions, dynamic management views, and system stored procedures can illuminate details from a single column up through an entire SQL Server instance. We will demonstrate metadata techniques to help you: - Document your database schema objects such as procedures, functions, tables, columns and indexes - Investigate performance and look for bottlenecks and tuning opportunities - Discover metadata to administer your databases backups, index maintenance, and security - Apply your own metadata using extended properties We will also cover the official Microsoft documentation on these features and other resources on how to use them.
Speaker(s): Rob Volk,
Abstract:
"Cursors are bad, never use them!" How many times have you been told this by your senior DBAs or developers? In this session I will explore why I use cursors to solve certain problems. Discuss when they are appropriate, and when they are not, as well as a performance comparison to non-cursor based solutions.
Speaker(s): Anders Pedersen,
Abstract:
Database corruption could happen to you. When it happens to you, do you know what to do? Will you realize quick enough that you have corruption? The presentation begins by talking about how to detect the corruption and the different strategies for handling unique corruption issues. Highlight of topics 1. Why corruption occurs? 2. Detecting corruption – how SQL Servers detects corruption at the page level. 3. Different types of corruption- e.g. False alarms, memory corruption etc. 4. Limitation of DBCC how to speed the DBCC process. 5. Undocumented DBCC commands. 6. Monitoring I/O errors. 7. Verifying backup for corruption.
Speaker(s): Stephen Muliokela,
Abstract:
Curious how to monitor your IT Services using Power BI? Come see how UCF tracks our IT services to ensure our staff, students, and faculty are meeting their teaching, learning, research, and service objectives. Utilizing ITIL (Information Technology Infrastructure Library) practices, ServiceNow data, and Power BI we are able to take quantitative information and turn it into graphical visualizations to aid leadership and our customers in making informed decisions.
Speaker(s): Priscilla Camp,
Abstract:
Are you thinking of converting your large databases from traditional row store tables to Column Store? If so then you will want to attend this session. We will discuss some important lessons learned from actual deployments of CCI into production and highlight some key areas you want to focus on ahead of time. There are often many ways you can do things but getting it right the first time is crucial with CCI conversions on large scale databases. Come see what these are before it's too late.
Speaker(s): Andrew Kelly,
Abstract:
REST has become the dominant technology for providing programmatic access to various cloud applications. We will show an easier way to interact with REST APIs with support for any authentication mechanism, support for complex, composite structures and unlimited flexibility. If you are a SQL Server user, you definitely must attend this session and get all your questions answered.
Speaker(s): Ivan Peev,
Abstract:
This is a game changing session. Lets go 0 to 100 real quick by building a business app in minutes using PowerApps, Microsoft Flow and SQL Server. Then lets look at the enterprise-grade security to publish and share your app to iOS, Android, Web and Windows 10. - AGENDA: 1. T-SQL Stored Procedure on SQL Server database (on-prem or cloud). 2. PowerApps (Inputs, Button, Outputs) 3. Flow (Input, SQL Server, Variables, Respond, Tests) 4. Gateway 5. Publish Share with Enterprise Governance. We'll have time for QA. Maybe we'll even ask Cortana a few questions. I look forward to seeing you there!
Speaker(s): Hiram Fleitas,
Abstract:
Postgresql is an Open Source, Free, and a Popular alternative database for building software applications. In this session, we will look into getting started with PostgreSQL, review unique features that make it exciting to work with and wrap up the presentation with strategies to migrate, deploy and scale for on-premise and cloud deployments.
Speaker(s): Ramu Pulipati,
Abstract:
Building a network is much more than LinkedIn and is crucial in career success. In this session, we will explore ideas and tips for building growing a successful network. Everything from "ice breakers" to cultivating your current network.
Speaker(s): Leveat Ruse,
Abstract:
You are a DBA, you are the Elite of Database World. Your time is valuable and you should not make a typing mistake. In the first hour we'll go through the most common SSMS keyboard shortcuts and I'll show you how to setup your own shortcuts with your own queries. In the second hour I'll show you how to set the best SQL queries developed by the best brains in the industry in your own SSMS and apply it to your environment.
Speaker(s): Slava Murygin,
Abstract:
This session is a technical overview of Power BI architecture options. Power BI terminology and its most prominent features and functionality will also be reviewed to help attendees gain an understanding of the broad collection of tools, services, and features which represent the Power BI ecosystem.
Speaker(s): Melissa Coates,
Abstract:
Almost all of us use SQL Server Management Studio to interact with SQL Server, and thankfully it works right out of the box. But did you know there are so many tricks and shortcuts that hide just under the surface that can make working with SSMS feel like second nature? In this session, I will take a fresh install of SSMS and step through customizing it. I will demonstrate features and help you become more efficient at utilizing SSMS to it's fullest potential - a lot of the time without using the mouse. Finally, I’ll show you some cool text editing tricks that will take your SQL skills to a whole new level.
Speaker(s): Adrian Mee,
Abstract:
This session will cover the incorporation of Agile's Test Driven Development (TDD) into traditional T-SQL Database Development. The session will show the benefits of integrating this methodology into your database development processes. These benefits would include proper unit testing as well as the prevention of introducing performance issues into production.
Speaker(s): Anthony Mendoza,
Abstract:
Azure Machine Learning services is an integrated, end-to-end data science and advanced analytics solution that provides professional data scientists and data engineers with tools not only to develop ML models, but also tools for data preparation and wrangling, data visualization, model deployment, and model management at cloud scale. This session will teach the attendees how to get their hands on each tool in the stack.
Speaker(s): Bhakthi Liyanage,
Abstract:
Are you a developer or analyst who has been asked what changed for a particular record, and thus need to get the record at a given time? Well, in 2016, we were introduced to system-versioned temporal tables in SQL Server, which can tell you the full history of what the data looked like if you ever need to fend off questions. You will get to know the business uses for temporal tables, how they are built, the ways to query temporal table records, converting your current in-memory tables, and other elements to consider.
Speaker(s): Chris Voss,
Abstract:
This session will show attendees a way to dynamically ingest data into a centralized data store (i.e. SQL Server or Data Lake) using Azure Data Factory from multiple sources. If going into SQL Server the processes will automatically create all needed tables and stored procedures for the process.
Speaker(s): Chris Pollock,
Abstract:
In this session we will cover Spatial Data Types available in SQL Server. Then we will review the basics of spatial queries and the different methods to create points, lines, and polygons. Finally we will demo a few examples of location analytics and how to integrate into other data sets.
Speaker(s): Lucas Feiock,
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:
What are your first steps when you hear one of your SQL Servers is having a performance problem? In this demo-driven session, we will discuss key DMVs that can provide us data quickly. We will examine a number of example queries that can lead us to a quick root cause analysis in a number of different situations. This session will be kept at a very functional level, and should be accessible for anyone interested in SQL Server performance.
Speaker(s): Jared Poché,
Abstract:
NoSQL is here, along with traditional SQL. In this session I will guide you to compare 3 different database technologies: Microsoft SQL Server, Mongo DB (Document) and Neo4J (Graph) databases. We will go from basic concepts, language syntax, Local Cloud installation and operation, will focus on Azure. Depending on your needs, the 3 of them have great use for different use cases.
Speaker(s): Art Cardenas,
Abstract:
Technology moves at a blinding pace and the SQL Server platform is no exception. With the release of SQL Server 2019, you will see some great improvement in the database engine of the platform. In this session, you will examine some of the new features of SQL Server 2019 such as Accelerated Database Recovery (ADR), resumable index creation, UTF-8 support, online columnstore rebuilds, an improved data truncation message, among other features. After this session you will have a better understanding how you can leverage SQL Server 2019 to enhance your database environment.
Speaker(s): John Morehouse,
Abstract:
As containers are becoming more and more prevalent, this session provides an introduction to the different options of running containers in Azure. I'll cover the following different options for running Docker containers in Azure: - Azure Container Registry Azure Container Instances Azure Kubernetes Services This session is aimed at SQL Server DBAs and Developers who have some experience with Docker and want to know the different options that are available in Azure. Each topic will be backed up with demos which will show how simple it is to get up and running with these technologies.
Speaker(s): Andrew Pruski,
Abstract:
Overview of What is SQL Server on Linux. The Platform Abstraction Layer (SQLPAL), SQL Server on Linux feature compatibility, Implementing SQL Server on Linux. Performance and Security of SQL Server on Linux, HA/DR with SQL server on Linux. What’s next for SQL Server in containers, Container orchestration using Kubernetes and SQL Server HA on Kubernetes.
Speaker(s): Prabhaker Potharaju,
Abstract:
Using SentryOne Plan Explorer, a 100% free product, DBAs and Devs write better performing SQL code in a fraction of the time otherwise possible. Plus, troubleshooting existing SQL code becomes a fast, easy, and visually vibrant experience. Learn all the ways SentryOne Plan Explorer helps in this demo-packed session!
Speaker(s): Kevin Kline,
Abstract:
Turbo charge your career, your projects, and your team by changing the way you approach failure, learning, practice, and praise. This session will cover research in cognitive psychology and neuroscience in an actionable path forward to eliminate perfectionism and other career-stifling behaviors and thoughts, which those of us in the tech industry are particularly susceptible to.
Speaker(s): Donna Ellis Wilson,
Abstract:
Python is a powerful general purpose programming language that has emerged as one of the main tools of data scientists. Python was added to Power BI in June of 2018. This session will demonstrate the two areas python can be used inside the Power BI desktop-- how to leverage python scripts inside the Power BI query editor and how to use python visuals in Power BI reports.
Speaker(s): Julie Smith,
Abstract:
Come hear these "emergency" stories called into Microsoft's SQL Server Product Support team. I'll cover common backup\restore problems, SQL Server not starting, lost data, crash dumps, and infectious SQL found on Web just to name a few. Learn background to the problem and what was done to correct in hope of avoiding your own SQL Server emergency.
Speaker(s): Chris Skorlinski,
Abstract:
Are you excited to know about the MSBI tools and work as a Business Intelligence Professional, a dynamic and rewarding career in Information Technology? If yes, this is the right time and place for you. In this session, I will give you the overview of the MSBI tools (SSIS, SSRS, SSAS, Power BI, Azure Analytics). I will also provide you some insights to build the MSBI career and to leverage the learning curve in Microsoft Data Platform, based on my knowledge and experience, the proven strategies and techniques.
Speaker(s): Ganesh Lohani,
Abstract:
All kind of things can be done for improving query performance and IOPS (IO operations), however what if your hardware and disk drives were not properly configure to give SQL the best performance. This session review the basics of disk drives, partitions, controllers and storage hardware and then looks into ways to improve SQL performance with correct disk drive architecture.
Speaker(s): Michael Wharton,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Prabhaker Potharaju is a Senior Consultant at Microsoft and has been with Microsoft for almost 20+ years with experience in Business Intelligence, Database Development and Administration, and Application Development using Microsoft technologies. He has extensive understanding of SQL Server internal architecture, performance tuning, as well as data implementation and maintenance of high availability, disaster recovery, and high performance OLTP and OLAP systems. Also has experience on Public and Private cloud platforms, Hybrid IT and delivering SQL Azure offerings.
LinkedIn: https://www.linkedin.com/in/shabnamwatson
Contact: https://shabnamwatson.wordpress.com/
Shabnam Watson is a Business Intelligence architect with 20 years of experience developing data warehouse and business intelligence solutions. Her work focus within the Microsoft BI Stack has been on Analysis Services and Power BI. She is an active member of PASS community and has spoken at PASS Summit, SQL Saturdays, PASS Business Analytics and Women in Technology virtual chapters, and many other local user groups and conferences. She is one of the organizers of SQL Saturday Atlanta BI Edition. She holds a master's degree in computer science, a bachelor’s degree in Computer Engineering, and a Certified Business Intelligence Professional (CBIP) certification by The Data Warehouse Institute (TDWI).
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.
LinkedIn: https://www.linkedin.com/pub/slava-murygin/9/b95/858
Contact: http://slavasql.blogspot.com/
Started working with SQL Server 7.0 as DBA and Developer. Since then went through all SQL Server versions, migrations and multiple companies of different sizes and industries. Currently working as a contractor with all aspects of SQL Server, including, but not limited to: troubleshooting performance, designing/developing: databases, systems, processes, data warehouses, cubes, reports, ETLs; Refactoring old code; Migrating data from other systems to SQL Server; Securing the data on enterprise level.
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/artcardenas/
Contact: https://artcardenas.wordpress.com/
Art Cardenas is a Data warehouse developer at Atrium Health, he has over 20 years experience with databases administration, design and development. SQL Server, Oracle, Tandem SQL non-stop. Most recently learning NoSQL databases such as MongoDB (document) and Neo4J (Graph) databases. Currently studying the Masters degree in Data Science and Business Analytics at UNCC.
LinkedIn: https://www.linkedin.com/in/marc-bushong-606515121/
Marc is a data engineer at the Medical University of South Carolina. He loves to learn and constantly challenge himself through new concepts, technology, and techniques. For the first 2 and a half years of his career, Marc worked as an X-Ray Technologist in Philadelphia and Charleston. Currently, he is working with various Microsoft tools including SSIS, SSAS, SSMS, and SSRS to develop assets for the healthcare enterprise.
My interests span (but not limited to) application of analytics and technology in the construction industry, supply chain management and optimization, data science, analytics, data visualization, GIS and location analytics.
LinkedIn: https://www.linkedin.com/pub/kevin-feasel/7/716/504
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.
LinkedIn: https://www.linkedin.com/in/srutzky
Contact: http://SqlQuantumLeap.com/
Solomon Rutzky has been working with databases for since 1996, focusing on SQL Server since 2002. He has written several articles for SQL Server Central (including the Stairway to SQLCLR series), and SimpleTalk, and has a blog: https://SqlQuantumLeap.com/ . Solomon is owner / founder of Sql Quantum Lift ( https://SqlQuantumLift.com/ ), and is the creator of the popular SQLCLR library of functions: SQL# ( https://SQLsharp.com/ ). He does what he can to help others by answering questions on a couple of StackExchange sites ( https://stackexchange.com/users/281451/ ), Ask.SqlServerCentral.com/users/20164/SRutzky.html , and SqlServerCentral.com/Forums/ .
LinkedIn: https://linkedin.com/in/sandrapeele
Sandra Peele started her career in the 1980’s as a demand forecaster in the materials planning department of ATT Network Systems. She left the workforce in 1990 to raise a family and in 2010, returned to school to study database technology, eventually teaching courses herself. She has both MSCE: Data Management and Analytics and Oracle 11g OCA certifications. Sandra is a SQL Developer at CMI Solutions, a Microsoft Partner specializing in software for convenience stores.
LinkedIn: https://www.linkedin.com/in/lucas-feiock
Contact: https://sql-stack.com
Lucas Feiock is a Senior Business Intelligence Consultant with KiZAN Technologies. He has four years of experience with the Microsoft BI Stack. In addition to data warehousing, data integration and data visualization, Lucas is also involved with machine learning and advanced analytics. He has experience working in multiple industries including manufacturing, sales, gas and electric utilities, and health care.
N/A
LinkedIn: https://www.linkedin.com/in/pulipati/
Ramu is the CTO/CoFounder of botsplash, an omni-channel platform to engage customers over messaging. At botsplash, Ramu focuses on building solutions that utilize open source technologies, including Postgresql and Clickhouse to enable communication choices for mid to large enterprises.
LinkedIn: http://www.linkedin.com/in/hiramfleitas
Contact: http://fleitasarts.com
Hiram Fleitas develops and manages database applications and AI bots using Machine Learning models trained on natural language, claims, policy, and social media data to predict business opportunities that grow customer satisfaction and loyalty in real-time. He's worked with SQL Server for over 20 years, with some of the largest companies in the world. He's spoken on SQL Server, Azure and Power BI at User Groups, Code Camps, SQLSaturdays, and corporate events. He coded his first program in BASIC at 13 years old and developed a passion for computers ever since. Hiram is also a code contributor to several open source projects and serves as the IS Flotilla Staff Officer for the United States Coast Guard Auxiliary.
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.
Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;
LinkedIn: http://www.linkedin.com/in/melissacoatesprofile
Contact: https://www.CoatesDataStrategies/blog
Melissa Coates is a data architect with a background in data warehousing and business intelligence. Her current professional focus is enterprise-level Power BI governance, deployment, security, and administration. As the owner of Coates Data Strategies, Melissa produces training and consults to help companies strengthen and sustain their data-driven initiatives. Melissa is big supporter of the technical community, and has been a Microsoft Data Platform MVP since 2013. You can visit Melissa's website at CoatesDataStrategies.com, which includes community resources like diagrams, blogs, and videos.
LinkedIn: https://www.linkedin.com/in/cwvoss
Contact: http://ceedubvoss.com
Chris is a data professional located in the Raleigh-Durham region of North Carolina. He has been working on data analysis and database development in SQL Server since 2008 R2. His experience includes hacking T-SQL code, using Reporting, Integration, and Analysis Services for solutions, and delivering data models and optimized queries. He has been a member of the TriPASS user group since 2013 and is part of the organizing committee for SQL Saturday Raleigh. In his spare time, you can spot him working within the autism spectrum community or running somewhere (most likely at a local run club).
LinkedIn: https://www.linkedin.com/in/chrispollock2/
In my over 10 years of working with databases, I've worked with many different technologies and aspects in software development. SQL Server and the integration of getting data in and out has been my main focus area. Nearly half of my career has really been focused around ETL; from home grown ETL solutions, to SSIS and now Azure Data Factory.
LinkedIn: https://www.linkedin.com/in/anders-pedersen-993676
Contact: http://blog.AndersOnSQL.com
20+ years of experience with SQL Server, from version 6.0 to 2017. Funnily enough, the only certification I have is on SQL 2012, the one version I have never used. Mostly worked at medium sized companies, by choice. Was a consultant for 6+ years, working on anything from facility security systems, background checks, retail PoS systems, to major financial systems. Passion for performance, and teaching people easy ways to better SQL performance.
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/oscardgarcia/
Contact: https://ozkary.com
Oscar Garcia is a Principal System Architect, Company Founder, Microsoft MVP and certified solutions engineer with many years of experience building solutions using .Net framework and multiple open source frameworks. Currently, he specializes in building cloud solutions using technologies like Azure, AWS data platforms. He enjoys sharing his technical experiences by maintaining a blog and delivering presentations. You can follow Oscar on Twitter via @ozkary or visiting his blog at ozkary.com.
LinkedIn: https://www.linkedin.com/in/jared-poche-51102797
Contact: https://sqljared.com
Jared Poche began working with SQL Server as an instructor for certification classes and has a passion for teaching and performance troubleshooting. Jared spent 10 years providing customer support at Microsoft, most recently as a Sr. Support Escalation Engineer. He is currently working as a Database Engineer for ChannelAdvisor and is blogging about his current experiences at sqljared.com
LinkedIn: http://www.linkedin.com/in/kekline/
Contact: http://blogs.sentryone.com/author/kevinkline
Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.
LinkedIn: https://www.linkedin.com/in/andrewpruski
Contact: https://dbafromthecold.com/
SQL Server DBA with over 10 year's experience. Originally from Wales but now living in Ireland
LinkedIn: https://www.linkedin.com/in/anthonymendozajr/
Anthony Mendoza is currently employed as a Senior Development DBA with Transfast. He has worked with SQL Server in some capacity since 1998 across various industries such as government, elections, military, financial and transportation. He holds a Master's Degree in IT Management as well as a MCDBA MCSD.
LinkedIn: https://www.linkedin.com/in/leveatruse
As an Executive Technical Recruiter with Ctrl+f, I currently develop effective recruitment strategies to attract top talent at all levels of an organization. I am an IBM certified trainer and began my career performing general human resources duties. I quickly worked my way up through the ranks of technical recruiting from Lead Recruiter to Senior Recruiter to Business Development.
LinkedIn: https://www.linkedin.com/in/bhakthi-liyanage/
Bhakthi Liyanage is a seasoned IT professional with many years of industry experience, a Microsoft MVP on AI, and is currently working as an AI Architect at one of the largest banks in the US where he leads projects to provide predictive analytics and AI solutions for complex business problems.
LinkedIn: https://www.linkedin.com/pub/stephen-muliokela/32/a45/830
I have been a DBA for many years now and currently hold multiple SQL Server certificates. In addition, I am also a Six Sigma Blackbelt.
LinkedIn: https://www.linkedin.com/in/sqlatspeed
Contact: http://www.sqlatspeed.com
Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group and a frequent domestic and international community speaker. He's an IDERA ACE alumnus and 2020 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs.
LinkedIn: https://www.linkedin.com/in/justindearingnyc
Contact: http://www.justaprogrammer.net
Justin Dearing has been working in IT in 2002. He started as a night shift AS/400 operator and rose through the ranks at a series of companies. He currently works as a developer in the capital markets industry. Justin has served in both the development and production side of the house on Windows, Unix and Midrange Platforms. His database experience includes MongoDB, MySQL, Postgres and Microsoft SQL server. These days he programs in C#, PowerShell and PHP.
LinkedIn: https://www.linkedin.com/in/itdatadiva/
Contact: https://itdatadiva.com
Priscilla Camp is a Business Intelligence and Analytics Specialist at the University of Central Florida. She has over 9 years of experience in the field of IT working as a Business Intelligence Analyst. Priscilla started her career working for a startup small business in 2010 and several years later moved over to the Higher Education Industry where she currently resides. Priscilla's focus is T-SQL, Data Warehousing, MS Power BI, and B.I. Strategy. She is also the Leader of the Orlando Power BI User Group.
LinkedIn: https://www.linkedin.com/in/thepeterdoyle/
On Jan 12, 2019, Peter attended his first SQL Saturday and experienced an engaging and uplifting community that encouraged everyone regularly to give back. That experience resulted in teaching eleven sessions and delivering a SQL Fundamentals pre-conference the last six months of the year. He is passionate about sharing knowledge on building a solid T-SQL foundation without wasting time. Peter's journey from minimal Excel knowledge to writing Dynamic SQL all started from watching Youtube videos for three hours every morning before work. Managers took notice of the results and transferred him to the reporting department. A few months later, a co-worker suggested he should learn SQL Server and his world of data has never been the same.
LinkedIn: http://linkedin.com/in/skingaby
Contact: http://omwtm.blog
Simon Kingaby has been moving data for 20 plus years. In the last few years, he’s been moving data from DB2, Oracle, Netezza and SQL Server to Azure SQL and Azure Data Warehouse, using Azure Data Factory, SSIS and SQL. At BMI, he developed a Rules Engine Sync application that uses DB2 QRep messaging and Azure ESB to move DB2 transactions to the cloud in near-real-time. Now at Deloitte on the Big Data team, he is developing ETL processes to move API, SaaS and SQL data into reporting databases on-premise and in the cloud. He is also creating SSRS and Power BI dashboards for the CIO and related Services.
LinkedIn: https://www.linkedin.com/in/donna-wilson-26212a37
Contact: https://sqlgrrl.net
Data professional with 25 years in the industry, nearly 10 of which at Microsoft in Product Support. Areas of focus includes: SQL Server administration, general troubleshooting, HADR, replication, log shipping, connectivity, security, and performance tuning. Passionate about women and diversity in tech, brain hacking, behavioral change, and psychology.
LinkedIn: https://www.linkedin.com/in/ganesh-lohani-6275a716
Ganesh Lohani has 10 years of experience working with Business Intelligence platform and Data Analytics, with over 8 years of experience with MS BI tools and Business Intelligence processes. He is currently working for Stericycle as a senior Business Intelligence Developer. He also enjoy his evening and weekend time in providing online training, coaching and mentoring individuals who want to learn MSBI (T – SQL, SSIS, SSRS, SSAS, and Power BI ) products. He holds MSIS degree from University of Texas at Arlington.
LinkedIn: http://www.linkedin.com/in/kekline/
Contact: http://blogs.sentryone.com/author/kevinkline
Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.
LinkedIn: http://www.linkedin.com/in/armordba
Contact: https://armordba.com/
Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.
LinkedIn: http://www.linkedin.com/pub/bill-anton/12/526/4bb
Contact: http://byobi.com/blog/
Bill Anton is an expert in Analysis Services and an experienced data warehouse practitioner. In 2013, he founded Opifex Solutions, a consulting firm with deep expertise in enterprise-scale architecture, design, and performance optimization of Analysis Services and Power BI solutions. He loves eating and spends most of his free time convincing his beloved wife to adopt more golden retrievers.
LinkedIn: http://www.linkedin.com/in/watsoned
Contact: http://sqlgator.com
Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Today, Ed specializes in the Business Intelligence stack and enjoys specializing in Power BI immensely. He currently lives in Atlanta and is active with the Atlanta MDF and Atlanta BI user groups and is an organizer for SQL Saturday Atlanta, Atlanta BI, and Pensacola.
LinkedIn: https://www.linkedin.com/in/tracyboggiano
Contact: http://databasesuperhero.com
Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC. Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com. Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.
LinkedIn: http://www.linkedin.com/in/juliesmith0503/
Contact: http://datachix.com
Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer--but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.
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/rob-volk-134ba81
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
LinkedIn: https://www.linkedin.com/in/michaelwhartoncomputer
Contact: http://MyProjectExpert.com
Michael Wharton is a Project MVP. He has been an independent consultant for the past 20 years, with over 30 Project/SharePoint Server deployments. He has an MBA from Wake Forest and has over 44 Microsoft Certifications. Michael's primary job is helping companies setup a PMO, Project Management Office using Project Server using SQL server on a SharePoint Farm. He has worked extensively with the back end support setting up SQL server, SharePoint Server and Project Server using PowerShell.
Contact: http://sqlblog.com/blogs/andrew_kelly/default.aspx
Andrew J. Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and lives in Clarkdale, AZ. He has over 20 years experience with relational databases and application development, but his main focus now is SQL Server. In addition to general SQL Server training and mentoring, he specializes in performance, scalability, and maintainability of large-scale SQL Servers. He is a regular speaker at conferences and user groups and was a SQL Server / Data Platform MVP for 18 years.
LinkedIn: https://www.linkedin.com/in/jwsluder/
Contact: http://sqlslaughter.com
After 10 years as a systems admin, I'm taking a new adventure into the world of SQL. I currently work doing ETL testing in a Data Warehouse environment. I am currently studying database development and Data Science.
Erika Nalley works with STX Business Solutions in Bentonville, Arkansas specializing in retail data solutions for adult beverage suppliers and distributors. As Microsoft Silver Partners in Data Analytics, STX uses all Microsoft Platform solutions. With certifications in Category Management and Wine Production, Power BI has been our preferred way to slice and visualize data for the last few years. It's a rough life working with data, whiskey, and wine, but someone has to do it! After work, Erika can usually be found hiking with her husband and three dogs or trying to keep up with friend and co-worker, Amber Muehlbach on a trail run (which usually doesn't happen:).
The following is a list of sponsors that helped fund the event.