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…
Year: 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…
SQL Server AlwaysOn & Failover scenarios
SQL Server AlwaysOn Architecture SQL Server AlwaysOn is recommended for high availability, zero data loss protection, automatic failover of multiple…
SQL Server – Considerations while opting SSAS cube for existing OLTP application
The following points must be considered while opting for the SSAS cube: 1) Implementing the SSAS cube will change…
Recommendation for separate staging database
Following are the reasons to recommend separate staging database: 1) The database log file does not contain the staging ETL…
White Paper – SQL Server 2012- Merge Replication between SQL Server Enterprise with Express edition
Abstract Replication is a set of technologies for copying and distributing data and database objects from one database to another…