SQL Server Table Design Guidelines - Data Types, Designing for Deletes and Primary Keys

In this article, we look at three table design guidelines when building an SQL table including data types, designing for deletes, and primary keys

It’s Probably Time to Upgrade Your Cloud VMs

If you’ve been in Azure or Amazon for a few years, you’re probably on old, slow hardware.

Security in the cloud: Whose responsibility is it?

While the cloud is recognized as more secure than on-premises servers and infrastructures, it does come with the often talked about shared responsibility model. Cloud providers are responsible for security ‘of’ the cloud, while their clients are responsible for security ‘in’ the cloud. Find out more in this Q&A with Dustin Dorsey

Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points

Is MongoDB in use within your organization? The Flyway development team is adding MongoDB support into Flyway and would like to better understand the current pain points. If you are able help, or are interested in finding out more, please participate in our 5-minute survey.

Something’s Up with Parallelism in Azure SQL DB Serverless

Or perhaps another way to phrase that is, Microsoft is up to something with parallelism. I don’t know how long it’s been this way – could even be since the launch of Azure SQL DB Serverless – but I just now noticed it while helping a client with a slow query.

Don’t use DISTINCT as a “join-fixer”

I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there only to serve as a “join-fixer,” and I can explain what that means using an example.

Five database DevOps practices for boosting team productivity

Speed of delivery and protecting data can often feel incompatible, but there are industry-proven database DevOps practices that bring them together in harmony.

Across each of these five key practices, there’s a theme of removing barriers and cognitive load for teams; but crucially, they are also putting safeguards in place to reduce the risks to production environments.

SQL Server Fragmentation Impact with Modern Hardware

Read this article to find out if you still need to worry about SQL Server index fragmentation with modern hardware.

Normalize strings to optimize space and searches

While this article is specifically geared to SQL Server, the concepts apply to any relational database platform. The Stack Exchange network logs a lot of web traffic – even compressed, we average well over a terabyte per month.

Why Database Discussions Have Moved From the Backroom to the Boardroom

There are good reasons why business leaders should care about their databases—and hidden costs for neglecting them. Our CMO, Kate Duggan, wrote about the risks and potential costs in this article on Bloomberg.