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

Editorials

Kathi Kellenberger in Editorials

How to make classifying SQL Server data easier

Classifying the data within an organization is not just something nice to do. It’s critical for complying with regulations such...

09 September 2020 4 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

Database Administration

Robert Sheldon in Database Administration

Storage 101: Data Security and Privacy

No discussion about storage is complete without thinking about security of the data. In this article, Robert Sheldon explains what...

22 July 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

Data Privacy and Protection

David Poole in Data Privacy and Protection

Database Security, People and Processes

Protecting data is not easy, but it is critical. In this article, David Poole discusses database security and the behaviors...

20 December 2019 17 min read

Data Privacy and Protection

Robert Sheldon in Data Privacy and Protection

DevOps security privacy and compliance

Robert Sheldon continues his DevOps series with a look at DevOps security, privacy, and compliance. …

10 September 2019 11 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

Database Administration

K. Brian Kelley in Database Administration

The End of SQL Server 2008 and 2008 R2 Extended Support

Many organisations still run their companies on SQL Server 2008 or 2008 R2. There are many reasons to upgrade, but...

21 June 2019 26 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

Editorials

Kathi Kellenberger in Editorials

Scary Stories from the Trenches

If you have worked with databases long enough, you probably have many frightening stories to tell about things that have...

03 April 2019 3 min read

Oracle

Cynthia Dzikiti in Oracle

Security Considerations for ERP Applications

Security is, or at least should be, the priority for any IT system. In this article, Cynthia Dzikiti discusses the...

01 April 2019 16 min read

Data Privacy and Protection

Grant Fritchey in Data Privacy and Protection

GDPR in the USA

GDPR enforcement began in May of 2018, but if you are doing business in the US, you may not think...

28 March 2019 10 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

Editorials

Kathi Kellenberger in Editorials

Protecting Data During Development

In the years before joining Redgate, I was a SQL Server database consultant. I spent a lot of time doing...

20 February 2019 3 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

Database Administration

Greg Larsen in Database Administration

Protecting SQL Server Data Using Static Data Masking

In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and...

07 January 2019 19 min read