Database Management
We review your MS SQL Server and recommend appropriate database backup schedules, create scripts to backup and retrieve data, and review your data for data integrity.
Database backups
We review with you how you use your data and others access your data. Then we recommend the appropriate backup schedules.
We create scripts so that the backups can be easily scheduled. Additionally, the scripts ensure that the backups are consistently done. Additionally, if test databases are needed we can create scripts to retrieve the data from the production database and transfer to a test database.
Data integrity
Integrity is key to keeping your data ‘correct’.
How can you use your data without the surety that all the ‘pieces’ are aligned
The data in databases is like a jigsaw puzzle and we review to make sure all the pieces are aligned and fit together. You would be surprised how much data isn’t accurate. You need to be able to rely on your data, in whichever table it resides or when it is displayed
Examples
Age- simple as the difference between today and your year of birth right. But if the person is dead then it’s a different formula.
YTD earnings – what happens when checks are voided for prior years?
Person information – is your ssn and date of birth secure? Is that info viewed by everyone or restricted by security? Is it used as keys?