Post reply

A DDL Auditing Solution

  • April 19, 2012 at 12:01 am

    #255044

    Comments posted to this topic are about the item A DDL Auditing Solution

    DBA Dash - Free, open source monitoring for SQL Server

  • April 19, 2012 at 9:50 am

    #1476115

    Sounds like a great tool.

    Will it remain free when a Final version is available?

    Thanks.

  • April 19, 2012 at 12:45 pm

    #1476216

    valentijn.scholten (4/19/2012)

    Sounds like a great tool.

    Will it remain free when a Final version is available?

    Thanks.

    I don't have any plans to charge people for the application and it's unlikely that there will be a commercial version of the application in future.

    My website has a slightly corporate look/feel to it, but it was established in 2004 as a way for me to share some of the tools/scripts I've developed with the IT community. If people find my contributions useful great! 🙂

    This particular tool started life as a simple DDL trigger, capturing events into a table which I would query as and when required. This proved to be more useful than I expected which prompted the development of the GUI tool which I did in my spare time. I created the tool mostly for me, but I also planned for it to be used internally by our developers and to publish it later to a wider audience on the internet. I know other DBAs will have done similar things with DDL triggers - hopefully my tool adds a bit of extra value and also saves people from re-inventing the wheel.

    DBA Dash - Free, open source monitoring for SQL Server

  • April 20, 2012 at 1:18 am

    #1476447

    Thanks, we'll give it a try and let you know!

  • May 22, 2012 at 10:08 am

    #1491190

    Nice to see someone else working on DDL auditing via XE. Is it possible to get a copy of the code without the application? I can see how it'd make things easier, but for automation it seems easier to do it all via SQL/SMO+PS (to script out the initial set)....

    ah, just read that part. You will, just not yet. Okay, cool. Looking forward to seeing it!

    (Would love a copy of the XE code, though, as well as the SMO you're using to script out the database)

    Also: what is the actual link for the app? The install page has the prereqs, but I don't actually see the app. Thanks again!

  • May 22, 2012 at 12:17 pm

    #1491280

    michael bourgon (5/22/2012)

    Nice to see someone else working on DDL auditing via XE. Is it possible to get a copy of the code without the application? I can see how it'd make things easier, but for automation it seems easier to do it all via SQL/SMO+PS (to script out the initial set)....

    ah, just read that part. You will, just not yet. Okay, cool. Looking forward to seeing it!

    (Would love a copy of the XE code, though, as well as the SMO you're using to script out the database)

    Also: what is the actual link for the app? The install page has the prereqs, but I don't actually see the app. Thanks again!

    Hi,

    The download link for the app is on the top right of the screen:

    Are you referring to the database schema snapshot feature when you are talking about PS/SMO automation? The snapshot isn't required but it is useful if you want to have a point in time copy of your DB to compare changes against when the initial CREATE statements haven't been captured by the event notifications. If you have a large number of databases to snapshot this might be an administrative headache.

    I thought of adding an option that would allow people to snapshot multiple databases in one step. I also considered adding a command line option for creating database snapshots. I didn't get round to implementing either of these features, but they might make there way in to a future version of the app.

    I hope you find the tool useful - please let me know if you have any additional feedback.

    Thanks,

    David

    DBA Dash - Free, open source monitoring for SQL Server

  • May 28, 2012 at 9:40 pm

    #1493949

    Go me! I'm denser than usual, it appears. Thanks.

    Admin: yes. There's 30 servers and a couple hundred databases I'd like to cover. Anything that requires clicking is, honestly, not worth the trouble. But I'll give it a spin.

  • October 14, 2012 at 1:50 pm

    #1548966

    Howdy, David. Another question for you: how are you doing the DDL Snapshot? My guess is SMO, but wanted to be sure. Thanks.

  • October 15, 2012 at 1:11 pm

    #1549285

    Yeah - I'm using SMO to script the database objects.

    Hope this helps,

    David

    DBA Dash - Free, open source monitoring for SQL Server

  • March 8, 2020 at 10:44 am

    #3732269

    This reply has been reported for inappropriate content.

    this is the tool i was looking for. You can check my website on admit card here

    admit card[/url]

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply