About Ajit

 

Ajit

Ajit is a Microsoft Certified Specialist in Big Data Analytics Solutions, Microsoft Certified Solutions Associate (Business Intelligence) and a Certified Scrum Master. He has a Masters degree in IT from the University of Technology Sydney and over 10 years of industry experience working with data in roles such as Data Architect and Tech Lead. He currently works as a Senior Consultant and Microsoft Ambassador at Servian in Sydney, Australia.

Advertisements

2 Responses to About Ajit

  1. Mark says:

    I am looking for a Service Broker solution that can track who is logging into all my servers. I do have a Central Management Server set up if that is an option. I need to track any user that logs into SQL using either an AD account that has sysadmin privileges or anyone who would log into one of my servers just using the SA account.

    Thanks

    • Hi Mark,

      You can make use of Logon Triggers (http://technet.microsoft.com/en-us/library/bb326598.aspx) and build them in such a way that they are able to detect users logging in with the roles/accounts you’ve described. These Logon Triggers can then make use of a variant of the Service Broker solution described in the article on my blog to log the audit details.

      You might want to make use of individual Service Broker instances talking to a single Service Broker instance on the Central Management Server so that you can keep track of the Audit Queue.

      Ajit.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: