@HannahVernon Two semi-legit use cases I've used it for: 1. The data handed to you sucks, is denormalized, and you're not allowed to change it prior to de-duping it. 2. With the FIRST_VALUE() / LAST_VALUE() window functions to get the first / last values of multiple columns, and am feeling lazy / don't want a second layer of code from enumerating the rows with ROW_NUMBER() before filtering on the results of that expression, and performance doesn't matter much in the use case.

I'm not saying to never use it, just that it's usually a red-flag when I see it during a code review.

kinda like when I see WHERE [some_datetime] BETWEEN @start_date and @end_date. That's just gotta go.

@HannahVernon Yea no doubt. Definitely agree, and same I usually find it as a red flag when I see other developers using it too lol.

Morning

Morning

Enabling Change Tracking on one table in QA takes 50 sec, and I have no idea why. It's not a SCH-M lock

@SeanGallardy r u on Mastadon?

It seems like the other processes are waiting on a sys.sysrowsets. Still no idea why it takes so long, but at least I found @JoshDarnell's blog post joshthecoder.com/2018/06/29/locks-on-system-tables.html

@JohnK.N. I don't have any social media at all

You have the Heap™

@JohnK.N. I know what it is...but sounds complicated

@Zikato change tracking was a mistake

@Zikato Hooray \o/

Makes me feel special.

no moderation here

beat it

moderation was a mistake

defend the moderators

amen

Large companies are the absolute worst

I have, of course, encountered places like that

One was v surprised at the amount of work they needed to do to switch to RCSI

If only there were some kind of global setting for isolation level

@SeanGallardy Yikes.

@PaulWhite I like how SQL Database has optimistic locking by default.

@PaulWhite connection strings i suppose

> Microsoft TEAMS may also affect the quality of the broadcast

lol

I'm going to go out on a limb and say the fact that there are about 72 anti-virus/process inspectors/egress prevention/anti-malware suites running on each workstation is not helping either.

@HannahVernon 😂😂😂😂😂

talk about a time suck lol

@ErikDarling I wasn't thinking of that, just setting the isolation level once at connection time as @Zikato said. Plenty of things ought to be set a particular way at the start. Isolation level is just one of them.

apparently we did 450,000 security patches in 2022

as if that's some kind of important metric

(I'm watching our year end report broadcast)

... wow

@SeanGallardy is there a way to get the password hash for a credential similarly to using LOGINPROPERTY([name], 'PasswordHash') as you would do for a login?

sqlpackage.exe is generating a CREATE CREDENTIAL statement when the password doesn't match, so there must be a way.

I'll ask the q. on main

Compare a credential secret against a known value

@Zikato its quite similar. Nice post btw

@PaulWhite that's a lot of words to agree with me man

You cannot set an isolation level in the connection string though

You seemed to be suggesting using the connection string. I'm talking about issuing a SET command after the connection is established

Look at us all agreeing using many words

I know many words. Big words. Best words. I am very smart

@Zikato okay

I'll send the invoice later

that's what i see skilled developers© use to take advantage of snapshot isolation in professionally crafted databases

That maybe so, but you can reuse a single connection string for all your app's database code. You still have to set each transaction separately

doesn't the jdbc driver allow for that?

one invoice at a time, please

couldn't find it here learn.microsoft.com/en-us/sql/connect/jdbc/…

@HannahVernon I've scanned the documentation and couldn't find anything

learn.microsoft.com/en-us/sql/connect/jdbc/…

@Zikato thanks for looking

that looks like it would do it, but i am not a skilled or professional developer

yeah, I stand corrected learn.microsoft.com/en-us/sql/connect/jdbc/reference/…

What are you all wobbling on about

still, it's not a connection string. It's a connection class

Calling a method on a connection object isn't the same as setting it at connection time in the connection string

Yeah, I think it's time for bed. Good morning everyone

Amateur developers. V unprofessional

Tears of a clown

you're v. picky with these things

sometimes

somethings

r gud enuf

That's heaps of words to say you agree with explicitly setting an isolation level for the connection but it can't be done in the connection string

ANYWAY

Putting NOLOCK hints on every object in every query is dumb and unnecessary

Like large companies

can you edit the transcript for me

so that last line says "r gud enuf"

and then delete all evidence

i don't wanna look dumb in front of mustaccio

very droll

apparently spelling that with only one l was a mistake

@HannahVernon Interesting, I'm not really sure. I don't think so, but there could be something.

I've only used that executable a handful of times, I'm not sure what it uses as its base

There is a modified date, that would have been my first go to

outside of that you're talking about grabbing the value from the sysobjvalues table

Which would require DAC

thanks for looking into it.

I appreciate the confirmation that it would be DAC; no way SQLPackage is doing that :-)

@SeanGallardy that's interesting though

:D

cheers

> i don't wanna look dumb

worry not, I wasn't looking

Nice room

why thank you

it has many available costumes and personalities for you to choose from

parasols are extra

I'll take 3

Expedited parasols even more so

@ErikDarling so how would you do something like that?

group on the grouped within group group group

row number works well

derp. i'll check it out