Browse by Tags

Pivot table connectivity to SQL Server Analysis Services - security gotchas

Security permissions in OLAP is similar to normal OLTP based environment. Say if you are using Pivot Table object in MS Office Excel to display the reports using OLAP objects like Cubes. To achieve this it should connect to an OLAP Server and database to fetch the data. As per the configuration when...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 03-14-2008
Data Warehouse Scalability Features in SQL Server 2008

By now you might be aware or have gone through the web resources and conferences about what's new within SQL Server 2008 version, one thing is sure scalability for your database platform. Though there isn't a real-time data warehouse implementation within my work place, I have browsing through the Technet...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 03-07-2008
Scale-Out Querying with Analysis Services Using SAN Snapshots

Hi Here is a new document from the SQL CAT team: Summary : This SQL Server Best Practices white paper describes the use of virtual copy SAN snapshots in a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services to increase the number of concurrent queries to Analysis...

Posted to The Premiers (Weblog) by ThePremiers on 09-17-2007

Page 1 of 1 (3 items)

SQL Server Community Blogs