Browse by Tags

SQL Server BI - Managing Large Datawarehouse environment, guidelines

Published 17 September 8 3:24 AM | SqlServer-QA.net

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

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

Automation of Analysis Services database backup

Published 26 September 7 5:19 AM | SSQA.net

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

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

SQL Server 2005 Performance Dashboard Reports - making most out of it!

Published 26 June 7 4:19 AM | SSQA.net

Another set of reports you can generate using SQL Server 2005 Performance Dashboard Reports, this is mainly useful to monitor and resolve performance problems on your SQL Server 2005 database server using the Management Studio client. The reports allow...

Filed under: dashboard, sql server, performance, databases, dba, reporting