Database provisioning from backups using SQL Clone

A step-by-step guide to creating an image from a database full backup, or from a full backup plus differential backup. Read more

SQL Prompt Tip: how to control when the suggestion box pops up

By default, SQL Prompt shows code auto-completion suggestions automatically, and continuously. Phil Factor shows how to control this behavior, for the times when you need it to be a little less intrusive, such as when working through more intricate coding problems that require careful thought. Read more

Using multiple custom SQL formatting styles in SQL Prompt

Louis Davidson shows how to use SQL Prompt formatting styles to create and maintain multiple code styles, each for a dedicated purpose, and to switch between them and apply a new style to existing code, with ease. Read more

The Louis Davidson custom style for SQL Prompt

Louis Davidson sticks his neck out and offers his take on a sensible SQL code formatting style, based on twenty-plus years of writing SQL. Starting from SQL Prompt's Default style, he customizes it based on his own list of personal preferences for how SQL code should look. The result is the Louis Davidson custom SQL Prompt style that you can download, try out, and adapt as required. Read more

How to implement a SQL formatting standard using SQL Prompt v8

Louis Davidson explains why your team needs a standard style for formatting SQL and how SQL Prompt will help make this happen. Read more

VMware Monitoring in Redgate Monitor

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

Basic data masking for development work using SQL Clone and SQL Data Generator

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

Using striped backups with SQL Clone

Can we use a striped backup as the source for a SQL Clone image? Yes we can! Read more

How to document multiple SQL Server databases using SQL Doc and PowerShell

Phil shows how to use SQL Doc, PowerShell and a SQL Doc XML Project file to document multiple databases at once. Read more

How to deploy a database plus static data using SQL Compare and SQL Data Compare

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