I have a feeling that all entities in this chat are Paul's puppets; when he signs off, the chat just dies.

Wait...

Did he sign off?

No

Oh good, that's why I'm here

@HannahVernon That's returned from an nvarchar(32) field? Have you tried it on a Windows instance or just 🤢nix?

I'm not a puppet!

Sounds like something a sock would say tbh

I know right?

@SeanGallardy I have an Intel book like that. A really good read but also performs well as a soporific

@PaulWhite that -20 result was from Windows Server 2022

@mustaccio I think therefore Paul is. - The Cart

Morning

Service Borker

@PaulWhite It did take a while

Gosh doing that on mobile is awkward

we need better friends if we're #1 among them :)

Tried to make a Space Invader™

Space Invader after it was shot

🤣

Look at you all with your 1900's scores

meanwhile I'm trying to break 1600

@Zikato added

it's just for puzzles, not real games

Yep :)

While you were still learning how to spell your name, I was being trained to conquer chess puzzles!

probably

Haha yeah, that's an old movie

So uninstalling SSMS 18 broke SQL Prompt

I had to manually re-register textmgrp.dll to get it to work

Of course, I tried a repair on SSMS 19 first (and a reboot), which did not help at all

Still finding a few things that SSMS 19 didn't copy across

Always some drama with these things

The dll was in C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Automation by the way

I've seen it referenced somewhere. I guess it's a known issue

forum.red-gate.com/discussion/80803/…

so when you're switching over to the ADS?

SQL Assistant has an interface for re-registering the tool with whatever editor you are using

@Zikato Did you notice the last contribution there at all

@Zikato Next beach day in Hell

My obviously unrealistic expectation was that installing SSMS 19 side-by-side with SSMS 18 would go smoothly, and eventual uninstallation of 18 would not cause problems.

@PaulWhite yeah. but I didn't read it since it has 2 stars out of 5

I hope you flagged it

This question is protected to prevent “thanks”, “me too!”, and spam posts from new users

i've run into that a couple times, but only with the most recent 19 builds

the first 2-3 were fine

Yes, it seems specific to 19.0.2 (and older versions in history but not 19.x)

sort of a weird thing to suddenly stop working

but what do i know about computer science

I do understand their desire to get away from the special VS shell and complicated mess that SSMS became over the years. Incrementally releasing a worse replacement is probably the best option they had. I still won't use it until it's a direct replacement of everything I use SSMS for.

In the same way I understand why Extended Events exist and Profiler is only begrudgingly kept on life support.

I do try ADS from time to time, but it always disappoints. I try it less often as time goes by.

i've stopped trying with it entirely

It's weird because current Visual Studio is a lovely place to work with a very nice upgrade experience. It feels polished in the exact same way ADS isn't.

whenever i check the change notes nothing had been added that makes it more attractive

They get very excited about very slowly releasing things that SSMS already does better.

mom get the camera

I was asked for my input on adding execution plans to ADS. I found no way to frame a polite response.

I mean SSMS literally does it quite well already. Just do that.

nice that they asked you

Not really

i like when people still try to sell me on the plan explorer plugin for ads

like have you used it lately

It's like the emails I get from people v excited for me to contribute to their project that has no design and (more importantly) no budget.

@ErikDarling I succeeded in installing it a couple of times after much trial and error. It was not worth it.

@PaulWhite yeah, i get asked to review a lot of software for free

"we'll give you a complimentary license"

Yeah, well this is genuine consultancy-level work with a budget sufficient for a cup of coffee and maybe a plain biscuit

One gets kinda good at saying "no", but I still don't enjoy it

likely by people who have never done a day of consulting in their life

Billion-dollar companies with a $50 gift card IT&T budget

They'll happily pay 100K a month for cloud services tho

Anyway, yeah ADS continues to suck

oh yeah, i like to go fishing with those requests

"wow, that's really exciting, but it sounds like a lot of work. i'd imagine the total commitment would run around $25k. is that cool with you?"

