Learn how to design for speed, concurrency, and correctness and avoid common database development pitfalls.
The video is not available to view online.
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.
The video is not available to view online.
A guide to available services and solutions for timeseries data
The video is not available to view online.
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!
The video is not available to view online.
Understand the automatic performance changes in Azure SQL and SQL Server
The video is not available to view online.
Understand how to get started with any machine learning project using Databricks AutoML
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.
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.
The video is not available to view online.
A intro session showing the whys, how's and what's for building a Data Lakehouse in Azure Synapse Analytics
The video is not available to view online.
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
The video is not available to view online.
DBA/Developer Toolset to get you out of that hole and save you some time
The video is not available to view online.
Session covering table distributions, partitioning , RSC and materialised views.
The video is not available to view online.
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.
The video is not available to view online.
How you can improve performance by splitting up large operations in chunks
The video is not available to view online.
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.
The video is not available to view online.
What do index rebuilds and defrags really do?
The video is not available to view online.
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?
The video is not available to view online.
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.
The video is not available to view online.
Building a Data Quality implementation in Purview using the Glossary and Databricks
The video is not available to view online.
In this session you will learn how to keep you data up to date i Power BI.
The video is not available to view online.
This session will discuss a custom solution we have built to solve the problem of row level encryption in a highly complex data lake.
The video is not available to view online.
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.
The video is not available to view online.
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 video is not available to view online.
The art of choosing the perfect set of actions to reach the ultimate value that can be achieved.
The video is not available to view online.
In this demo-led session, we will be exploring various capabilities for optimising a Power BI Desktop report for Mobile. So, if you want your Power BI Mobile Reports to look and feel as good as your Power BI Desktop Reports, this is the session for you.
The video is not available to view online.
Introduction of areas for partitioning for Beginners
The video is not available to view online.
Why PBI Premium Gen2 should replace SSAS and AAS in your toolset.
The video is not available to view online.
Performance tune Power Query in Power BI and Power BI Dataflows
The video is not available to view online.
Learn how to use Performance Analyzer in Power BI to get a first idea of performance bottlenecks in Power BI reports.
The video is not available to view online.
Building a dashboard using Serverless SQL Pools in a performant way
The video is not available to view online.
As far upstream as possible. As far downstream as necessary. In 20 minutes.
The video is not available to view online.
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.
The video is not available to view online.
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.
The video is not available to view online.
SQL Storage Fundamentals for Azure VMs
The video is not available to view online.
Delicious Demos For Doubting Developers
The video is not available to view online.
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.
The video is not available to view online.
This session will be about database load patterns that show the application design issues and solutions to those issues.
The video is not available to view online.
A short introduction of the cool tools you need as a DBA today.
The video is not available to view online.
In this session, I will walk you through how to tune a very simple but surprisingly slow Transact-SQL query and how to decide when to stop this process.
The video is not available to view online.
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.
The video is not available to view online.
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.
The video is not available to view online.
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.
<<123>>