A guide to the things that you should be doing if you use the CLR, as well as those that you shouldn't. Find out what you need to be aware of, with a cause-and-effect approach.
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
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.