Five ways we’ve implemented Agile marketing at Redgate

Implementing Agile working practices reminds me of Communism – if we just did it properly, everything would work perfectly! All projects would be a dream to work on, all deliveries would be early, the customers would get exactly what they needed, and so on. However, perfection is the enemy of progress. We’ve implemented an... read more

SQL Prompt to the rescue with tab coloring

When you’re hard at work, it’s all too easy to make a mistake as you rush to get a job done. Say, for example, you have a QA database you need to get rid of. You run a query to drop it and then… oh no! You’ve accidentally run it in Production. Your day... read more

How to use custom filters in SQL Compare

I used to work at JD Edwards, and in one of our ERP products we had a cumbersome database schema. There were tables like this: These were the tables that held various information in the system. Trying to find data was an exercise in frustration, even for those of us that were familiar with... read more

3 Results Grid features SQL Prompt brings to SSMS

You may not have heard about it yet, but three helpful features were recently added to SQL Prompt that are activated when you right-click on the Results Grid in SQL Server Management Studio (SSMS). 1. Copy as IN clause This feature is available when you have values from a single column selected. You can... read more

Time travelling with SQL Compare

In SQL Server 2016, Microsoft introduced support for system-versioned temporal tables. Temporal tables are a database feature that provides information about data stored at any point in time, rather than only the data that is correct at that specific moment. Why are temporal tables needed? Simply put, they make it much easier to analyze... read more

How to sell a car

At Redgate we’ve had various debates over the years about how much impact the sales function has on the business. We’ve run experiments, had philosophical debates, made significant shifts in our policy and practice. There is a painful lesson that I’ve had to relearn many times, though: if the sales teams don’t do the... read more

Automatically filling your SQL Server test databases with data

This article explains how you can use SQL Data Generator (SDG) to automate data provisioning for test databases, during the database development cycle. Having first created an SDG project file for a database, to define the data generation strategy, we can write a command line batch script, or PowerShell script, which uses a build... read more