Join me on a journey through the different offerings in Azure Arc and how they can benefit you as a data professional!
Learn how to design for speed, concurrency, and correctness and avoid common database development pitfalls.
Some types of data are a very bad fit for a database. Join me to see how to survive with a database full of data that should not be stored there. I will demonstrate how to deal with billions of rows of logs without trashing the database, how to store millions of pictures effectively and how to deal with dynamic attributes in a sensible way.
Using open source apache nifi to integrate and ingest data at scale
Join us, as we explore the capabilities of Azure Arc-enabled SQL Managed Instances.
Welcome to Azure DevOps trio, a tale about how a development team and an operations team have to bond together and start using Azure DevOps for Data Platform deployments.
The video is not available to view online.
You will be challenged with a case study to design a solution using Azure SQL Database capabilities. At the end of this session, you will better understand the possibilities to migrate on-premises databases to Azure SQL Database. You will learn how to synchronize data across different environments and get more insights on how to troubleshoot issues in Azure SQL Database. This is a hands-on, open discussions and team work kind of session (not a traditional slideshow).
The video is not available to view online.
Database Projects 101 in ADS is an introductory session on how to incorporate Database Projects in Azure Data Studio into a Data Professionals toolkit.
A session for DBAs considering where their career needs to go.
DBA/Developer Toolset to get you out of that hole and save you some time
Are you trying to increase uptime locally or for disaster recovery but your network is terrible? Join the club. This session will discuss different techniques, their pros and cons, as well as considerations for availability when your network is flaky at best.
Want to have a deep dive into how SQL Server and Azure SQL service maintain high availablity? This is your session.
Azure SQL performance capabilities, how to configure and maintain your Azure SQL for higher performance. We will explore various monitoring tools and pick few scenarios for deeper troubleshooting. In this demo centric session, we will tune our database and find an optimal ground to manage cost. We will generate Power BI powered database score card for trend analysis.
Automate checking your database security model
Learn how to and why you should protect your data with Row Level Security in SQL Server and Power BI.
Two consultants, two different companies, two data professionals passionate about performance tuning. Do we like the same things? Do we have the same approach to problems? Topics will include: Trace Flags, DMVs, DBCC commands, Community Scripts and Intelligent Query Processing Features. We will talk about the features and solutions we agree on, and discuss where we disagree.
Learn how to best configure and use Ola's Maintenance Solution, based on years of experience using this on thousands of SQL Server instances.
A tale about how a development team and an operations team must bond together and figure out how to use GitHub and Azure DevOps together for Data Platform deployments.
You know where to find an execution plan. You have taken your first steps reading them. But how are you going to apply this knowlledge to real world problems?
In this lightning talk I'll demonstrate how to apply the R implementation of Benford's law (which actually is not about crime or fraud) to identify possibly fraudulent invoice or other data.
The video is not available to view online.
Learn how enhancements to the SQL Server optimizer improve performance without code changes.
SQL Server 2022 is here! In this session, I’ll go over all the new capabilities in SQL Server 2022 including how to connect with Azure for disaster recovery, near real-time analytics, and security. I will show you innovations in the database engine for security, performance, and availability including SQL Server Ledger and Intelligent Query Processing.
Everything you need to get started with PowerShell.
The video is not available to view online.
A variety of 5 minute sessions to include:
SQL Server is a complete Machine Learning platform - learn a complete process to use it from data ingestion to model deployment.
Meet SQL Server audit and compliance requirements for all instances across your enterprise with an easy centralized user interface.
The video is not available to view online.
Come learn about all the latest innovations for SQL Server 2022 and Azure SQL directly from the Microsoft engineering team. This 2-part session will go into some detail for some of the new scenarios planned for Microsoft's flagship RDBMS.
The video is not available to view online.
Come learn about all the latest innovations for SQL Server 2022 and Azure SQL directly from the Microsoft engineering team. This 2-part session will go into some detail for some of the new scenarios planned for Microsoft's flagship RDBMS.
The video is not available to view online.
Quickly and easily migrate databases and associated logins using dbatools.
Even in a cloud provider or virtualized, you still need to worry about the infrastructure supporting SQL Server. This session will cover what that means in the modern world.
Join this session to learn how this “new” T-SQL functionality can save you time when writing queries that also perform great.
The video is not available to view online.
I often recommend that folks proactively manage statistics, but I always seem to run out of time to talk about HOW to do that...this session will cover exactly that.
Introduction of areas for partitioning for Beginners
Learn how to use Performance Analyzer in Power BI to get a first idea of performance bottlenecks in Power BI reports.
As far upstream as possible. As far downstream as necessary. In 20 minutes.
Do not be afraid to move your onprem SSIS packages to Azure. Come and learn how lift and shift them to the cloud
Scaling SQL Servers is complex and is more relevant today as the transactional and data growth rates continue to grow. In this session, we will talk about what it takes to scale SQL Server to meet the peak workload.
Do you want to get the current 232 suggested best practices from the Microsoft SQL Server Team and evaluate your environments? In this all demo session (Yes, no slides), I will show you both the "what" and "how" to do the same using the SQL assessment API and Azure Data Studio 'SQL Assessment' extension.
SQL Server has included capabilities to connect to the cloud for years. SQL Server 2022 moves hybrid to the next level with features to connect you to Azure for disaster recovery, near real-time analytics, and security. Come take a deep dive in this session for all the existing and new hybrid capabilities of SQL Server. See how to easily setup a managed disaster recovery site in the cloud with Azure SQL Managed Instance.
In this session we will cover the benefits of using SQL Server 2019 / 2022 with Intel technology – optimized for performance and scalability. We will discuss how SQL Server can take advantage of Intel Optane™ Persistent Memory to improve scalability, how Intel QuickAssist Technology (a new SQL Server 2022 feature) improves backup performance and capacity, and finally we will highlight new storage engine features in SQL Server 2022.
The video is not available to view online.
SQL Server now runs on Linux, Containers and Kubernetes. In this session you will get an overview of this environment, and explain the installation, management, and monitoring of each.
The video is not available to view online.
Understanding how DAX determines evaluation context is a critical skill for a Power BI Developer. Writing anything other than the most simple measures requires this skill. In this session we'll explore Filter Context and Row Context individually, and how they combine to form Evaluation Context. We'll have a look at a number of simple measures and visualise how the context affects them.
Delicious Demos For Doubting Developers
There is a time and a place for everything. John and Rob, being consultants, often say "Well, it depends" Lets talk about some of the times when the "rules" may not fit
Come and hear our top five disasters and how we managed them (or not)
Let us walk you through our steps to triage and troubleshoot issues as they come in to make sure things get fixed in the right order at the right time and we all stay sane.
Start learning Extended Events today to help you solve your issues in SQL Server.
Best practice checks to optimize costs, increase the performance, and reliability of all your Azure VM's and Azure SQL DB's.
The video is not available to view online.
Best practice checks to optimize costs, increase the performance, and reliability of all your Azure VM's and Azure SQL DB's.
The video is not available to view online.
<<12>>