Uploaded April 2026 | Updated September 2026, 2 hours ago
#course
This video is the seventh in a nine part introduction to the discipline of Software Configuration Management (CM), highlighting its role in maintaining system consistency through a controlled repository of all components.
This video provides an overview of the challenges and solutions to upgrading SQL databases, coming from a background of over 20 years experience in Configuration Management.
We cover the daily challenges in database configuration management focussing on how to update SQL structures without compromising user data.
Explaining the distinction between a database's schema, which acts as the blueprint, and its stored data, which must remain intact during software releases.
We emphasize the shift from manual labour to automated upgrade processes, highlighting the necessity of pre-deployment safeguards like backups and HASH comparisons.
Finally, the role of the Database Administrator is presented as vital for maintaining security and performance throughout these complex deployment cycles.
Part 1 - Requirements - youtu.be/udGnxwMA4-Y
Part 2 - Planning - youtu.be/5wq0MNvB_A0
Part 3 - Development and Version Management - youtu.be/ULEfjc4ymJ0
Part 4 - Development and Build Management - youtu.be/Y8B_TfU3Pls
Part 5 - Testing - youtu.be/olP-q6XSe9g
Part 6 - Support and Helpdesk - youtu.be/jqL6LaFb1T0
Part 8 - Appendix 2 - Version Management - youtu.be/ZRDbmHu_ljg
Part 9 - Appendix 3 - Disaster Management - youtu.be/4rb1HP7sjSM
AI was heavily used to assist in the illustration of this video
I don't work for, nor am I paid or sponsored by, the owners of PowerBASIC, or any other company mentioned in these videos, I'm just a fan of their products.
For more information on PowerBASIC visit
pbusers.org
OR
pump.richheimer.de/index.php
A full listing and Index of all our videos on YouTube is available from here
gsfsoftware.co.uk/PBTutorials/Projects.htm
Music by ghosthack.de
Additional Graphics & Videos
Google Veo 3, NotebookLM
Hailuo AI
ArtSpace.ai
#course
This video is the seventh in a nine part introduction to the discipline of Software Configuration Management (CM), highlighting its role in maintaining system consistency through a controlled repository of all components.
This video provides an overview of the challenges and solutions to upgrading SQL databases, coming from a background of over 20 years experience in Configuration Management.
We cover the daily challenges in database configuration management focussing on how to update SQL structures without compromising user data.
Explaining the distinction between a database's schema, which acts as the blueprint, and its stored data, which must remain intact during software releases.
We emphasize the shift from manual labour to automated upgrade processes, highlighting the necessity of pre-deployment safeguards like backups and HASH comparisons.
Finally, the role of the Database Administrator is presented as vital for maintaining security and performance throughout these complex deployment cycles.
Part 1 - Requirements - youtu.be/udGnxwMA4-Y
Part 2 - Planning - youtu.be/5wq0MNvB_A0
Part 3 - Development and Version Management - youtu.be/ULEfjc4ymJ0
Part 4 - Development and Build Management - youtu.be/Y8B_TfU3Pls
Part 5 - Testing - youtu.be/olP-q6XSe9g
Part 6 - Support and Helpdesk - youtu.be/jqL6LaFb1T0
Part 8 - Appendix 2 - Version Management - youtu.be/ZRDbmHu_ljg
Part 9 - Appendix 3 - Disaster Management - youtu.be/4rb1HP7sjSM
AI was heavily used to assist in the illustration of this video
I don't work for, nor am I paid or sponsored by, the owners of PowerBASIC, or any other company mentioned in these videos, I'm just a fan of their products.
For more information on PowerBASIC visit
pbusers.org
OR
pump.richheimer.de/index.php
A full listing and Index of all our videos on YouTube is available from here
gsfsoftware.co.uk/PBTutorials/Projects.htm
Music by ghosthack.de
Additional Graphics & Videos
Google Veo 3, NotebookLM
Hailuo AI
ArtSpace.ai
