Anders Pedersen

Senior DBA, 20+ years experience.
Views are entirely my own unless stated otherwise.
He/him.

This profile dead. Same account name on Bluesky

[Anders Pedersen @arrowdrive]

25 years ago today I lost my wife Tab to suicide. Gone but not forgotten. If you are struggling, please talk to someone. Chat with me here (anonymity guaranteed). Seek professional help. Call one of the suicide prevention hotlines.

You are not alone.

[Anders Pedersen @arrowdrive]

@SQLGene It has been a about 180 days since the last rename, so your suggestion comes just in time

[Anders Pedersen @arrowdrive]

Well that says it all.

https://t.co/SUpOYv73Gn

[Anders Pedersen @arrowdrive]

@drsql Give all developers SA in production so you, the DBA, don't have to be woke up at night to fix their deployments

[Anders Pedersen @arrowdrive]

@sqL_handLe We had a Datsun on the farm.... A tiny little diesel pickup. Dang we abused that thing. One day has so many hay bales on the back we couldn't back it into the barn to offload it.

[Anders Pedersen @arrowdrive]

@sqlmal @PASSDataSummit FTE being paid to go

[Anders Pedersen @arrowdrive]

@sqlmal The Pepsi should have been a dead giveaway!!!!

[Anders Pedersen @arrowdrive]

@ashley_lucy10 Actually goat cheese and Nuggatti works well together

[Anders Pedersen @arrowdrive]

Nomm

Quick trip to Norway

[Anders Pedersen @arrowdrive]

@mmoengen @PASSDataSummit @EmilieRonning @cathrinew Yes! I'll be there, jet lagged like crazy!

[Anders Pedersen @arrowdrive]

@elbruno @shanselman Trondheim does not use any of the 3 special ones!

[Anders Pedersen @arrowdrive]

@engineering_bae On the other hand, that breach might have been big enough to save the US Postal Service!

[Anders Pedersen @arrowdrive]

@mipsytipsy @clairevo I talk to people above my position all the time. Straight up the line, to the side of my live, whoever needs to hear it. And likewise anyone in the company that needs my advice comes straight to me

[Anders Pedersen @arrowdrive]

@mcdowell_is @SenThomTillis I would guess he makes more money from big pharma than he does of us

[Anders Pedersen @arrowdrive]

@thatjeffsmith Getting a wee bit wet out here on the NC coast.

[Anders Pedersen @arrowdrive]

@engineering_bae And I bet your engineers don't have a problem talking with you either.

[Anders Pedersen @arrowdrive]

@GlennAlanBerry Well we did come up with a solution. Going to write up a blog post on it as soon as I get the AGs back up and running

[Anders Pedersen @arrowdrive]

In place upgrade from SQL 2017 to 2022. Towards the end failed with "Can't create backup directory at K:\MSSSQL\BACKUPS". Drive doesn't exist.

When server came back up, it was still 2017. And I can't upgrade to 2022 "No features to upgrade"
#sqlhelp

[Anders Pedersen @arrowdrive]

@GlennAlanBerry Yeah, I changed the default backup directory, then re-ran upgrade. That is when I got the "no features to upgrade" on the feature selection screen.

[Anders Pedersen @arrowdrive]

@AngryPets oh I do not disagree about not doing in place upgrades. Was against my advice...

The only thing the logs says is "failed to create default backup directory"