SQL SERVER - Interesting Observation of Logon Trigger On All Servers frontimage1

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

SQL SERVER - Interesting Observation of Logon Trigger On All Servers frontimage2

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

For SQL Server Emergency Help, you can reach out to me at pinal@sqlauthority.com with words URGENT in the email subject line for other services mention “Comprehensive Database Performance Health Check“.

SQLAuthority News – Summary of TechEd India 2009 – A Grand Event

TechEd India 2009 was undeniably a magnificent success! The 3-day grand event was adorned by delegates, sponsors, partners, customers, media as well as celebrities from cross the world. The event was marked by the CEO of Microsoft Steve Ballmer‘s keynote, Academy Award Winner Film Sound Designer of Slumdog Millioner Resool…
Read More

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.

Read More

SQL SERVER – Fix : Error : SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct to correct this problem. in a modal dialog with the title SQL Writer

I often receive emails from reader requesting solution to following error: “SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct to correct this problem.” in a modal dialog with the title “SQL Writer” While searching online there are…
Read More

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!

Read More
Menu