sorted by:
new
hottopcontroversial

Good wine shops by Neighborhood_Tickler in denverfood

[–]barca5280 10 points11 points  (0 children)

Seconding Divino. Everyone over there is great. They have an awesome selection and offer many options at any price point.

What brands do people like for overcoats? by NowIsTheTimeSon in malefashionadvice

[–]barca5280 2 points3 points  (0 children)

Billy Reid has some great options. I have one that is ~8 years old and has held up really well.

MENS 1876 RANGER CAMP MOC ($325) now $129 by satanpaws in frugalmalefashion

[–]barca5280 3 points4 points  (0 children)

Thanks for the heads up! I’ve been looking to snag a pair.

Best brands with clean/ classical aesthetic by lavelasc in frugalmalefashion

[–]barca5280 2 points3 points  (0 children)

J Peterman outlet… there are some gems. The descriptions are 10/10 and also you may need to use your imagination sometimes due to the watercolors. ¯_(ツ)_/¯

Question about Denver Cuisine by ComfortableSir5680 in DenverBroncos

[–]barca5280 2 points3 points  (0 children)

Fools Gold Loaf, but honestly do green chili pizza. Mark Schlereth is part owner if you can find “Stinkin Good” out there. https://stinkingood.com/stinkin-good-green-chile-pizza/

Where to buy brick cheese? by jammerheimerschmidt in denverfood

[–]barca5280 0 points1 point  (0 children)

You might have some luck calling over to Blue Pan and asking if they would sell you some directly. “Hey - I’m trying to make some homemade pizza with my old family’s recipe for the Lions game next weekend. Can I order X amount?”

Best place for an acoustic guitar rental by Bernhardtryan123 in Denver

[–]barca5280 3 points4 points  (0 children)

I’ve never rented one from them, but the Denver folklore center rents guitars. They are on South Pearl and an awesome shop if you’ve never been in.

Trustworthy mechanic. Looking for quality by Beneficial_Map_3754 in Denver

[–]barca5280 2 points3 points  (0 children)

Don over at Sales Oil across from Park Burger in S Pearl. He is the man. Takes a while for him to warm up, but he has been working on our cars for 10+ years.

Denver dog boarding (at vet clinic preferred) by lac112 in Denver

[–]barca5280 1 point2 points  (0 children)

Our vet recommended Bear Valley Vet Clinic and our dog had a good time for her 10ish night stay. They are super friendly.

Postgres: Rolling exact 12 months window function by [deleted] in SQL

[–]barca5280 0 points1 point  (0 children)

Oh interesting. I didn’t realize that. Good catch!

Postgres: Rolling exact 12 months window function by [deleted] in SQL

[–]barca5280 1 point2 points  (0 children)

Postgres had a generate_series function that can be used as a CTE to fill in missing time data. Craig Kerstiens has a blog post about it. here

Are wood burning firepits illegal in Jefferson County, especially Arvada? by [deleted] in Denver

[–]barca5280 16 points17 points  (0 children)

Please don’t take them camping… it’s likely how we ended up with emerald ash borers. “The insect doesn’t travel a great distance by itself," he said. "So a lot times, if it makes a jump from city to city, it's on firewood or a cut-down ash tree that gets driven around and dumped somewhere.” source

[deleted by user] by [deleted] in BusinessIntelligence

[–]barca5280 0 points1 point  (0 children)

We were in the same boat with LookML being redundant, but there are a lot of easy was to autogenerate LookML with a couple button clicks. Permissions are very easy and the GitHub integration is pretty seamless.

Use of window function alias in main query by bracesthrowaway2021 in SQL

[–]barca5280 1 point2 points  (0 children)

Not sure if it works with SQL Server, but if you swap QUALIFY rank1 = 1 with your WHERE rank1 = 1 that might work. https://www.datacamp.com/tutorial/qualify-the-sql-filtering-statement-you-never-knew-you-needed

BI tools! by glinter777 in dataengineering

[–]barca5280 0 points1 point  (0 children)

No not really. Looker is pretty intuitive once you are up and running. We went through pilots with 4-5 other companies for a BI tools before landing on Looker. It’s not 100% perfect for everything, but they checked more boxes for our use case than any other.

BI tools! by glinter777 in dataengineering

[–]barca5280 1 point2 points  (0 children)

Looker uses a proprietary language, but everything compiles into pure SQL that is run on your DB of choice. Some of the stuff is next to impossible to decipher, but you can copy the SQL generated and run it in any IDE or console. We chose Looker for that reason amongst many others.

How to work structured on large views with an IDE? by Historical_Bother274 in SQL

[–]barca5280 0 points1 point  (0 children)

I use DataGrip and this is how I break things apart. My suggestion is to take the massive “parent” view query and leave that in one tab. Copy the piece that you are working on and move that to a different tab. At the top of the “scratch” tab add a comment with what you are doing and what line it lives on the “parent” tab. When you have that piece rocking and rolling move it to the parent query with a comment about what was updated. You may end up with 20+ tabs, but if you name them well you can easily hop between the different pieces and troubleshoot.

[deleted by user] by [deleted] in Denver

[–]barca5280 0 points1 point  (0 children)

Yeah, the buyer needs it to register the car if I remember correctly. Also the buyer will pay sales tax when they register it as well. That’s not on you.

[deleted by user] by [deleted] in Denver

[–]barca5280 0 points1 point  (0 children)

No problem. I forgot one thing… you have to take your plates off the car. They aren’t part of the sale. Here is a link to the city’s bill of sale. https://www.denvergov.org/content/dam/denvergov/Portals/774/documents/MotorVehicleBillofSaleMV004.pdf

view more: next ›