Web Development

Note to the Reader This article is for developers with an existing ASP.NET Core Entity Framework based application currently utilizing SQL Server database for user authentication. If you’re considering migrating to PostgreSQL, this guide is designed to provide you with a clear and effective roadmap for a seamless transition." Overview In the ever-evolving landscape of database management, the decision to migrate from SQL Server to PostgreSQL marks a strategic move towards enhanced flexibility, cost efficiency, and scalability.

We were working on an application that utilized Azure Active Directory (AAD) for handling user authentication and authorization seamlessly. Everything functioned as expected until certain users encountered login difficulties. Following a comprehensive examination, we discovered that authentication issues were exclusively experienced by users who were members of an increased number of Azure Active Directory Groups. To address the problem, we initially resorted to removing users from some of these groups to restore functionality.