Check out the solution in the video T-SQL: How To Audit Login Failures for checking what users have attempted to login and failed. This may be a concern relative to the architecture of our setup and if we are dealing with a less sophisticated hacker.
Some questions that are answered in the video:
For mastering data transformation from one form to another form, check out the highest-rated Automating ETL course on Udemy. For a coupon to the course, check out the trailer video on the channel SQL In Six Minutes.
Be careful about automation with this as we may see automation users that fail, not because of a hack attempt, but because of a user reset/password reset. This could generate false alerts that we react to when there is a legitimate reason for many user login attempts failing.
Are you looking for tech consultants that can assist with design and development? From building custom applications to working with existing infrastructure that's causing you trouble, we can get you connected to consultants who can assist. You can contact for assistance.
SQL In Six Minutes | Automating ETL | T-SQL In 2 Hours | Consumer Guide To Digital Security