Degree Apprenticeships
Training more people on the job, while still allowing them to continue their education is something Steve thinks would help more people get started in technology.
Improve Query Performance when SQL Server Ignores Nonclustered Index
In this article, we look at why SQL Server may not use a non-clustered index over the clustered index and what you can do to improve performance.
Mastering a cloud migration: 10 video tips
If you haven’t had time to catch up on our latest full-length webinar on Cloud Migration, here’s an easy way to digest the tips from our experts in less than 20 minutes!
Learning with Sample Data
I just had my one-year anniversary working for Redgate, and I must tell you, it’s been one of the best years of my professional career of 25 years. People aside (and there are a lot of really great people!), one of the reasons I’ve enjoyed this year so much is that Redgate understands and believes […]
Be Valuable, Not Critical
One piece of advice for engineers is to be valuable, but not critical. It's a mistake Steve made early in his career, but he hopes you can do better.
First Normal Form Gets No Respect
Dr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 No 6; June 1970). Some more work followed up after that by other people, giving us normal forms and other things we have taken for granted for 50+ years.
Power Query Editor in Power BI for Formatting Text Columns
This article looks at ways to clean up text data used in Power BI reports and charts for a more meaningful and consistent message.
The Justification Database
Having a good process for managing security is important, but how many of us enforce that?
How We Ate Our Own Dog Food To Level-Up Internal Testing with Redgate Clone
Most applications have large and complex databases at the back end, making it hard for developers to adequately test their work before it goes out. Having a fast, repeatable process to deliver data on demand is an essential part of an effective software development lifecycle, ultimately leading to improved customer satisfaction. In this article, we’ll explore the journey our own engineering team went on to leverage our own tool, Redgate Clone, to spin up short-lived database instances in containers for automated testing.
Top 10 Methods to Improve ETL Performance Using SSIS
Extraction Transformation Load (ETL) is the backbone for any data warehouse. In the data warehouse world data is managed by the ETL process, which consists of three processes, Extraction-Pull/Acquire data from sources, Transformation-change data in the required format and Load-push data to the destination generally into a data warehouse or a data mart.
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers