This article explains some simple steps to create a GitHub database repository and then version control your SQL Server database, for team development work, using SQL Source Control. Read more
With basic grasp of regex expressions, a tool like SQL Data Generator can generate test data with addresses that are realistic for your part of the world. Read more
How to compare SQL databases using DACPACs, script out differences and then run a database deployment task to synchronize the schema of the target database. Read more
SQL Compare provides a command line interface (CLI) for running database schema comparisons and generating a deployment script, as part of a scripted process. I'll demonstrate how to do this with a 1-click process, using a batch (.bat) file. Read more
SQL Compare can help you compare two databases that have In-Memory objects, the tables, their indexes and any natively-compiled procedures, and generate the appropriate scripts. Read more
As you test your row-level security in various environments, you can use SQL Compare to script out and deploy those changes to other databases. Read more
SQL Compare works with dynamic data masking, detecting the differences in masks across tables and generating the T-SQL you need to deploy your masking configuration to other databases. Read more
How to use a combination of database roles, along with rules, filters and post deployment scripts in SQL Source Control, to add the required users to the correct role, for each database. Read more