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

SQL Server 2016, the next major release of Microsoft ... the end user or the execution context of their connection. Because all of the permissions logic is stored in the database, the security ...

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

policy templates for reporting on SQL Server permissions as required by the Payment Card Industry (PCI) and the Health Insurance Portability and Accountability Act (HIPAA); support for FIPS 140 ...

The ability to cryptographically guarantee the integrity of data is especially useful for sharing data between partners, allowing an organization to attest to auditors or other business parties that ...

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the ...