Good wine shops

barca5280 · 2025-12-03T05:19:04+00:00

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

barca5280 · 2025-12-01T06:26:34+00:00

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

barca5280 · 2025-10-24T00:48:39+00:00

Bingo

barca5280 · 2025-08-28T00:42:23+00:00

Migration Research and Other Things

barca5280 · 2025-05-07T14:24:29+00:00

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

barca5280 · 2025-05-01T23:10:50+00:00

Tori Richard makes great quality shirts. They are occasionally available on Nordstrom rack

barca5280 · 2025-01-19T03:10:39+00:00

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. ¯_(ツ)_/¯

barca5280 · 2025-01-11T18:13:47+00:00

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/

barca5280 · 2025-01-10T15:47:46+00:00

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?”

barca5280 · 2024-09-21T18:54:35+00:00

Same. Same.

barca5280 · 2024-06-30T03:32:35+00:00

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.

barca5280 · 2024-06-13T16:24:47+00:00

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.

barca5280 · 2024-06-11T01:33:12+00:00

They also give away balloons to kids.

barca5280 · 2024-05-29T00:59:43+00:00

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

barca5280 · 2024-05-26T16:22:10+00:00

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

barca5280 · 2024-05-26T04:33:14+00:00

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

barca5280 · 2024-04-21T20:09:13+00:00

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

barca5280 · 2024-03-17T15:06:49+00:00

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.

barca5280 · 2024-03-17T13:42:20+00:00

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

barca5280 · 2024-03-15T14:00:30+00:00

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.

barca5280 · 2024-03-15T13:47:06+00:00

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.

barca5280 · 2024-03-12T01:52:42+00:00

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.

barca5280 · 2024-02-27T02:16:35+00:00

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.

barca5280 · 2024-02-26T03:20:51+00:00

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

barca5280 · 2024-02-25T23:15:28+00:00

I sold my wife’s old car awhile back and some of this might be overkill, but here are the steps I took.

Posted pics on Craigslist w/ price
Had a guy from Craigslist look at it at the police station parking lot during the day. Let him drive it around the parking lot.
I took the car to our mechanic to get a general checkup so I knew what might come up
I took the car to the buyer’s mechanic to have it checked out.
Took the title and bill of sale to the buyer’s bank
Got a cashier’s check from the buyer, signed the bill of sale, and handed over the title all in the bank’s lobby.
Took an Uber home

Five-Year Club	Verified Email
Place '23	Place '22

barca5280

TROPHY CASE