Learn how to leverage the data model to create flexible behaviour in a cube without the overhead of calculated members
This session will introduce the concept of scoped assignments in MDX and show how they can be used to solve various calculation problems.
A chance for speakers new and seasoned to take the stage for 5 minutes and effuse about something/anything in SQL Server they love.
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.
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.
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 provides several new key features for building SOA applications directly with SQL Server 2008.
SQL Virtualisation using the Microsoft Assessment Planning tool and the SQL Consolidation Toolkit
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.
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.
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
This presentation will cover all of the new engine and tools features coming our way in the next major version of SQL Server.
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"?