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)
170 reads
Blog Posts
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
55 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
45 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
36 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
52 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)
379 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)
222 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)
177 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
30 reads
Developer Q&A: Dika Fei of Jelly Pixel Studio
"Let me know where you get your magic pixie dust from!"
2024-08-30
53 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers