Unit Testing of SSRS Reports
1. Background The article describes how we can start the unit testing of SSRS reports. Unit testing helps us in…
Year: 2013
SSRS Questions
1) How to implement Stepped-down group in Report? 2) How to use Gauge in the column of the Report to…
SSRS : Case Study for managing information about a mobile user
Objective: Create a report that’s gives complete information about a mobile user and its call history. Report should have a parameter…
SSRS – How to implement alternate background color in rows
1. Background The purpose of this article is to provide a way of showing different color in alternate rows in…
How to add additional Job step in all the existing jobs in an SQL Server instance
1. Background SQL Server Agent Jobs play an important role in the process automation of any application. Apart from Job…
Sample email format showing job failure notification
Background To monitor various automation processes of a system, alert and notification plays an important role that allows Users/Operation/Support team…
SQL Server Data Mining Presentation
Agenda What is Data Mining Data Mining Techniques Data Mining Algorithms Data Mining Architecture What is Data Mining Data Mining…
SQL Server – How to remove HTML tags from data
1. Background The purpose of this article is to provide a way of cleaning up of HTML tags within the…
SSAS – How to create Analysis Database Snapshot or Cube Snapshot
1. Background The purpose of this article is to provide detail information about how to create an Analysis Database Snapshot…
How to design calculated members in SSAS
1. Background The purpose of this document is to describe how to create Calculated Members in the cube and how…
SSAS –Design Aggregation and Usage Based Optimization
1. Background The purpose of this document is to provide details on importance of aggregation, how effectively we can design…
How to create incremental drop script by using MS Build and SQLPackage utility
1. Background The purpose of this document is to provide a way of creating incremental drop script with respect to…