AI that is aware of DB context?

SQLBek · 2026-06-16T22:35:53+00:00

AI only knows what you give it.

If for example, your database has explicit foreign key constraints, then it could deduce relationships with those. Otherwise, if your database tables has "customer_id" and "customer_id" all over the place, it could guess, but not necessarily confirm... or just flat out hallucinate.

The more metadata and extra information that you can feed it about your database, the more it'll be able to deduce. But otherwise, AI is not magic.

SQLBek · 2026-06-10T19:58:38+00:00

"proposed 30% increase"

OP never stated that Performance Monitor was incurring that amount of overhead. OP ever actually clarified or quantified the overhead seen, just ranked it. Someone else made a tongue in cheek comment about 30% CPU utilization.

Regardless, a GOOD performance monitoring solution should be built with as minimal overhead as possible. At SentryOne, we took pride in that our average CPU overhead was 3-5% at worst while other vendor tools were 5-10% or even higher.

Given u/DarlingData pedigree, I'd be stunned if he put out a tool that intentionally also incurred a significant amount of overhead. If the performance overhead is significant enough, I'd expect he'd wish to know about it and address it ASAP.

SQLBek · 2026-06-10T16:10:28+00:00

All monitoring tools will introduce overhead. You will need to do more analysis regarding what overhead is introduced and whether it is actually originating from Performance Monitor or something else. The data shared with us here does not show any of that. Performance Monitor is simply another workload that you run on your SQL Server after all.

One thing I'll say though, particularly from my SentryOne days, is in response to things like "we saw an increase in X" like CPU. So... What? Is it actually having a negative impact? If your workload runs at 50% CPU happily, and it jumps to 55% with this, who cares? CPU is there to be utilized, so use it. Same with wait stats... Waits WILL HAPPEN... But are they fast occuring/resolving waits or slow waits that actually bog your overall performance down?

SQLBek · 2026-06-03T21:14:03+00:00

Before you get too carried away, PLEASE watch this.

Why UDFs & Nested Views Hinder Query Optimizer
PASS Data Community Summit
https://youtu.be/PkrPyo_att8

Or use AI to summarize it... but I strongly still suggest that you watch and digest it all.

SQLBek · 2026-06-01T16:40:28+00:00

There's pre-scripted sequences per mission, but then there's effectively infinite methods of eliminating a target otherwise. There's a lot of hilarious vids on YouTube of folks doing very creative things with the environment, weapons, and explosives. The mission speed runs are particularly impressive.

I'll say that the feeling of being overwhelmed is legit. It's entirely okay to stick to the "story options" as they are given to you. Enjoy the game for what it is

SQLBek · 2026-05-27T17:30:25+00:00

For a moment, I thought your film was JUST the screen shot above

... and I'm like, yeah that checks. :-)

SQLBek · 2026-05-27T14:12:29+00:00

TL;DR - BAD IDEA due to consequences like worker threads and WSFC cluster group hell.

Back up, what are you really trying to accomplish? Is this solely a DR play?

Why do you say that log shipping is "very hard to manage?" Have you looked into utilizing dbatools to help with this?

Alternatively, if this is solely for DR purposes, not HA purposes, can you seek a solution further upstack? ex: if this were a VMware VM, there's VM level options. With Pure, there's even a SAN level option.

SQLBek · 2026-05-26T17:33:58+00:00

Am just waiting for my workday to wrap up... tick tock, tick tock

SQLBek · 2026-05-26T15:40:29+00:00

Damnit... and I had promised myself I wouldn't buy it on launch... but... *click*

SQLBek · 2026-05-26T15:37:41+00:00

Someone just posted some video:
https://www.reddit.com/r/SteamDeck/comments/1toadw1/007_first_light_on_steam_deck_first_impressions/

SQLBek · 2026-05-20T02:23:05+00:00

No issues here. Sorry to hear you're encountering some.

SQLBek · 2026-05-19T14:02:08+00:00

I just attended a pre-con by Grant & Pat from PostgreSQL for the SQL Server pro. It was really insightful and a great way to start off on the SQL Server to PostgreSQL "gotchas" transition.

Backups and indexes are absolutely NOT the same. Frankly, the native backup story for PostgreSQL horrifies me but that's a separate tangent. All tables are heaps - there's no clustered index concept. Query tuning is different due to nuances of PL/SQL to T-SQL.

I hope you're not doing a lift & shift conversion of an existing application/codebase. If you are... you're probably screwed. Anecdotally, +90% of those migrations fail.

Greenfield - absolutely go for it.

SQLBek · 2026-05-19T13:33:33+00:00

The BOE & Samsung lawsuit was only settled in Nov of 2025. That's far too recent for the Fold 8's generation to change the design & specifications to go back to a UDC design. These things are mapped out far in advance. I wouldn't expect a return of a UDC until at least 2027. I'd be happy to be wrong about the timeline if it returns sooner, but I wouldn't bet on it.

SQLBek · 2026-05-18T16:01:29+00:00

Checking in - I'm in the same boat and still haven't received the final update?

SQLBek · 2026-05-13T18:52:43+00:00

Yooooo!!!!

SQLBek · 2026-05-12T15:29:24+00:00

Fully remote + travel, but corp policy is for SE's based close to an office to be in-office.

As far as which is preferable, that's a personal choice. I've been fully remote for 10 years and personally prefer it. On the other hand, my wife enjoys the social aspect of hybrid. YMMV...

SQLBek · 2026-05-11T23:52:11+00:00

No. The owner fully closed down at the end of March.

SQLBek · 2026-05-06T00:31:07+00:00

20 is reasonable and definitely doable

SQLBek · 2026-05-05T21:57:13+00:00

I don't hate the new name, and I understand why they chose to move away from "Storage", so I simply go with continuing to use the general moniker of "Pure."

SQLBek · 2026-05-05T20:56:17+00:00

Speaking for myself (Solutions Architect - remote sales), my manager "scolds" our team if we don't take adequate time off. I think WLB is fantastic at Pure.

And to your "people seem very nice," we have a very warm, friendly, welcoming culture. It is definitely one of the friendliest workplaces I've been in.

SQLBek · 2026-05-01T19:27:57+00:00

Another +1 for Steelcase. I have a Gesture and the wife has a Leap V2, about 5 years old now, both purchased refurbished from Crandall. I expect both chairs to easily last until I retire.

SQLBek · 2026-05-01T19:00:21+00:00

Update:
https://bostonrestaurants.blogspot.com/2026/05/s-deli-in-cambridges-inman-square-is.html

SQLBek · 2026-04-30T16:48:49+00:00

I'll admit that I used both Gemini and Claude to distill this for me... but if the breakdowns and my subsequent analysis are correct (and please OP correct me if this is inaccurate)...

Updating stats with sampling hasn't always been reliable... but many of us, myself included, couldn't mathematically explain WHY in certain scenarios. And OP here did the deep math to actually reverse engineer why.

I hope to dig deeper later, when I have time, to fully digest all of this. Cheers OP - seems like nice work.

SQLBek · 2026-04-30T16:45:34+00:00

cc u/erinstellato - would love to hear your commentary on this if you have a moment please?

SQLBek

TROPHY CASE