T-SQL: Kill all inactive sessions from specific user

bschelst/ July 17, 2020/ SQL-Server/ 0 comments

T-SQL: Check status of automatic seeding

bschelst/ July 16, 2020/ SQL-Server/ 0 comments

T-SQL: size of replication specific tables

bschelst/ March 25, 2020/ SQL-Server/ 0 comments

On the distribution database, you can execute the statement below to get the sizes of the internal replication specific tables

T-SQL: check replication backlog

bschelst/ March 25, 2020/ SQL-Server/ 0 comments

You can use the code below on your distributor in order to check the backlog of the replication

T-SQL: Resume or suspend all always on databases

bschelst/ February 17, 2020/ SQL-Server/ 4 comments

You can use the t-sql code to resume/suspend all databases from the always on group.

T-SQL: only run job on primary node

bschelst/ August 26, 2019/ SQL-Server/ 0 comments

T-SQL: check seeding speed

bschelst/ August 26, 2019/ SQL-Server/ 0 comments

T-SQL: Getting lag for sync always on replication

bschelst/ June 28, 2019/ SQL-Server/ 0 comments

T-SQL: Getting lag for async always on replication

bschelst/ June 28, 2019/ SQL-Server/ 0 comments

t-sql : find schema modifications which occurred the last day

bschelst/ June 18, 2019/ SQL-Server/ 0 comments

In SSMS you have the “schema changes history” report. You can have the same (or even more) details from T-SQL. You can use the t-sql statement below in order find schema changes the last day, in a particular database.