User profile for Josh Head

Hi there, Do you know if the email itself was ever sent by your email system? Did the alert show the ended time or did it just stay escalated at medium? / comments Official comment

Hi there, Do you know if the email itself was ever sent by your email system? Did the alert show the ended time or did it just stay escalated at medium?

0 votes

Hi there. I don't have the script mentioned, however in versions of SQL Server 2016 and later, you can do this: SELECT CONVERT(VARCHAR(MAX), DECOMPRESS(CONVERT(VARBINARY(MAX), CONVERT(VARCHAR(MAX), _QueryText)))) FROM data.Cluster_SqlServer_TopQueries_Instances That should give you the same result. / comments Official comment

Hi there. I don't have the script mentioned, however in versions of SQL Server 2016 and later, you can do this: SELECT CONVERT(VARCHAR(MAX), DECOMPRESS(CONVERT(VARBINARY(MAX), CONVERT(VARCHAR(MAX),...

0 votes

I went to the VM I have Redgate Monitor installed on, made sure I was logged in to Monitor, and then went to the link you provided. It installed fine for me. Do you get some kind of error when you try? / comments Official comment

I went to the VM I have Redgate Monitor installed on, made sure I was logged in to Monitor, and then went to the link you provided. It installed fine for me. Do you get some kind of error when you ...

0 votes

I would take a look at the documentation found here: https://documentation.red-gate.com/monitor14/automated-installation-and-updates-on-windows-239668713.html / comments Official comment

I would take a look at the documentation found here: https://documentation.red-gate.com/monitor14/automated-installation-and-updates-on-windows-239668713.html

0 votes

Hi Ed, SQL Prompt does not currently include a built-in feature to automatically expand or inline sp_executesql statements into their fully parameterized DML equivalents like you're asking for. If you'd like to make a feature request, I'd suggest visiting our User Voice site. / comments Official comment

Hi Ed, SQL Prompt does not currently include a built-in feature to automatically expand or inline sp_executesql statements into their fully parameterized DML equivalents like you're asking for. If ...

0 votes

The developers have identified the bug and are working on a fix. It should likely be included in the next release of SQL Prompt (current version is 10.16.6) / comments

The developers have identified the bug and are working on a fix. It should likely be included in the next release of SQL Prompt (current version is 10.16.6)

0 votes

I see the same behavior you are describing. It does appear to be a bug. I will get this over to developers to have a look. / comments

I see the same behavior you are describing. It does appear to be a bug. I will get this over to developers to have a look.

0 votes

What version of Redgate Monitor 14 are you using? / comments

What version of Redgate Monitor 14 are you using?

0 votes

Have you tried reinstalling SQL Prompt? This may restore the History options. The newest version is 10.16.5. / comments

Have you tried reinstalling SQL Prompt? This may restore the History options. The newest version is 10.16.5.

0 votes

I haven't been able to replicate the issue on my side yet. Can you try the newest version 10.16.5 and see if you have it happening there? / comments

I haven't been able to replicate the issue on my side yet. Can you try the newest version 10.16.5 and see if you have it happening there?