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…
Month: April 2014
How much is your vote worth?
Today we are a bit off topic from our usual technical blogs and the reason is because there are elections going on in India. The elections in Karnataka concluded a few days back and the turnout was poor. The reason for this is not because there is a shortage of educated socially aware individuals in…
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 covers…
Installing SQL Server 2014
Today we are going to look at the different steps involved in installing SQL Server 2014. The important thing to keep in mind here is that while the steps are the same as that used for SQL 2012 , we still need to pay attention to why we select certain options at different stages. While…
Downloading SQL 2014
In this part of the series we are going over the step by step how to download MS SQL Server 2014. You can download the trail version of MS SQL server 2014 here. The link provides a download of the trail version of MS SQL Server 2014 which is valid and fully functional equivalent of…
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…
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 to get rid of this behaviour and try and render the report within the single page try changing the report layout to landscape mode by doing the…
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…