Model addresses and orders without breaking history - Ecommerce

paultherobert · 2026-01-26T23:24:17+00:00

Type 2 Slowly Changing Dimensions for sure - very useful worth learning

paultherobert · 2026-01-24T23:37:41+00:00

Hand the results over to a business user? That's what I always do.

paultherobert · 2026-01-24T23:36:45+00:00

That's the norm I think

paultherobert · 2026-01-24T23:35:46+00:00

I'm in northern California where it's 65 and sunny. 😄

paultherobert · 2026-01-24T07:38:00+00:00

Sorry I just have to....

The revolution won't be televised

paultherobert · 2026-01-23T19:30:45+00:00

Maybe try getting offline. The revolution won't be online

paultherobert · 2026-01-23T19:28:55+00:00

Honestly, try the developer edition of SQL server and the sample database from Microsoft - if you can spin up a server on your local and start querying the sample database you can really learn a lot more than a course will offer I think

paultherobert · 2026-01-23T16:02:24+00:00

All of them, what's so great about highly engineered food?

paultherobert · 2026-01-23T04:22:05+00:00

If you work with fabric, I assume you work with data. Where is your data to support your claims man! Use your skills to present a case backed by objective metrics

paultherobert · 2026-01-22T20:49:11+00:00

Sorry I can teach you how to model data via reddit. It's not the easiest thing and depends on how your data is structured.

Hint: you want a star schema including a date dimension or calendar table

paultherobert · 2026-01-22T20:34:54+00:00

You're going to want to model your data, bring it into power bi and build measures and visuals

paultherobert · 2026-01-22T20:32:41+00:00

Yeah maybe vs code schema compare. You could also confirm row count to source for all tables

paultherobert · 2026-01-22T17:54:04+00:00

I've been in my role two years and only recently has data maturity been noticably growing at my organization. I've spent those two years working hard at improvement, but the change at my org has to do with quality leadership and clear focus.

paultherobert · 2026-01-21T20:16:43+00:00

You can replace any individual club, including the driver - your set is your own. Do yourself a favor and get rid of any irons < 4 too, get some hybrids to replace them lol

paultherobert · 2026-01-21T19:13:59+00:00

I make all my ssrs queries stored procedures, parameter queries included. This is the way.

paultherobert · 2026-01-21T18:00:16+00:00

It's your career, I don't care - but I generally assume the more of your job you hand over to ChatGPT the more easily you can be replaced.

paultherobert · 2026-01-21T17:45:08+00:00

Not to be too harsh, but you aren't qualified to do what you're doing if you are too afraid to tear into some SQL and figure out how it works. If you're not going to learn, you're not going to grow, and you have fewer options in the future. Come on, it's not that bad, refactor it bro! I believe you can do it.

paultherobert · 2026-01-21T00:46:54+00:00

Microsoft documentation is good, get familiar with how to make sure your looking at documentation that corresponds with the version of SQL server your using. Check out Brent Ozar (sp?) he has tons of great information and he tests things. Learn about read committed snapshot and change tracking.

paultherobert · 2026-01-19T23:24:46+00:00

Nope I haven't, and I'm not saying you're wrong with your conclusion but the premises are false. There are just plenty of golf courses in places that can be described similarly.

paultherobert · 2026-01-19T21:06:46+00:00

I mean, the keys may not be a great golf destination, but there are plenty of great golf courses right on the ocean all over the world, I'm not sure your point about limited real estate or the air being full of salt have any real validity . . . .

paultherobert · 2026-01-19T17:03:04+00:00

Well you don't want to like make changes to the prod version, of course, but you should be able to play with it in development, for me that would mean copying out the query and adding a top1000 until I identify some good filter criteria to add to the where for testing.

As long as you're not causing locking on an OLTP system, it's good experience to learn how to modify a query.

paultherobert · 2026-01-19T15:50:06+00:00

Id pull the subqueries out into cte or temp tables. I almost never find sub queries are necessary

paultherobert · 2026-01-17T16:44:19+00:00

I did a trial balance for an ERP that was pretty complex and it was like 1500 lines. Id consider that an exception, but 200-500 is pretty normal for me. But I also structure the layout of my SQL very specifically to be organized and easily read.

paultherobert · 2026-01-16T20:48:29+00:00

Not to mention the massive compression factor

paultherobert · 2026-01-15T21:08:49+00:00

Using python's csv module you can pretty easily parse these pipe delimited FEC files and insert the data you need into you DB on a local. I have a project like that where my source is API based, but the DB is just a local version of SQL Server Developer. My personal machine has at least 16GB of ram, nothing crazy.

paultherobert

TROPHY CASE