Just talking to an AD expert yesterday after I presented a session on SQLi. Evidently there is a "golden ticket" in AD that unlocks the kingdom. Without that, the answer...

Not a problem. Happy to help. Hopefully we hear from a few others as well. There is some degree of disagreement on this topic.

So, I work for Redgate. Take anything else I say with that in mind.

The whole purpose for purchasing a monitoring tool is to buy time. We're literally not doing anything...

Welcome to SQL Server Central.

It looks like the usual has occurred and you have  a couple of good answers to your question. Never hesitate to ask follow-up questions. We like...

Your query is working. I tested it running this:

SELECT *
FROM Sales.SalesOrderDetail AS sod
WHERE sod.SalesOrderDetailID = 432;

And modifying the index to [IX_SalesOrderDetail_ProductID]. It worked fine.

So, the problem must...

Here's the bad news. You need both. If logically the UserName value is the business defined identifying value, you should have a unique constraint on it. This is what is...

The information is captured in system tables. You just have to query those and you're off and running. Take a look at sys.jobhistory. Then, to only get the longest one,...

@Grant: Can you provide me an example on how to do that using Query store or extended events or any article that you can point out that would help...

I'm doing a precon at Columbus.

SPEND YOUR MONEY!!!!!

Here are a bunch of examples from my blog of using Extended Events to answer various questions. This should provide you with a bunch of what you're asking. I'll...

Ah, interesting use of the tools. Unfortunately, I don't know of a way to do it. I'm not saying it can't be done, just that there's not a way I'm...

Really curious what the use case and need is though.

One is for SQL Server version 2016 and the other...

I don't think you can because the hash is created internally based on a structure in the optimizer, not the T-SQL text, that would also have to be recreated. You...

There are built in metrics in Permon that you can use. Here's an article. Chapter 3 (or maybe 4, I forget) of my book also discusses monitoring the network....