You're so personable

that's what keeps the wine coming

Oh I get that it's necessary and works

On another topic, it's bizarre that creating community wiki posts requires 10 rep

that seems low

or high

if you're running a disposable comment converter sock

oh

can't you just moderate some rep to it

Not without breaking the law

THOU SHALT NOT INTERACT WITH THY SOX

i have 200 announcer badges

It's a bit stupid really. I can use el socko to convert someone else's comments to an answer, but then I lose the ability to vote on it

@ErikDarling That's a moderately high number

what's funny is the number of posts i have it for that haven't received any additional voting activity

I've got 31

maybe i need to record more youtube videos

@ErikDarling Yeah, I've seen you mention that b4

I suppose some of it is people without an account or enough rep to up vote

maybe

Most of it will be ungrateful bastards

People with no moral compass

Vampires

3

but enough about washington dc

heh

@ErikDarling Have you ironed that green screen yet

Steamed it w/e

yes it's quite taut these days

Unfortunate name.

SQL Server Agent not starting after in-place upgrade of SQL Server from 2012 to 2019

yeah, who would name a kid shanky

> this happens when using AOAG

Yes, indeed.

AOAG is the new VM problem

Was contained system databases a 2022 thing?

Yes docs.microsoft.com/en-us/sql/database-engine/…

yeah

it's a good idea

@PaulWhite Steam & Stream

> Each contained availability group has its own master and msdb system databases, named after the name of the availability group. For example, in contained availability group MyContainedAG, you will have databases named MyContainedAG_master and MyContainedAG_msdb.

how can i shrink my aoag

try icy water

be sure to wait at low priority

all this chatter about shrinking tempdb

wait until they find out what happens when you restart sql server

Another win

slam dunk

No log shipping as a target either, though

couldn't take the competition

It's a bit of a hack though really isn't it

how so

The whole master-or-msdb--but-not-really thing

Doesn't feel like a natural solution blending easily into an extensible architecture

I think I first saw checks for contained (master/msdb) in 2019 debugging

There's heaps of special case code all over the show

I wonder what was missed

Early days to hear about things using the 'wrong' master/msdb perhaps

eh yeah well most things are just tacked on rather than actually integrated into the product

hehe

could be worse, could still be a fucking comment but ok

@ErikDarling Like external tables, Java, and whatnot

I just found it amusing

Live look at SQL Server 2023 preview

wait until they decide to rename the master database

or memory-optimize it

but yes I'm surprised it hasn't been renamed in the current times

I suppose they'll've found some of the name dependencies just recently

I bet they don't name it primary

oh just ctrl + f for master and replace it with main in the code

it'll go fine i'm sure

yep, main is famously unused in code

French people will wonder what hands have to do with it I guess

just name it arnold

I knew he'd be back

ha ha

arnold;

time flies

Another crashed Space Invader™

Nice symmetry on the numbers though

6,5,6,5,6

how is your dag upgrade going

#2

WITH(DAGLOCK)

well who knew shit stuck to sheep asses would bring chat to such a grinding halt

thanks paul

does anyone know of a way to generate sql dynamically

what would you call that

if you had to give sql generated dynamically a name

tough one

Sounds like a case for *.

i'm sure jd will have a comment for them

@JoshDarnell i hear that's bad for performance because sql has to look up metadata

@JoshDarnell heh was thinking the same thing.

@ErikDarling it went very smoothly and completed in about 2 hours. One of the 12 or so databases refused to cooperate, so the secondary copies needed to be removed from both AGs, then I restored the log backups that were being dutifully taken during the upgrade, and simply added it back in to the AG. I did the DAG secondary AGs secondary instance first, of course, then the primary of the secondary DAG, then the secondary of the primary DAG AG, and finally the primary.

But too tired to comment, no worries Erik. 🙃

@HannahVernon does automatic/direct seeding work with a dag, or do you have to do all that manually still?

@ErikDarling Easy, add more cores for metadata lookups.

