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