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

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

Visualize SQL Server Audit Data in Power BI: Tables, Charts, and Gauges

Connect Power BI Desktop to SQL Server Audit data to create interactive reports. Covers test database setup, DML/DDL audit generation,...

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

Data Privacy and Protection

Robert Sheldon in Data Privacy and Protection

HIPAA and Database Administration – Part 2

HIPAA was signed into law in the United States in 1996. In this article, Robert Sheldon discusses how the act...

09 October 2018 13 min read

Data Privacy and Protection

William Brewer in Data Privacy and Protection

Fifty Different Ways to Enact Data Privacy Laws?

Now that the GDPR has gone into effect, many are wondering what will happen in the United States. California is...

19 September 2018 13 min read

Data Privacy and Protection

David Poole in Data Privacy and Protection

Exhuming the GDPR Bodies

Since the GDPR has gone into effect, the focus has often been on databases. There are many other ways that...

12 September 2018 20 min read

Data Privacy and Protection

Rebecca Edwards in Data Privacy and Protection

Questions About HIPAA That You Were Too Shy to Ask

As a data professional or developer, you will likely have questions about how HIPAA impacts you and your day to...

04 September 2018 8 min read

Register for Simple Talk

Security, Privacy & Compliance

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

The End of SQL Server 2008 and 2008 R2 Extended Support

Introduction to SQL Server Security — Part 6

Introduction to SQL Server Security — Part 5

Scary Stories from the Trenches

Security Considerations for ERP Applications

GDPR in the USA

Introduction to SQL Server Security — Part 4

Introduction to SQL Server Security — Part 3

Protecting Data During Development

Introduction to SQL Server Security — Part 2

Protecting SQL Server Data Using Static Data Masking

Introduction to SQL Server Security — Part 1

Visualize SQL Server Audit Data in Power BI: Tables, Charts, and Gauges

SQL Server Auditing for HIPAA and SOX – Part 4

SOX and Database Administration – Part 3

HIPAA and Database Administration – Part 2

Fifty Different Ways to Enact Data Privacy Laws?

Exhuming the GDPR Bodies

Questions About HIPAA That You Were Too Shy to Ask