spoken like a true licensing rep

@ErikDarling automatic seeding worked like a dream for the most part

I have a query I use in sqlcmd mode that shows the status of the seeding restores, it cool to see it work

what's your deal with sqlcmd

@ErikDarling SQL-on-the-fly?

keep your zipper up pal

I'll probably get OP'd here. But I gave it a shot.

"We only import 70 of the 80 columns to dev"

@ErikDarling reminds of VB

@JoshDarnell at least you were nice enough to take identities into account

@HannahVernon thanks for making that spelling error free. A real 6/6* performance!

@ErikDarling I'm v. nice like that.

Imagine doing something dangerous outside a transaction

it's only dev

devs are people too

replicants

Hang on, we just need to reload dev because I accidentally

People like you would forget to register dlls all over the shop

No craftsmanship

DAGLOCKs

i do not traffic in dlls

you should know better

Wait til the recession kicks in

Oh man I forgot about that "I accidentally" meme.

"wait"

That always makes me chuckle.

me too 😀

For reference: knowyourmeme.com/photos/124764-i-accidentally

worth inlining I feel

HAHAHA

SWITCH would be even faster if applicable

i enjoy that one as well

lifts your spirits does it

@ErikDarling Hahaha I haven't seen that one.

I should go into fortune telling.

Or...misfortune, I guess.

what the heckin heckity heck does that mean

computed columns?

Oh that's a good guess. I was stumped.

the sound of chickens returning

🍳

> f you must do it this way - you can do a select from a virtual table INFORMATOION_SCHEMA.COLUMNS like this:

informatoioin

boioioioioing

twit-twooo

Yay! J.D. found time!

@JoshDarnell ok you've baited me into commenting

Prod and Post

Well, this question has been a big disappointment so far

shocking

truly shocking

Hey @Erik did you know dynamic SQL is "unmaintainable and prone to errors approach"

4u

4 owls

that account should be banished to the hinterlands

> I should have mentioioioned this is a graph table with GENERATED ALWAYS columns

You know, we should have some sort of reference as to how to ask query questions

Someone get on that

can we close this as tip o' the mciceberg

I'm kinda curious as to how bad the final crash will be

@ErikDarling done

Would be an easy close if it weren't for the eager beavers jumping right in

I am intrigued to find out about all the problems EAV solves

Hopefully someone will suggest a JSON schema soon

Or a lifehack for cleaning an oven

Seeing as we're going way of track

just use redgate schema compare

or something

do a devop

Has anyone visited the OP's website yet

i'm not clicking that

Gives one pause doesn't it

Yes, ok, paws

kudos for not skipping leg day i suppose

every day it seems

@PaulWhite He was just sticking up for me 😀

man, he seems stumped by all those comments

@PaulWhite I thought that was real for a second.

@JoshDarnell admirable, and the prime use for comments as we all know

@JoshDarnell excellent

It does need clarity. Let's close it for a bit

Entertaining as this all is

Ah no

I see the confusion

Chat was entertaining

Has it tho

Mod abuse!

Yep

@SeanGallardy > adaptors

Sean Special

adapters?

whichever

i feel like there's a affect/effect difference here

fewer/less

Nobody really knows

but i'm lazy

carry on

early adapter

That's a great def

> operative compatibility

That verb definition doesn't look quite right

> first-person singular present passive indicative of adaptō

@ErikDarling it lets me get results from all 4 SQL Server instances in SSMS grid output.

this was weird

@Lamak is that the answer?

Maybe adaptō is an aternative spelling

@HannahVernon that seems like a registered server/multi-query thing too?

MSX/TSX

@SeanGallardy 🤫

> adaptor n (plural adaptoare)

Really?

adaptoare sounds Italian

@PaulWhite I fucked up again

@ErikDarling yah but why though

it would give you "results from all 4 SQL Server instances in SSMS grid output"

@Zikato Sort of word you absolutely have to gesticulate for

Gives it a certain gravitas

I was looking for that emoji, but apparently it's not standard

