April 19, 2012 at 12:01 am
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
Sounds like a great tool.
Will it remain free when a Final version is available?
Thanks.
April 19, 2012 at 12:45 pm
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
Thanks, we'll give it a try and let you know!
May 22, 2012 at 10:08 am
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
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
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
Howdy, David. Another question for you: how are you doing the DDL Snapshot? My guess is SMO, but wanted to be sure. Thanks.
March 8, 2020 at 10:44 am
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
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy