Data generation is the science and art of providing data for database development work that is as realistic and controllable as possible. The skills of generating realistic data are an essential part of being a database developer. It is important: you need plenty of data of exactly the right type, size and verisimilitude
I was at a customer this week (sorry, can't share who). I spent the day talking about Redgate Monitor and how it can help with query tuning, server management, and estate management. Through the day, the data pros at the company were sharing how they were managing hundreds of servers and several thousand databases. They […]
Setting up High Availability in SQL server has some prerequisites. One of these is that the database servers must be members of the same Windows Server Failover Cluster. In this article I show how to succesfully set up WSFC and activate Cluster Aware Updating
Monitoring and observability are becoming more important in today's 24x7x365 environment for applications. Steve asks what data helps you solve problems today. Tell us what's important to you.
In this article, we look at how to enable a large language model (LLM) to answer questions based on data stored in Azure SQL Database.
In this third level of the Stairway, we examine how to store your encryption certificate in the Azure Key Vault.
In this new article, we examine how to work with OneLake storage.
In the second level of the stairway to TDE, we examine how you can restore your databases on another instance after moving the encryption certificate.
The first level of the Stairway to TDE will explain how the feature works and how to set this up on one of your instances and databases.
When and where should you test code? Steve has a few thoughts when we consider the database as a crucial part of our software.
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
I'm trying to get this string_agg to put all the 'comments' into one result...
Comments posted to this topic are about the item Vectors in SQL Server 2025
Comments posted to this topic are about the item Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers