New functions in SQL Server 2022 - LEFT_SHIFT and RIGHT_SHIFT
Learn about the new functions LEFT_SHIFT and RIGHT_SHIFT in SQL Server 2022 and how these functions could be used.
2023-03-20
Additional Articles
The business value of frequent deployments
The multi-million-dollar question for you and your business is... what is the real business value of frequent deployments? Part one of three in this series on the value of database DevOps.
2023-03-20
SQL Server .WRITE() Function to Update VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) Data Types
Learn about the SQL Server .WRITE function along with how to use this to update data in VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX) data types.
2023-03-17
What are the biggest challenges organizations face in their digital transformation efforts?
As part of a recent Redgate Summit which focused on data modernization, Grant Fritchey interviewed Pramod Sadalage, a Director at Thoughtworks. They discussed data and DevOps, and the typical challenges organizations come across in their digital transformation efforts. Grant Fritchey shares this Q&A.
2023-03-17
Optimizing Queries in MySQL: Optimizing Reads
In this blog, we’re going to walk you through how to solve the issues posed by that concern. At the end of the article, we’ll also walk you through some DDL operations to load test data.
2023-03-15
Recording What’s Changed when Running Oracle Migrations with Flyway
This article uses Flyway and a PowerShell framework to generate a simple JSON model for each new version of an Oracle database, and then compares models to get a high-level 'narrative' of which tables, views or procedures were changed by each Flyway migration.
2023-03-15
How to Install the AdventureWorks Sample Database in Azure SQL Database
Learn how to configure Azure SQL Database and setup the AdventureWorks database for code testing and learn how to use features of SQL Server.
2023-03-13
Join Redgate at SQL Bits, March 15-18
From castles and dragons to swordfights and spells, this year’s SQL Bits will have it all. Make sure you don’t miss out on our great sessions, from Code Errors to Reliable Releases, to adding some PostgreSQL skills to your repertoire. Come and say hi to us at the Redgate booth! Get 10% off registering with 10REDGATE.
2023-03-13
On-Demand Webinar - Monitoring: The ROI of Build vs. Buy
Missed our recent webinar on ‘Monitoring: The ROI of Build vs Buy’? Catch up on demand and find out the pros and cons to building a monitoring system versus purchasing one. Watch now!
2023-03-10
SELECT DISTINCT SQL Command to Return a Unique List of Values
Learn about the SELECT DISTINCT SQL command to return a unique list of values from SELECT queries along with several examples.
2023-03-10
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers