Ben Johnston in SQL Server

SQL Server Row-Level Security: Integration, anti-patterns, and alternatives (complete guide, part four)

A complete guide to SQL Server Row-Level Security integration, anti-patterns, and alternatives.…

17 September 2023 20 min read

SQL Server

Ben Johnston in SQL Server

SQL Server Row-Level Security: Performance, tuning, and troubleshooting (complete guide, part three)

Tune SQL Server Row Level Security performance: compare authentication methods (SESSION_CONTEXT, roles, AD), optimise access predicate indexing, and troubleshoot ETL...

10 September 2023 25 min read

SQL Server

Ben Johnston in SQL Server

SQL Server Row-Level Security: Setup, access predicates, and examples (complete guide, part two)

Set up SQL Server Row Level Security with access predicates (inline TVFs) and security policies. Part 2 covers three setup...

03 September 2023 16 min read

SQL Server

Ben Johnston in SQL Server

A practical introduction to Row-Level Security in SQL Server (complete guide, part one)

Row-Level Security in SQL Server lets identical queries return different rows per user. Here's how it works, when to use...

01 August 2023 16 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

SQL Server

Pamela Mooney in SQL Server

SQL Server Backup Strategy: 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 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

.NET

Rishit Mishra in .NET

Securing Web Application Secrets Through Azure Key Vault

Azure Key Vault is a service for storing securely certificates, credentials, connection strings, and more. In this article, Rishit Mishra...

12 August 2020 12 min read

Security, Privacy & Compliance

Vasanth Makam in Security, Privacy & Compliance

Why Organizations Need to Pay Attention to Cloud Security

As organisations move to cloud platforms like Azure and AWS, understanding security is more important than ever. In this article,...

21 April 2020 10 min read

Database Administration

Joshua Feierman in Database Administration

How to Use SQL Audit and Azure Log Analytics to Comply with Audit Rules

You can use SQL Audit to record changes to security, access to tables, and more to help you meet compliance...

09 September 2019 16 min read