Optimizing SQL Server Infrastructure in the Enterprise: Margarita Naumova
SQL Server has been aside from consolidation and virtualization technologies. There are some fears and in the air if it is appropriate to implement optimization technologies like consolidation and virtualization, will the SQL Server continue to perform in the same way, how to define the resources we need. Let’s talk about it and see when and how we can optimize our SQL Server infrastructure in the enterprise, what the valid approaches are and how to plan for them.
Doing fast! Optimizing Query performance with ColumnStoreIndexes in SQL Server 2012: Margarita Naumova
Learn how SQL Server 2012 can allow you to get more business value from your data through fast, interactive exploration. SQL Server 2012 introduces new columntore indexes which allow your queries to perform ways faster. IT workers can reduce development costs and ETL times since columnstore indexes limit or eliminate the need to rely on pre-built aggregates, including user-defined summary tables, and indexed (materialized) views.
SQL Server Query Tuning: Klaus Aschenbrenner
If you have a database driven application which reacts very slowly when the data increases, then you are right in this session! In this session you will learn, how you can tune SQL Server Queries with the information available inside an execution plan. You will see how SQL Server retrieves data from the database file, how SQL Server can join resultsets, and how you can react with indices if you are in performance troubles.
*) JOIN techniques used by SQL Server
*) Table/Index scan vs. Index Seek
*) Avoiding Bookmark-Lookups
*) Index Usage
SQL Server Memory Management: Klaus Aschenbrenner
There are so many different concepts and things that you have to know when you have to configure memory settings for SQL Server correctly. In this session you get an overview about the memory architecture of SQL Server 2008 and how SQL Server is using memory internally. You will also learn how you can track memory consumption inside SQL Server, and what are the most relevant memory configuration options that you can use to fine-tune and troubleshoot SQL Server. We will also have a more detailed look into the new memory architecture of SQL Server 2012.
Distributed Replay with SQL Server 2012: Klaus Aschenbrenner
One of the new coolest things in SQL Server 2012 is the capability of replaying high-volume workloads through the new Distributed Replay technology. In this session we will cover the basic concepts about Distributed Replay, how to setup your own test lab for Distributed Replay, and how to perform the Distributed Replay itself. As a demo we will take a TPC-C based workload with a few hundred users, and replay it in a large scenario to see if performance optimization techniques were useful.
SQL Server 2012 AlwaysOn: Gianluca Hotz
Business continuity is becoming more and more a central topic for many companies. AlwaysOn is the new solution for high availability and disaster recovery introduced with SQL Server 2012. With the help of live demos, in this session we will cover in details this new technology that extends on the familiar concepts of database mirroring and failover clustering. We will also introduce some other engine enhancements that will help raising the overall service availability.
Introduction to DAX Queries and Calculations : Chris Webb
DAX is Microsoft’s new multidimensional query and calculation language, used in PowerPivot and the Analysis Services 2012 Tabular model. This session will introduce basic concepts in DAX and show how to write DAX queries and calculations.
The Microsoft Self-Service BI Stack : Chris Webb
Over the last few years Microsoft – already very successful in the corporate BI space – has made several moves to strengthen its self-service BI offerings too. This session will provide an overview of the Microsoft tools that can be used for self-service BI: Excel, PowerPivot, Data Explorer, Sharepoint and many others. It will also cover what’s coming in the future and how self-service BI can be integrated with corporate BI tools.
What’s New in SQL Server Analysis Services 2012? : Chris Webb
The 2012 sees Analysis Services splitting into two: the Multidimensional model, which is basically the Analysis Services of cubes and dimensions that we’re all familiar with, and the new Tabular model which is very similar to PowerPivot. This session will cover what’s new in Analysis Services 2012 Multidimensional, provide a brief overview of the Tabular model, discuss their relative strengths and weaknesses and help you decide which one is appropriate for your project.