Sutha's SQL BI Blog

Performance Point 2007 Documentation

All

You can download the following Documentations from Technet site.

• PerformancePoint Server 2007 Planning & Architecture Guide
• PerformancePoint Server Operations Guide
• Deployment Guide for PerformancePoint Server 2007

Thanks

Sutha

SQL Server Beta

All

Most of you probably know this. I just found out about this site. If you want to play with SQL Server 2008 you can do it here at SqlServerBeta. It is totally free, you just need to sign-up and you would get 100MB database space. It will give you your own space to play with.

Keep an eye out for MDM area on the same page or check out SQLPass website. It should appear soon, where you can test and play with Microsoft's new MDM solution.

Thanks

Sutha

Presenting again at SQLBits

I am presenting on Microsoft's Master Data Management (MDM) at SQLBits.

Thank you for all voted for my session.

See you all there.

Thanks

Sutha

Data Profiling

I am very pleased to see Data Profiling Task is going to be part of SQL2008. I have been requesting this task since SQL 2005 TAP programme when I was at Reuters.

You can read all about Data Profiling Task here.

Another feature I would like to see and have requested in the past is Dependancy Analysis Graphical Tool, which will tell me what would the impact on the whole project if I delete a column x from the ETL. In otherwords, which tables, views, stored procedures, packages, cubes and reports are affected by this change. I know there is an add-on available which allows us to do Dependancy Analysis. This was shipped as part of SQL Server 2005 Business Intelligence Metadata Samples Toolkit.

Does anyone agrees with me or not?

Thanks

Sutha

What's new in SQL Server 2008 for SSIS - Part2

What's new in SQL Server 2008 for SSIS - Part1

http://blogs.msdn.com/mattm/archive/2008/01/10/what-s-new-in-sql-server-2008-for-ssis-part-one.aspx

Thanks

Sutha

SQLBits II

Most of you know that I am not a regular blogger. Since first SQLBits presentation I haven't updated my blog. Guess what, second one is around the corner.

You can get more information here.

I have submitted a session on Master Data Management (MDM). Hopefully the product will be available soon on TAP. Microsoft suppose to release the product end of last year. I hope they will release it soon.

There are over 35 sessions submitted and please vote for the topics you would like to see most.

You can vote now at http://www.sqlbits.com/information/PublicSessions.aspx

Thanks

Sutha

Thank You For Attending SQLBits

Thank you for all of you who turned up today for SQLBits. It has been well organised and well run, thanks to Tony, Simon, Martin & Chris.

Thank you for all of you who attended my session on Early Arriving Facts. It was a reasonable turnout for a Saturday morning 09:30.

Slide deck and demo will be posted on SQLBits website.

If you have any queries please do not hesitate to contact me.

Looking forward to the next year SQLBits already!

Thanks

Sutha

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