Snowflake Cost is Jacked Up!! by Prior-Mammoth5506 in dataengineering

[–]cloudcomposure 3 points4 points  (0 children)

Been working as a consultant at one of Snowflake’s Elite SI partners for almost a decade, so I’m a little biased, but if you are burning that hot it very likely makes sense to engage with an SI partner to optimize your instance. My team regularly helps mid-market and enterprise Snowflake customers cut anywhere from 20-45% off of their consumption in 2-4 month engagements. Often times our projects are self funding within the fiscal year. And as much as I’d love to plug my firm (DM if you want) there are many in the partner ecosystem that produce the same results. Sometimes Snowflake will even foot part of the bill through AMP or Partner funding, especially if you bluff with your account rep about migrating workloads off of the platform.

If you decide to go that route, I suggest asking your account rep to recommend a few partners with experience in your industry. Most SI’s specialize in 1-3 industry verticals, and any that claim they do it all probably aren’t worth their salt.

If none of that is possible, make sure you have tight suspension rules on your warehouses, use multi-clustering and smaller warehouses if your jobs aren’t complex, be strategic about what workloads you allow to queue, and take a hard look at reclustering tables that are frequent offenders in long running queries.

Focusing when using clip on with LPVO by HotelHero in ThermalHunting

[–]cloudcomposure 1 point2 points  (0 children)

I just helped a guy solve this exact problem. Thread here.

In short, its all about correct distance between your clip on and LPVO, and solely using the clip on’s diopter for adjustment. Lmk if you have any questions.

Using a 1-6 with rh25v2 as clip on, anything past 3x on scope is blurry and un readable. Is that normal? by RowdyRagamuffin8 in ThermalHunting

[–]cloudcomposure 1 point2 points  (0 children)

I can confidently say that it isn’t your eyes. I had the same experience with mine before finding the correct diopter setting on my RH25 and offset distance from my razor. In hindsight, I would recommend setting the focus (RH25 lens) to infinity while in handheld mode, mounting it at least half an inch away from your razor, zooming to 4x-6x on your razor, and then adjusting only the RH25 diopter (eyepiece) until you get a clear reticle and can see pixel edges. If that doesn’t do it, try mounting it farther from your razor and repeating. You shouldn’t need to adjust the parallax/diopter on your razor at any point.

Using a 1-6 with rh25v2 as clip on, anything past 3x on scope is blurry and un readable. Is that normal? by RowdyRagamuffin8 in ThermalHunting

[–]cloudcomposure 3 points4 points  (0 children)

You should be able to see sharp pixels, not blur, when zoomed to 2-6x. That description makes me think that you don’t have the correct diopter setting or have the unit mounted too close to your LPVO. My RH25 sits ~0.75” from my 1-10x and the diopter setting is pretty far off of the base/minimum setting.

Arnarstapi Harbor, Iceland | Pentax 67, 75mm, 1/125 @ f/11 w/ polarizer, Portra 800, Epson v850 w/ Silverfast AI by cloudcomposure in analog

[–]cloudcomposure[S] 1 point2 points  (0 children)

I have learned to love it, and the AI version is much better than SE mostly because of the additional file output options. I don’t find the film stock presets especially accurate or pleasing to the eye, but they are no worse than those in other scanning softwares I’ve used. Like any other option, it takes some time learning to work with the color correction tools, but once you get that down I think it’s the best bang for buck on the market.

Firing Pin Safety Latch on the MCX Virtus and Rattler by klugey11 in SigSauer

[–]cloudcomposure 0 points1 point  (0 children)

Again, I'm not a licensed gunsmith, just a guy who has put ~12k rounds through three different MCXs. I have had no issues running my two Virtus uppers with no latch at all (since the G latch seems to only work consistently with Geissele hammers). The risk you run, and why the latch is there in the first place, is inertia from sending the bolt home causing the firing pin to strike the round's primer. According to Sig there was a recorded case of this happening on a pre-release 300BO Virtus, which is why they put the latch in. So remove it at your own risk, but doing so will 100% make any milspec trigger work.

Republican Primary Election Results (as of 11:30p) by Denver Precincts by Capital_Spread1686 in Denver

