SQL Saturday Boston 2024 Plans
I was accepted to speak at SQL Saturday Boston 2024, which is taking place on October 5, 2024. One month away. This is a fun event that takes place...
2024-09-04
15 reads
Blog Posts
State of the Database Landscape Survey 2024
Hello all! This post is nothing but a simple request. Please, if you have a few spare minutes, meander on over to this link and fill out the State...
2024-09-04 (first published: 2024-08-13)
149 reads
Simple Talks Episode 5
The fifth episode of Simple Talks is out. Simple Talks is the Redgate podcast from myself, Grant, Ryan, and Louis. The main page is here, and it has links...
2024-09-03
41 reads
The Secrets of One of the World’s Largest Ad-Free Blogs
There are no secrets about how PostSecret handles millions of visitors.
2024-09-03
16 reads
The Secrets of One of the World’s Largest Ad-Free Blogs
There are no secrets about how PostSecret handles millions of visitors.
2024-09-03
9 reads
Using T-SQL Snapshot Backup - Point in Time Recovery - Azure Edition
Introduction In this post, the third in our series on using T-SQL Snapshot Backup, I will guide you through using the new T-SQL Snapshot Backup feature in SQL Server...
2024-09-03
22 reads
Building a Cost-Effective SQL Server Failover Cluster in Google Cloud Platform
Building a SQL Server Failover Cluster in Google Cloud Platform (GCP) is a powerful way to ensure your databases remain highly available, even in the face of unexpected failures....
2024-09-02 (first published: 2024-08-13)
276 reads
Expanding Northwind with Prompt+
I was trying to do a little testing of our subsetter and needed a larger database. So I decided to ask Prompt + to help me with a little...
2024-09-02 (first published: 2024-08-14)
198 reads
Using T-SQL Snapshot Backup - Are Snapshots Backups?
Introduction Traditional SQL Server backups can struggle with large databases, resulting in longer backup times and resource contention. T-SQL Snapshot Backup, a new feature in SQL Server 2022, addresses...
2024-09-01 (first published: 2024-08-31)
141 reads
A New Word: Flashover
flashover – n. the moment a conversation becomes alive and real, when a spark of rust shorts out the delicate circuits you keep insulated under layers or irony, momentarily...
2024-08-30
10 reads
Blogs
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Forums
Columnstore index question
Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but...
Transactional Replication
Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...
Member was not found in the cube when the string
Hey, I've not done a cube for many years but I find myself supporting...
Question of the Day
Identify a Slipstream Installation
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers