How do you ensure that SQL Drift does not occur in agile development?

By Proper ACL's at DB level. ACL's are basically your authentication control level which will manage and record the user access. Which would avoid Drift.

MS SQL SERVER is a program to work databases from Microsoft Corp. and intense interaction with programming languages ​​designed by this company more than other programs such as Access.