Sutha's SQL BI Blog

Performance Point RTM Available

Performance Point RTM is available for download. Please note this is only Evaluation version. MSDN download should be available in 2 weeks time.

http://www.microsoft.com/downloads/details.aspx?FamilyId=6372C24F-67DD-42DD-B034-748907B23420&displaylang=en

Thanks

Sutha

BI User Group

I just got back from BI User Group Evening. Mark Hill and Suranjan Som did couple of excellent presentations.

It was nice to catch up with some old buddies.

Thanks

Sutha

I am presenting at SQLBits

All

I will be presenting at SQLBits. I am presenting on how can we handle early arriving facts?

I will be around at Ask The Experts area. I will be coming along to the social event at Reading Bowl.

You can find out more at http://www.sqlbits.com/

Look forward to see you all there.

Thanks

Sutha

Not Being Able to Connect To PAS - Modify global.asa

Assign all Web Standard users to the same Active Directory domain or to a trusted domain.

•Register a Service Principal Number (SPN) in Active Directory on the computer running Analysis Services.

•On your domain controller and on all client computers, configure the Active Directory Users and Groups setting to enable Computer is Trusted for Delegation.  

•On Analytics Server, edit global.asa to enable pool.negotiateauthentication. Any servers deployed between Analytics Server and Analysis Services must also be configured so that the Active Directory setting Computer is Trusted for Delegation is enabled. 

Configure Global.asa on Analytics Server

• On the computer running Analytics Server, browse to the following directory: C:\Inetpub\wwwroot\PAS
• Using a text editor such as Notepad, open global.asa and set the method named pool.negotiateauthentication to True.
• Restart

Mark provided me this information and I am putting it here for my future reference.

Thanks

Sutha

Enable Kerberos Event logging

If you had issues with Kerberos and wanted to see where things are going wrong you can enable a registry setting, This setting wouldnt even need re-boot.

http://support.microsoft.com/kb/262177/

Thanks

Sutha 

Cumulative update package 3 for SQL Server 2005 Service Pack 2

There is a new hotfix available for SQL Server 2005 SP2. There are number of fixes in this.

http://support.microsoft.com/kb/939537/

This is not publicly available. You would need to subit a request and you will get a reply within few hours stating the location and password where you can download the cumulative package.

Thanks

Sutha

SQL Server 2005 Performance Dashboard Reports

If you have come across performance issues in SQL Server 2005, you might find this useful.

http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

Thanks

Sutha

MDX Studio

Take a look. It looks quite powerful. I hope this will be part of Katmai release.

http://sqlblog.com/blogs/mosha/archive/2007/09/18/announcing-mdx-studio-ctp1-v0-1-alpha.aspx 

Thanks

Sutha

Looking For Jobs

Edenbrook is looking for people all the time. Specially in SQL Server BI Stack. If you think you are good at SSIS / SSAS / SSRS please get in touch with me immediately. Edenbrook offers a very good salary (depending on experience) along with 25 days holidays as well as other benefits. You dont have to be an expert all the products (in otherwords you can just be an MDX expert, we are interested in you). We are also looking for people with Oracle / BizTalk skills.

Thanks

Sutha

The XML page cannot be displayed due to £ sign

I came across something simple and annoying earlier this week.

I had XML file as source with a string called "Room Hire £200". For one reason or the other I couldn't load the file via SSIS. I couldn't see anything wrong with the file. I try to open the file via Internet Explorer and I got the following error message.

 Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh <BLOCKED SCRIPTlocation.reload()>  button, or try again later.

            An invalid character was found in text content. Error processing resource ‘file:///C:/MAB/SourceFiles/Micros/EmReferencedat...

 

            <MenuItemName>Room Hire

To fix this problem I had to put the following statement on top of the XML document.

<?xml version="1.0" encoding="Windows-1252"?>

Ref - http://discuss.joelonsoftware.com/default.asp?joel.3.394399.24 

Thanks

Sutha