Trace flag 902 in SQL Server and Error 574

What is Trace Flag t902?How to check trace flag in SQL Server? Read more →

How to capture SQL login details with Extended Events

An application owner wanted to record the usage of a specific logon and assess where the connections were coming from Read more →

How to capture deadlocks using system_health Extended Events

Find SQL Server deadlock details easily with Extended Events Read more →

How to find database objects created with SQL default trace

How can you find information about SQL database objects created? We're talking about CREATE DATABASE,CREATE INDEX,CREATE PROCEDURE,CREATE DATABASE. There are common scenarios where you may require these details. For example: 1) It is the organisation's sql server security policy for any production database to progress through a change request and review process. Monitoring database objects added , can identify developers attempting to avoid the review process. 2) Attempting to identify rogue processes. For example - software added to manage the server introduces new database processes - such as database tables 3) Troubleshooting an outage. An unexpected service impact occurs and... Read more →

How to get user security changes with SQL default trace

Question: There were some recent user security changes on a SQL Server login user account. Is there a way to grab this information - via the default trace? I haven't got a dedicated Extended events monitor set up - so I'm relying on the default trace . Management want to understand the details related to this security change. Answer: It is possible to report on security changes administered on SQL Server via the default trace. In fact - it's excellent - except if the default trace configuration is set up to rollover the files. Recently I had to use the... Read more →