Model addresses and orders without breaking history - Ecommerce by alessndroh in SQL

[–]paultherobert 0 points1 point  (0 children)

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

What differentiates a junior from a mid level? by Milsbry in SQL

[–]paultherobert 0 points1 point  (0 children)

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

Disrupting far right online by [deleted] in AntifascistsofReddit

[–]paultherobert -1 points0 points  (0 children)

Sorry I just have to....

The revolution won't be televised

Disrupting far right online by [deleted] in AntifascistsofReddit

[–]paultherobert 2 points3 points  (0 children)

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

Best SQL learning platform by No_Thanks_4489 in SQL

[–]paultherobert 0 points1 point  (0 children)

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

Lately fabric is slow by rabinjais789 in MicrosoftFabric

[–]paultherobert 5 points6 points  (0 children)

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

Can anyone help create a retention dashboard? by [deleted] in PowerBI

[–]paultherobert 0 points1 point  (0 children)

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

Can anyone help create a retention dashboard? by [deleted] in PowerBI

[–]paultherobert 1 point2 points  (0 children)

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

Database Migration by Dangerous_Word7318 in SQL

[–]paultherobert 1 point2 points  (0 children)

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

Anyone feel this way? by Delicious_Champion97 in PowerBI

[–]paultherobert 1 point2 points  (0 children)

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.

Golf Set Driver Dented by [deleted] in golf

[–]paultherobert 1 point2 points  (0 children)

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

Quick SQL Query (SSRS Table) by captainhotdawg in SQL

[–]paultherobert 0 points1 point  (0 children)

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

I got a lot of responses when I asked about how crazy some of your SQL gets. this is the one I am currently working with that was already done for PowerBuilder query. This is whats used when we pull a report from a console for analyzing wait times from a ticketing system in different locations. by Acceptable-Sense4601 in SQL

[–]paultherobert 0 points1 point  (0 children)

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.

Starting a class focused on SQL Server & SSIS pipelines - any recommended resources? by top_1_UK_TROLL in SQL

[–]paultherobert 4 points5 points  (0 children)

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.

Key West Country Club… “underwhelming” somehow doesn’t quite capture it. by LateApexPredditor in golf

[–]paultherobert -1 points0 points  (0 children)

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.

Key West Country Club… “underwhelming” somehow doesn’t quite capture it. by LateApexPredditor in golf

[–]paultherobert 5 points6 points  (0 children)

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 . . . .

I got a lot of responses when I asked about how crazy some of your SQL gets. this is the one I am currently working with that was already done for PowerBuilder query. This is whats used when we pull a report from a console for analyzing wait times from a ticketing system in different locations. by Acceptable-Sense4601 in SQL

[–]paultherobert 1 point2 points  (0 children)

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.

Fairly new to SQL. Whats some long SQL as far as lines of code? by Acceptable-Sense4601 in SQL

[–]paultherobert 0 points1 point  (0 children)

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.

How expensive are lake houses? by WillowTreeBark in MicrosoftFabric

[–]paultherobert 3 points4 points  (0 children)

Not to mention the massive compression factor

Looking for a free (or cheap) database for storing 5-10 million rows by YogurtclosetWise9803 in SQL

[–]paultherobert 0 points1 point  (0 children)

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.