Product Reviews

Stay Up on Current Events

Despite a few rough edges in the beta version, Entegra does a fairly complete job of auditing SQL Server activity.

Lumigent has just announced Entegra, a new solution for auditing activity in Microsoft SQL Server databases. I had a chance to play with a pre-release copy, so here are some impressions.

Unlike other auditing solutions I've seen, Entegra doesn't instrument your database with triggers. Instead, it uses the technology that Lumigent developed for Log Explorer to monitor the SQL Server log files, so it knows about every logged operation in the database. It then turns around and writes this data back to a SQL Server repository database (with an open schema, so you can layer your own report writer atop their data if you like).

The product is designed to audit DDL, DML, and SELECT statements, though the version I saw didn't include SELECT auditing (that's not expected to ship until Q1 2003 - they're also planning Oracle and Unix support in that timeframe). The DDL and DML auditing, and reporting through their web-based console, is impressive enough. Here's an example of what you can do: choose a row in a table, see its original state, and its current state -- and every state in between, together with the exact changes and when they were made.

Other features include alerting and monitoring, and the consolidation of audit data from multiple servers into a single repository. You can choose what you want to audit on the database, table, and action level, so you can keep routine and non-critical transactions from overwhelming the repository.

There were a few rough edges on the late beta copy I looked at. The program required a bunch of prerequisite software, and the install wasn't well-integrated. The reporting console also wanted to see a SQL Server login rather than integrated authentication, which I find distressing, given the well-known insecurities in SQL Server authentication. But the overall concept is great, and the ability to watch full audit trails of the data without modifying the database in any way is overwhelmingly cool. I can think of lots of times when I would have loved to have this, and there are plenty of obvious applications (healthcare, personnel, and other sensitive types of data). Assuming they get a little more polish on the product for release, this is one to watch.

About the Author

Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.


  • Phishing Tops Concerns in Microsoft Study of Remote Work

    Potential phishing attacks were a top concern of most IT security professionals when organizations switched to remote-work conditions early last year.

  • How To Configure Windows 10 for Intel Optane Memory

    Intel's Optane memory technology can significantly improve the performance of your Windows 10 system -- provided you enable it correctly. A single mistake can render the system unbootable. Here's how to do it the right way.

  • Microsoft and SAP Enhance Partnership with Teams Integration

    Microsoft and SAP this week described continuing partnership efforts on Microsoft Azure, while also planning a Microsoft Teams integration with SAP's enterprise resource planning product and other solutions.

  • Blue Squares Graphic

    Microsoft Previews Azure IoT Edge for Linux on Windows

    Microsoft announced a preview of Azure IoT Edge for Linux on Windows, which lets organizations tap Linux virtual machine processes that also work with Windows- and Azure-based processes and services.

comments powered by Disqus