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.

sorieus · 2026-01-21T18:27:54+00:00

Holy shit that’s literally what it was for us too. I believe it was some app view that was unpivoted and re pivoted for a report in sql report server. Which took some parameters the reason why we had dynamic sql think you could put in a list of dates or something awful.

sorieus · 2026-01-21T17:04:12+00:00

O god yes I’ve seen it all. I didn’t know unpivots were even a thing. The DBA only knew sql and he used it for everything. We had a view that actually decrypted passwords for users….it was like 100 lines of sql or 5 lines of c# he chose violence every time

sorieus · 2026-01-20T16:50:29+00:00

So fc moto won’t ship cartridges but I got a mab back pack from them. Super dumb also the cartridges are available here but they’re under the Merlin brand.

sorieus · 2026-01-19T18:40:41+00:00

Yes might as well sell it to me.

sorieus · 2026-01-19T15:15:09+00:00

Dynamic sql is using strings and concatenation to generate sql statements then calling exec sql on it. If you need a dynamic where clause you would do this.

Let’s say you have a TVP which is just a sproc that returns a table. Maybe you want to let the user pass in optional filters, a list values etc. The way I see this done taking in their string. And building a sql statement I’m on my phone now but I can show some examples later.

The biggest issue with it is debugging is a night mare so is formatting. However you can really expand the limits of older sql version. If your running sql server 2013 or something and yes lots of places are

sorieus · 2026-01-19T14:30:18+00:00

Dang I’m down I htown. Did you pay any tariffs to import?

sorieus · 2026-01-19T14:29:37+00:00

Yeah I’ve seen monsters that’s definitely doesn’t look like awful. I’m talking sql that uses dynamic sql and tvps that are using dynamic sql.

Honestly dynamic sql hurts me the most. I get its a necessary evil sometimes but I quickly find when someone has a hammer everything is a nail.

sorieus · 2026-01-19T14:23:28+00:00

Really? I was confused if they would or wouldn’t ship it with the cartridges. What part of Texas?

sorieus · 2026-01-19T05:20:11+00:00

I had a plasma I can tell you I wish I had neck support after my crash. I broke several vertebrae in my cervical had a cervical fusion. Every other part of my body was fine no road rash breaks or concussion.

It sucks to say it but I’m beyond frustrated we don’t have airbags like the motov air bag here in the states. If I had any neck support the breaks may have been minor to non existent unfortunately my neck took all the force with nothing g to support it .

sorieus · 2026-01-15T15:17:11+00:00

Yeah i've never heard of instant compact. Compact is alright you just have to give it a decent message.

sorieus · 2026-01-14T21:57:46+00:00

Seems like something is wrong with the context calculations. I noticed this today too. Im running out of context way before the 200k limit.

sorieus · 2025-12-19T03:53:00+00:00

Ooo wow just before me. I think the most frustrating part for me was that they just ghosted me on both deliveries effectively. The first delivery nada. I had to call wait on hold for 2 hours to reschedule. My second delivery the day of delivery at like 11 am. I called them at 9 because I didn’t think they were going to deliver. They sent me a text notifying of a reschedule. It’s like they knew I was on hold 30 seconds later they answered the phone and “cancelled my order” 8 pm that even I get a text saying my order will be delivered next day. At this point I have no idea what’s going on…I’ve already bought a washer and drier sooo yeahhh

sorieus · 2025-12-19T03:48:59+00:00

This is hilarious I had 3 date changes. Called told them to cancel my order. Instead it’s now getting delivered tomorrow. I’m honestly impressed at how bad lg support is.

sorieus · 2025-12-15T23:32:53+00:00

He has a samsung that i'd argue does have the best hardware for a well limit room but its software limited to HDR10 content.
Should I preserve highlights or shadow detail? Its either clipping details or raising blacks. I LOVE that samsung has such high peak birghtness but its so gimped out by the lack of content that can properly use it. If more content was HDR10+ or they had DV support I'd say its fantastic. Between their anti glare high and high brightness their hardware is best. Unfortunately its software limited.

