Sessions & Content

Search
Content Type
Conference
Tags
2 Fast 2 Furious - designing for speed, concurrency, and correctness (20 min edition) Mark Broadbent
Learn how to design for speed, concurrency, and correctness and avoid common database development pitfalls.
3 things you don’t want to store in a database (but sometimes have to) Gianluca Sartori
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.
About time: how to work with timeseries in Azure Benjamin Kettner
A guide to available services and solutions for timeseries data
Ambush Assassins: Secret killers of your Power BI performance and how to deal with them Nikola Ilic
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!
Automagic Tuning in SQL Server Joey D'Antoni
Understand the automatic performance changes in Azure SQL and SQL Server
AutoML: An Introduction To Get You Started Gavita Regunath
Understand how to get started with any machine learning project using Databricks AutoML
Beyond Buttons: More Than Meets The Eye Reid Havens
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.
Building the Lakehouse Architecture with Azure Synapse Analytics Mike Dobing
A intro session showing the whys, how's and what's for building a Data Lakehouse in Azure Synapse Analytics
Cost cutting strategies for Azure Cosmos DB Hasan Savran
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 toolset - Getting things done when the pressure is on martin croft
DBA/Developer Toolset to get you out of that hole and save you some time
Dedicated SQL Pools : How some stuff 'really' works Mark Pryce-Maher
Session covering table distributions, partitioning , RSC and materialised views.
Different dimensions of monitoring and tuning performance for Azure SQL Surbhi Pokharna
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.
Erin & Monica’s Favorite SQL Stuff Monica Rathbun
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.
Fragmentation Explained in 20 Minutes Brent Ozar
What do index rebuilds and defrags really do?
Here’s the execution plan … now what? Hugo Kornelis
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?
Hitting Top Speeds with Spark SQL in Azure Synapse Ajith Ramanath
Tips and tricks for getting the best performance out of Spark SQL on Synapse Analytics while keeping costs under control.
How To Use Azure Managed Identities Richie Lee
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.
Implementing a Data Quality Framework in Purview Ust Oldfield
Building a Data Quality implementation in Purview using the Glossary and Databricks
Keeping your data fresh in Power BI Patrick LeBlanc
In this session you will learn how to keep you data up to date i Power BI.
Leveraging Apache Spark for Efficient Data Encryption at Scale Daniel Harrington
This session will discuss a custom solution we have built to solve the problem of row level encryption in a highly complex data lake.
Looking under the hood of the parquet format André Kamman
Understanding how the parquet format works helps with understanding why it can help you retreive your data fast, or perhaps why you struggle to get the desired performance out of your design.
Modern database design (anti)patterns Margarita Naumova
We must realize that patterns which were valid 10 years ago are less likely to work now, like cursor logic, xml usage, or storing all in db v/s using NoSQL. From global industry trends to specific database patterns, this session is a combination of best practices, good and bad patterns, tips, and tricks which I give to customers in my work as a consultant.
Optimisation in Business Luke Menzies
The art of choosing the perfect set of actions to reach the ultimate value that can be achieved.
Partitioning for Beginners Uwe Ricken
Introduction of areas for partitioning for Beginners
PBI Premium Gen2 or: how I learned to stop worrying and love vertipaq Alex Dupler
Why PBI Premium Gen2 should replace SSAS and AAS in your toolset.
Performance Tuning Power Query And Dataflows In Power BI Chris Webb
Performance tune Power Query in Power BI and Power BI Dataflows
Power BI Performance Analyzer crash course Marco Russo
Learn how to use Performance Analyzer in Power BI to get a first idea of performance bottlenecks in Power BI reports.
Reporting on 1.4B rows with Serverless SQL Pools Stijn Wynants
Building a dashboard using Serverless SQL Pools in a performant way
Roche's Maxim of Data Transformation Matthew Roche
As far upstream as possible. As far downstream as necessary. In 20 minutes.
Scaling SQL for your Peak Database Load Ben DeBow
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.
SQL Assessment - Microsoft's Best Practices Checker Taiob Ali
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 Storage Fundamentals for Azure VMs Bob Duffy
SQL Storage Fundamentals for Azure VMs
The fundamentals of building a lakehouse with Synapse Luke Moloney
The fundamentals of building a lakehouse with Synapse
The SQL Server Performance Tasting Menu Erik Darling
Delicious Demos For Doubting Developers
Using WorkloadTools to analyze your workload Gianluca Sartori
In this session I will show you how to use WorkloadTools to connect to a SQL Server database, on-premises or in the cloud, and analyze all the queries that are run against it.
What SQL Server database can tell us about application issues? Denis Reznik
This session will be about database load patterns that show the application design issues and solutions to those issues.
Why star schema is your best choice in Power BI Alberto Ferrari
In this session Alberto compares different models with a star schema, showing the technical details why a star schema is quite always the best choice.
Why You Need Query Store Erin Stellato
I can spend an entire day talking about Query Store and all it can do, but in 20 minutes I can convince you that it should be a feature you start using today.
Your Performance Tuning Check List Monica Rathbun
Everyone needs a list of what to double check in your environment to ensure your servers and databases are optimized in order to make SQL Server run faster, better and more efficiently. In this session you will learn about what you need to review and implement to get a performance and configuration improvements.
"Stop that!": What does compliance mean for development? Christopher Unwin
In this session you'll learn some of the key data privacy problems facing database developers and DBAs and 10 steps to help your database team build a "defensible position" through development.
5 Mistakes in Cloud Data Migration Justin Langford
We're fortunate in seeing tons of customers migrate to the cloud - this session covers major
Advanced Plan Explorer Usage for Tuning Execution Plans Andy Yun
Users of Plan Explorer often only utilize the basic capabilities to tune execution plans. This session will cover more advanced techniques to get the most out of SentryOne's FREE execution plan analysis tool.
Azure AI, Power new possibilities for every organization Lindsey Allen
AI and data is at the center of the digital feedback loops. We have invested in a comprehensive portfolio of AI tools, infrastructure and services. Come to this session to get an update of Azure AI with demos.
Azure Cost Management Dustin Dorsey
Learn the tools and techniques you can use to create governance and insights around your Azure spend
Azure data services on Azure Arc Umachandar Jayachandran
In this session you’ll learn more about Azure data services on Azure Arc
Azure DW and Power BI, reporting at the speed of light! Stijn Wynants
In this action-packed demo full session, we will be showing you how to combine Azure DW and Power BI to get optimal performance for running your day to day reports.
Azure Machine Learning and the Python SDK Robin Lester
Understand how to create, train and operationalize your data science projects in Azure Machine Learning.
Azure SQL and SQL Server: Path to an Intelligent Database Pedro Lopes
Come join us in the intelligent database world that started with SQL Server 2017 and takes a leap forward with the upcoming SQL Server 2019 and Azure SQL DB.
Azure SQL Hyperscale Deep Dive Denzil Ribeiro
We will deep dive into the architecture of Hyperscale and its various components. We will dive into scaling aspects and the new application patterns it enables and also diagnostics that enable bottleneck identification.
Azure: Maxmise your bang for Buck Justin Langford
Considerations in how you buy Azure to provide maximum bang for buck
<<123>>