For changing role membership, ALTER SERVER ROLE replaces sp_addsrvrolemember and sp_dropsrvrolemember. These stored procedures are deprecated. You can view server roles by querying the sys.server_role ...

Microsoft has introduced SQL Server 2012 to the world and it's time for IT professionals to start to come to speed on what's new in this highly anticipated version of SQL Server. 1. ... User-Defined ...

When tuning SQL Server performance, consider the CPU's clock speed, core count, and cache size. These factors directly affect how quickly the server can perform calculations and process transactions.

CASE WHEN d.is_policy_checked = 1 THEN 'Yes' ELSE 'No' END PolicyChecked, CASE WHEN d.is_expiration_checked = 1 THEN 'Yes' ELSE 'No' END ExpirationChecked FROM sys.server_role_members a RIGHT JOIN sys ...

SQL server structure—Each instance of the MS SQL Server has four system databases (master, model, tempdb and msdb) and one or more user databases. 3 Security is built around the master/server level ...

About SQL Server. SQL Server 2019 is offered in two main commercial editions to accommodate the unique feature, performance and price requirements of organizations and individuals: Enterprise Edition ...

For roles other than running SQL Server, it’s worth checking the matrix of which server roles can be upgraded from Server 2012 and which will need to be migrated to new hardware running the new OS.