Today we are extending our look at user accounts by creating database users and then adding them to specific roles for to provide the proper level of access to a database. First thing is first: we ...

To audit SQL Server 7.0 activity on a deeper level, ... SQL Trace’s new role and new capabilities. ... SQL Server 2000 auditing extends to database security.

This excerpt from the upcoming book, SQL Server 2008 Administration in Action, introduces the role of service-level agreements (SLAs) as part of a DBA's overall strategy to maintaining reliable ...

SQL Server’s End of Life Puts the Spotlight on Database as a Service Many IT managers are already looking at the possibility of shifting workloads to cloud service providers . Although larger ...

RLS lets administrators provide row-level access to data based on a user's identity or role. The company released the RLS feature in its Azure SQL Database last week.

Row-Level Security in SQL Server 2016 (and SQL Azure) is based on a specially crafted inline table valued function. ... or the db_ddladmin fixed database role”. ...

In addition to StretchDB and AlwaysEncrypted, there are two more exciting features in the works for SQL Server 2016: dynamic data masking and row-level security. In the case of these two features, ...