Sessions & Content

Search
Content Type
Conference
Tags
Common Analysis Services design mistakes and how to avoid them Chris Webb
Learn about the most frequently made Analysis Services design mistakes, the problems they cause, and how to fix them or not make them in the first place
Implementing Common Business Calculations in DAX Chris Webb
This session will introduce the basic concepts of the new multidimensional calculation language, DAX, and show how to implement several common calculations in it
Physical Join Operators Ami Levin
See how the optimiser chooses the operators it does through real world examples.
SQL CLR Demystified Matt Whitfield
A look at the basics of CLR integration with SQL Server, focusing on the nuts and bolts of CLR objects, followed by some practical examples.
Troubleshooting Transactional Replication in the Wild Chirag Roy
Transaction Replication is a widely used feature in SQL Server though its internals are sparsely understood. In this session we will look under the hood and gain indepth understanding about Transactional Replication architecture and its corresponding components like logreader and distribution agents, Reader/Writer threads, etc. We will learn methods of identifying and monitoring replication latency and methods of troubleshooting and eliminating bottlenecks to improve Replication Performance.
TSQL Techniques - Why and how to tune a routine Dave Ballantyne
An overview of some everyday TSQL tuning techniques.
<<1>>