SSRS – How to change backgroud of Dashboard/ Report
1) Below is the sample dashboard with white bachgroud. 2) Right clcik on the body of the report, you will…
SSRS – How to create a Map report with Geospatial data
The objective of this article is create a SSRS report with geospatial data. Here we will use geospatial data for…
SSRS – How to create a report with XML data source
1) Objective: The objective of this article is to provide a way of developing report with XML as data source. Here…
SSRS – How to create a report with “Enter Data” connection type
1) Objective: The objective of this article is to provide a way of developing report without connnecting any data source…
SQL Server – Error handling and Transactional handling in T-SQL programming
Below is an example showing how to use Error handling as well as Transactional handling in TSQL programming. 1) When…
TSQL Database Deployment script
Following things keep in mind while preparing database deployment script. 1) Include IF EXISTS THEN DROP Statement 2) Include IF…
SQL Server – Database Deployment from QA environment to Production Environment
The objective of this document is to provide simple steps for SQL database deployment from one environment to another. For…
Example of Configuration table in SQL Server
Following is an example of configuration table in T-SQL which can be used for configuring the paramter(s) and providing the…
Directive of Digital Waste Management
1) Now it a time to change the word “Online” to “OnTime” platform which means in place of unnecessary online…
Benefits of SSAS Performance Monitoring and Reporting
By consolidating SSAS performance data, we can build variety of performance monitoring reports that will help us in taking right…
Data Sources for SSAS Performance Monitoring
The following sources can be involved in the ETL processes to consolidate the performance data from SSAS instances for Performance…