By Markus Ehrenmüller-Jensen on Wednesday, March 03, 2010

Die Big>Days 2010 kommen ...

... immer näher (http://www.microsoft.com/austria/events/bigdays2010/). Sind Sie schon angemeldet?

Ich darf heuer gemeinsam mit Martin Pöckl (Microsoft) einen Vortrag zum Thema Mit BI-Lösungen Daten entscheidungsgerecht aufbereiten" halten und aus der Beschreibung zitieren:
"BI ist nicht mehr die Elitedisziplin, die von einigen wenigen im Unternehmen praktiziert wird: Stellen Sie sich vor, die Endanwender könnten in der vertrauten Office-Oberfläche ihre Berichte und Analysen einfach und performant selbst erstellen. Sie als IT-Spezialist behalten dabei den Überblick und könne ... Read More »

By Markus Ehrenmüller-Jensen on Tuesday, June 02, 2009

Synonms are a great feature of SQL Server (introduced in version 2005). I’m using them in most of my projects for staying independent of database names (eg. when using a table stored in the staging area database in a procedure stored in the datawarehouse database).

Synonms work fine with SELECT, INSERT, UPDATE, DELETE and EXECUTE statements.

Unfortunatly this list does not contain TRUNCATE TABLE (which I prefer instead of DELETE because of performance reasons). But mixing synonyms and original names, using synonyms in some places, but original names in other places, would be a nonsens (I would get independent of database names in some places only, but not in others).

 

Here comes my workaround: Read More »

By Markus Ehrenmüller-Jensen on Monday, January 21, 2008

With one of my customers I published a ProClarity Analytics page to SQL Server 2005 Reporting Services and activated "Add a link to analyze data in ProClarity" and chose "Data from this report".

Publishing worked fine. But when following the link back to ProClarity Analytics I received an error message (within my browser): 

Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
/pas/en/src/PRSQuery.asp, line 50
Invalid class string

Research let me find out that one DLL was not registered. Registering can be done very simple through "Start - Run" the following command:

c:\windows\microsoft.net\Framework\v2.0.50727\regasm "c:\Pro ... Read More »