Morning

@McNets You have tonnes of that fluffy stuff now, don't you?

Morning

Morning all - Dia dhaoibh a chairde! Ice more or less completely broken up on canal now - not walking on it today! :-)

Lake here has frozen now.

@JohnK.N. Morning. What fluffy stuff?

The cold, white, powdery, fluffy stuff. AKA snow.

@JohnK.N. oh sorry. Yes, but not in my village. Filomena has been more active in central Spain. Curiously my mother's name was Filomena.

→ 1 message moved to Trash

We're now a balmy 8C with 10C forcast for Wed. and a semi-tropical 11C on Sat. next! No more walking on the canal for me!

I don't know about the sunny Ireland but this kind of forecast wouldn't exactly mean no more walking on canals where I live. We usually have very chilly February, so for any lovers of crepuscular perambulation on solid water here, there would still be some hope to indulge themselves before the end of the season.

Good morning

People will keep going out on the ice here until there are at least three articles of someone's car going through the ice and sinking to the bottom of the lake.

The more and more I'm trying to move this data off of one platform and into a new schema the more I'm convinced it was badly neglected and we need to return to the original files provided by the vendor.

There are far too many columns that have valid values for one time period, then disappear altogether... or substitute zero when it should be NULL or vice versa.

I JUST WANTED TO LIFT AND LOAD

Nothing as refreshing as indirectly finding bugs in someone else's code, eh?

Can be very invigorating in the middle of an otherwise dull working day

If it wasn't systemic within my organization. But there's just sort of a shrug when you come across this type of thing.

I remember mid 2000s we ran into an actual bug with SSIS. Once we hit a magical number of records (times data width) it was silently wiping the data in the final N columns. 1000 x 10 grid of data, no problem, 1001 x 10 - we'd get 1001 rows in the staging table but the last 3 columns were completely blanked out

Boss's boss is standing over my shoulder yelling at me wondering why it isn't working and I'm like heck if I know, you can see as clearly as I can that it's clearly a bug with the software. The architect pipes up - well, why didn't your test cases find this before hand?

This was a ... budget conscious shop. It was not uncommon to get yelled at if your estimated task look 15-30 minutes longer than you told the sales person who had already passed the estimate along as a firm commitment.

Cue me letting out a Rocket Raccoon style laugh youtube.com/watch?v=EKmKhOPbeRk saying that's hysterical that we have test cases

Bigwig: "I don't find that funny. I don't find that funny at all"

Yeah, the day that was bad got very much badder after that

I sure don't miss that place

Oof.

Afternoon all

Potentially going crazy here but, unless you're trying to restore a deleted database or have specified PITR, there's no way to see the backup files of a SQL Managed Instance?

I think you can only specify a time you want to restore to and that's it

I can't find a definitive "yes, you can" or "no, you can't" in the docs :|

@Shaneis think that question has more of a sql-community.slack vibe IMO, but maybe someone here knows

Yeah, good point Peter, I'll give it a ping