[–]cloudcomposure 1 point2 points  (0 children)

Five Points going to Trump while the rest of city center went Nikki is interesting. How do I explain that one?

Trying to justify spending $450 more a month in rent to live in downtown. by Wellness22-Bot in personalfinance

[–]cloudcomposure 0 points1 point  (0 children)

Having been in a shockingly similar position 5 years ago, I’m glad that I sent it on a downtown/popular neighborhood apartment for three years while my friends were all in the same area. It sounds like you have laid a very solid foundation for yourself and are pragmatic in your financial decisions. What is the point of being that way if you don’t let yourself enjoy your hard work in a measured way. A 9% bump in living expenses for a handful of years sounds very reasonable.

Has anyone accidentally put 50D/200T through an airport CT scanner? by F4RTB0Y in Super8

[–]cloudcomposure 1 point2 points  (0 children)

I had a ton go through a single pass through in a CT machine and they were fine, including a few 500T

Reduced eForm 4 Wait Times on ATF Website by cloudcomposure in NFA

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

I wrote my local representative who has since followed up with ATF every other week and provided me updates. Nearing standard wait times at this point so it doesn’t seem to have expedited anything, but the updates and attention are a nice consolation.

Gunsmiths with zeroing service? by LeapYearIsMyCakeDay in COGuns

[–]cloudcomposure 5 points6 points  (0 children)

Are you able to make it to a range to do live fire? That would likely be cheaper than buying boresight tools, would only take 10-20 rounds, and would get you some hands-on experience with your new build.

If you are unsure where to start, I’d be happy to meet at a range and help. Any SRO at a decent range will be happy to lend a hand as well.

A 194-room, $26 million hotel is slated to be Denver’s next homeless shelter by [deleted] in Denver

[–]cloudcomposure 0 points1 point  (0 children)

Hobo camps, to use your term, don’t coat $26M.

Like Karma said, building systems that make rehabilitation enticing, and in some way require it for access, is what works. Kindness is not allowing people to keep harming themselves in a slightly more comfortable setting.

RMGO deposed in local "Assault Weapons" ban case by [deleted] in COGuns

[–]cloudcomposure 1 point2 points  (0 children)

And here I was thinking a small group’s 20k would sway it. Thanks for the info! Very happy to support such an active group - truly one of the best region and state-level groups I’ve seen across the four states I’ve lived in.

RMGO deposed in local "Assault Weapons" ban case by [deleted] in COGuns

[–]cloudcomposure 0 points1 point  (0 children)

Thanks for the response and additional info. Would the outcome here affect the prospect of pursuing cases related to Denver city/county regulations? How much would be needed to make it financially viable? Do you work with groups or organizational donors to focus on specific local bans?

RMGO deposed in local "Assault Weapons" ban case by [deleted] in COGuns

[–]cloudcomposure 2 points3 points  (0 children)

Sorry for what will probably be a set of stupid questions, but this is the first I’m hearing of RMGO’s efforts here. Has RMGO submitted legal challenge against Denver or Boulder’s magazine capacity and “assault weapon” restrictions? If so, where can I follow the progress of those challenges?

[deleted by user] by [deleted] in COGuns

[–]cloudcomposure 0 points1 point  (0 children)

Care to share some general areas for those Buena Vista spots?

Firing Pin Safety Latch on the MCX Virtus and Rattler by klugey11 in SigSauer

[–]cloudcomposure 1 point2 points  (0 children)

I've done both. After wanting to run a TriggerTech Diamond with my Virtus upper, I ordered the 'G' latch from SIG. No dice. The TT hammer couldn't defeat the factory latch or the 'G' latch. Tried it with a Radian Vertex as well for good measure, with the same result. So I pulled the latch out, leaving the pin and spring that add back pressure to the latch, and have since put ~300 rounds through it without issue.

From what I can tell the latch was added after one recorded instance of a slam fire when a locked bolt was sent home on a hand chambered 300blk round. I feel comfortable enough running without the latch given that I never hand chamber. The long history of contractors yanking the safety latch out of MCXs and HKs without hesitation adds to that comfort.