sql server 2019 & spark

https://cloudblogs.microsoft.com/sqlserver/2019/04/01/how-to-develop-and-submit-spark-jobs-to-sql-server-big-data-clusters-in-intellij/

 https://www.mssqltips.com/sqlservertip/3555/read-sql-server-transaction-log-backups-to-find-when-transactions-occurred/

https://www.sqlskills.com/blogs/paul/using-fn_dblog-fn_dump_dblog-and-restoring-with-stopbeforemark-to-an-lsn/

https://www.sqlshack.com/how-to-continuously-read-transaction-log-file-data-directly-in-a-sql-server-database-with-fn_dblog-and-fn_dump_dblog/

https://www.sqlshack.com/how-to-read-a-sql-server-transaction-log/

https://www.sqlshack.com/is-this-the-end-of-sql-profiler/

 

cdc

https://www.meziantou.net/sql-server-change-data-capture.htm

 

 

SELECT is_broker_enabled FROM sys.databases WHERE name = 'test'
ALTER DATABASE test SET NEW_BROKER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE test SET ENABLE_BROKER;

 

fn_dblog, fn_dump_dblog

 https://blog.51cto.com/ultrasql/1953572