Browse by Tags

All Tags » sql server   (RSS)
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...
Analysis Service error: Either the user, Domain\User, does not have access to the Database Name database, or the database does not exist.
10 July 08 01:02 AM | SQL Master | 2 Comments   
As it seems the error text on the subject looks familiar when you have installed SQL Server or working with SQL Server databases. How about getting the error on Analysis Services databases (OLAP) within your BI Platform. So in the case of handling the Read More...
EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.
27 May 08 01:48 AM | SQL Master | 2 Comments   
Granting permissions to relevant account is a required criteria within the SQL Server databases management, for this even Reporting Services is not exceptional. As per the configuration by default the users connect to the report server by using their Read More...
SQL Server Reporting Services: Resources and information - all in one place
13 May 08 01:30 AM | SQL Master | 2 Comments   
During a conference few users asked about resources and information to go through the Reporting Services, as it is a general assumption from the end-user community that referring to Books Online aka BOL doesn't get them anywhere. I always recommend to Read More...
SQL Server Business Intelligence - adopt sustainable practices on ETL processes with SSIS
24 April 08 04:14 AM | SQL Master | 2 Comments   
Making best use of SQL Server Integration Services within your ETL processes is a flexible choice, which has a huge share within the Business Intelligence application platform. You may be aware that SSIS introduces several new and enhanced features and Read More...
SQL Server BI and Performance Point Server 2007 - good match
13 March 08 03:10 AM | SQL Master | 2 Comments   
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 Read More...
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...
SQL Server 2008 BI enahncements - what you want is what you get!
25 February 08 01:49 PM | SQL Master | 2 Comments   
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 Read More...
SQL Server 2005 BI evaluate and diagnose Analysis Services database performance
18 February 08 02:57 AM | SQL Master | 3 Comments   
Performance - one word does it all! You are aware that during the Performance Tuning exercise there are few quick wins within the SQL Server Relational Database Engine such as table statistics for data and indexes. When it comes to Analysis Services (BI) Read More...
SQL Server OLAP - back to basics for Cube access from front-end application?
11 February 08 02:38 AM | SQL Master | 3 Comments   
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 Read More...
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...
SQL Server Analysis Services MDX Query performance monitoring - highlights
29 January 08 02:27 AM | SQL Master | 5 Comments   
When it comes to monitor the query performance whether it is TSQL or MDX, the process is similar. You need to have a better understanding on how queries are executed (architecture), what tools are available for monitoring and best practices to improve Read More...
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...
New whitepaper available on Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
03 January 08 10:36 AM | SQL Master | 2 Comments   
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 Read More...
Backup and Restore of Analysis Services Database - gotchas
12 December 07 02:38 AM | SQL Master | 2 Comments   
Since the evolution of SQL Server 2000 version the backup and restore methods have been enhanced for better performance to provide a better option for the DBA, as usual the backup and restore operations are an integral part of the Analysis Services infrastructure. Read More...
More Posts Next page »