The Heap™ – Consultancy ©®

« first day (5005 days earlier) ← previous day next day → last day (24 days later) »

Hannah Vernon

4:07 AM

Wordle 1,185 3/6*

⬛⬛⬛🟨⬛
🟨⬛⬛⬛🟩
🟩🟩🟩🟩🟩

Peter Vandivier

the frog standards in this chat have really gone downhill lately imo

i blame the children

Paul White

4:28 AM

Frog generation is significantly more difficult than is commonly realised

Top Men are working on the problem

5 hours later…

John K. N.

9:16 AM

Wordle 1,186 5/6*

⬛⬛⬛⬛🟨
⬛🟨🟨🟨⬛
⬛🟩🟩⬛🟩
⬛🟩🟩⬛🟩
🟩🟩🟩🟩🟩

Paul White

9:44 AM

Wordle 1,186 4/6*

⬛⬛⬛⬛⬛
⬛⬛🟨🟨⬛
⬛🟩🟩⬛🟩
🟩🟩🟩🟩🟩

2 hours later…

mustaccio

11:35 AM

> Driving On-Prem Performance Boost and Cloud Cost Efficiency for Netezza Workloads in the Gen AI Era

The stuff people do

Buzzword quotient goes through the roof

2 hours later…

Hannah Vernon

1:07 PM

Wordle 1,186 3/6*

⬛🟨⬛⬛🟨
⬛⬛🟨🟨🟩
🟩🟩🟩🟩🟩

Paul White

@mustaccio I asked Co-Pilot to rewrite that. It came up with:

> Enhancing On-Premise Performance and Maximizing Cloud Cost Efficiency for Netezza Workloads in the Generation AI Era.

Alanis Morissette - Ironic (Official 4K Music Video)

►

mustaccio

1:41 PM

Where did the driving go

AI can't drive

co-pilot my ass

also, "on-premise"

Paul White

Faulty premise detected

Also, Alanis is clearly driving

Finally, I think Gen meant Generative, not Generation

Thanks, AI

J.D.

2:46 PM

@SeanGallardy Oh wise Availability Group supporter, I have a question about Basic Availability Groups. Putting licensing aside, the passive secondary replica, is it literally physically inaccessible, while inactive? Or the docs use the term inactive loosely?

Erik Reasonable Rates Darling

the database in the bag would not be queryable

not the entire instance

J.D.

@ErikReasonableRatesDarling Welp my root question is, would it be possible to use that passive secondary replica's database as the primary in another basic availability group. I'm pretty certain the answer is no for a number of reasons, but the dumb people I'm talking to don't seem convinced.

Also nice name lol.

Erik Reasonable Rates Darling

expectations of "basic" are a bit much here

J.D.

I feel their expectations even exceed what AAGs are capable of at this point, but they're fixated on BAGs lol.

Paul White

What does it mean for a BAG to be 'inactive'?

J.D.

2:57 PM

@PaulWhite The secondary replica remains inactive unless there is a need to failover.

Paul White

I see, thanks

Erik Reasonable Rates Darling

@J.D. they’re not gonna be happy

J.D.

@PaulWhite 👍

Paul White

An unreadable secondary

Erik Reasonable Rates Darling

Is it MVP renewal season or did Aaron remember this site exists because of yesterday’s maintenance

Paul White

2:59 PM

mystery ghost

J.D.

@ErikReasonableRatesDarling Fortunately these are some randos, not someone I work with or anything...

Erik Reasonable Rates Darling

oh who should i invoice

J.D.

@ErikReasonableRatesDarling Send it to me, I'll forward it along ;)

Zikato

@J.D. I gues there is room for interpretation but the limitation list seems clear
No read access on secondary replica.
You may have multiple Basic availability groups connected to a single instance of SQL Server.
Support for one availability database

J.D.

@Zikato I agree they're clear. But the dudes I'm talking to seem to think "No read access on secondary replica" only means no read-routing via a listener. I'm pretty sure Microsoft means no reading of any kind lol.

Paul White

3:11 PM

Chuck Norris could read the database

J.D.

😆

Paul White

You could also write your own code to read the files on storage

J.D.

Technically correct is the best kind of correct.

Sean Gallardy

@J.D. Correct, you won't be able to actively use it as you would in enterprise edition with readable secondary replicas.

@J.D. You would not, no.

J.D.

@SeanGallardy Didn't think so. Sweet, ty sir.

Sean Gallardy

3:17 PM

Basic AGs are only there to be a drop-in replacement for mirroring. Whatever the restrictions on mirroring were, it's basically the same.

Erik Reasonable Rates Darling

made more annoying by fabric having a feature called mirroring

which is cdc+replication afaict

Sean Gallardy

Yup

Considering CDC doesn't scale, at all, and it easily overrun on performance... it's not a great story.

Zikato

currently dealing with CDC scaling as well. Do you have any interesting benchmarks, Sean?

Paul White

3:33 PM

Yeah, he lifted 2lbs once

But it's never been replicated

Erik Reasonable Rates Darling

cdc is still better than change tracking

Sean Gallardy

@Zikato It's essentially the same as the 2008 whitepaper when CDC first came out. The biggest things I can tell you to get decent throughput is have super fast log devices, keep transactions small, have enough cpu available, set the maxtrans and maxscans appropriately.

CDC, if you dig through the internals, essentially scans the log 3 times

Paul White

Loves a scalar function too

But realistically, scaling log changes is always going to be tricky

Sean Gallardy

yeah

Currently there are 7 phases though, which is a ton.

Also, if at all possible, don't interleave CDC enabled table changes in the same transactions as those without CDC enabled.

Paul White

It's almost as if the fundamental logging scheme wasn't optimised for these kinds of activities

Sean Gallardy

3:38 PM

Weird right?

Paul White

Massively weird

Almost as weird as scanning the log to build change tables for triggers

The good old days

Zikato

This one?
https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008/dd266396(v=sql.100)?redirectedfrom=MSDN

Sean Gallardy

@Zikato Ano

3 hours later…

J.D.

6:41 PM

In other thoughts, where should I travel to for one of my honeymoons? Planning to go right after US Xmas through the new year. Not sure if anywhere else in the world is still seasonally celebratory at that time.

Zikato

7:33 PM

One of your honeymoons?

dolphinaris.com/…

Cade Roux

8:19 PM

I'm all for the beach, preferably a tiny island where you can just sail around it yourself.

maps.app.goo.gl/gMqCX3D1USHSU9JKA

1 hour later…

J.D.

9:26 PM

@Zikato Yea we love to travel and found that going to Grand Cayman in December is the same price as going in February and somewhere else in December, so 2 trips lol. Plus we had a mini-moon already.

Dolphin jokes...on porpoise, har har.

Erik Reasonable Rates Darling

9:43 PM

NEVIS

But only if you stay at the Four Seasons

« first day (5005 days earlier) ← previous day next day → last day (24 days later) »

all rooms