As with any installation of SQL server we start with the licensing of SQL Server 2014. Most DBAs are unaware of the implications of licensing costs on the […]
SQL 2014 Series
Starting today we are launching a new series on topics related to SQL Server 2014. Free videos and tutorials on key new features as well as some interesting […]
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 […]