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.
<<123>>