The Scary DBA

Blog Post

Six Months!

Oh good gosh. Six months without a single blog post. Most important information: I’m not dead. Apologies. The issue is pretty simple. I’m getting old. Ha! Seriously though, I...

2024-06-17

10 reads

Blog Post

Query Store Reports Time Intervals

A great question came up over at DBA.StackExchange regarding the query store reports time intervals: How can SQL Server’s Query Store Reports show data for minute-length intervals, when “Statistics...

2023-11-24 (first published: )

232 reads

Blogs

Speaking at SQL Saturday South Florida 2024

By

I’m heading to SQL Saturday South Florida 2024 next week. This is my second...

The Next Phase & A Fresh Start

By

As of June 1, I am no longer an employee at 3Cloud. I am...

How do you restore a SQL Server 2000 database in the year 2024?

By

A discussion on LinkedIn led to this hypothetical “real world” question: Problem statement: I...

Read the latest Blogs

Forums

dbcc clonedatabase issue

By blom0344

I have used the 'dbcc clonedatabase'   schema-only backup procedure many times in the past...

The Secondary Database Name in an AG

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Secondary Database Name in...

Cloud Transformation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cloud Transformation

Visit the forum

Question of the Day

The Secondary Database Name in an AG

I am setting up a SQL Server 2022 Availability Group and I am ready to restore the database on the secondary. The primary database is named Finance. However, we also use this instance for QA and already have a database named Finance. How do I configure the AG to use a different database as the secondary?

See possible answers