Universal Architecture

In this post, I’d like to introduce you to the Universal Architecture idea described by J.B. Rainsberger in the podcast Unit Testability and the Universal Architecture. Everyone wants to deliver software that works and delivers value to our customers. That’s a fact! Everyone wants our software to be easy to change and maintain. That’s obvious! Unfortunately, we... read more

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