SQL Server 2014 Upgrade Advisor Prerequisites, Download and Installation What is SQL Server Upgrade Advisor? Microsoft has provided a free tool to analyse existing SQL Server Instance, database, its components, features and configurations and generates...

As a part of SQL Server migration we need to migrate all the logins and passwords from one SQL Server instance to other SQL Server instance or you can also transfer specific login and password to other instance for that we will use microsoft knowledge...

Migrating a database is very critical and time bound process, if anything goes wrong then its very difficult to rollback things and move back to existing environment again. So its very important to prepare a checklist before migrating a database and also...

AS DBA Checklist The role of Database Administrator is very critical and important and DBA has to perform lots of activities and monitoring is one of the important task. A good DBA always tries to minimize his routine activities by automating tasks. The...