SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part ...

Server and Database Roles in SQL Server All versions of SQL Server use role-based security, which allows you to assign permissions to a role, or group of users, instead of to individual users. Fixed ...

Creating Application Roles in SQL Server Application roles provide a way to assign permissions to an application instead of a database role or user. Users can connect to the database, activate the ...

Application Roles offer a better, more secure way for users to gain access to SQL Server data. Here's why.

The new ledger feature in SQL Server 2022 provides blockchain-based security to ensure data isn't tampered with.

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.

Microsoft's continued focus on SQL Server 2025 highlights the lasting demand for on-premises and hybrid deployments that prioritize performance, control and flexibility for enterprise workloads.