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 […]
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 […]
SSAS: – Date dimension
In previous posts we have successfully created a simple cube deployed and processed it. In this post we are now going to add one of the most important […]
Taxes Arghh!!! To Ahaa…
Tax season has started and we are half though it, I usually do the accounts for my company or at least keep a close eye on what’s happening […]
SSAS: Manually processing the cube
Occasionally there may be a need to manually process the cube. This would occur when the cube design has not changed but new data has been imported into […]
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 […]
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 […]
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 […]