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.
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.
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.
The art of choosing the perfect set of actions to reach the ultimate value that can be achieved.
Introduction of areas for partitioning for Beginners
Why PBI Premium Gen2 should replace SSAS and AAS in your toolset.
Performance tune Power Query in Power BI and Power BI Dataflows
Learn how to use Performance Analyzer in Power BI to get a first idea of performance bottlenecks in Power BI reports.
Building a dashboard using Serverless SQL Pools in a performant way
As far upstream as possible. As far downstream as necessary. In 20 minutes.
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 Storage Fundamentals for Azure VMs
The fundamentals of building a lakehouse with Synapse
Delicious Demos For Doubting Developers
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.
This session will be about database load patterns that show the application design issues and solutions to those issues.
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.
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.
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.
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.
We're fortunate in seeing tons of customers migrate to the cloud - this session covers major
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.
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.
Learn the tools and techniques you can use to create governance and insights around your Azure spend
In this session you’ll learn more about Azure data services on Azure Arc
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.
Understand how to create, train and operationalize your data science projects in Azure Machine Learning.
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.
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.
Considerations in how you buy Azure to provide maximum bang for buck
<<123>>