Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of http://www.SQLHub.com
In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace which is not the most intuitive tools. However in the latest editions, we are now given quite a lot of power for auditing with some purpose built tools. The SQL 2008 Audit is meant to be replacing SQL Trace, it is faster, more granular and easier to interact with from SQL Server Management Studio, and with code. In this article, I am using a T-SQL code approach.
Since this is one of the big topics in SQL Server 2008 (and bound to become more popular), it is not possible to cover it completely here. However, I will try to give you one detailed but simple example as an introduction to SQL Audit.
Well It’s been almost six and a half months I am helping the community via my own blog SQLHub.com and few forums, mainly Experts-Exchange.com and sometime Forums.Asp.Net. Today I thought to calculate about how many people I have helped in forums so just went to statistics and found that I have answered 936 questions in the area of Microsoft technology in Experts-Exchange.com and in forums.asp.net, I have answered approx 114 questions so far, so the total is 1050. In my blog SQLHub.com, I have written 225 articles till date and have received so many comments and 100s of emails from readers about appreciating my work.
Saturday 11th July 2009 was really memorable day for me. I had an achievement in my personal as well as professional life.
I got married on 11th July 2008 and last Saturday I have completed one year with my beautiful wife who used to encourage me all the time to help community more and more.
One more achievement was that, I became “SAGE” in MS SQL SERVER zone in Experts-Exchange.com. “SAGE” is really one of the prestigious awards and I am proudly say that I have achieved it in just 3 months and 10 days.
I have joined Experts-Exchange.com on 26th March 09 but actively started participating by 1st April 2009 with 0 points. Right now I am about to complete 800,000 points in Experts-Exchange.com. Out of which I have more than 500,000+ points in MS SQL SERVER zone because of which I have been awarded with “SAGE” certificate in MS SQL Server zone. Apart from “SAGE” certificates, I have achieved few more certificates in Experts-Exchange.com. You can have a look at my profile in EE at:
In this wonderful moment I would like to thanks to my wife, parents and few of my friends in technical fields (Pinal Dave and Bihag Thaker) who always encourage me to achieve more and more, help community more and more. Apart from all these person, how can I forget my blog reader? You are really wonderful people and always send me suggestions for improvement. BIG THANK TO YOU ALL.
Hope to have co-operation from all of you and blessings as well in future and I promise that I will do my best to help community.
Thank you very much once again.