8,815 reputation
1668
bio website brentozar.com
location Chicago, IL
age 41
visits member for 4 years, 2 months
seen 16 hours ago

I make SQL Servers faster and more reliable. I'm a Microsoft Certified Master and Microsoft MVP.

Stuff I'm proud of:


Mar
18
comment Which databases can meet these replication requirements?
@dc2 exactly, speghettidba is right on. There's no one "right" way to do a design like this in MSSQL. It's like asking, "Can I build an app that does ___?" Modern RDBMS's have all kinds of features built in, including the replication features we're describing, but it's still up to you to combine those features, architect them, and load test them with your loads and hardware in order to get to the right answers. In theory, this design works great. In practice, it's a multi-million-dollar project. (I've been on these.)
Mar
15
comment Which databases can meet these replication requirements?
No, publishers are the original source of the truth, and they pass the list of replicated data off to distributors. Can MSSQL support all these things? Sure, but think about licensing: Standard Edition is ~$2k USD per CPU core. The project you describe would be millions of dollars just for licensing alone, even before hardware.
Mar
15
answered On Prem SQL Server: Log shipping via Azure Blob Storage: Possible?
Mar
15
answered Can SQL Server be configured to backup to a network share through a separate NIC?
Mar
15
answered Which databases can meet these replication requirements?
Feb
17
awarded  Nice Answer
Jan
23
awarded  Revival
Jan
13
awarded  Yearling
Jan
11
answered SQL profiler running on prod
Jan
11
comment SQL profiler running on prod
What's the problem that the experts are trying to solve?
Jan
6
awarded  Enlightened
Jan
6
awarded  Nice Answer
Jan
1
comment Paging performance with customizable sorting over many millions of rows
Achievement unlocked. @PaulWhite
Jan
1
revised Paging performance with customizable sorting over many millions of rows
Fixing typo - "fist" should be "first" - mostly just so I can say I fixed a Paul White answer, muhahaha
Dec
16
awarded  Revival
Dec
11
comment What is a deterministic method for evaluating a sensible buffer pool size?
James - generally speaking, I don't want to make changes that cause users to complain. If you do want to do that, you could gradually step down the amount of memory for each server until the users start to complain, but when I'm already overworked, I generally don't have time to take those steps. I have to focus on the tasks that will make unhappy users happy - rather than trying to make happy users unhappy. ;-)
Dec
11
awarded  Revival
Dec
11
answered What is a deterministic method for evaluating a sensible buffer pool size?
Dec
8
awarded  Necromancer
Dec
8
answered AlwaysOn Availability Groups log_send_rate