Archive System-Versioned Temporal Table History Data
I am a big fan of SYSTEM-VERSIONED TEMPORAL TABLES and the way they automatically store
DBA Tasks
Move Table to Another, New or Different File Group
This week I’m working on reorganizing some of the tables in a database. I want
Change Data Capture (CDC) Setup, Update, Reenable
There is a great post on MSSQLTIPS on how to RESTORE a database and keep
Install Certificate for TLS In Transit End-to-end Encryption
Today I need to install SQL Server on a new development server. Even though “it’s
Check Dbcc Database Backup Verification for Data Recovery
Twice a year, auditors verify that — should there be an “incident,” we can recover
Create an Audit for Data Using a Temporal Table
Recently someone has been changing data in a table on a legacy application written more
Snapshot or Backup AWS RDS SQL Server
Going to be away at Orlando’s SQL Saturday this weekend and one of my company’s
Directly Import data from AWS S3 to SQL Server 2022
Today I wanted to show my team how we might be able to use one
SQL LOGIN PASSWORD MANAGER
Right before I went on vacation, in an audit, we discovered that occassioanlly there was
SQL TABLE PI DATA CLEANING SOLUTION (PART 2)
In Part One I set up the solution that cleans our data. In this part