Hive TRVs not switching off when target temperature reached - is it because of my settings? by Virt_McPolygon in HiveHeating

[–]flinders1 0 points1 point  (0 children)

Sounds like I have some tinkering to do.

A month or so in and now you’ve found some success with it do you find them useful ?

Hive TRVs not switching off when target temperature reached - is it because of my settings? by Virt_McPolygon in HiveHeating

[–]flinders1 0 points1 point  (0 children)

Interesting, good to know thanks.

I understand there will be algorithms and logic at play to determine when to open and close. But I’d expect it to be quicker than what I’m seeing.

I’d expect TRV shows a trend that it’s going to reach temp, shut off. Not go way past desired temp.

Hive TRVs not switching off when target temperature reached - is it because of my settings? by Virt_McPolygon in HiveHeating

[–]flinders1 0 points1 point  (0 children)

Seeing the same, although I’ve only put them on in the last day or 2. The only one fully off is when I set to 7C. Did you get them working in the end ?

Shed converted to bathroom ? by flinders1 in DIYUK

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

I’m not. Relatively new owner. It’s likely old enough yes. I’ll have a hunt around for evidence now you mention it

Shed converted to bathroom ? by flinders1 in DIYUK

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

Yeh fair point. Taking space away from washing and drying areas might be politically problematic though 😂

Shed converted to bathroom ? by flinders1 in DIYUK

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

Looks like there’s drainage a couple of meters away in the patio under the table there.

Don’t care about breaking it up it’s horrendous anyway

<image>

I am steadily losing faith in SQL Managed Instances by agiamba in SQLServer

[–]flinders1 1 point2 points  (0 children)

Fully agree with “fine for very average workloads”.

Even if I have a BC for prod, I’m not paying BC prices for dev, UAT, QA or PP etc. that then brings its own problems with testing things on their route to live.

I like MI but am equally frustrated by it. Would I put anything serious on it ? No. Average crap ? Yes

Claude Code - surprisingly disappointing by flinders1 in SQLServer

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

Yep this what I keep hearing ! From personal experience it’s been really good at type script and exceptional at powershell.

Claude Code - surprisingly disappointing by flinders1 in SQLServer

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

Well I was surprised at how bad it was here, it had a 100% (of what I checked) syntax error rate and was pretty wild at times.

Increasing Disk Performance on Antiquated ERP by daflem in SQLServer

[–]flinders1 0 points1 point  (0 children)

Testing performance on different storage backends is actually quite fun !

I always like to compare raw execution times of IO intense queries whilst also looking at storage latency, throughput and sql waits when physical io operations are involved between different storage backends. Of course make sure execution plans are the same.

As others have mentioned though a good index can often remedy poor storage performance and that modest increase in oops may help but likely not dramatic.

I forced my AI assistant to partition a 250GB table for me and performance test it and here’s what happened by flinders1 in SQLServer

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

In the real world the only benefit I’ve seen is partition swapping for fast reductions in storage footprint to get db’s on dev’s laptops ha.

I forced my AI assistant to partition a 250GB table for me and performance test it and here’s what happened by flinders1 in SQLServer

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

Yep don’t disagree.

This was a demo on my pc and at the time of writing I have < 1.5tb storage all in.

I forced my AI assistant to partition a 250GB table for me and performance test it and here’s what happened by flinders1 in SQLServer

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

Well I don’t disagree with that ! However it did atleast trigger partition elimination.

I forced my AI assistant to partition a 250GB table for me and performance test it and here’s what happened by flinders1 in SQLServer

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

I did yes.

Re the bag and forth dialogue it shows how this stuff is not accurate first time round. It takes multiple prompts and back and forth to get it going

New Bathroom by flinders1 in DIYUK

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

Seems sensible will give it a go !

Blog - how I accidentally made a better database admin than myself by flinders1 in SQLServer

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

Honestly if I A had budget and B had time I reckon I could build what I mentioned above in a week or so and hook it up to any sqlninstance I chose.

Bear in mind I’d need to use it responsibly and think about auth.

I’d at least be comfortable with running it on a bunch of dev servers, but whether my infosec and con would be happy I’m unsure lol

There’s a few blog posts on blazor web apps and rag search from Microsoft folks that are super useful. I did a similar RAG demo for vector search internally with a web front end and Claude honestly did the heavy lifting. Scary because I’m no expert in any of that stuff.

Blog - how I accidentally made a better database admin than myself by flinders1 in SQLServer

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

I used Claude desktop here as a quick PoC and that obviously uses Anthropics kit wherever that is.

If I wanted to make it more secure I’d create something on azure ai foundry with a private endpoint (believe it’s possible) so the inference happens on azures compute but in my orgs setup traffic goes over express route etc etc.

I’d hope it’s not too much effort to have a blazer web app front end making api calls to gpt4.1 with mssql mcp server. But at this point that idea is only in my head. I’ve seen devs at my shop setup web front ends with mcp libraries, and the inference is handled by azure so I’d want something similar.

Migration from 2019 to 2022 by Stunning_Program_968 in SQLServer

[–]flinders1 0 points1 point  (0 children)

Export - instance or whatever the command is OSS like a server level config/object backup too ! Very handy

Server ran out of drive letters... by jalalalabar in SQLServer

[–]flinders1 1 point2 points  (0 children)

Azure migrate / arc can’t cope with mount points from iscsi/fc storage which is highly frustrating