Sessions & Content

Search
Content Type
Conference
Tags
Data Modelling for a flexible cube Jessica Stevens-Taylor
Learn how to leverage the data model to create flexible behaviour in a cube without the overhead of calculated members
Fun with Scoped Assignments in MDX Chris Webb
This session will introduce the concept of scoped assignments in MDX and show how they can be used to solve various calculation problems.
Lightning Talks Various Speakers
A chance for speakers new and seasoned to take the stage for 5 minutes and effuse about something/anything in SQL Server they love.
Notes from the field: Cross-team Performance Troubleshooting Justin Langford
This session will be presented jointly by Justin Langford and Gavin Payne . The focus of the session is the approach to a cross-team Performance Troubleshooting engagement where multiple stakeholders were involved.
Parameter Sniffing Problem with Stored Procedures Milos Radivojevic
In this presentation it will be clarified when and why parameter sniffing is a problem in SQL Server stored procedures. Of course we will offer several solutions for this problem and discuss which solution is applicable in which scenario.
Performance Tuning Large Analysis Services Cubes Duncan Sutcliffe
Cube tuning is a key part of any BI project and it gets more so as cubes get bigger. Here are a series of tuning procedures to follow for cubes large and small.
Service Broker: Message in a bottle Klaus Aschenbrenner
Service Broker provides several new key features for building SOA applications directly with SQL Server 2008.
The video is not available to view online.
SQL Consolidation Planning Bob Duffy
SQL Virtualisation using the Microsoft Assessment Planning tool and the SQL Consolidation Toolkit
SQL Server 2008 Database Internals Klaus Aschenbrenner
Do you already wanted to know how SQL Server 2008 stores a database file physically on the hard drive? In this session you will learn the internal structure of a SQL Server 2008 database file.
SSIS Custom Components Dave Ballantyne
Writing your first SSIS custom components can seem like a very steep learning curve. In this session i shall walk you through a simple skeletal one to start you on your way.
We have control!-Controlling Resources in SQL Server Chris Testa-O'Neill
With SQL Server you can integrate traditional tools such as SQL profiler and performance monitor to pinpoint problems. With SQL Server 2008, you can control environments using Policy based management and with the Resource Governor. Chris will explore
The video is not available to view online.
Whats new in SQL Server "Denali"? Aaron Bertrand
This presentation will cover all of the new engine and tools features coming our way in the next major version of SQL Server.
Where did I put my keys? Ami Levin
If you want to see DBAs fight - ask them what is better: using IDs or native keys? This old debate has been troubling database designers since the days of Dr. Codd and Chris Date. Are you ready to hear the "truth"?
The video is not available to view online.
<<1>>