SQLBits 2024
Navigating Modern Authentication in SQL
Learn about modern authentication and credential management options available for Azure SQL and Arc-Enabled SQL Server, and how to implement best practices for keeping your infrastructure secure.
In the rapidly evolving world of data security, understanding the nuances of authentication is crucial. This session aims to provide a comprehensive overview of the modern authentication options available for SQL Server and Azure SQL.
We'll discuss the limitations of legacy authentication solutions and the inherent risks associated with password-based systems, including the potential for credential exposure and the difficulties in managing password policies. We'll discuss modern authentication options for user and programmatic access, and how these can significantly reduce the possibility of credential exposure, thereby enhancing the overall security of your data. Single Sign-On, multifactor authentication (MFA), and credential-less auth with managed identities will all be covered.
At the end of this session, you'll have a strong understanding of the authentication solutions available with SQL Server and Azure SQL Database, and their pros and cons.
We'll discuss the limitations of legacy authentication solutions and the inherent risks associated with password-based systems, including the potential for credential exposure and the difficulties in managing password policies. We'll discuss modern authentication options for user and programmatic access, and how these can significantly reduce the possibility of credential exposure, thereby enhancing the overall security of your data. Single Sign-On, multifactor authentication (MFA), and credential-less auth with managed identities will all be covered.
At the end of this session, you'll have a strong understanding of the authentication solutions available with SQL Server and Azure SQL Database, and their pros and cons.
