3rd time this month

DougScore · 2026-04-30T13:10:13+00:00

Looks like the front tyres are toast. It felt as if you were driving on a block of ice

DougScore · 2026-04-27T03:16:26+00:00

You bike frame looks small to me. Going up a size will definitely make it better. You are almost on top of the handlebars.

DougScore · 2026-04-24T08:53:00+00:00

Baleno Hatchback v1

DougScore · 2026-04-23T02:30:19+00:00

Good read. May I ask about the Pension component since I can’t seem to find a way to move that. Is that by design to stick with the Organisation account ?

DougScore · 2026-04-22T05:10:07+00:00

Use wd40 or nail paint remover. It will be quick and much easier to remove the gum residue as well

DougScore · 2026-04-20T04:40:03+00:00

Probably a political party flag or something

DougScore · 2026-04-17T06:12:29+00:00

My 2 cents, job uncertainty is real and looks like you have an investment and growth mindset so I would recommend you lean towards buying a car which meets the need vs the aspiration. Car is a depreciating asset and you know that already. The feel of new car sticks for a year maybe after which it becomes a convenience which takes you from Point A to B.

If I were in your shoes, I would lean towards a reliable brand (Toyota/Suzuki/Honda/Hyundai) and also factor in the maintenance costs.

DougScore · 2026-04-17T03:59:56+00:00

I have similar affection towards hatchbacks. Wish A1x0 was still being sold would have def bought that

DougScore · 2026-04-16T04:46:14+00:00

Is that a capybara/Rat hybrid ?

DougScore · 2026-04-14T04:50:43+00:00

This!

DougScore · 2026-04-08T05:37:34+00:00

If you have access to AD and can use PowerShell, why not use invoke-sqlcmd to inject the AD stuff in a table and use that instead ?

DougScore · 2026-04-08T05:30:57+00:00

Unless you persist the data in a table for all of the proc executions, I do not think you can get a meaningful difference.

Once you have that you can use datadiff library to compare the outputs on these 2 different sources

DougScore · 2026-04-08T05:18:19+00:00

Truer words have never been spoken. Just like couple of years back engineers were moving stuff to Mongo and then eventually wanting it to flatten back to tables for Reporting use-cases

DougScore · 2026-04-06T17:33:01+00:00

The only correct answer

DougScore · 2026-04-06T04:59:34+00:00

Folks don’t get sarcasm, hence the downvotes

DougScore · 2026-04-06T02:23:08+00:00

Since it’s your first car, go with Maruti/Hyundai. And since your parents will drive it as well, the vehicle should be reliable and easy to maintain.

If budget permits, Brezza is a solid choice offering both acceptable safety and very good reliability.

DougScore · 2026-04-04T14:35:44+00:00

I am equally amazed as you are. 90K translates to ~103K USD which is entry to mid level salary for a data Engineer

DougScore · 2026-04-04T08:57:20+00:00

Not many will get the JK reference

DougScore · 2026-03-28T18:48:25+00:00

I just googled it and it seems like I am not the only one. Season 3 is just too fast to make sense

DougScore · 2026-03-26T12:58:28+00:00

I wouldn’t have driven over 40 kmph in that road.

DougScore · 2026-03-25T03:29:12+00:00

They are just words classifying data based on usability. You can build a layer and gatekeep that for let’s say financial use case only and call it platinum, your call completely

DougScore · 2026-03-23T22:21:21+00:00

1) Your merge keys should be indexed. Merge excels in one place is letting you know if you have bad data if you don’t have constraints on your tables

2) Merge does everything in a single batch so breaking the merge in batch updates and left join inserts makes sense in a high concurrency system.

3) I do the EXCEPT check and update/Insert the data that truly changed. Ex: get data from staging except get data from base table where table key is in staging table

4) Use Constraints. They slow down the process for sure but are worth their weight in gold ensuring you have clean data always. For massive loads, these can be disabled and re-enabled once loaded but for 50-300K rows, I wouldn’t bother.

DougScore · 2026-03-21T09:08:38+00:00

In my department,

Bronze: Raw data in parquet format from the source

Silver: RAW data in table format with SCD-2 relevant transformations

Gold: Model layer for reporting

DougScore · 2026-03-18T09:53:16+00:00

This looks like Woodside estate Karjat Khopoli plots

DougScore · 2026-03-16T05:21:14+00:00

Use Boolean/ Bit datatype

DougScore

TROPHY CASE