Louis Davidson explains why your team needs a standard style for formatting SQL and how SQL Prompt will help make this happen. Read more
Jon Hayman reviews how the metrics available in Redgate Monitor can help you diagnose problems that might come from SQL Server running in a virtual environment. Read more
Richard Macaskill describes a lightweight copy-and-generate approach for making a sanitized database build available to development teams, using SQL Clone, SQL Change Automation and SQL Data Generator. Read more
Can we use a striped backup as the source for a SQL Clone image? Yes we can! Read more
Phil shows how to use SQL Doc, PowerShell and a SQL Doc XML Project file to document multiple databases at once. Read more
Tony Davis shows how to get a database, plus any static data, into source control, and then uses the "/include:StaticData" switch in the SQL Compare Pro command line, fromPowerShell, to automate the process of creating a new build script. Read more
What if you now do development work on a clone, but you to continue working on you own local clone while ‘disconnected’, such as when travelling? One simple option if the original database contains no private data, or the image has been masked, is to performance a normal backup and restore operations the clone, although you'll now be working with a normal, full-sized database. Read more
How to use SQL Compare Pro command line with PowerShell to automate the processes of getting a new database into source control, updating the source with the latest database changes, creating a new build script for a database version, and creating a deployment script to synchronize an existing database with source. Read more
How to use the SQL Compare Pro command line to automatically compare the schema of two versions of the same database, and then subsequently deploy to the target database any differences detected in the source database. Read more
How to use filters in SQL Compare, when you don’t work with all the objects in a database. Read more
