Jeff Moden (12/1/2016)

---

Eric M Russell (12/1/2016)

---

Jeff Moden (12/1/2016)

---

Benki Chendu (11/29/2016)

---

Friends,

I have used Microsoft SCOM, HP Openview, BMC Patrol and a few more tools to monitor my database infrastructure..But currently, I...

One wrinkle I would add, however you build the deployment, SSIS or Powershell (I'd lean to Powershell personally), have that process create a script from the collection of ad hoc...

Might be a little confusion there. EXEC 'some query' is very easily hacked. What Gail teaches in that article is not.

But if you are asking about a SQL Server 2016 instance in the 2008 forum, if people here are not running 2016, as many are not, you're not going to...

If you want the trace to stop at a specific time. If you don't care if it runs forever, don't bother stopping it.

You would have to make a call to xp_cmdshell. It's going to be more than a little sloppy. Why not reverse it. Create a Powershell command that calls to the...

joeroshan (12/1/2016)

---

Bruce-12445 (11/30/2016)

---

Joe - it might be better to do both inner joins on the asset to attribute table which returns a match of 14,538 records a 40,355 difference from...

Everything Lowell says, plus check the system_health extended event session. It captures a whole bunch of behaviors, errors, etc., that aren't normally in the log. It could help identify the...

Just so you know, we're hosting SQL in the City as a streamed, live event this year. Check out my intro.

John Mitchell-245523 (11/30/2016)

---

There's no...

I don't see any protection against SQL injection with this approach. I'd be a bit cautious about it. You don't want to meet Bobby Tables[/url].

All the tool vendors will do this for you.

I work for Redgate software. I like our tool, SQL Monitor[/url]. It does all of what you're asking for and more. It...

Both queries went to Full optimization which is good. No timeouts. You have several scans and a key lookup on [DB1].[dbo].[ASSET_ATTR]. Those are my concerns. It means that the WHERE...

Ah, I didn't see the second post there, sorry. So, the correlated queries are running faster? Hmmm.... I'd want to see both execution plans to understand why.

Oh wow, it's a muck table[/url]. If you ever get a shot at redesign... this should be public enemy #1.

The first query is the preferred method. Not the second. It'll...