Using Google Charts API to Visualize Schema Changes
Last week I have worked on the new email report using Google Charts and liked it so much that decided to share it here with anyone who finds it useful. I have a Schema Changes Audit table which is being maintained by the DDL Trigger. The relevant record is added to this table every time anyone changes objects on the server. Here is a report that I have generated using Google Charts absolutely for free and easily. If you are not familiar with the Google Charts, you can read my old post about it and how it works here . It is easy to use, very customizable and FREE. The above visualization is using Google Bar Chart. To keep things short, I am using Transact SQL to build an HTML Image tag. The above email body contains this HTML: http://chart.apis.google.com/chart? cht=bvg& chs=660x250& chco=CF9036,90062D,67E13B,82088D,319CBA& chd=t:0,1|1,3|3,2|18,5|4,8& chds=0,19& chxt=x& chxs=0,ff0000,12,0,lt& chxl=0:|Sep%202|Sep%