GPGeorge
Grover Park George
- Local time
- Today, 03:37
- Joined
- Nov 25, 2004
- Messages
- 1,867
Please join us for our Monthly Chapter Presentation April 4, 2024, at 6:30PM Pacific (UTC -8)
Kent Gorrell shares a new and intriguing method of creating audit tables in SQL Server.
The best part is that no SQL Server triggers are involved and once it’s in place, the audit table automatically inherits any new columns added to the table being audited. As close to pain-free as it comes.
Kent will reveal the secret and demo his method, which uses Temporal tables. Temporal tables have been available in several recent versions of SQL Server. Kent’s method is a good way to get familiar with the exciting possibilities they offer.
Osel Solutions is based in Brisbane with clients around Australia and the South Pacific.
Kent been involved in software development since the early 1990s. He specialises in Business Analysis and building Custom Business Applications for small to medium sized business using Microsoft Access and SQL Server Visit Osel Solutions to learn more about Kent.
Access Pacific holds FREE Q&A webinars the First Thursday of every month, from 6:30 pm to 7:30 pm Pacific.
==============================================================================
Please prepare ahead of time by downloading Zoom, if you don’t already have it.
Get Zoom
To join our meetings, please use the following link and phone number or use your computer’s speakers with audio:
Use WorldTimebuddy to determine the appropriate start time for your time zone.
Join the meeting from here:
Join Zoom Meeting
If you are asked use
Meeting ID: 861 2395 1916
Passcode: 123456
Dial by your location
+1 253 215 8782 US (Tacoma)
+1 346 248 7799 US (Houston)
+1 669 900 9128 US (San Jose)
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
+1 646 558 8656 US (New York)
Meeting ID: 861 2395 1916
Passcode: 123456
Kent Gorrell shares a new and intriguing method of creating audit tables in SQL Server.
The best part is that no SQL Server triggers are involved and once it’s in place, the audit table automatically inherits any new columns added to the table being audited. As close to pain-free as it comes.
Kent will reveal the secret and demo his method, which uses Temporal tables. Temporal tables have been available in several recent versions of SQL Server. Kent’s method is a good way to get familiar with the exciting possibilities they offer.
Osel Solutions is based in Brisbane with clients around Australia and the South Pacific.
Kent been involved in software development since the early 1990s. He specialises in Business Analysis and building Custom Business Applications for small to medium sized business using Microsoft Access and SQL Server Visit Osel Solutions to learn more about Kent.
Access Pacific holds FREE Q&A webinars the First Thursday of every month, from 6:30 pm to 7:30 pm Pacific.
==============================================================================
Please prepare ahead of time by downloading Zoom, if you don’t already have it.
Get Zoom
To join our meetings, please use the following link and phone number or use your computer’s speakers with audio:
Use WorldTimebuddy to determine the appropriate start time for your time zone.
Join the meeting from here:
Join Zoom Meeting
If you are asked use
Meeting ID: 861 2395 1916
Passcode: 123456
Dial by your location
+1 253 215 8782 US (Tacoma)
+1 346 248 7799 US (Houston)
+1 669 900 9128 US (San Jose)
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
+1 646 558 8656 US (New York)
Meeting ID: 861 2395 1916
Passcode: 123456
