Browse by Tags

SQL Server Business Intelligence - handling data mining and mission critical applications

Published 22 July 8 4:31 AM | SSQA.net

Data, data and data everywhere: a typical scenario for an Enterprise DBA to handle the mission critical applications and comprehensive information across the organization using SQL Server technologies. Since the inception of SQL Server 2005 version Business...

Filed under: sql server, microsoft, data mining, learning, business intelligence, data providers

BI Virtual labs on MSDN - specific to data mining and top 10 classed in Tech-ed.

Published 26 February 8 4:45 AM | SSQA.net

As blogged here before Virtual Labs are very handy for the new users and existing professionals to test out new features without disturbing their own platform. In this scenario Microsoft events are helping the users by providing access to their virtual...

Filed under: sql server, performance, microsoft, technet, data mining, version, virtual, labs, 2005, loading

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

SQL Server Analysis Services slicing and dicing

Published 27 January 8 6:8 AM | SSQA.net

I was going through Books Online in learning the concepts of slicing of data within Analysis Services for the new project that is upcoming, all these years I have basic knowledge of SSAS and with latest available features in SQL Server 2005 Analysis Services...

Filed under: sql server, performance, data mining, 2005, Analysis Services, slicing

Monitoring the parallel processing performance of Analysis Services?

Published 8 October 7 3:8 AM | SSQA.net

The ascmd.exe command-line utility is a handy tool for testing performance characteristics to determine the appropriate values for parallel processing. This utility is similar to the sqlcmd.exe utility that you use to execute SQL statements in SQL Server...

Filed under: sql server, performance, data mining, process, tool, samples, Analysis Services, command line, parallel, ascmd

FIX: Error message when you use the Association Rules algorithm to process a data mining model in SQL Server 2005 Analysis Services: "This number of attributes exceeds the attribute limit of 5000 allowed by the current version of the algorithm"

Published 12 September 7 12:42 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Error message when you use the Association Rules algorithm to process a data mining...

Filed under: sql server, data mining, attributes, kba, Analysis Services

OLAP Design best practices for Analysis Services

Published 13 May 7 2:57 AM | SqlServer-QA.net (SSQA)

We have got best practices articles on BPA , Security , IndexOptimization for SQL 2005 (non BI) and BP(suggested) for SSIS and I was searching for similar in OLAP - Business Intelligence on Analysis Services in SQL Server 2005. Here it is, a collection...

Filed under: databases, integration, data mining, business, olap, intelligence

How to deploy a SQL database to a remote hosting environment?

Published 10 May 7 3:44 AM | SqlServer-QA.net (SSQA)

The process is easy when you have all ingredients in place (handy) without any issues on the current environment. The Database Publishing Services are a set of ASP.NET web services you can easily deploy to make it simple for your customers to deploy SQL...

Filed under: dashboard, sql server, web, deploy, data mining