SqlServer-QA.net

What kind of database maintenance operations you should be doing when you are DBA? You should have better understanding on the terms in managing the Database platform at your end, without proper information it is very hard to say you are managing your platform effectively. Think about DBCC checks, backups and database maintenance tasks and list ...

SSMS - useful tool for a SQL Server DBA and user to manage their work in SQL Server. This tool has been fine tuned since the RTM release of SQL 2005 since Nov.2005 and you may be aware using this tool you can manage SQL 2005 and 2000 instances without any issues. IF you are on a Windows domain network then for the day-today work you must use ...

Well the prime criteria for DBAs is to upgrade from the previous versions to latest version and it is not an easy option or platform to perform so quickly without having a proper testing within their environment. As far as the SQL Server is concerned with the version 2005 you have Upgrade Advisor tool and also you need a documentation on setting ...