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
This session will introduce the basic concepts of the new multidimensional calculation language, DAX, and show how to implement several common calculations in it
See how the optimiser chooses the operators it does through real world examples.
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.
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.
An overview of some everyday TSQL tuning techniques.