sp_who2, the life of a lock…

23. Luglio 2019 Riflessioni, SQL Server 0
Locks are a incredible resource in a RDMS, but a nightmare where concurrency is high and lock retention is time consuming. SQL Server let sysdba exploring locks using sp_who2 stored procedure. EXEC sp_who2 return the list of active sessions and some information related to them, e.g. the related locks (who blocks and who is blocked). ...

But… is antivirus safe or unsafe?

10. Luglio 2019 Riflessioni, Sicurezza 0
Today a big surprise early in the morning: some virtual servers in our farm had a fault. All of them were implied in “loop without end” very similar to a malware infection. Windows Machines… updated… with antivirus updated… with antiexploit installed… with firewall on… but unusable. Symptoms: full use of RAM, both on poor amount ...