Thanks again for this useful post, however, when SP runs for 1st time, [DataUpdatedOn] is always null. I went through the 2 SPs but not sure I understand when this...

Dear James, I downloaded the zip file, created the functions, then ran the code in 04_GenerateSPs_Run.sql, I get right away

ErrorNumber ErrorSeverity ErrorState ErrorProcedure ErrorLine ErrorMessage

134 15 1 insertCommandLog 1 The...

Dear James, I downloaded the zip file, created the functions, then ran the code in 04_GenerateSPs_Run.sql, I get right away

ErrorNumber ErrorSeverity ErrorState ErrorProcedure ErrorLine ErrorMessage

134 15 1 insertCommandLog 1 The...

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...