Maintaining a Database Build Script with SQL Compare

Phil Factor explores a lesser-known capability of SQL Compare, which is to help you maintain a 'traditional', well-documented, single file build script, for creating the current version of the database during development. Read more

Database Deployments and Rocky Rollback Horrors: Where Does the New Data Go?

Phil Factor describes the problem of preserving data that is left 'in limbo' when you need to revert the database to a previous version that has no way of accommodating it. Read more

Monitoring Amazon RDS SQL Servers to Optimize Performance and Manage Costs

Israel Valverde explains the triple benefits of using Redgate Monitor to cover your SQL Server instances running on Amazon RDS, for SQL Server performance optimization, controlling AWS-hosting costs, and in providing a single, unified view of the health of all your SQL Servers, regardless of where they are hosted. Read more

Database Build Blockers: Four-part Object References

Cross-server references keep cropping up as a problem for development and build. Phil Factor demonstrates how using linked server 'aliases' can get around these issues, even if the individual databases use four-part references within the code rather than synonyms. Read more

Sharing SQL Code Snippets with Coworkers, The World and Yourself

Louis Davidson explains how he manages and shares several different sources of SQL Prompt code snippets, in a single Snippet library, using Dropbox and source control. Read more

Managing Cross-Database Object References (EI016, EI026, EI027)

Phil Factor explains cross database and cross-server references, how to find them in your code, and when it's better to avoid hard-coding these references and use synonyms instead. Read more

Creating a SQL Code Snippet in SQL Prompt and SSMS

Phil Factor's "getting started" guide for turning all your trusted and most frequently used queries into SQL code snippets. Read more

Solving the Provisioning Problem in Database Development using Clones

When database development is described, the details often get vague when the data gets beyond spreadsheet-size. There is 'hand-waving' talk of providing databases for each developer, but little detail of how you would provision all the databases that would be needed, at the correct version and with the correct development data, and then keep them all in sync with the source code, as developers commit changes. This article explains the requirements, and how SQL Clone can meet them. Read more

Questions about Comparing Databases with SQL Compare that you were Too Shy to Ask

Phil Factor offers straightforward answers to tricky SQL Compare questions. Read more

How to Classify and Protect your Development Data Automatically using SQL Data Catalog and Data Masker Command Line

Chris Unwin describes a classification-driven static data masking process, using SQL Data Catalog to classify all the different types of data, its purpose and sensitivity, and then command line automation to generate the masking set that Data Masker for SQL Server can use to protect this data. Read more