Browse by Tags

• 2005
• Analysis Services
• ascmd
• bi
• business
• business intelligence
• command line
• data providers
• databases
• development
• integration
• intelligence
• labs
• learning
• links
• loading
• management
• microsoft
• olap
• operation guide
• parallel
• performance
• process
• samples
• slicing
• sql server
• technet
• testing
• tool
• version
• virtual

SQL Server Business Intelligence - handling data mining and mission critical applications
22 July 08 02:31 AM | SQL Master | 2 Comments   

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

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

BI Virtual labs on MSDN - specific to data mining and top 10 classed in Tech-ed.
26 February 08 03:45 AM | SQL Master | 2 Comments   

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

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

What is Business Intelligence? How to obtain complete tools suite to test?
08 February 08 11:11 AM | SQL Master | 2 Comments   

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

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

SQL Server Analysis Services slicing and dicing
27 January 08 05:08 AM | SQL Master | 3 Comments   

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

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

Monitoring the parallel processing performance of Analysis Services?
08 October 07 01:08 AM | SQL Master | 2 Comments   

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

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

OLAP Design best practices for Analysis Services
13 May 07 12:57 AM | SQL Master | 1 Comments   

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

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