SQL Compare

Using SQL Compare with Dynamic Data Masking

One of the features that I hear many DBAs excited about in SQL Server 2016 is Dynamic Data Masking (DDM). This allows DBAs to centrally set a mask that is returned for a table column instead of the actual data. This means an application that wants to limit what information is returned to certain users […] Read more

DLM Automation

Using database replication with automated deployments

The Redgate DLM Automation team that we’re part of took time out from development to explore some of the issues our customers face when automating database deployment. Following on from previous posts about cross-database and cross-server dependencies and production database drift, this blog shares some of our thoughts about how to deal with database replication. Database replication is […] Read more

SQL Monitor

SQL Server monitoring from the trenches: An interview with Anthony Nocentino

I recently sat down with Enterprise Architect, Anthony Nocentino, to talk about how effective monitoring can help resolve many of the issues companies face every day. I was fascinated because my career revolves around how we can improve SQL Server monitoring. Anthony’s involves actually doing it at the coalface. He’s made a name for himself […] Read more

DLM Dashboard

We don’t need no documentation – automating schema docs in Redgate DLM

“Understanding the existing product consumes roughly 30 percent of the total maintenance time.” Facts and Fallacies of Software Engineering by Robert L. Glass. You should be documenting your database schemas. I know it, you know it. Having (current, accurate) documentation available accelerates time-to-resolution for faults, aids tech-to-business conversations, and is a regulatory requirement for a great number of firms. […] Read more

DLM Dashboard

Dealing with production database drift

The Redgate DLM Automation team that we’re part of recently took time out from development to explore some of the issues our customers face when automating database deployment. Following on from last week’s post about cross-database and cross-server dependencies, this blog shares some of our thoughts about how to deal with production database drift. If […] Read more

DLM Automation

DLM Automation add-ons

Many software teams are already integrating their application code but haven’t yet brought the continuous integration discipline to their database development. With DLM Automation, you can extend that process by plugging into third party tools commonly used for application development. It’s now even easier to find the add-on you need for your build or release system. […] Read more

DLM Automation

Deploying cross-database dependencies to different environments

The Redgate DLM Automation team that we’re part of recently took time out from development to explore some of the issues our customers face when automating deployment of database changes.  As part of that exercise, we took a closer look at cross-database and cross-server dependencies – these can cause problems when deploying databases to multiple […] Read more

DLM Dashboard

Monitoring your database schemas with pipelines

DLM Dashboard tracks changes to your database schemas across different environments. In this blog post, we’ll talk about organizing your databases into pipelines, and how this can help you to better understand your workflow. How was it organized before? Grouping databases by category In the first version of DLM Dashboard, databases were grouped by category […] Read more

ReadyRoll

Deploying Entity Framework code first migrations with T-SQL

If you’ve reached the point where the DB change management approach of Code First migrations is no longer meeting your deployment needs, it might be time to consider moving to a change script-based approach. This week’s ReadyRoll release introduced a simple integration with Code First that allows you to continue modelling your database using Entity […] Read more

SQL Source Control

Source controlling your database permissions

The problem A common question we encounter when working with SQL Source Control is about database permissions. Different environments require different permissions, so should you just omit them entirely from Source Control? Or perhaps include only permissions for your production environment? Permissions are extremely important, so not source controlling them at all doesn’t seem right; […] Read more