Monthly Archives: November 2024

Rename a Database: #SQLNewBlogger

I had someone ask me how to rename a SQL Server database recently. They were doing some development work and wanted to rename databases to test an application. I thought I remembered, but in this post, I show I learned … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Separate Reads

Recently I was watching a presentation on how to scale performance in your SQL Server environment and one of the suggestions was setting up Availability Groups (AGs) and having read-intent connections that would query the secondary and not the primary. … Continue reading

Posted in Editorial | Tagged , | 2 Comments

Simple Talks Episode 9–Data masking and subsetting

The episode on data masking and subetting is out. You can see it here: Youtube Spotify Watch and check this out. This is especially close to my heart as I’ve been pushing for subsetting from Redgate for a long time. … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Simple Talks Episode 9–Data masking and subsetting

Monday Monitor Tips: Tracking The Cost of Instances

One of the things that I’ve been asked in every operations situation is what licenses do we need for our servers. This is a rare request, often once a year, but it results in a bunch of work to figure … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Monday Monitor Tips: Tracking The Cost of Instances