Search
Conference
Tags
A quick 20 minute discuss about learning how to deal with emotional hurdles when working for a SQL Celebrity.
The video is not available to view online.
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.
SQL bits and London Power BI user group are brining a Q&A panel with some of Power BI CAT team members to ask everything about Power BI. Join us with your questions
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.
Azure SQL DB and SQL Server introduced ground-breaking query performance enhancements under the Intelligent Query Processing family in the past few years. These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale, while remaining adaptive to the constantly changing world of data! Now join us to find about what's coming next in this new intelligent database world with SQL Serevr 2022 and Azure SQL!
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.
Being data-driven is all about making decisions based on insights generated using data.​
The video is not available to view online.
Being data-driven is all about making decisions based on insights generated using data.​
The video is not available to view online.
What do index rebuilds and defrags really do?
The video is not available to view online.
Trying to rapidly build out an Engineering function to meet internal demand? Struggling to hire/retain the right resource and team structure? Listen to How Heathrow have laid out the foundations and accomplished a true Data Transformation by leveraging a partnership with Adatis. A must see, intriguing session to see how a Data Platform has been brought to life in Aviation.
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.
Tips and tricks for getting the best performance out of Spark SQL on Synapse Analytics while keeping costs under control.
The video is not available to view online.
In this session, we’ll go deep into the internal behavior of SQL Server CPU, including the internal and external memory pressure, worker thread management, and how to troubleshoot CPU 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.
SolarWinds Orion - Monitoring Beyond The Database
The video is not available to view online.
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.
Query store hints enables changing query plan shapes without modifying application code. We will look at a few poor performance scenarios and use query store hints to improve performance of the application. Become an instant hero  having query store hints in your toolkit.
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.
Get to grips with data loading in Synapse.
The video is not available to view online.
SolarWinds DB Management - An Overview
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.
In this session we will cover the benefits of using SQL Server 2019 / 2022 with Intel technology – optimized for performance and scalability. We will discuss how SQL Server can take advantage of Intel Optane™ Persistent Memory to improve scalability, how Intel QuickAssist Technology (a new SQL Server 2022 feature) improves backup performance and capacity, and finally we will highlight new storage engine features in SQL Server 2022.
The video is not available to view online.
SQL Storage Fundamentals for Azure VMs
The video is not available to view online.
The fundamentals of building a lakehouse with Synapse
The video is not available to view online.
Delicious Demos For Doubting Developers
The video is not available to view online.
<<12>>