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. […]
Querying SQL Azure database from online portal using the Manage URL
Occasionally you might want to quickly execute a query or run a few scripts on your Azure database without actually connecting from Management studio. For example when you’re […]
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 AlwaysOn Part 2 AlwaysOn […]
Creating a Network and Domain in Windows Server
This blog covers creating a simple domain in order to setup a windows failover cluster. The intention here is not to cover the details of setting up an […]
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 […]