Information security, whether in databases, applications, or larger IT systems, is based on the principles of Authentication and Authorization, often referred to as AuthN and AuthZ respectively. Likewise, PostgreSQL security involves creating roles that allow access to server resources (AuthN) and then granting privileges to database objects appropriately (AuthZ). Understanding how each of these components work together is essential to effectively manage security in a PostgreSQL cluster.

Undoing Actions on Groups of Database Tables

by Additional Articles

Redgate

Vendors/3rd-party Products

During development, you'll occasionally need an undo script that drops a group of tables, or you might need to truncate a group of tables and then insert fresh data in order to run some tests. Unless you perform the required actions in the correct dependency order, you'll be tripped up by foreign key constraint violations. This article provides a SQL function that returns the list of tables in the correct dependency order.

A Nice Holiday

by Steve Jones

SQLServerCentral

holiday

Today Steve takes a holiday from computers.

How To Avoid MERGE in SQL Server

by R Glen Cooper

SQLServerCentral

Introduction This article shows how to script a basic merge between two tables, without using MERGE. This can be handy when you're merging a pair of tables with hundreds of columns, since the script doesn't know anything about them. This technique introduces and populates some auditing columns (IS_DELETED, IS_INSERTED, IS_UPDATED, TRANSACTION_DATE) for each record, and runs fast. […]

3 Key Areas to Drive Digital Transformation

by Additional Articles

Redgate

Vendors/3rd-party Products

This article explores three key areas that need to be considered to make digital transformation occur: as a response to current changes, in preparation for future changes and to enhance the human experience. Read on to find out more!

json_object and json_array Functions SQL Server 2022 Tutorial

by Additional Articles

MSSQLTips.com

SQLServer

Learn about the new functions JSON_OBJECT and JSON_ARRAY to work with JSON formatted data in SQL Server.

With the Rise of AI Chat, are Experts Still Needed?

by RyanBooz

SQLServerCentral

As I looking at the feed of technology stories this week, two things jumped out at me. First, Valentine's day happened to fall on the monthly release day for Microsoft updates and feature previews. If you work with Azure services, specifically in the data platform space, there are a lot of update announcements to work […]