The Cost of the Cloud
Basecamp is leaving the cloud and Steve thinks it's a good decision. He also thinks the cloud can work very well for organizations.
Getting Started with Flyway Migrations on Oracle
A quick demonstration of using Flyway with Oracle, for those of a nervous disposition. We'll use Flyway to run some migrations on an Oracle Autonomous Database, building the initial version of the database then filling it with development data.
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.
Blogs
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers