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….
Month: July 2014
CHENNAI 21st to 22nd Aug
Quick stop over at Chennai to train MSBI professional on SSIS for a Multi-Billion $ US tech Firm
MUMBAI 18th Aug to 20th Aug
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.
Training CTS DBAs on MS SQL 2012
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.
MS SQL Server 2014 to Cloud Backups – Part 1
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…
SSAS: – Dimension Hierarchies
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…
SSAS: Working with Dimensions, what is a dimension?
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…
SSAS: Working with Dimensions, what is a dimension?
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…
SSAS: Securing Analysis Services Part 3
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…
SSAS: Securing Analysis Services Part 3
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…
SSAS: – Securing Analysis Services – Part 2
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…
SSAS: – Securing Analysis Services – Part 2
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…
SSAS: Processing Options
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…
SSAS: Processing Options
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…