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.
A guide to available services and solutions for timeseries data
Tired of slow performing Power BI solutions? Sick of user complaints that their report takes forever to render? If you answered “YES” to either one of the questions above, join us for this session packed with best practices and tips to avoid secret (and non-secret) killers of the Power BI performance! No slides, no long story – it’s just YOU, Power BI, and us!
Understand the automatic performance changes in Azure SQL and SQL Server
Understand how to get started with any machine learning project using Databricks AutoML
In this presentation you'll see many unique and creative ways to implement both both bookmarks and buttons to supercharge the filter and navigation experience for your users.
A intro session showing the whys, how's and what's for building a Data Lakehouse in Azure Synapse Analytics
Your Azure Cosmos DB solution's performance and bill depends on partitioning and indexing. Please join me as I share how partitioning and indexing works in Azure Cosmos DB
DBA/Developer Toolset to get you out of that hole and save you some time
Session covering table distributions, partitioning , RSC and materialised views.
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.
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.
What do index rebuilds and defrags really do?
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?
Tips and tricks for getting the best performance out of Spark SQL on Synapse Analytics while keeping costs under control.
Let's be honest; dealing with Keys for Azure Service Principal can be a pain. Fortunately Azure Active Identity has an Identity type called Managed Identity that we can assign to a resource and make use of that for authorisation. We will discuss the beneifts of using Managed Identities in Azure to authorise resources without having to use Service Principals.
Building a Data Quality implementation in Purview using the Glossary and Databricks
In this session you will learn how to keep you data up to date i Power BI.
This session will discuss a custom solution we have built to solve the problem of row level encryption in a highly complex data lake.