Stairway to Database Containers Level 2: Persisting Storage in Containers
The second level of the Stairway to Database Containers looks at the basics of persisting storage in your containers.
Stairway to Database Containers Level 3: Building Custom Container Images by Hand
In this next level of the Stairway to Database Containers learn how to customer a container and save the changes to a new image.
We Stink!
You know I have to say something about Crowdstrike. How could I not? Recovery for most people seems to be well in hand, but there are still places dealing with it. I was personally impacted because I was trying to fly home last Friday. While my airline and the airports I was flying through were […]
An Alternative (Better?) Method to UNPIVOT (SQL Spackle)
Normalizing or UNPIVOTing data may be improved by using this lesser known approach in SQL Server 2008 or later.
I may need to re-think the use of table variables
Table variables have been fixed in SQL 2019, so now I have to decide if I will use them again.
Migrate a SQL Server Database to a PostgreSQL Database
Learn about various options to migrate an entire SQL Server database to a PostgreSQL database.
Thinking About Technology
Steve is thinking about technology today, inspired by a developer/architect that asks some philosophical and moral questions of software.
Microsoft Fabric, the Land of Wizards and Trolls
In my previous article (What is Microsoft Fabric All About) I explained what Microsoft Fabric is, how it came about and whether it brings anything new to the data insights domain.
SQL Server 2012 Always On Groups and FCIs Part 1
Learn how to get a Failover Cluster Instance set up and configured with Windows and SQL Server. This is part of a series showing how to combine a Failover Cluster Instance of SQL Server with an Always On availability group.
SQL Server 2012 Always On Groups and FCIs Part 4
This is Part 4 of a series on Always On and FCI integration in SQL Server. In this article we will learn how to add the iSCSI disk storage to our SQL Server nodes and build the cluster.
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?