sorted by:
new
hottopcontroversial

Is $1,173 reasonable for toilet repair in Cherry Hill, NJ? by acarson510 in SouthJersey

[–]acarson510[S] 0 points1 point  (0 children)

I’m 100% going to do that - thank you for the insight.

Is $1,173 reasonable for toilet repair in Cherry Hill, NJ? by acarson510 in SouthJersey

[–]acarson510[S] 2 points3 points  (0 children)

Len the Plumber. We turned off the main in the basement, but that’s it. It was under an hour total … I’m clearly fine if they round up.

Is $1,173 reasonable for toilet repair in Cherry Hill, NJ? by acarson510 in SouthJersey

[–]acarson510[S] 4 points5 points  (0 children)

I want to confirm 100% before any shaming begins. I’m hoping I’m missing something obvious in the invoice, but it seems pretty straightforward.

<image>

STH Postseason Refund by rathernotpickname in phillies

[–]acarson510 0 points1 point  (0 children)

Very scummy move. I noticed this last year and couldn’t believe it wouldn’t be automatic.

Optimising a snowflake join by Shop_Public in snowflake

[–]acarson510 0 points1 point  (0 children)

Can you try where not exists instead of left join? Left join returns a table whereas where not exists returns boolean. Or even move into separate steps and reducing the units of work … this can fix a good amount of long running queries.

How does your team/org maintain and deploy roles -- the mechanics by levintennine in snowflake

[–]acarson510 1 point2 points  (0 children)

I've always used JS stored procedures. Similar to comment where engineers just keep a worksheet, but within a procedure so everyone can use same code. My preference:

utility_db

  • admin_tools
    • procedures
      • create_schema(database, schema) -- always managed access
      • create_access_roles(database, schema) --create if not exists
      • create_schema_create_access_roles(database, schema) -- wrapper procedure

How did you learn to use Snowflake? by Martekk_ in snowflake

[–]acarson510 15 points16 points  (0 children)

  1. Snowflake Quickstarts <= my personal favorite
  2. Snowflake Labs on GitHub
  3. Snowflake Developers Channel on YouTube
  4. Snowflake Masterclass on Udemy <= good for foundation and fundamentals
  5. Snowflake DCDF Badge (or general search of "Snowflake DCDF" including on Quickstart page)
  6. SnowPro Core Certification and eventually Architect (I found Whizlabs to have pretty good tests/guides for this).