Browse by Tags

• 2005
• administrator
• adomd.net
• Analysis Services
• backup
• business
• business intelligence
• data mining
• data warehouse
• diagnose
• driver
• feature pack
• integration
• intelligence
• management
• mdx
• olap
• performance
• permissions
• process
• profiler
• readonly
• reporting
• Reporting Services
• reportserver
• reportservertempdb
• rsexecrole
• security
• sql server
• sqlagent
• sysmon
• xmla

SQL Server BI - Managing Large Datawarehouse environment, guidelines
17 September 08 01:24 AM | SQL Master | 2 Comments   

What will be the main challenge for a DBA/User to manage a large Data Warehouse (DW) environment, size does matter and also think about downtime you need to deploy whenever any patches are required. Before that you need to be perfect or well-versed with Read More...

Filed under: sql server, performance, databases, reporting, management, business intelligence, data warehouse, readonly

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

Filed under: sql server, databases, Reporting Services, security, sqlagent, permissions, reportserver, reportservertempdb, rsexecrole

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

Filed under: diagnose, sql server, performance, databases, Analysis Services, process, security, administrator, sysmon, profiler

"Provider cannot be found" error when trying to run a MDX query?
05 November 07 01:39 AM | SQL Master | 2 Comments   

One of the Business user asked for the resolution for the error they are getting when running a MDX query against the Analysis Services database within their data mart. The error is "Provider Cannot be found", before going further on this error ensure Read More...

Filed under: sql server, mdx, databases, Analysis Services, driver, adomd.net, feature pack, 2005

Automation of Analysis Services database backup
26 September 07 03:19 AM | SQL Master | 2 Comments   

You may be well versed with scheduling the database backups using SQL Serve Agent --> Jobs with Enterprise Manager or Management Studio. So how about creating a automation job for SQL Server 2005 analysis services database backup every night. Simple, Read More...

Filed under: sql server, databases, reporting, Analysis Services, backup, security, sqlagent, xmla

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