ha ha ha

emojipedia.org/pinched-fingers

I had exactly the same link on my clipboard

adaptoare

That's the Apple one. Microsoft Teams gives us:

What is Homer doing

that's a microsoft auditor giving you a prostate exam

prostatoare

funny yous

Sean missed an opportunity there

@PaulWhite LOL nice one on that edit to my reply to your reply to me

@ErikDarling but sqlcmd mode is just so easy

if you say so

I was about to share my script with you, but it has capitalized data types, and I don't want to look more silly than I already do.

does ads support sqlcmd mode?

Who could know the answer to that without actually using ADS

and who would do that

maybe one of the professional developers in here would know

but it might be a selling point if it doesn't

actually it does make a rather nice runbook

> Come meet Angie from Bayab/Vusa and try these winning and well-priced Gins and a Vodka from the first Black-owned distillery in Africa. (Let that sink in). While they are distilled in South Africa, these are pan-African spirits using only African ingredients.

and some folks say white privilege isn't a thing

@PaulWhite you maybe interested in this one: oldtowntequila.com/bayab-orange-marula-gin

I know there aren't very many DBAs in here, but in case you're interested in the script that shows progress for Availability Group seeding, this is it:

SELECT
      [Server]                  = @@SERVERNAME
	, [Session_ID]              = r.[session_id]
	, [Command]                 = r.[command]
	, [Percent Complete]        = CONVERT(numeric(6,2), r.[percent_complete])
	, [Start Time]              = r.[start_time]
	, [Estimated Completion]    = CONVERT(varchar(20), DATEADD(MILLISECOND, r.[estimated_completion_time], GETDATE()), 120)
	, [Estimate Time Remaining] = FORMAT(CONVERT(datetime, CONVERT(decimal(10,2), r.[estimated_completion_time]) / 1000 / 86400), N'HH:mm:ss')

LOL TABS DETECTED

FUCK

Tabs, the best of all the whitespace

see how dumb that looks?

What a day to be alive

Looks good to me

it should be perfectly lined up

ok, no tabs:

Also interesting you're not using the seeding stats DMV

SELECT
      [Server]                  = @@SERVERNAME
    , [Session_ID]              = r.[session_id]
    , [Command]                 = r.[command]
    , [Percent Complete]        = CONVERT(numeric(6,2), r.[percent_complete])
    , [Start Time]              = r.[start_time]
    , [Estimated Completion]    = CONVERT(varchar(20), DATEADD(MILLISECOND, r.[estimated_completion_time], GETDATE()), 120)
    , [Estimate Time Remaining] = FORMAT(CONVERT(datetime, CONVERT(decimal(10,2), r.[estimated_completion_time]) / 1000 / 86400), N'HH:mm:ss')

@SeanGallardy yah I'm probably stupid like that in many ways

you're not stupid, come on now

some would undoubtedly disagree, but I appreciate the sentiment

I like this script because it shows ALL backup and restore activity, whether or not it's AG related

and it also shows you how far along your DBCC SHRINKFILE is, because you know we all do that all the time

lol

I'll show you some backup and restore activity 😄

twitter.com/zacbowden/status/…

@SeanGallardy pardon 🤣

Can it get any worser?

@JohnK.N. that is tooooo funny

search and replace gone wild

@HannahVernon LOL WAT?!

I go to get a screenshot of fancy backup and restore and come back to kicked?

Mod abuse no doubt

it wasn't me that kicked you

@PaulWhite 100%

👋

Thought you were gone for the day

Could sneak that in

@SeanGallardy Yep. You did

I'm a small child, what did you expect?

Everyone knows I have clones

@SeanGallardy I am also four

Paul started the clone wars, confirmed

🫳🍪🫙

So where's this fancy screenshot then

S/b got kicked

@PaulWhite It's all messed up now, I have to get it again

@HannahVernon i had written some dmv queries ages ago that use the direct seeding related doodads: brentozar.com/archive/2016/06/…