Recently I was faced with a challenge most people might face at least 1 or 2 in their life time. While in most cases the result is expected […]
SSRS Sorting data within a Report
Sometimes when we create reports we define the sort order of the data within the report itself. This allows the user to pick and choose data based on […]
SSRS Reports not rendering beyond 90 seconds
Today I came across an interesting problem with SSRS and ASP.Net. I usually have all my reports optimized to run quickly, this includes creating snapshots revisiting indexes etc. […]
Displaying a report in Landscape mode when exporting to PDF
Often the report doesn’t fit within the boundaries of the page and these results in part of a tale being moved to the next page. When you want […]
Drill through Reports
In the below report we are fetching the column that are present within a particular table by Entering the table name as an Input parameter. This works fine […]
SQL Server Replication Series: – Server is not configured as a distributor.
When setting up a distribution database using the wizard, if you select the second radio button from the below screen you need to already have configured the distribution […]
SQL Server Replication Series: – Configuring the distributor
In this blog we will look at how to configure the distribution database for SQL Server replication. The distribution database is a very important database in replication as […]
SQL Server Replication Series: – Removing Replication
Most times we do not remove replication from a server once it’s been setup but there are occasional scenarios where it may be required. E.g. when decommissioning a […]
Key columns and the clustered index
I was recently asked if there was any importance of the primary key clustered index in terms of performance. While the answer is obvious I wanted to explore […]
Network connectivity issues AWS SQL Express instance
Amazon is one of the premier cloud solutions providers out there and they offer development houses a number of solutions and features that cater to almost any requirement […]