Browse by Tags

SQL Server BI and Performance Point Server 2007 - good match

Published 13 March 8 5:10 AM | SSQA.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...

Filed under: sql server, management, webcast, bi, tools, reporting services, elearning, performancepoint, business intelligence, 2007, training, office

SQL Server 2005 Partitioned Tables and Indexes - learning curve

Published 12 March 8 3:1 AM | SSQA.net

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...

Filed under: sql server, performance, indexes, data, backup, bi, database, statistics, partition, monitoring, strategy, data warehouse

SQL Server 2008 BI enahncements - what you want is what you get!

Published 25 February 8 2:49 PM | SSQA.net

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...

Filed under: sql server, performance, ssis, bi, ssrs, 2008, new, reporting services, enhancement, samples, business intelligence, integration services

SQL Server OLAP - back to basics for Cube access from front-end application?

Published 11 February 8 3:38 AM | SSQA.net

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...

Filed under: sql server, technet, bi, olap, dimension, table, whitepaper, cube, business intelligence, architecture, fact, what if

What is Business Intelligence? How to obtain complete tools suite to test?

Published 8 February 8 12:11 PM | SSQA.net

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...

Filed under: sql server, management, microsoft, bi, data mining, labs, development, testing, business intelligence, links, operation guide

New whitepaper available on Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques

Published 2 January 8 6:36 AM | SSQA.net

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...

Filed under: sql server, performance, msdn, bi, download, optimization, whitepaper, Analysis Services, sqlcat

Business Intelligence & Application Platform Virtual Conference

Published 18 September 7 3:9 AM | SSQA.net

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...

Filed under: sql server, webcast, microsoft, bi, event, business intelligence

BI - PerformancePoint Server LAST CTP announced!

Published 16 August 7 10:32 AM | SSQA.net

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...

Filed under: sql server, performance, high availability, bi, bids, performancepoint

BI Survey - world's largest independent survey about your experience

Published 10 July 7 12:59 PM | SSQA.net

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...

Filed under: sql server, bi, ssas, olap, survey

Get smart with BI solutions

Published 15 June 7 3:33 PM | SSQA.net

I don't mean to say physically, but managing and mastering your data . THE ROLE OF DATA WAREHOUSING IN BI STRATEGIES We know all to well that information is King. But simply managing that data is not enough. During this on-demand program our experts...

Filed under: sql server, bi, solution

What we have and what we need in BI?

Published 30 May 7 5:15 AM | SSQA.net

There is no doubt that from SQL Server 2005 version onwards Business Intelligence (BI) solutions has been better as compared to the previous versions. Still it is interested to know what is the Microsoft's strategy on the expansion of BI. Having the...

Filed under: sql server, integration, ssis, bi, ssas, ssrs, business, intelligence

Data explosion and attributes in BI

Published 10 May 7 8:4 AM | SqlServer-QA.net (SSQA)

One of our Business Manager has asked can we handle the data explosion and BI requirement to handle billions of rows for their Sales pitch using SQL Server Analysis Servers. The obvious answer was 'yes' using the latest version of SQL Server and...

Filed under: sql server, analysis, integration, ssis, bi, ssas, attributes, business