SQL Server 2008 has some great new features. One of them is the new auditing capability. Now we can audit at the server, database and table level according to specifications provided by the DBA.

SQL Trace is the heart of SQL Server 2000’s auditing capabilities. In fact, Microsoft resurrected SQL Trace, which had been downplayed in SQL Server 7.0, specifically to facilitate auditing.

When you enable C2 auditing, SQL Server automatically creates a trace file called audit_YYYYMMDDHHMMSS_ [seq].trc in the \microsoft sql server\mssql\data directory.

You can’t know whether a database is truly secure unless you know what data has been accessed, how it has been modified, and who has viewed it. Entegra — an enterprise-level auditing tool for ...

ManageEngine is demonstrating SQLDBManager Plus and its new SQL Server Audit reports in booth K4 at PASS Summit 2014 being held through Nov. 7, 2014, at the Washington State Convention and Trade ...

Eric Johnson, SQL Server MVP, is the owner of Consortio Services in Colorado Springs providing IT systems management and technology consulting. He is also the President of the Colorado Springs SQL ...

Auditing capability in Microsoft Windows Server has always been a somewhat unsophisticated affair: either filling up event logs so quickly that they truncate or spiralling out of control. Extraneous ...

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target. Logging is an essential feature for any application, as it ...