SqlServer-QA.net

Over the times managing RDBMS platform has evolved into a phase that all of the essential functionality that a Database Administrator needs to administer a multivendor or single-vendor database environment wrapped in an intuitive graphical interface. May be it is a smaller system or mission-critical system to maintain, there are various factors ...

Another common question in the forums asking about what are the best practices for using antivirus software on servers running SQL Server. In my experience if your SQL Server is not a internet-faced one then no need to have one installed on a SQL Server that is dedicated to databases, rather tighten the access on the file access and share on ...

Red-Gate software limitied has released another useful tool for the DBAs, SQL Backup that has impact of what a metamorphosis it has undergone! Many of you will know SQL Backup for its high performance  in creating and encrypting backups. The performance in SQL Backup 5 has improved still further, with multiple threads now available ...

Microsoft is investing a lot to help the Business Intelligence (BI) platform users with the content and get acquaintance to the platform. You are aware BI includes SQL Server Analysis Services, Integration Services and Reporting Services, you can get to know by referring to the media presentation and learn about the enhanced features since the ...

Recently I have had a job to generate a test on a disk subsystem to test a capacity growth on one of our SQL Server system. I was referring through this LessonsLearned article by Geert Vanhoe to simulate the stress testing, I'm aware about using SQLIOSTRESS utility using the patternsinclude heavy page insert/split simulations, inserts, updates, ...

Updates to system catalogs are not allowed - a big subject and nothing but opening door to trouble by allowing direct updates or modifications to system tables in SQL Server 2005. If I remember correctly since the days of SQL 6.5 version Microsoft has been discouraging udpates to system tables even though the provision has been enabled. Since ...