Ledger - SQL Server 2022 (English Subtitles)
HTML-код
- Опубликовано: 6 авг 2024
- Ledger tables allow you to be sure that the continuity of data modification has not been disturbed. Not only by registering changes and the ability to view them, but also by saving encrypted data in system tables and their subsequent verification. In this part, I will present how to create the ledger tables, how to analyze the history of changes, using the table of changes, generated view and system objects.
Scripts:
github.com/kursysql/SQL-Serve...
Microsoft documentation
docs.microsoft.com/en-us/sql/...
docs.microsoft.com/en-us/sql/...
www.kursysql.pl
Agenda:
00:00 Introduction
00:42 Creating a table
03:10 Reading data
05:32 Ledger view
08:18 Modifying data
11:30 database_ledger_transactions
12:24 Deleting a table
13:42 Summary