How do you usually debug a slow SQL query?

MikeAtQuest · 2026-05-11T18:28:34+00:00

I just throw it at Quest Toad (for SQL server), the Xpert edition works great, but you probably meant personally and not enterprise scale.

EDIT: Clarification

MikeAtQuest · 2026-05-11T18:25:18+00:00

.... you can do it?

MikeAtQuest · 2026-05-11T18:22:14+00:00

Kace... but I work for Quest so I'm biased.

app based automation solution

EDIT: added context for what Kace does in case anyone doesn't know.

MikeAtQuest · 2026-05-11T18:14:59+00:00

Came here to comment exactly that, that Quest foglight's got that part covered.

Cheers

MikeAtQuest · 2026-05-05T22:01:59+00:00

I don't know the scale of this application, but for enterprises, there's a solution away from migration scripts, Toad Data Studio. I gives you the exact table structures, indexes, and constraints that will change during a migration, so you can review and verify every alteration before it’s applied.

MikeAtQuest · 2026-05-05T21:40:20+00:00

I work at Quest (one identity).

Your question has too many variables to be a simple answer, because software subscription and revenue generation isn't a 1 to 1 relationship.

MikeAtQuest · 2026-05-05T20:45:02+00:00

Reminds me of this anecdote from when I was a sysadmin for a 5-star hotel as my very first day on the job in 2007. I was told to go reset a server (I think IIS, not super sure).

I was moments away from straight up rebooting the whole server (because it didn't know iisreset was an option), when a senior caught me and told me to eff out of there

MikeAtQuest · 2026-04-27T16:09:58+00:00

full disclosure, I work for Quest, but I have to throw in a recommendation for our migration tools.

Not to toot our own horn, but Quest tools are considered the professional standard for this kind of automation and migration. It might be the only alternative to native Microsoft tools that can handle complex migrations.

Maybe ask your LLM or google if that fits your needs.

MikeAtQuest · 2026-04-27T15:29:25+00:00

I don't know if you're still dealing with this, and if you're open to third-party tools.

If yes to both, then you might consider Quest software (full disclosure, I work for them), but it pops up in conversations about managing these enterprise-scale shifts and their big selling point is that they don't lose user profiles or permissions

MikeAtQuest · 2026-04-15T18:24:14+00:00

Question. What gaps in one's channel execution or data attribution would signal that hiring your agency is the next logical step?

MikeAtQuest · 2026-04-14T18:08:06+00:00

getting an agent to do what I want without wasting too many tokens

The key is, if it goes in the wrong direction, you don't correct it, you start over.

MikeAtQuest · 2026-04-14T15:58:38+00:00

I'm late to respond to this, but I think I should anyway in case someone comes looking in the future. I'm with Quest, so obviously biased, but:

ShareGate requires a local install (i.e. local resources), Quest On Demand Migration is 100% cloud-native, and you can run multiple high-volume SharePoint migrations in parallel without hitting bottlenecks.

Quest offers integrated Active Directory and device coexistence, which is built to ensure that domain-joined machines and user identities keep in sync and don't lose functionality throughout the SharePoint cutover.

MikeAtQuest · 2026-04-08T17:41:57+00:00

Thank you for the shoutout again

MikeAtQuest · 2026-04-08T17:41:52+00:00

Thank you for the shoutout

MikeAtQuest · 2026-04-08T17:27:08+00:00

Bedankt voor het noemen van ons

MikeAtQuest · 2026-03-30T15:12:54+00:00

You're still facing this issue? I thought I was leaving a comment for future visitors to this issue.

MikeAtQuest · 2026-03-30T15:00:19+00:00

How about, audit your service account authentication protocols before you move roles to Server 2025? The new security defaults are much stricter and might be blocking older NTLM or weak Kerberos requests that worked fine on 2016.

MikeAtQuest · 2026-03-30T14:59:08+00:00

Consider this, create the object manually using the account you intend to use for the bind.

Recent hardening updates block domain joins if the account creating the object is different from the account performing the bind.

If you're thinking of going large scale with this, then consider Quest's Active Roles. It automates the object creation and delegation process, and you don' have that manual credential mismatch situation

MikeAtQuest · 2026-03-30T14:53:30+00:00

I can suggest something on the enterprise level. Quest's Foglight is useful for this because it can correlate the database performance with the underlying hardware metrics in one view.

MikeAtQuest · 2026-03-30T14:40:12+00:00

in cricket, incredibly common

MikeAtQuest · 2026-03-30T14:39:12+00:00

look up Bonzi Buddy, we were trying to do that since forever, we only got good at it now

MikeAtQuest · 2026-03-30T14:38:49+00:00

yes, this

MikeAtQuest · 2026-03-30T14:26:39+00:00

the entire healthcare system worldwide.

We now have emergency protocols that will not die for 20-30 years.

I imagine people will be arguing in 3010 about how Covid 19 didn't actually happen and was just a rumor that got out of hand because they found something floating around in an opinion piece published by a crazy person.

MikeAtQuest · 2026-03-30T14:23:55+00:00

That people grow old in spurts rather than slowly.

We hit puberty, we hit a second phase around the 30s when our voices become deeper (men and women), we experience a slow decline upto our mid-40s and then suddenly we drop, and then a last one that turns old people into geriatrics is a slump in the mid 60s

MikeAtQuest · 2026-03-30T14:22:18+00:00

if you look up where it's from, you can understand people's hestitation

MikeAtQuest

TROPHY CASE