22-25 April 2026 
Compression - Define your Strategy
2012TL; DR
The Enterprise only feature "Compression" can make a HUGE difference to your storage requirements and we will examine this feature in detail, integrate this into your strategies, finding objects which your should use this one
Session Details
The Enterprise only feature "Compression" can make a HUGE difference to your storage requirements and we will examine this feature in detail, integrate this into your strategies, finding objects which your should use this one - we will be using compression estimates along with index usage information, fill-factors to achieve a balanced strategy
This session will not only cover the core principles of SQL Server's data compression feature, how it functions, what options you can choose, and how it performs under differing workloads.
We will also look at how to integrate data compression into your current schema designs and the challenges you will likely encounter, examining the all-important performance aspects and the configuration changes to consider along with SKU editions requirements.
This session will not only cover the core principles of SQL Server's data compression feature, how it functions, what options you can choose, and how it performs under differing workloads.
We will also look at how to integrate data compression into your current schema designs and the challenges you will likely encounter, examining the all-important performance aspects and the configuration changes to consider along with SKU editions requirements.
3 things you'll get out of this session
Speakers
Neil Hambly's previous sessions
PowerBI-Model Designs
Building effective PowerBI reports and dashboards requires a well-designed data model with the right relationships and measures, this session tackles those challenges your encounter during the design phase and where to get training required for this.
Load Testing With SQL Server Tools
Understanding how SQL Server performs under various Load scenarios, requires controlled testing of a SQL Server instance whilst capturing key metrics
using tools like Distributed Replay Controller can make this challenging task easier
Effective Index Partitioning, Compression Strategy
We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server. When Indexing also combines 2 of the Enterprise features: Partitioning & Compression
SQL Server 2012 Memory Management
SQL Server 2012 brings a wide range of changes, including a key change in how SQL Server memory is managed. Earlier releases of SQL Server have two memory managers, which have now been merged into one, discover all these important changes
Why are we Waiting..
Not to be confused with the Rugby / Football ditties, but actually an in-depth look @ "Waits" Side of the well-known "Waits & Queues" methodology
With focus in this session on interpreting the information in the (DMV) sys.dm_os_wait_stats
Why are we Waiting.. Part 2
This session was first given @ SQLBits 8, with the upcoming Denali release we can not only revisit this topic once more, but add to it further showing techniques and enhancements to the "Waits" analysis now possible with the latest SQL release
DAC (Data Tier Applications) - Build and deploy your first Dacpac
DAC(Data Tier Applications) a new feature introduced in SQL Server 2008 R2, learn how this new feature can fit into your database deployment lifecycle strategies, monitor the health & performance of your DAC applications using Utility Explorer