Browse by Tags

10 Best Practices for Data Archiving - all platforms

Published 31 December 7 6:44 AM | SSQA.net

When you think about effective data management, archiving will also play important role to manage your data. In this regard Windows Magazine has included best practices for your data management. Data privacy and identity theft have a higher profile in...

Filed under: sql server, data, reporting, features, best practice, key, platform, database management, archive

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

How do I grant permission to those users so that they can view the report?

Published 6 September 7 8:59 AM | SSQA.net

You can use the Report Manager by following these steps: Go to the folder in Report Manager where you have the report and click the Show Details button in the upper right. Click the Edit icon next to the report you want to share, and then click the Security...

Filed under: sql server, security, reporting, users, report builder

Web Server: What’s New in IIS 7 for IT Pros

Published 4 September 7 8:34 AM | SSQA.net

So what's coming wth IIS7, the overview session will highlight the key points of interests for IT Pros in Internet Information Services version 7. IIS7 modularity increases security by allowing a reduced installation footprint and creation of specialized...

Filed under: application, sql server, management, webcast, reporting, iis, pool, websites

Dig further for a process (SPID) using Query Analyzer (SQL 2000 version specific) not DBCC INPUTBUFFER though.

Published 20 August 7 6:53 AM | SSQA.net

Based on this Troubleshoot a process (SPID) using tools & TSQL queries blog post I have been asked to provide same information within SQL Server 2000 version, as that talks about SQL 2005 version specific. Within SQL 2000 to troubleshoot further about...

Filed under: sql server, performance, tuning, reporting, troubleshoot, dbcc inputbuffer, transact sql

Spurious errors when using SQL Server 2005 Performance Dashboard Reports

Published 16 August 7 8:25 AM | SSQA.net

You might have observed errors when using Performance Dashboard reports that is available (recently) for SQL Server 2005, the error below is mostly ocurred: Difference of two datetime columns caused overflow at runtime. Based on the forums & other...

Filed under: dashboard, sql server, performance, ssrs, services, reporting, reports

KBA: Blank space appears in the file when you export a report to a physical page format file in SQL Server 2005 Reporting Services or in SQL Server 2000 Reporting Services

Published 10 July 7 4:50 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete Blank space appears in the file when you export a report to a physical page format file in SQL Server 2005 Reporting...

Filed under: sql server, server, reporting, kba, 2000, physical, 2005

Support WebCast: How to use custom assemblies in SQL Server 2005 Reporting Services

Published 27 June 7 11:51 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Reporting Services Notification Contents: New and All Modifications Support WebCast: How to use custom assemblies in SQL Server 2005 Reporting Services http...

Filed under: sql server, webcast, server, reporting, kba, assembly

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

FIX: Error messages are logged, and some threads may not sort the data successfully if many threads are displaying a report in SQL Server 2005 Reporting Services

Published 22 June 7 4:25 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: Error messages are logged, and some threads may not sort the data successfully if many threads are displaying a...

Filed under: sql server, services, reporting, error, kba

FIX: Rows in a table are not aligned correctly in a SQL Server 2005 Reporting Services report when you view the deployed report in a browser

Published 22 June 7 12:1 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: Rows in a table are not aligned correctly in a SQL Server 2005 Reporting Services report when you view the deployed...

Filed under: sql server, services, reporting, kba

FIX: The background color of a report may be black when the report is hosted by a report server in SQL Server 2005 Reporting Services

Published 15 June 7 2:29 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: The background color of a report may be black when the report is hosted by a report server in SQL Server 2005 Reporting...

Filed under: sql server, reporting, kba, black

KBA: Modified Knowledge Base Articles for SQL Server 2005 Reporting Services

Published 15 June 7 2:25 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: You receive an error message when you use SQL Server 2005 Reporting Services to run a report that has two or more...

Filed under: sql server, services, reporting, kba

KBA: An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems

Published 14 June 7 4:8 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & Reporting Services Notification Contents: New and All Modifications An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported...

Filed under: sql server, services, reporting, kba

A list of the bugs that are fixed in SQL Server 2005 Service Pack 2 - Reporting Services 2005

Published 25 May 7 6:10 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete KBA - A list of the bugs that are fixed in SQL Server 2005 Service Pack 2...( read more ) Read More...

Filed under: sql server, services, reporting, kba

Beginner in SQL Server Business Intelligence

Published 16 May 7 1:30 PM | SqlServer-QA.net (SSQA)

You may be aware that SQL Server 2005 version provides many new features as compared to other Business Intelligence products with rich media presentations, not only on the presentation layer if you deep dive into the new features there many more to integrate...

Filed under: sql server, microsoft, integration, ssis, ssas, ssrs, business, reporting, intelligence

Get statistics on Query plan optimizer execution

Published 11 May 7 4:48 AM | SqlServer-QA.net (SSQA)

As you might know PERFMON (SYSMON) and DMVs in SQL 2005 are very handy to know internal resource information about the SQL Server engine. So you might be thinking what might be the cause of this poor performance when you have a simple query to run and...

Filed under: sql server, stats, security, query, optimization, perfmance, reporting