SSAS 2012 – Multi-Dimensional Handout
Topics Dimensional Modeling Building a Cube Dimension Usage Namedset Calculated Member KPI Drill Through Partition Design Aggregation Perspective Translation Browsing…
Month: December 2017
SSIS 2012 – Data Flow Transformations Handout
Data Flow Transformations Aggregate Conditional Split Data Conversion Derived Column Lookup Sort Merge Merge Join Multicast OLEDB Command Row Count…
SQL Server Reporting Services(SSRS) – Performance Monitoring & Optimization
Common Report Performance Issues Data takes too long to retrieve Report takes too long to process Report takes too long…
Web Application / Database Failover & Load Balancing
Web application would be hosted on web server 1 and web server 2. Both the web server would be configured…
SQL Server – SSIS Configuration for Fault Tolerance
Integration Services service is not a clustered or cluster-aware service and does not support failover from one cluster node to…