Generate User Email List For SQL Server Logins

If you've ever performed some impactful maintenance on a SQL Server, you probably notified users. If you're great at documentation and already know exactly who to contact, this script isn't for you. If you don't have a user email list, this script will create it for you! I used to manage 500 SQL Server instances… Continue reading Generate User Email List For SQL Server Logins

SQL Server Graph Database of US Capitals

SQL Server 2017 introduced graph database functionality. Graphs are a core concept in computer science and I was excited to hear of this new feature. Robert Sheldon has a great series on SQL Server's graph database here. If you're interested in learning about graphs in SQL Server, it's a great place to start. While there's… Continue reading SQL Server Graph Database of US Capitals

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

Rolling Downgrade From Enterprise to Developer

So, is it possible to go from Enterprise to Developer in an AlwaysOn cluster? TLDR: Yes. I was working in a dev environment recently that had been setup with AlwaysOn Availability Groups using the Enterprise Edition of SQL Server 2016. This environment is completely devoted to development of our applications which means it qualifies for… Continue reading Rolling Downgrade From Enterprise to Developer