Analysis Services is the most dominant technology on the 70-448 exam. About 40% of the questions will pertain to SSAS.
This was originally posted on stackexchange as an answer. I haven't seen it anywhere else, and it'd be a travesty if it were lost for some reason.
Thanks, Martin !
Table Variables vs. Temp Tables in SQL Server:
The SELECT permission was denied on the object 'configurations', database 'mssqlsystemresource', schema 'sys'Submitted by jeff on Wed, 05/22/2013 - 17:15
I recently encountered a situation where this error message began appearing to all non-sysadmin logins on a SQL Server.
Most commonly, this is caused by hardening of a SQL Server (the revoking of permissions assigned to PUBLIC) or the user(s) being added to a group that was being denied select permissions.
In this case, it was occurring for all users that didn't have the sysadmin server role.
Too useful not to repost. Original source is ComputerHope.Com. There's also a VBScript version.
When your SSIS .DLLs get unregistered for the 90th time, you can use this to re-register them.
Of all the various SQL Server disciplines with which I’ve worked, I find SSRS to be the messiest and most uninteresting. The configuration is still clunky – even in 2008 – and developing reports is quite dull.
Dataset filters limit the data displayed on the report after retrieval from the source. This applies to any regions or parts of a report that use that dataset.
This section covers about 30% of the exam. The breakdown, roughly, seems to be SSIS (30%) / SSRS (30%), SSAS (40%).
à make a package more dynamic – set options like server name, data source in a configuration file to make them easier to move from server to server.
Exam prep: Microsoft Exam 70-448 (070-448): Microsoft SQL Server 2008, Business Intelligence Development and MaintenanceSubmitted by jeff on Tue, 01/29/2013 - 22:25
Next up: BI.
The good news: There are decent textbooks and possibly even a serviceable .VCE.
The bad news: There’s a TON of material to know for this exam. Multiple complex topics are touched on, including data mining/modeling.
Getting started: If you haven’t read it, I strongly recommend Ralph Kimball’s The Data Warehouse Toolkit.