Sessions tagged as 'Optimising'

How to build a data warehouse solution for your analytical workloads8th@09:00
Mastering Parameter Sniffing8th@09:00
Notes from the Field: A Guide to Modern SQL Server Availability Architectures8th@09:00
Analytics at scale with Power BI and Azure Synapse9th@09:00
Azure Data Integration Pipelines - Advanced Design and Delivery9th@09:00
Azure from Admin to Architect9th@09:00
Cracking Power BI Performance Tuning in a day!9th@09:00
Finding Problems and Stabilizing Performance with Query Store9th@09:00
Improve Power BI performance by optimizing DAX9th@09:00
The Day after Dashboard in a Day9th@09:00
The Professional Performance Tuning Blueprint9th@09:00
How to Troubleshoot SQL Server CPU Problems10th@10:10
Partitioning for Beginners10th@10:10
The fundamentals of building a lakehouse with Synapse10th@10:10
Why star schema is your best choice in Power BI10th@10:10
$%*# I Learned Working for Denny Cherry10th@11:30
One Size Does Not Fit All10th@11:30
Why You Need Query Store10th@11:30
You CAN Run SQL at Scale in the Cloud!10th@11:30
Different dimensions of monitoring and tuning performance for Azure SQL10th@12:00
Heathrow’s Data Transformation – How to rapidly build out a data engineering function10th@12:00
SQL Storage Fundamentals for Azure VMs10th@12:00
Automagic Tuning in SQL Server10th@13:40
Power BI Performance Analyzer crash course10th@13:40
About time: how to work with timeseries in Azure10th@14:10
Cost cutting strategies for Azure Cosmos DB10th@14:10
Reporting on 1.4B rows with Serverless SQL Pools10th@15:20
Five steps to create a data-driven culture10th@16:40
Looking under the hood of the parquet format10th@17:10
An evening with Power BI CAT team10th@18:15
3 things you don’t want to store in a database (but sometimes have to)11th@10:10
Azure SQL Database - A true story journey from migration, through synchronization and beyond.11th@10:10
Implementing a Data Quality Framework in Purview11th@10:10
Unified insights and staying ahead of performance issues all within a single view for Hybrid Env11th@10:10
Dba toolset - Getting things done when the pressure is on11th@11:30
Erin & Monica’s Favorite SQL Stuff11th@11:30
Lessons learned from managing Azure Data platforms! Put your data hat on!11th@11:30
Leveraging Apache Spark for Efficient Data Encryption at Scale11th@11:30
AutoML: An Introduction To Get You Started11th@13:40
Roche's Maxim of Data Transformation11th@13:40
What SQL Server database can tell us about application issues?11th@13:40
Ambush Assassins: Secret killers of your Power BI performance and how to deal with them11th@14:10
Azure SQL and SQL Server 2022: Intelligent Database Futures11th@14:10
Modern database design (anti)patterns11th@14:10
The SQL Server Performance Tasting Menu11th@14:10
Here’s the execution plan … now what?11th@15:20
Keeping your data fresh in Power BI11th@15:20
Your Performance Tuning Check List11th@15:20
2 Fast 2 Furious - designing for speed, concurrency, and correctness (20 min edition)11th@16:40
Fragmentation Explained in 20 Minutes11th@16:40
How To Use Azure Managed Identities11th@16:40
SQL Server and Intel: Unlock Better SQL Performance and Scalability11th@17:10
When to stop tuning a query11th@17:10
Beyond Buttons: More Than Meets The Eye12th@09:30
Building the Lakehouse Architecture with Azure Synapse Analytics12th@09:30
Dedicated SQL Pools : How some stuff 'really' works12th@09:30
Don't Bite Off More than You Can Chew - Take it in Chunks12th@09:30
Less QQ, More PewPew in IT12th@10:50
What they should have told me about being a DBA12th@10:50
Monster Data Loading with Synapse12th@11:20
Optimising Power BI Reports for Mobile12th@11:20
Performance Tuning Power Query And Dataflows In Power BI12th@11:20
Scaling SQL for your Peak Database Load12th@11:20
Five steps to create a data-driven culture12th@12:50
Optimisation in Business12th@12:50
PBI Premium Gen2 or: how I learned to stop worrying and love vertipaq12th@12:50
SQL Assessment - Microsoft's Best Practices Checker12th@13:20
Hitting Top Speeds with Spark SQL in Azure Synapse12th@14:40
Mitigate performance problems using Query Store hints12th@15:50
Unified insights and staying ahead of performance issues all within a single view for Hybrid Env12th@15:50
Using WorkloadTools to analyze your workload12th@15:50

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference


Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.