A perspective is a very useful feature within SSAS as it allows the designer to mask the underlying complexity of the cube based on the user. The perspective […]
SSAS: browsing the cube
With the cube processed we are now ready to browse or query the cube to fetch some data from it. There are many way of doing this; the […]
SSAS: – Defining a measure
Now that the dimension has been defined we need to add a measure to our cube in order to be able to answer the question “What is distribution […]
SSAS: – Define translation
In previous posts we explored the properties of a cube and some basic tasks that we would need to perform as part of creating and managing a cube. […]
Connecting to a Azure database from SSMS and how to configure database level Firewall
So you finally have an Azure database, but how do you connect to it? Surprisingly simple actually, you can access your database remotely from within SSMS so for […]
Creating a SQL Azure Server and Database
Have you ever wondered how to create a SQL Server and then a Database within the server that is managed within the Microsoft PaaS cloud know as Windows […]
Video on Always ON Part 1, 2 and 3
I just realized I have not uploaded links to some of my older videos so here is a list of videos AlwaysOn Part 1 http://youtu.be/JrV9o2fXuPI AlwaysOn Part 2 […]
Create a 5 star rating indicator using SSRS
Today we are going to create a 5 star rating indicator in SSRS. Indicators are available in SQL Server 2008 R2 and above and provide a quick way […]
MSBI at the Airport
I was recently at Bangalore International Airport and while waiting for a flight was looking for a way to pass the time. I noticed there is an fnb […]
Changing the background colour for a Cell in SSRS conditionally
In this blog we look at how to change the background colour for a cell in SSRS using IIF conditional logic. He below screenshot shows a table with […]