A DDL Auditing Solution

  • wiseman82

    SSCommitted

    Points: 1635

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

  • valentijn.scholten

    SSC Journeyman

    Points: 86

    Sounds like a great tool.

    Will it remain free when a Final version is available?

    Thanks.

  • wiseman82

    SSCommitted

    Points: 1635

    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.

  • valentijn.scholten

    SSC Journeyman

    Points: 86

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

  • michael bourgon

    Right there with Babe

    Points: 751

    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!

  • wiseman82

    SSCommitted

    Points: 1635

    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

  • michael bourgon

    Right there with Babe

    Points: 751

    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.

  • michael bourgon

    Right there with Babe

    Points: 751

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

  • wiseman82

    SSCommitted

    Points: 1635

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

    Hope this helps,

    David

  • pavankumar1

    Newbie

    Points: 1

    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 10 (of 10 total)

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