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 ...

it was difficult to allow users to see the SQL Server Agent jobs on your database server without giving the user sysadmin permissions. SQL Server 2005 makes assigning this permission much easier ...

Here are two more in the works to think about: dynamic data masking and row-level security. In the case of these two features, they’ll be released first to the cloud platform (Azure SQL Database) and, ...

The new ledger feature in SQL Server ... database with just some ledger tables that those particular tables will give you these guarantees -- these tamper evident guarantees -- and the rest of the ...