Sql logins – Microsoft DB

SQL Security – Logins and users

December 31, 2024December 31, 2024adminLeave a Comment

SQL 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 […]

MSSQL databases Migration and Upgrade

December 31, 2024December 31, 2024adminLeave a Comment

Migration 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 […]