Thursday, December 30, 2010

SSAS: Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))

Today, I've no idea what happend to my SSAS suddenly!! but I got that nasty error while browsing one of my cubes.
Searched it down and found that you'll need to re-install the 'office 2003 web components' Although I'm using Office 2010 for the last 2 Months.
Also if you have time, please read that... will explain more Office Web Components “Roadmap”

Thursday, December 23, 2010

Server Explorer not showing up on Visual Studio 2008

VS 2008 is acting up lately on me! nothing happens when you click on "server explorer" from the VIEW menu, or press "Ctrl + Alt + S".

The fix is to open a Visual Studio Command Prompt  and run  devenv /resetsettings or devenv /setup

Friday, December 17, 2010

How to Setup Row-Level Security for SQL Server - Linked Article

Before I used to do it through several 'Views' and grant different permissions to each View, but recently I came across this good article by K. Brian Kelley....
How to Setup Row-Level Security for SQL Server

Friday, December 3, 2010

T-SQL Display Month Numbers and Names

SELECT Number + 1 as [Month Number],
DateName(mm,DATEADD(mm,Number,0)) as [Month Name]
FROM master..spt_values
WHERE Type = 'P' and Number < 12