SSRS Issue – Unable to deploy the bulk RDL files
1. There is a property called maxRequestLength which needs to be increased in the machine and web.config file which is…
SSRS Issue – Request length exceeds a certain amount
Error description: Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server…
SSRS – Issue with Refresh Button
Error description: Once we upload the page and we leave it open for a certain amount of time (let’s say 60…
SSRS – How to use Sub Report from Chart report
1) Main Report Here is the main report which is showing the State/UT wise Census report for top…
SSRS Report – Workaround for resolving the color changes/column merging issue
Workaround for resolving the color changes/column merging issue in SSRS report: 1. Status color changes while exporting to excel 2.…
SQL Server Reporting Services – Memory Configuration & Management
1) What is Memory Pressure Memory pressure simply is the percentage of physical memory less than free and reclaimable memory…
T-SQL Programming – How to see Query execution time in milliseconds
1) Objective of the Article Many times, we need to work on small set of masked data in the projects…
SQL Server – DTS to SSIS Migration
1. Need of DTS to SSIS Migration DTS was first released with SQL Server 7.0 with a objective of helping…
SQL Server 2012 Licensing and Pricing Guide.
1. Overview This Licensing Guide provides a way to understanding how Microsoft® SQL Server® 2012 database software is licensed through…
SQL Server – High Availability & Disaster Recovery solutions
Following is the difference between High Availability & Disaster Recovery solutions provided by SQL Server: High Availability and Disaster Recovery…
SQL Server Reporting Services Vs Performance Point Server (SSRS vs PPS)
Following are the difference between SQL Server Reporting Services (SSRS) and Performance Point Server (PPS) SSRS as well as PPS…
SQL Server – Database Architecture
Database is a place in the SQL Server where we store the data. It the collection of tables, views, stored…