DECLARE @sql as varchar(max)

SET @sql = ‘Select @@SERVERNAME DB_SERVER, NULL AS DB_NAME, NULL AS Table_name, NULL AS CDC_table_name, Null As Create_Date’

SELECT @sql=@sql+’ UNION ALL select @@SERVERNAME DB_SERVER, ”’ + name + ”’ AS DB_Name, sys.name COLLATE DATABASE_DEFAULT AS table_name
, cdc.capture_instance + ”_CT” as CDC_table_name
,cdc.Create_Date

FROM ‘ + name + ‘.sys.tables sys(NOLOCK) JOIN ‘ + name + ‘.cdc.change_tables cdc (NOLOCK) on sys.object_id = cdc.source_object_id’ +char(10)
FROM sys.databases
WHERE is_cdc_enabled = 1

EXEC (@sql)

SQL Server – How to write an Upsert using MERGE

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-execute-external-script-transact-sql?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-execute-external-script-transact-sql?view=sql-server-ver15

— ==== — Enable Database for CDC template

— ====

USE MyDB

GO

EXEC sys.sp_cdc_enable_db

GO

USE Test
GO
EXEC sys.sp_cdc_enable_table
@source_schema = N’dbo’,
@source_name = N’Sales_Test’,
@role_name = NULL,
@supports_net_changes = 1
GO

EXEC sys.sp_cdc_disable_table
@source_schema=’dbo’
,@source_name=’Sales_Test’
, @capture_instance=’dbo_Sales_Test’

metric list:

https://ga-dev-tools.appspot.com/dimensions-metrics-explorer/

https://stackoverflow.com/questions/951419/how-many-windows-handles-in-use-is-too-many

SELECT has_perms_by_name(null, null, ‘ALTER TRACE’)
EXECUTE AS LOGIN = ‘testUser’;
–Verify the execution context is now login1.
SELECT SUSER_NAME(), USER_NAME();
SELECT has_perms_by_name(null, null, ‘ALTER TRACE’)

REVERT;
–Display current execution context.
SELECT SUSER_NAME(), USER_NAME();

SELECT name,type_desc,is_disabled
FROM master.sys.server_principals
WHERE IS_SRVROLEMEMBER (‘sysadmin’,name) = 1

https://docs.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi?view=sql-server-2017