MSSQL Database Administrator
States of SQL Server Database: Online: When a database is in an online state, the database is available for access. OFFLINE: When a database is in OFFLINE state, then the database is not accessible for user connections. One can set the database to this state if you don’t want users to connect to the database. […]
Continue ReadingSQL Security: Login: Those who are want to privileges for login into SQL server called login. Windows Authentication mode: It allows only active directory users or windows users to connect and work with SQL Server with mapping logins. It provides high security. SQL login: It allows non active directory users to connect and work with […]
Continue ReadingMigration and Upgrade Migration: Migration is a manual process in which the DBA installs a new instance of SQL Server and copies the metadata and data from an old instance to the new instance. Migration provides access to two instances of the system, letting you verify and compare the two systems. During migration, both the […]
Continue Reading