📅 September 2021
(3 posts)
📅 2021-09-29
✍️ Bart Schelstraete
The code below can be used to query the linked servers & the user assigned to them. select s.name, p.principal_id, l.remote_name from sys.servers s join sys.linked_logins l on s.server_id =…
Read more →
📅 2021-09-28
✍️ Bart Schelstraete
This guide, coming from Google, explains how to use a dynamic IPsec VPN tunnel with strongSwan on Linux. Step 1 : Configure BIRD /etc/bird/bird.conf # Config example for bird 1.6 #debug protocols…
Read more →
📅 2021-09-01
✍️ Bart Schelstraete
With this command you can check the number of transactions in the distribution database. SELECT count(*) FROM [distribution].[dbo].[MSrepl_transactions] where entry_time > '2021-08-31…
Read more →