Manage Data Over Time with SQL Server MERGE Statement
Once data is in a table it needs to be maintained....
The Growth of T-SQL
I saw this tweet recently, where Richie Rump asked what has changed in T-SQL since the SQL Server 2012 version. A few people from Microsoft responded that there were changes in all versions, and while I think some versions have few changes, I decided to look. SQL Server 2012 introduced the window functions with the […]
What is ChatGPT – Is it the rise of the Skynet era?
An interesting conversation with the ChatGPT artif...
An Introduction to Assessing Normal Distribution with Python
This tip illustrates graphical and statistical tec...
How do your DevOps plans really measure up?
Digital transformation seems to be on the to-do list of every organization at the moment. Alongside it, DevOps is one of those buzzwords that gets lumped in, with some vague intention of having things automated. If you’re championing a DevOps implementation in your organization, or wish to see where your current processes measure up against your peers, read on.
Constant Learning
Yesterday, I had the opportunity, and the privilege, to attend an all-day workshop put on by Bob Ward teaching all about SQL Server 2022 (you can take this too, Bob is presenting it at SQLSaturday Austin and SQL Bits, and there will be more). It was a great day. Bob is an excellent teacher. Even […]
Join Redgate at SQL Bits, March 15-18
SQL Bits is coming to Wales, home of dragons and D&D, and we’re happy to announce we’re supporting them as platinum sponsors again this year. Meet us at our Red Keep and catch sessions by noble Fighter Grant Fritchey, Sorcerer Steve Jones, and more beloved Redgate Paladins and Druids. For a magical 10% discount on your ticket, use 10REDGATE from our spell book.
Steps to add a new disk to SQL Server failover cluster instance and move a user database to it
In this article, we look at the steps to add another disk to an existing Windows Failover Cluster used for SQL Server and also how to move an existing database to this new disk.
A Version Control Strategy for Branch-based Database Development
The migration to a different VCS should not be underestimated, as there is a lot more involved than just switching tools, and that’s what Tonie Huizer covers in this article.
First, the team needed to migrate the monolithic repos over to Git, second the team needed to make sure we had a branching strategy and workflow in place.
It involved a big process change for the team as well, but this switch is mandatory to make full use of branch-based database development.
Coaching the Digital Transformation
Helping your business get value from a digital transformation can start within your own team or group.
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Solutions for Environmental and Pollution Testing | Fare Labs Pvt. Ltd.
The state-of-the-art FARE Labs Environmental Testing Laboratory provides a broad range of testing services...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers