Forcing Innovation

Yes you read it right. Today we are discussing the approach I have seen in some companies where they try to force innovation. As you will soon realize I am against it. The thing about innovation is that you shouldn’t try too hard. The best innovations or discoveries happen at the most unexpected times and…

Downloading the SQL 2014 product guide

Today we are going to do a quick post on where you can download the SQL 2104 product guide. http://www.microsoft.com/en-in/download/details.aspx?id=39269   The above link takes you directly to the download file. Once downloaded you need to extract the zip file. You will notice the content is not as extensive as that for 2012 but it…

SQL 2014 licensing

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 overall project. But over the years these costs have been increasing more importantly the options have been decreasing as well. Like with SQL 2012 we still have…

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 changes compared to how we used to do things in previous versions. But first things first, what is actually new and features to look out for? Memory-Optimized…

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 in this case it couldn’t follow the traditional approach for obvious reasons. So what am I talking about? I was on my way to the bank a…

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 the sort order that make most sense when viewing the data. Notice how the second column ( which is the column order or position of the column…

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. However for one of my clients the data is huge and we were using OLTP systems so query response times were still not great especially when it…

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 if all we are interested in is this report. What if we want to first start at a higher level such as the tables that belong to…

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 server or changing the high availability plan for a particular database server. Removing replication is much easier than setting it up and can be done within a…