Sql Server 2008 & MSBI 2008 - **Features &Enhancements**

Hi,
In Sql server 2008 and especially in BI enhancements are beautiful and nice.
They mainly focused on robust, security and Performance.
Nice articles are here.
http://sqlcat.com/top10lists/archive/2009/01/30/top-10-sql-server-2008-features-for-the-database-administrator-dba.aspx
http://www.mssqltips.com/tip.asp?tip=1313
Regards,
Ravindra

SSAS-Videos

Hi Guys,
Here are the video url’s from Microsoft.
· SSAS-info Webcasts
· Craig Utley's videos for SSAS Beginners - registration is free
· Creating an Analysis Services Project
· Defining and Deploying a Cube
· Modifying Measures, Attributes and Dimensions
· Implementing Best Practices for Large Analysis Services Databases – Part I
· Create and Publish a Data Cube for SQL Server Analysis Services 2008
· Viewing Analysis Services Data in Excel 2007 – SQL School Video
~Ravindra

SSAS-Videos

Hi Guys,
Here are the video url’s from Microsoft.
· SSAS-info Webcasts
· Craig Utley's videos for SSAS Beginners - registration is free
· Creating an Analysis Services Project
· Defining and Deploying a Cube
· Modifying Measures, Attributes and Dimensions
· Implementing Best Practices for Large Analysis Services Databases – Part I
· Create and Publish a Data Cube for SQL Server Analysis Services 2008
· Viewing Analysis Services Data in Excel 2007 – SQL School Video
~Ravindra

SSRS Issue with IE8-Workaround

Hi All,
We faced a issue SSRS report with ie8 like, “page number footer missing”.
Here is the nice blog and corresponding -workaround links.
http://blog.mgallen.com/?p=338
I hope it might helps you.
~Ravindra

SSRS Issue with IE8-Workaround

Hi All,
We faced a issue SSRS report with ie8 like, “page number footer missing”.
Here is the nice blog and corresponding -workaround links.
http://blog.mgallen.com/?p=338
I hope it might helps you.
~Ravindra

SSRS Issue with IE8-Workaround

Hi All,
We faced a issue SSRS report with ie8 like, “page number footer missing”.
Here is the nice blog and corresponding -workaround links.
http://blog.mgallen.com/?p=338
I hope it might helps you.
~Ravindra

SQL Server Data Warehouse basics

Hi Guys,
Before going to start any datawarehouse project, every developer should know the below basic concepts on datawarehouse with Sql Server.
It’s really nice article from Robert Scheldon.
Pls go thru this.the below topics are covered in the post.
· The Data Warehouse
· Data Warehouse vs. Data Mart
· Relational Database vs. Dimensional Database
· Dimensional Database vs. Multidimensional Database
· The Data Model
· The Star Schema.
· The Snowflake Schema
· The Star Schema vs. the Snowflake Schema.
· The Fact Table
· The Dimension
· The Surrogate Key
· The Date Dimension
· The Slowly Changing Dimension.
· The Data
~Ravindra
http://www.simple-talk.com/sql/learn-sql-server/sql-server-data-warehouse-cribsheet/

Basic Steps for Implementing an Analysis Services Database

Hi Friendz,
To achieve OLAP requirement, we have multiple tools in the competitive world, MS-OLAP tool is one of the best one.
Here I am sharing some details from Robert Scheldon blog about to know basic stuff on how to implement OLAP DB by using SSAS.
Nice one.
~Ravindra
http://www.simple-talk.com/sql/reporting-services/five-basic-steps-for-implementing-an-analysis-services-database/

I Passed **70-448** Exam

Hi Friendz,
I am happy to share the news with you about-i passed the 'MCTS 70-448' exam.
Here are the details about the exam.
http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-448&locale=en-us
Regards,
Ravindra

I Passed **70-448** Exam