Storage 101: The Language of Storage
Robert Sheldon continues his series on storage. This article covers some of the basics of performance metrics, HDDs, and SSDs.
Personal Power
Because of my job with Redgate (which I love and will never leave even after I’m dead), I spend a lot of time learning about compliance and all the new laws and regulations coming out of things like the GDPR and the CCPA (they changed the name evidently). However, I’m a nerd. I’m not a […]
Incremental Package Deployment – A SSIS 2016 Feature
This article provides step by step instructions to deploy individual SSIS packages in a project deployment model.
Changing SET options in a Procedure or Trigger leads to Recompilation (PE012)
Phil Factor delves into SQL Prompt's performance rule, PE012, which will advise you if it detects the use of the SET statements within a stored procedure or trigger, which might cause unnecessary recompilations, though the issue extends to other types of batches.
Performance Tuning Means 3 Things
Brent Ozar discusses performance tuning and how From the outside it looks more complicated than it is, but at the end of the day, it always comes back to just 3 knobs and knowing which ones you can turn.
Introduction to PIVOT operator in SQL
Learn how to use the PIVOT operator in SQL in a step-by-step manner.
Efficient Solutions to Gaps and Islands Challenges
Window functions are useful for solving many SQL queries. In this article, Ed Pollack demonstrates how they can be used to analyse baseball winning streaks.
Updates to the Deployment Suite for Oracle
Redgate has added new capabilities to the Deployment Suite for Oracle, so it now supports automated migrations-based and state-based Oracle deployments on both Linux and Windows. They've introduced Redgate Change Control, a new capability for understanding development changes, generating migration scripts for version control, and getting precise control over the migration path during automated deployments. Our Schema Compare and Data Compare for Oracle command line tools have been extended to Linux as well as Windows, and we’ve added static code analysis that encourages teams to follow good coding practices on Windows or Linux.
Staying Safe when Traveling
Today, Grant talks about keeping your laptop and phone safe while traveling.
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers