ADA ICT blogs

The blog has moved

Kasper de Jonge — 2009-02-06 08:59:00

This blog has moved to our new blog engine at: http://business-inteligence.kdejonge.net/. Those of you who are subscribed to my RSS wont have to do a thing, thats automaticly updated.

Using UserName to Control Data Access and Default Member in SSAS

Kasper de Jonge — 2009-02-04 17:14:00

A great sample from MS on how to use the UserName function to restrict data access and control the default member in SSAS, great stuff:

http://www.sqlserveranalysisservices.com/OLAPPapers/UsingUserNametoControlDataAccessandDefaultMemberinSSAS.htm

I wish the Real world was as easy :)

Adding "Runas" back into Vista and Windows 2008

Kasper de Jonge — 2009-02-04 17:07:00

When testing security in SharePoint/Reporting Services you want to run IE as another user, I run my laptop and VM's on Windos Server 2008, the runas feature has disappeared from this release. But SysInternals has a tool who puts the “Run as different user…” option back into the context menu for applications.

You can download the tool from HERE, (which comes as a ZIP file containing the EXE and a licensing agreement), and run the exe from an “administrator” command window like this…

Shellrunas.exe /reg

Found this tip here:
http://blogs.msdn.com/normbi/archive/2008/04/26/adding-runas-back-into-vista-and-windows-2008.aspx

PerformancePoint KPI's under the hood

Kasper de Jonge — 2009-02-03 17:10:00

While playing with PerformancePoint Monitoring I found some great blog posts that show you how the KPI's in PerformancePoint monitoring are calculated and rollups are influenced:

Times are Tough, BI Still #1 Priority for CIOs

Kasper de Jonge — 2009-02-02 10:26:00

Gartner reports that BI is the number 1 technology spending priority for CIO’s for the fourth year in a row. This in combination with flat IT spending in 2009 means CIO’s will be looking to get more “bang for their buck” and extend existing technology investments for BI.

Lower the total cost of technology is also a very hot topic at the moment and in 2009 CIO’s will look to take steps to make a more efficient technology spend. Some additional areas that are highlighted in the report include:

Modernize the technical infrastructure, as new technologies offer lower cost
Use less energy
Deliver better performance and provide greater capacity

The CIOs surveyed represent more than $138 billion in corporate and public-sector IT spending, encompassing 1,527 enterprises across 48 countries and 30 industries.

Read the enrire report here:

http://www.gartner.com/it/page.jsp?id=855612

Top 10 SQL Server 2008 Features for the Database Administrator (DBA)

Kasper de Jonge — 2009-02-02 09:18:00

SQLCat has a great post for you DBA's out there. The top 10 SQL Server 2008 features which help the DBA do their day to day task.

Read them all here:

http://sqlcat.com/top10lists/archive/2009/01/30/top-10-sql-server-2008-features-for-the-database-administrator-dba.aspx

Blog URL changed

Roel van Lisdonk — 2009-01-30 09:28:13

This blog will be ported to http://roelvanlisdonk.wordpress.com/

Save not permitted in SQL Server 2008 - Management Studio

Kasper de Jonge — 2009-01-28 16:11:00

For those who work with SQL Server 2008, you probably got this message, when trying to change the columns in some tables, add columns or change nullity conditions. "Save is not permitted"... and something like tables have to be dropped and re-created. The only choice you have is to click cancel, or to choose to save the message to a text file.

The solution i found today is in SQL Books Online, and it is pretty easy:
Tools -> Options -> Designers, and uncheck the option "Prevent saving changes that require table re-creation".

Microsoft Brings Business Intelligence to the Masses With SharePoint

Kasper de Jonge — 2009-01-28 09:32:00

More news about Performance Point from Microsoft. Microsoft has posted a short Q&A with the Senior VP of Office Business Platform Group at Microsoft . The interview gives some insight into the strategy announcement, why Microsoft made this decision, how planning customer will be supported and what the overall benefit to customers will be.

Read it here:

http://www.microsoft.com/presspass/features/2009/jan09/01-27KurtDelbeneQA.mspx

While it doesn't shed light on how they are going to replace the proclarity Desktop it clearly states the reason for the big change:

"We frequently sum up our mission as bringing “BI to the masses.” Incorporating Office PerformancePoint Server 2007 features into Office SharePoint Server helps us fulfill that mission and sets us apart from many of the BI vendors that require the purchase of specialized applications. "

Microsoft Business Intelligence strategy update and SharePoint

Kasper de Jonge — 2009-01-26 15:24:00

Ok for those of you who missed it last weekend, MS has changed the Performance Point strategy 180 degrees. From now on. Quote: "As part of this vision, and feedback from a wide variety of customers, PerformancePoint scorecarding and dashboarding capabilities will now become part of SharePoint Enterprise CAL and available to customers who are on SharePoint SA. This means that customers who want to deploy PerformancePoint can do so today at no additional cost. "

http://blogs.msdn.com/bi/archive/2009/01/23/microsoft-bi-strategy-update.aspx

But they sacrifice PPS Planning, it wil not be further developed. I think it’s a smart move, most MS enterprises will have MOSS so they will get instantly acces to All those great Performance management tools.

Some more insight on other blogs:

http://performancepointblog.com/2009/01/my-thoughts-on-performancepoint-planning%e2%80%99s-sunset/

http://cwebbbi.spaces.live.com/Blog/cns!7B84B0F2C239489A!4133.entry

http://nlbi.blogspot.com/2009/01/microsoft-bi-strategy-update.html

http://www.olapreport.com/Comment_Bizdemise.htm