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 […]
Popular Posts
Trending Posts
Converting times across time zones
SQL 2025 Optimized locking in SQL2025
You Can’t Be King till You’ve Killed Someone
Fuzzy String matches in TSQL
Recent Posts
Editors Choice
Converting times across time zones
SQL 2025 Optimized locking in SQL2025
You Can’t Be King till You’ve Killed Someone
Fuzzy String matches in TSQL
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 […]
Whose money is it?
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 […]