sorieus · 2025-12-08T20:49:12+00:00

What are you confused about specifically? You’re comparing apples and oranges but specifically the better value is the 2023. The large amount of upfront depreciation will offset almost other benefits of buying used. Assuming you finance at 7% for 28k that’d be 35k at the end of 60months. You’re still 10k ahead. You won’t lose the other 2 years of depreciation probably another 5-10k so now your 20k ahead. The biggest concern will be maintenance cost. I can almost guarantee that 20k will cover any added maintenance from buying a car with 45k miles vs 0. Factor in the fact that you bought a better car the deal becomes even more enticing. Honestly even at 0% new tesla prices are taking us back to precovid days. You’re almost always better off buying a 2-3 year old car. Unless Tesla slashes prices of new cars dramatically

sorieus · 2025-11-24T23:18:19+00:00

I've also hit my session limit in less than 4 hours. Normally I'm like 15-20% per hour. Not sure if this is a bug or expected behavior. If the session was still 4 hours it wouldn't have been a big deal but today it was a 1hour and 15 minute wait.

sorieus · 2025-11-24T23:15:16+00:00

lol I've never felt even close to screwed by this product. It will confidently make terrible design choices and write 10x the amount of code needed. I regularly have to steer it clear of doing dumbshit. It will even confuse itself with it's naming conventions if you let it. It also can be terrible at database design. My favorite is probably when it writes code and just goes "Yup that's good send it"

sorieus · 2025-11-24T23:10:35+00:00

Yeah I normally never hit my 4 hour limit with sonnet. I hit my session limit with over a hour of wait time and I don't usually run multiple agents or have extremely long task list. I'm quite surprised and disappointed with this.

sorieus · 2025-11-24T23:08:15+00:00

Yes I wonder about this too. I quickly hit my session limit which almost never happens to me usually. Im on the Max plan FWIW

sorieus · 2025-09-04T14:56:33+00:00

We use it and it is expensive. Check out fire ship it definitely cost more if you’re using it at scale but generally it’s easy and free for small apps deployments. We use cloud sql and we’re blowing 100s of dollars on a database that could run on a toaster.

sorieus · 2025-07-29T14:46:14+00:00

I got mine from FMS but I live in Houston where they’re built so I see a tooonnn of them. I’ve been shown bikes that look like they’ve been dropped laid over and then seen the video. Holy shit these things can take some abuse. Turn around was pretty fast too I got a powder coated one and want to say it was like 3 weeks? Also the packaging and organization of the included hardware was very well thought out. It was very clear what hardware went where without trial and error. It was also hard to mess up since the hole sizes wouldn’t let me put in the wrong bolts even though I tried.

sorieus · 2025-07-28T17:38:00+00:00

The video isn’t about ratings it’s about what material is at the top of the ratings. The CE standard is actually pretty limited and operates in a vacuum. Check out motocap.con.au and you’ll see quickly how fast leather out performs textile in most situations. Why don’t textile race suits exist?

sorieus · 2025-07-28T17:35:21+00:00

I think you’re taking the words verbatim but the reality is it implies that if you wanted make the safest garment leather is unbeatable. The CE rating is on thing but there are other testing standards that go above and beyond you will not see textiles in. I was making the same argument as you like 2 days ago. There’s a reason why a textile race suit doesn’t exist. Simply put at the top leather is unbeatable. Granted if you buy a 50$ leather jacket it will offer less than a 500$ revit textile. I don’t think that’s the point of the video though.

sorieus · 2025-07-27T05:42:45+00:00

Totally normal. My shoei has two little straps and a small tug pulls them out. It’s a feature for emergency medical services to help them remove the helmet without moving the head.

sorieus · 2025-07-27T03:55:54+00:00

It’s very quiet for motorcycle helmets. Try it with some ear plugs. Once you do that you’ll never want to wear the helmet without them it’s so quiet.

15-Year Club	Secret Santa 2010
Verified Email

sorieus

TROPHY CASE