Monthly Archives: April 2014

Forcing Innovation

By | April 29, 2014

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… Read More »

Downloading the SQL 2014 product guide

By | April 20, 2014

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… Read More »

SQL 2014 licensing

By | April 15, 2014

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… Read More »

SQL 2014 Series

By | April 14, 2014

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… Read More »

Whose money is it?

By | April 7, 2014

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… Read More »

SSRS Sorting data within a Report

By | April 2, 2014

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… Read More »

SSRS Reports not rendering beyond 90 seconds

By | April 2, 2014

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… Read More »