Open firewall ports required for UNC

137 138 (UDP) 139 (TCP) 445 (SMB)

70-448 (070-448) Exam prep, Part 3/3 - SSAS

SSAS

 

Analysis Services is the most dominant technology on the 70-448 exam. About 40% of the questions will pertain to SSAS.

 

Installation/Configuration

 

Martin Smith's comparison of table variables and temp tables

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'

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.

Register all .DLLs in a directory

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.

@echo off

 

70-448 (070-448) Exam prep, Part 2/3 - SSRS

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.

Enjoy !

Filtering Data

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.

70-448 (070-448) Exam prep, Part 1/3 - SSIS

This section covers about 30% of the exam.  The breakdown, roughly, seems to be SSIS (30%) / SSRS (30%), SSAS (40%).

 

Package Configurations

à 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 Maintenance

 

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.

SQL Server Certifications - Holiday Roundup

Syndicate content