Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution
Upgrading SQL Server is one of the most challenging and risky operations that you will perform as a DBA. Make the wrong move, and you could be heading for the exit. In this diverse session, we'll take an in-depth look at moving to SQL Server 2012.
In this session, we will use Grade of the Steel type workloads to quantify the CPU cost of enabling different types of compression. Using CPU profiling, we will try to quantify the cost of this feature.
In this session we are going to look at the some of the flavours of SQL in Azure, namely Windows Azure Database and SQL on IaaS. We will discuss the differences between them, look at what this means from a DBA stand point
This session will include a variety of such activities including Gathering Performance Counters in several servers at the same time using posh jobs, identifying Blocked Sessions and Reading & filtering SQL Error Log even if the Instance is offline
Attend this session to learn about 10 techniques that developers can apply to their code which will calm your DBAs’ fears and earn their admiration