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 Data partitioning & Data lifecycle within that DW environment.  Also buidling up ...

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 have a far greater financial impact on ...

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 BACKUP/RESTORE commands to ...

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 field, enter the ...

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 now “sandboxed” by default.  You’ll ...

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)SELECT @Handle = sql_handle FROM ...

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 is to update setup.sql file ...

Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Reporting ServicesNotification 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 Serviceshttp://support.microsoft.com/kb/938943/en-US

Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Reporting ServicesNotification Contents: New and All Modifications Support WebCast: How to use custom assemblies in SQL Server 2005 Reporting Serviceshttp://support.microsoft.com/kb/937263/en-US

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 there is a current bottleneck on their ...