SqlServer-QA.net

Another tool within BI platform to use when you have the huge farm of Analysis Services data warehousing & mining database setup at your end. So the provision of BI within SQL Server 2005 is a complete enterprise-ready and scalable data warehouse platform you can set, with the  features and functionality you need to ...

When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as:  [Id]  INT (make this primary key clustered), [Unit_Id]  UNIQUEIDENTIFIER, [EventType_Id]   ...

So far the SQL Server 2008 Analysis Services new features were included until October CTP, top features that Microsoft would like to include within RTM version: New Aggregation designer - to browse and modify aggregation designs that are now shown grouped by measure group. Simplified and enhanced Aggregation Design and Usage-Based ...

One of the [SSP] forum user asked about what is OLAP, how the process flow occurrs when update happens to a fact table! It sounds like the basic question for Analysis Services user, OLAP - On-Line Analytical Processing for BI - Business Intelligence is useful for a fast and interactive access to aggregated data and the ability to drill ...

Business Intelligence (BI) - is the new term from Microsoft for all Data Warehousing & Data Mining requirement since the SQL Server 2005 version is released. Say many organization face challenges with the Data Explode, this BI offers management and development tools for IT department and Business segment within your organization with ...

Got this update from SQLCAT blog on MSDN about new whitepaper on Analysis Services many-to-many dimensions that helps in MDX query performance  optimization steps you need to take care. Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great ...

Business Intelligence & Application Platform Virtual Conference Thursday, October 4, 2007 - Online Event Learn How IT Can Drive Business Solutions Is your IT organization in lock step with your business leaders? To stay competitive, IT leaders are now required to take a primary role in delivering business value. Learn how Microsoft's ...

Microsoft released PerformancePoint Server’s LAST Community Technical Preview (CTP) before launch!  To date, the CTP program has gathered close to 10,000 members and the product has been enjoying fantastic pre-launch press and analyst coverage.  For more information refer to ThePremiers blog. This is much exciting news for ...

If you would like to share your experience in managing Business Intelligence products and applications that are used in business/corporate/enterprise performance management, as a whole it is called OLAP. This survey is to help in identifying the trends and issues in BI market, ''The BI Survey'' company is behind this survey and referred to answer ...

I don't mean to say physically, but managing and mastering your data . THE ROLE OF DATA WAREHOUSING IN BI STRATEGIESWe know all to well that information is King.  But simply managing that data is not enough.  During this on-demand program our experts will present an enterprise class data warehouse platform that enables businesses to ...