Hi Steve, no reports under home and not sure why I have sp_whoisactive in monitoring

Hi Steve, very useful posts around ADS, however, when I fire my ADS for a 2k16 SQL, in the monitoring part I have no "Server Reports" nor tempdb as you...

Hi, I am waiting for the next part as subject is very interesting, Is this series dead? Thanks

Thanks Wingenious, you can say Salam ELIAS instead of my nickname eliassal if you like 🙂

I agree with Wingeniuos,

yes indeed it iis a lot of work to add Collate in every equality, I started to look at it but then I stopped

Here is the output of the sql statement

Thanks for the info, very usefull. However, when I try to execute

QueryTracker

for a SP in a DB whaich has collation "French_CI_AI"and Server default same , master DB...

Hi Sebastian, you indicate I presume in this n1st item " In this short series of articles.....", can you please share the link to the other items as I cant...

I fully agree with DaveRogers as his suggestion works fine in PS 7 as well as PS standard which is not the case when using the suggested solution as it...

Hi Kenneth, I tried following your talk, my sql is 2016, I chose the sql template when I hit finish Powershell opens then it errors I see text in red...

Hi, well for a beginner it is not so much self explanotory. I have Excel on French reginol settings, the formula generates an error. I maneged to correctly issue the...

Erin, very interesting post. However, I followed instructions and XE session created but when I read the details of the output of the session, it mentions events without indicating the...

Great, got it, but shouldn't we have something like

0 > 45 days ago

X > Current

90 > 45 days in the future

so it might look like this

-45 > 45 days ago

0...

I tried the following but results confused me more, got only 0s and 90, how should this interpreted

Here is the modified code as your suggestion

            
May 25, 2021 at 5:41 pm
            
#3887848