Redgate Blog

Annabel Bradford

29 July 2015

2 Comments

Annabel Bradford

29 July 2015

2 Comments

Why I get excited about SQL in the City …

It’s been four years since Redgate’s first SQL in the City and in that time we’ve hosted the event 16 times in a range of cities. It’s become something of a well-oiled machine and I’m pretty confident we’ve got the dynamic down to a ‘tea’. What I most look forward to is seeing everyone... Read more

SQL in the City

Amy Burrows

22 July 2015

Amy Burrows

22 July 2015

The key to avoiding database version control problems

It’s a familiar story. Two developers are working on a database, they’re using version control, and there’s a problem. The bigger problem is, they don’t even know they have a problem. As far as they’re concerned, they’re doing everything right. They’ve been using version control, so they can deploy the database changes they’ve been... Read more

22 July 2015

22 July 2015

Email Confirmation and Recovering Passwords

Modern applications have plenty of authentication features beside registration and login. In this article we will take a look at how to design the database for two such features: email confirmation and password recovery. Read more

Alex Yates

21 July 2015

Alex Yates

21 July 2015

Two different types of release branch

When devising the first workshop for the new Redgate DLM training program, Steve Jones and I got into a bit of a debate about branching. Upon reflection, it’s obvious why. People often use the term ‘release branch’, but they can mean different things. It is important to be clear. I did some Googling and... Read more

Release Branch

Redgate Data Modeler

17 July 2015

Redgate Data Modeler

17 July 2015

7 Common Database Design Errors

The art of designing a good database is like swimming. It is relatively easy to start and difficult to master. If you want to learn to design databases, you should for sure have some theoretic background, like knowledge about database normal forms and transaction isolation levels. But you should also practice as much as... Read more

Redgate Data Modeler

15 July 2015

Redgate Data Modeler

15 July 2015

Adding More Advanced Features Like Managing Categories and Voting on Threads and Posts

In this next article in the series on designing a database model for an online discussion forum, I continue to add features to the model. Firstly, I will enhance the post table. Then, I will deal with post categories and up/downvoting functionality. Read more

David Atkinson

14 July 2015

David Atkinson

14 July 2015

How to enhance database deployments with SQL Compare using DLM Dashboard

For a long time, SQL Compare has been the industry standard for comparing and deploying SQL Server database schemas. Packed with features that can be used to maintain a history of deployments, it makes it possible to build up a record of which objects were changed, when a change was applied, who made it,... Read more

9 July 2015

9 July 2015

How to Store Authentication Data in a Database. Part 1

How difficult is it to program a user login function for an application? Novice developers think it's very easy. Experienced developers know better: it is the most sensitive process in your application. Errors in login screens can lead to serious security issues. In this article we take a look at how to store authentication... Read more

Simon Galbraith

8 July 2015

Simon Galbraith

8 July 2015

Don’t leave your database behind

Continuous delivery brings big business benefits to application development – it’s time to give the database the same benefits, says Simon Galbraith, chief executive and co-founder of Redgate. Microsoft’s recent announcement that Windows 10 will be the last big-bang release for the operating system was a surprise to many. But what on Earth is... Read more

2 July 2015

2 July 2015

This October we’ll be back again in London and Seattle hosting our “SQL in the City” events

Over the years, our SQL in the City events have proved enormously popular in offering SQL Server training to hundreds of database professionals. Now in its fifth year, SQL in the City attracts Database Administrators and developers (as well as other professionals who work with SQL Server) who want to hear the world’s top SQL Server speakers... Read more

SQL in the City

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Blog

Why I get excited about SQL in the City …

The key to avoiding database version control problems

Email Confirmation and Recovering Passwords

Two different types of release branch

7 Common Database Design Errors

Adding More Advanced Features Like Managing Categories and Voting on Threads and Posts

How to enhance database deployments with SQL Compare using DLM Dashboard

How to Store Authentication Data in a Database. Part 1

Don’t leave your database behind

This October we’ll be back again in London and Seattle hosting our “SQL in the City” events

2025 State of the Database Landscape

Introduction to PostgreSQL for the data professional