A First Look at Redgate’s Subsetter
I have been a proponent of subsetting databases in dev/test for a long time. It took awhile, but as part of the Test Data Manager that Redgate launched at...
2024-03-11 (first published: 2024-02-28)
299 reads
I have been a proponent of subsetting databases in dev/test for a long time. It took awhile, but as part of the Test Data Manager that Redgate launched at...
2024-03-11 (first published: 2024-02-28)
299 reads
A customer recently asked about using FKs in SQL Data Generator, and I decided to write a short post showing how these work. The Scenario I’ve got a copy...
2024-03-06 (first published: 2024-02-26)
258 reads
proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward to – opening a decisive letter, meeting up with a friend who’s finally back in...
2024-02-23
12 reads
I got this message recently while committing some changes: This post shows my work in adding Git LFS support to GitHub. Another post for me that is simple and...
2024-03-04 (first published: 2024-02-21)
162 reads
maugry – adj. afraid that you’ve been mentally deranged all your life and everybody around you knows, but none of them mention it to you directly because they feel...
2024-02-16
5 reads
A customer asked recently why Flyway doesn’t detect the filegroup for some changes. I showed them it does and decided to write a post on this. I’ve been working...
2024-03-01 (first published: 2024-02-16)
150 reads
For years I’ve assumed I knew the string defaults, but I realized that’s not right. This post looks at what I learned. Another post for me that is simple...
2024-02-26 (first published: 2024-02-14)
313 reads
It’s that time of the month for a new blog party at T-SQL Tuesday. This month we have Brent Ozar hosing, and it’s a good topic. I wondered what...
2024-02-13
32 reads
I saw a post that Flyway Desktop has a dark mode and I had to try it out. I’ve been working with Flyway Desktop for work more and more...
2024-02-09
13 reads
wellium – n. an excuse you come up with to rationalize a disappointing outcome – telling yourself that you weren’t in the mood for that sold-out show anyway, that...
2024-02-09
12 reads
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
This is one I haven't seen before. I'm trying to drop a database user...
I have a PowerShell script that I use to automate the backup of Analysis...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers