SQLAuthority News – Blog Makeover – New Banner – New Color
Just a month back I had previously changed my personal homepage and had requested for feedback from my readers here SQLAuthority News – Authors Website Redesigned – https://www.pinaldave.com/ – Feedback Requested. To my astonishment, I received a huge number of emails. But I received only one comment. This time, I would like to request my readers to leave your comments on my blog instead of emailing it to me. This will allow everyone to know about others feedbacks and the actions I take towards incorporating the feedbacks on my blog and a new banner.
SQL SERVER – Interesting Observation of Logon Trigger On All Servers
I was recently working on security auditing for one of my clients. In this project, there was a requirement that all successful logins in the servers should be recorded. The solution for this requirement is a breeze! Just create logon triggers. I created logon trigger on server to catch all successful windows authentication as well SQL authenticated solutions. When I was done with this project, I made an interesting observation of executing a logon trigger multiple times. It was absolutely unexpected for me! As I was logging only once, naturally, I was expecting the entry only once. However, it did it multiple times on different threads – indeed an eccentric phenomenon at first sight!