SQLBits 2010

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

DAC (Data Tier Applications) introduced in SQL Server® 2008 R2 release, in collaboration with Microsoft Visual Studio® 2010 it allows Developers & DBAs to develop and deploy Data Tier Applications in self-contained units (dacpacs) Using DACs, developers and database administrators can now automate common operations and design practices during their database lifecycles in controlled environments We will discuss the key features and perform some demonstrations of the development & then deployments of a dacpac, as with any new feature it presently has several limitations, we will discuss those and where/when this feature can be used to good effect.

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