SUSER_SNAME() Returning the Wrong Login

If users are logging into your SQL Server with their Active Directory accounts, you may run into an issue if their login changes. This issue is usually associated with someone changing their account name to reflect a change in their legal name. If the user executes the function SUSER_SNAME(), it may return their old login.… Continue reading SUSER_SNAME() Returning the Wrong Login

Finding VMotions with Powershell and the VCenter CLI

If you work in a VMWare shop you're probably aware that VMs can be migrated to a new host under certain conditions. While the purpose of these migrations is good, I've found that virtual SQL Servers usually do not like to be VMotioned. At my current employer, this is often noticed in AlwaysOn Availbility Groups.… Continue reading Finding VMotions with Powershell and the VCenter CLI