Consultant & Trainer for all things MSSQL
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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 database on this instance. Please keep in mind that because SQL Server express edition doesn’t have a SQL Server agent you cannot have this instance setup as…
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 it is responsible to ensure that all publishers and subscribers are in sync. It plays a pivotal role in identifying the changes that have occurred in the…
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…