Sessions & Content

Tags
Content Type
Search
Conference
Designing a database to best support multidimensional OLAP
Data warehouse designers often ignore the specific needs of an OLAP database. In this session, John will outline the best ways to optimise your relational database to support your multidimensional OLAP cubes
Superscaling SQL Server 2014 Parallel Insert
This session will take a look at how parallel select into can be scaled to the nth degree in SQL Server such that all available hardware resources are utilised as fully as possible.
When good SQL design goes bad
In this humorous session I’ll be contesting many of the so called "best practices" in SQL Server and demonstrating counter arguments. Come along to see how so called "pillars" of design are starting to break down.
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
Patterns & Practices for Scaling Windows Azure SQL Database
This session will discuss the recommended approaches and best practices for partitioning and scaling Windows Azure SQL Database, allowing you to fully leverage the managed relational database service and take advantage of massive scale-out scenarios.
Incremental processing of SSAS Multidimensional databases
Processing of SSAS OLAP databases can be a tricky business, particularly when it comes to incremental processing of dimensions. John will give you real life examples of why certain approaches work and others do not.
Layered Partitioning - manage very large data sets
“Just use partitioning” is the answer you hear, when you need to manage very large data sets in your Data Warehouse. But how do you design and implement it? We will walk through different ways to design partitioning, including layered partitioning.
Scaling Out SSIS With Parallelism
An introduction to scaling out packages using parallelism with the "Work pile" pattern, balanced data distributor and "Roll your own" techniques.
A Deep Dive in SQL Server 2012 Data Warehousing
In this session, we are going to explain and test different DW features in SQL Server 2012, including star join optimization through bitmap filters, table partitioning, window functions, columnstore indices and more.
T-SQL Brush-up:The Best Things You Forgot You Knew About SQL
Sometimes some piece of T-SQL slips by, or falls out of memory.Come and revisit old favorites, and brush up on new T-SQL features and enhancements.This session is chock full of code examples, including before-and-after demos and how-to illustrations.
  1 to 10 of 13 first 1 2 last  Show 10 25 50 100 sessions per page