This month’s T-SQL Tuesday topic is about extended events and comes from Jes Borland (B|T).
Like in most environments, we utilize a mixture of Windows logins and SQL logins. Over the years, the amount of SQL logins we use has grown. Knowing that it is a better practice to utilize windows accounts, we now want reduce the number of SQL logins.
So how do we do that? You could just disable the accounts and see what squawks, right? The other alternative, which is what we choose, is to enable several types monitoring, which will allow us to see which accounts are being actively used. Once we have a defined list, we can then weed out the inactive SQL logins as well as move the active ones to a windows account.