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