Blog Archives

Default trace security auditing [SQL Server]

The Default trace enabled can provides us valuable information about the running server, but it isn’t well-documented. What is the default trace? The default trace is enabled by default in SQL Server and is a minimum weight trace which consists by

Tagged with:
Posted in Scripts, Security

How to Monitor AlwaysON – Primary / Secondary Replicas on SQL Server

Last month I developed a procedure to run in a SQL Server Agent Job, to monitor the synchronism status of the AlwaysOn Availability Groups. In case of “NO HEALTHY” status, the SP will send an email providing details of every

Tagged with: , , ,
Posted in Alerts, AlwaysOn, Scripts, Security

How to identify the last objects created or modified in all databases

The script provided below, shows every modified and created events in the last 7 days.

Tagged with: , ,
Posted in Security, SQL Server Tips