If some of your database constraints have system-generated names, they can cause 'false positives' when comparing schemas and generating build scripts using SQL Compare or SQL Change Automation. Phil Factor explains the difficulties, and the Compare option you need to enable to avoid them. Read more
How developers who were previously writing and managing database source code in SSMS can make a smooth transition to Azure Data Studio. Read more
SQL Change Automation makes automation simple enough that it can adapt to suit many different approaches to SQL Server database development. Phil Factor describes a project to update the Pubs database, using it in combination with a PowerShell function and to maintain in source control the build scripts, migration scripts and object-level scripts, for every version of the database. Read more
Stephanie Herr explains how to use the 'hybrid' approach in the Deployment Suite for Oracle to automate Oracle database deployments. This is where the team maintains the current state of the database in version control during development. then, at key stages, they generate and test the migrations script that will be used to deploy the new database changes safely. Read more
How well do the SQL Server licenses you own match up with what you need for your current use? William Durkin explains how to use Redgate Monitor to find out. Read more
Phil Factor on the fill factor, pages splits and index fragmentation, and how Redgate Monitor can help you decide if a custom fill factor for certain indexes might help alleviate performance issues. Read more
Phil Factor demonstrates a cunning way to test stored procedures or functions, such as after refactoring, by storing the 'before' and 'after' results in views and then using SQL Data Compare to spot any discrepancies. Read more
Phil Factor on how to cope with any database drift that results from various checks and tests and fixes made during deployment. Read more
Phil Factor distills the basic tasks of the database development stage and explains how SQL Compare can help tackle them. Read more
Alexander Diab demonstrates how a team of developers can work on and test features in different branches of a SQL Server database development project, while their local development database automatically remains 'synchronized' with the current branch in version control. Read more
