Script uses undocumented extended stored procedure xp_readerrorlog to find failed logins (grouped) and last successful login
While a diminished level of control is certainly a factor to consider when contemplating migration of on-premises systems to Microsoft Azure, especially when dealing with PaaS resources such as Azure SQL Database, you have a range of techniques at your disposal that allow you to control and monitor both the status of and access to your Azure-resident services. One of these techniques is SQL Database auditing.
I've been charged with coming up with a quick solution to audit login changes on my SQL Servers. However, there's no budget so I'm going to have to come up with basic scripts and the like to do the work. Is this tip we cover a solution for you to audit login changes.
Part 3 of the series on using MAP 5.0 looks at Software Usage Tracker audit mecanism, as well as migrating and uninstalling the MAP database.
Part 2 of the series on using MAP 5.0 looks at using the toolkit to inventory servers, preparing audit reports and server virtualization planning.