T-SQL Tools: Simplicity for Synchronizing Changes

Target Audience: Any DBA or developer that has ever faced the problem of moving data changes across databases. Abstract: One of most common problems a DBA or database developer may face is finding and syncing data changes efficiently between multiple systems. In this session we will look into different methods focusing on effective use of…
Read More

Columnstore Indexes: What are we waiting for?

Target Audience: DBAs and Query Optimisers – dive into the invisible part of the Columnstore Indexes. Abstract: Every time you see a Columnstore Index getting involved in the execution plan, do you realize that there are whole execution plans behind those Index Scans ? Did you ever ask yourself, what are those strange and weird…
Read More

The Agile DBA: A Guide To Database DevOps With SSDT

No Comments
Additional Resources: Slide deck and example Powershell scripts available on Github Target Audience: If you work with a development team to plan and implement database changes by hand or with third party tooling, you’ll love what Microsoft’s newest version of SQL Server Data Tools (SSDT) has brought to the table. This session is an introduction…
Read More

The Perfect Index

Target Audience: Database Administrators or Developers who want to create useful and thoughtfully designed indexes Abstract: Creating indexes is one of the most powerful ways to improve performance in your SQL Servers. It’s not easy to form indexes for a large and complicated query, and things only get more complicated when queries can come from…
Read More

An introduction to partitioning

Target Audience: Database Administrators\Developers with minimal experience of partitioning in OLTP\OLAP databases. Abstract: This mainly demo based session will cover the following: An introduction to partitioning, core concepts and benefits. Choosing a Partitioning Key Creating Partition Functions & Schemes Indexing Considerations Splitting, Merging & Switching Partitions Implementing Partition Sliding Windows Filegroup Restores with Partitioning After…
Read More