|
|
-
|
|
Hello dear readers,
After a year and half of writing I have finally decided to stick to blogging. I realized that I really enjoy it. It’s a great way to express my self about the technology areas I am most passionate about. So it was time to take the...
|
|
-
|
|
There is a MEET Windows Azure event organized in San Francisco, on June 7th 2012 1 PM PST/10 PM CET. This event will also be streamed live so anyone can attend this. It’s none other than Scott Guthrie and his Azure Team who will introduce the cloud based d...
|
|
-
|
|
In a data warehouse system there can be multiple star schemas addressing differing business processes because it is difficult to find a subject area that can be fully described by a single fact table. In almost every practical application, multiple fact ta...
|
|
-
|
|
Ever wondered how does a start schema really work? I did, when I was new to BI and Data warehousing. It is really important to understand how a star schema is actually used. The basic understanding allows a dimensional designer to make intelligent choices....
|
|
-
|
|
This post is in continuation to my MDX techniques series. To continue further, it is important to understand the difference between NonEmpty() function and NON EMPTY keyword as we would be using them a lot in the future.
Both the NonEmpty() function and N...
|
|
-
|
|
I have thought of putting together some of my favorite MDX tricks for a while now. Here is the first set of some basic tricks. All of the code examples have been tested on SQL Server 2008 R2 Analysis Services and on Adventure Works DW 2008 R2 sample databa...
|
|
-
|
|
As almost everyone out there is aware of the launch of SQL Server 2012 last week. Along with the launch Microsoft announced xVelocity in-memory technologies. This is an umbrella name for all the in-memory technologies. This includes re-branding of the Vert...
|
|
-
|
|
Thank you #SQLPASSBIVC for having me and thank you to everyone who attended my SQL Azure Reporting session today on the SQLPASS Business Intelligence Virtual Chapter.
The sample databases that I referred to during the presentation can be downloaded from SQ...
|
|
-
|
|
This is a very quick post about installing the Azure SDK. If you are trying to install the Azure SDK using the Microsoft Web Platform Installer and have run into an error that says that the following four dependencies could not be installed.
IIS: HTTP Red...
|
|
-
|
|
I am getting back to continuing writing on SQL Server 2012 – Tabular Projects. A series that I started back in September 2011 and then dropped off. If you are new to Tabular Projects I encourage you to read my earlier posts about them here.
This blo...
|
|