Consultant & Trainer for all things MSSQL
Its brand new and shiny, our updated blog features a whole new layout and easier to navigate menu and blog posts. After doing a fair amount of review on our previous site in terms of traffic and other factors we identified our Blog had a few issues in terms in usability and layout / appearance….
Quick stop over at Chennai to train MSBI professional on SSIS for a Multi-Billion $ US tech Firm
Training DBAs in Mumbai on MS SQL Server 2012 HA. Visiting the city after a short while hope to do more sightseeing this time around.
To kick off a new category on upcoming events I guess there could be no better way than to be at Chennai from the 11th to 15th Aug. I will be at the CTS main office in MPEZ. Look forward to meeting all my previous trainees.
In this series of blog posts the focus is going to be on the MS SQL Server 2014 Cloud backups feature. Most companies will easily be able to see the advantages of the above mentioned solution but we are still going to cover the merits of this now. The official MS stated benefits include:- Limitless storage…
All that is necessary for the triumph of evil is that good men do nothing. – Edmund Burke The darkest places in hell are reserved for those who maintain their neutrality in times of moral crisis. – Dante Alighieri This blog is a call to action. If the above two phrases has some resonance with…
Most of the time there will be a relationship between different attributes in the dimension. We saw an example of this kind when we created the date dimension in the previous post. In particular this kind of relationship was a parent child relationship or a hierarchy between Years to Month to Week to Day. Such…
In this post we now create our first dimension. A dimension is the data on which the question is being asked. The purpose of the cube is to answer questions hence the terms Business intelligence or Decision Support. A typical question that might be asked of a cube is “What are the top selling products…
In this post we now create our first dimension. A dimension is the data on which the question is being asked. The purpose of the cube is to answer questions hence the terms Business intelligence or Decision Support. A typical question that might be asked of a cube is “What are the top selling products…
Having created a server admin and a database admin we now need to add a business user who will have permissions on very specific aspects of the cube. This is important because most cubes within large organizations will contain information that is of a sensitive nature. As a result we need a mechanism by which…
Having created a server admin and a database admin we now need to add a business user who will have permissions on very specific aspects of the cube. This is important because most cubes within large organizations will contain information that is of a sensitive nature. As a result we need a mechanism by which…
In the previous posts we added a server level administrator to Analysis services. This administrator was able to make changes to server settings and also make changes to any database hosted on the server. Now we need to create a database admin. The idea with the database admin is to create someone who is similar…
In the previous posts we added a server level administrator to Analysis services. This administrator was able to make changes to server settings and also make changes to any database hosted on the server. Now we need to create a database admin. The idea with the database admin is to create someone who is similar…
In previous posts we have already covered why processing the cube is important, in this post we look at the various processing options available within Analysis Services. The below table has been reference from the MSDN website and neatly outlines the different options and the scenarios in which they are applicable. Usually process default works…
In previous posts we have already covered why processing the cube is important, in this post we look at the various processing options available within Analysis Services. The below table has been reference from the MSDN website and neatly outlines the different options and the scenarios in which they are applicable. Usually process default works…