When Work Isn't Done
Today Steve looks at the case when one software developer finishes their work, but another doesn't. The challenge of reordering work is something that happens more and more as teams struggle to coordinate their efforts.
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.
Not Useless Features
There are some useless features in SQL Server, but Steve Jones wants to know which ones aren't and need investment.
SQL Server Central Is Upgrading Our Servers
The SQL Server Central database servers are being upgraded on Thursday, Nov 2.
Using Pipeline Return Value in Azure Data Factory and Azure Synapse Analytics
Learn how you can return data from one ADF pipeline for use in another.
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.
Batch Execution Mode on a Rowstore in SQL Server 2022
Batch execution mode is a new optimization feature in SQL Server. In this Article, we'll explore how Batch execution mode works and how you can use it to get faster query results on Rowstore data.
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.
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
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...
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