Database Administration Fabiano Amorim in Database Administration Exploring errors to reveal unauthorized information Database administrators can never stop thinking about security. In this article, Fabiano Amorim shows how data can be revealed through... 19 October 2020 10 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
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
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 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
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 6 SQL Server has many tools used to make it secure. In this article, Robert Sheldon demonstrates several of these features... 29 May 2019 15 min read
Security Robert Sheldon in Security Introduction to SQL Server Security — Part 5 SQL Server contains many built-in views and functions that can be used to understand what is going on “under the... 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
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 4 The sa account is the most powerful account in a SQL Server instance, and most DBAs disable it. There are... 26 March 2019 19 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 3 SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the... 25 February 2019 14 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
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 2 In this article, the second in the series, Robert Sheldon demonstrates how to manage the SQL Server security with granting... 28 January 2019 23 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
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 1 Security is often considered the most important of a database administrator's responsibilities. SQL Server has many powerful features for security... 31 December 2018 14 min read
BI Robert Sheldon in BI Power BI Introduction: Visualizing SQL Server Audit Data — Part 9 SQL Server Audit is a powerful feature that can help you comply with regulations such as HIPAA and SOX, but... 29 November 2018 21 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection SQL Server Auditing for HIPAA and SOX – Part 4 Regulations may require that you audit exactly who does what in your databases. Robert Sheldon explains how SQL Server can... 13 November 2018 13 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection SOX and Database Administration – Part 3 Database administrators are typically responsible for the security and availability of financial data. In this article, Robert Sheldon discusses SOX,... 24 October 2018 13 min read
