Ben Johnston in SQL Server SQL Server Security Features: Complete Guide Complete guide to SQL Server security features - TDE, Always Encrypted, Dynamic Data Masking, Row-Level Security, auditing, firewall rules, and... 15 October 2023 39 min read
SQL Server Ben Johnston in SQL Server A practical introduction to Row-Level Security in SQL Server (complete guide, part one) A practical introduction to Row-Level Security in SQL Server: how the predicate function and security policy work, testing, performance, hierarchies,... 01 August 2023 16 min read
Security Priyanka Chouhan in Security SQL Server vulnerabilities and assessment SQL Server has many features to keep the database secure, but you must implement them to benefit. In this article,... 21 April 2022 11 min read
Security Robert Sheldon in Security Ransomware: A world under threat Ransomware has threatened many organizations over the past few years. In this article, Robert Sheldon explains the history of ransomware... 01 November 2021 12 min read
Security Robert Sheldon in Security Cybersecurity threats Not a week goes by without news of a new cyberattack. In this article, Robert Sheldon explains the cybersecurity threats... 30 September 2021 12 min read
Security Greg Larsen in Security SQL Server security – Providing a security model using user-defined roles Greg Larsen continues his series and shows how user-defined roles roles can control SQL Server security.… 26 April 2021 13 min read
Security Robert Sheldon in Security What to monitor for SQL Server security Keeping databases secure is critical. In this article, Robert Sheldon explains what to monitor for SQL Server security.… 24 March 2021 11 min read
SQL Server Pamela Mooney in SQL Server SQL Server backup strategy guide: RPO, RTO, recovery models, and restore types Build a SQL Server backup strategy from SLA to implementation: understand RPO and RTO, choose the right recovery model (FULL,... 09 November 2020 21 min read
Security, Privacy & Compliance Fabiano Amorim in Security, Privacy & Compliance SQL Server View-Based Security Flaw: How Error Messages Expose Hidden Data View-based row-level security in SQL Server leaks information through error messages - a user who can't see a row can... 19 October 2020 11 min read
SQL Server Pamela Mooney in SQL Server SQL Server security starter guide for DBAs: authentication, permissions, monitoring, and audit Comprehensive SQL Server security guide for DBAs - covering physical and data-file security, patching, authentication (Windows vs SQL), server and... 08 October 2020 28 min read
SQL Server Robert Sheldon in SQL Server SQL Server Security Tools: Vulnerability Assessment & Config How to use SQL Server Configuration Manager, sp_configure, Vulnerability Assessment, and Data Discovery & Classification to harden an instance.… 29 May 2019 15 min read
SQL Server Robert Sheldon in SQL Server SQL Server Security Catalog Views, DMVs & Functions The key SQL Server catalog views, DMVs, and system functions for auditing permissions, encryption, and logins — with T-SQL query... 23 April 2019 21 min read
SQL Server Robert Sheldon in SQL Server SQL Server Built-In Accounts: sa, dbo, guest & sys What SQL Server's built-in principals (sa, public, dbo, guest, sys, INFORMATION_SCHEMA) do by default, and how to check or change... 26 March 2019 18 min read
Databases Robert Sheldon in Databases SQL Server Contained Databases: Users & Portability How SQL Server's partially contained databases work — creating contained users, duplicating them across databases, and unlinking users from logins.… 25 February 2019 15 min read
SQL Server Robert Sheldon in SQL Server SQL Server Access Control: Logins, Roles & Permissions How to create SQL Server logins, roles, and database users, then grant, deny, and revoke permissions on them with T-SQL... 28 January 2019 24 min read
SQL Server Robert Sheldon in SQL Server SQL Server Security Overview: Authentication to Encryption An overview of SQL Server's security toolkit — authentication modes, principals/permissions, encryption, auditing, and vulnerability tools.… 31 December 2018 15 min read
SQL Server Robert Sheldon in SQL Server SQL Server Permissions: Principals, Securables & Roles How SQL Server principals, securables, and permissions work together — logins, users, roles, and GRANT/DENY/REVOKE — with T-SQL examples.… 02 August 2016 18 min read
