indeed, Jeff. Time flies when you're having fun ??

I hope there will be an occasion in the near future, when we have adapted to cope with covid-vnext.

It was a great session, Jeff

Good to hear you again 🙂

It will be good to hear you again. It's been a while for me.

I used to try to solve such quest from within TSQL, as some others suggest.

But nowadays, I keep it out of TSQL using Powershell dbatools !

#of course...

• This reply was modified 4 years, 3 months ago by Johan Bijnens.

btw Errorlog holds information about DBCC CLONEDATABASE !

ref: DBCC CLONEDATABASE (Transact-SQL)

https://dbatools.io/cms/

Clear-Host

$TargetPath = 'c:\SQL_CMS_Export'

Export-DbaRegServer -SqlInstance Your_CMS_SQLInstance -Path $TargetPath
 

explorer.exe "$TargetPath"

<# Results

Your_CMS_SQLInstance-reggroup-DatabaseEngineServerGroup-06022021131433.xml

#>

• This reply was modified 4 years, 3 months ago by Johan Bijnens.

Isn't CMS hosted in msdb?

You cannot put systems databases in an AOAG.

We always use

-- switch sqlserver logfiles (errorlogs)
EXEC msdb.dbo.sp_cycle_errorlog 

and

EXEC msdb.dbo.sp_cycle_agent_errorlog;

We do this in a single SQLAgent job, but in 2 steps, configured so they...

What disturbs me more is the fact that "will never share information" gets thrown overboard.

MS baught Whatsapp for its technology.

Instead of rebranding it to MSwhatever, they opt to keep the...

• This reply was modified 4 years, 3 months ago by Johan Bijnens.

keep min mind, a disabled job can still be fired using sp_start_job !

( it will just not be started by its coupled schedules or alerts )

Just in case you let...

• This reply was modified 4 years, 3 months ago by Johan Bijnens.

Nice article !

Check https://cloudblogs.microsoft.com/dynamics365/no-audience/2015/01/16/using-sql-server-extended-events-to-produce-a-blocked-process-report/

What have you tried ?

hierarcyId may have looked to be an interesting option, but ....

https://www.sqlservercentral.com/articles/hierarchies-on-steroids-1-convert-an-adjacency-list-to-nested-sets

https://www.sqlservercentral.com/articles/hierarchies-on-steroids-2-a-replacement-for-nested-sets-calculations-1

here is a nice ref:

by Brent Ozar

https://www.brentozar.com/archive/2020/10/want-to-use-columnstore-indexes-take-the-columnscore-test/

or direct https://columnscore.com/

Spot on, Jeff ! ??