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 the minds of consumers but data retention issues...
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, within SQL Server 2005 version you can schedule...
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 link on the left. In the Group or username...
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, streamlined servers. Application Pools are...
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 a SPID you can use: DECLARE @Handle binary(20...
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 blogs on the web suggests that The fix for that error...
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 Services or in SQL Server 2000 Reporting Services...
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://support.microsoft.com/kb/937263/en-US...( read...
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 a database administrator to quickly identify whether...
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 report in SQL Server 2005 Reporting Services http...