The SQL Server provides much functionality that increases the scalability and flexibility of your solution by distributing data and jobs among low-priced commodity servers.
Many of us know what dimensions and fact tables are. But dimensional modelling is more than just dimensions and fact tables. This session is about advanced dimensional modelling topics, which are useful for anybody involved in the design of a DW.
This dense hour of presentation will cover design techniques to leverage cube features that also consider possible maintenance of the database structure over time.
This session will show how to use DMVs (data management views) to query the OLAP cube structure, and then use SSRS to create a set of interactive reports including the BUS matrix, and using spatial data to generate automated star schemas.
In this session, I will demonstrate, step-by-step, the entire process of restoring all of the system and user databases from a damaged instance to a new instance.
A look at the new SSIS features in SQL Server code-named Denali
In this session Noemi Moreno, BI Developer and Tom Austin, SQL Tools representative, will show you how to use SQL Developer tools to simplify and enhance your Business Intelligence application.
Introduce the features of BISM (BI Semantic Model), the new engine that will be available in Analysis Services "Denali".
This session will present the tools and techniques used to create OLAP cubes and supporting data marts on-the-fly from a mere set of data files and configuration metadata.
This session will be an in-depth look at what the MDS business rules are and how they work, including a series of demos and guidance on how the rules are built. SharePoint Workflow will also be covered, as MDS can initiate a SharePoint workflow.
Attunity's Ian Archibald will discuss how CDC solutions can solve problems in BI and ETL/DW projects, co-hosted with two of the industry’s highly-respected SQL Server gurus BI expert Jennifer Stirrup and ETL expert and SQL Server MVP Allan Mitchell
This session will teach you how to successfully plan, implement and manage SQL Server consolidation and virtualization within your organization
Learn how to leverage the data model to create flexible behaviour in a cube without the overhead of calculated members
A new and fresh approach to datwarehousing that is agile, performant and easy to do. Data Vault is a new methodology that tries to overcome traditional problems that plagued traditional datawarehousing in the past.
Using technical demonstrations in Microsoft SQL Server Reporting Services, this presentation will focus on the practical implementation of data visualisation, along with cognitive science principles supporting data visualisations.
A look into the world of database testing, how to go about it, why do we really need it and how to work well with your peers and managers for greater project success.
We all know how much love DBA's have for Developers and visa versa. You can measure it in milligrams. This fun session discusses the issues we have with one another and presents some solutions to save knives in backs and blood stained carpets.
Fusion-io's Mat Young will look at how radical change is often achieved through distillation and simplicity of design in conjunction with passionate people and great software.
Executing SSIS Packages and handling the errors
This session will introduce the concept of scoped assignments in MDX and show how they can be used to solve various calculation problems.
This will show the replication options available in sql server and in which situations each type can be used. I will also show how to set it up and some diagnostic techniques for when it doesnt work
SQL Server spatial features have not yet made it into mainstream usage and many developers still ask "But *why* would I use them?". In this session, I hope to answer that question by replicating the functionality of Google Maps using only SQL Server.
In this session, I will talk about the lessons we have learned and the methodology we follow when diagnosing and resolving issues with real customer workloads running on 64 and 128 logical cores
PowerPivot can be a great troubleshooting / performance tuning tool for a dba besides just loading all the data in a database and start querying. I'll show the pro's and cons of PowerPivot while trying work with waitstats, profiler data etc.
Back (hopefully) by popular demand I'll be sharing the secrets to getting started with Powershell in a SQL Server Environment.