sp_whoisactive with transactions and more
Month: April 2022
envwhonow
sp_whoisactive with transactions and more in last ten seconds
envwhologin
activity by one specific user
Lonely Secondary Log Shipping
Have you ever had that rare situation where you need log shipping to another server, but have zero access to the primary server? I encountered that issue recently and my solution was two parts. A Secondary Log Shipping Target without a Primary. Pretty Cool. I had the need to consume transaction logs into a StandBy(ReadOnly)…
envwhoip
a whoisactive that also returns IP address
envwhodmv
dmv query like sp-whoisactive, includes IP Address
envwhodb
user activity in specific or current db
envwhobak
finds currently running backup or restore commands
envwhoami
colleciton of built in functions about you and your connection
envwho
sp_whoisactive with transactions and more