SQL Server Reporting

New SSIS Features in SQL Server 2012

SQL Server Integration Services (SSIS) has under-gone through some significant changes in SQL Server 2012 which I will outline in this article. Connection Managers Now you have project-based connection managers which mean those connection will be available for all the packages that you are creating. This avoids recreating frequently used connections for every package.  Those […]

Managing the Report Content Using Report Manager: Caching

Introduction In the Managing the Report Content Using Report Manager: Part I we saw how  to go about setting the security for the Report Manager report items. In this article we will be focusing on caching SSRS reports. Caching Caching is when a copy of the processed report after the execution is saved into into […]

Adhoc Reporting Using SSRS 2008 R2

Reporting Services comes with a built-in modeling tool called Report Model Designer which is used for developing adhoc reports. Due to their ease of creation, adhoc reports are often developed by end users as opposed to developers. The main purpose of the report model is to shred the dependency on the coding and give a […]

SQL Server Reporting Services – Insufficient Rights Error

Introduction At times when we successfully deploy the reports to the report server and try to view them through report manager we may encounter am insufficient rights error. This article focuses on resolving that error. Solution After deploying the reports to the report server we can view them in the Report Manager web app provided […]

Adding Custom Code to the Reporting Services 2008 R2

There are numerous circumstances when we wish to add a custom function to a SSRS report in order to cater for needs of the customer which exceeds the capability of the built-in functions in SSRS. In these scenarios we will have to write our own functions. In this article I will demonstrate how to add […]

SQL Server Data Mining with Microsoft Office Excel

Data Mining with Microsoft Office Excel Introduction A key issue in data mining is not only generating the results but also interpreting them. Unfortunately it is often difficult to interpret the results of data mining and many users are turning to Excel and its data mining add-in tool. Requirements You will need to have permission […]

Reporting Services 2008 R2: Geospatial Visualization – Part I

Geospatial Visualization is one of the key new features of SQL Server 2008 R2 Reporting Services.SQL Server provided geospatial data with SQL Server 2008 and you may have noticed (or perhaps used) the two geospatial data types in SQL Server 2008 : geometry and geography. This support is further extended with Reporting Services 2008 R2 […]

Data Warehouse Partition Strategies

Microsoft put a great deal of effort into SQL Server 2005 and 2008 to ensure that that the platform it is a real Enterprise class product.  I’m not going to write about all the new features in the OLTP Engine, in this article I will focus on Database Partitioning and provide a real world scenario.  This article will cover the following […]

Tweaks in SQL Server Reporting Services

SQL Server Reporting Services (SSRS) is very valuable tool for developers and users to design and view reports. However, there are few features which are not available directly in SSRS. These features are frequently required features for developers and users. Display Server Name or IP Address in a Report Often users will be mislead with […]

Enhancing Reporting Services with Dundas Reporting Controls

Introduction In SQL Server Reporting Services (SSRS) 2005, you have controls like the Textbox, Table, Matrix and Chart to display data.  In the case of SSRS 2008, you have additional controls like the Gauge and Tablix. Now here comes the million dollar questions - Are you satisfied with the available controls in SSRS?  Do you think that you […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |