Microsoft jdbc driver 6.0 and for sql server

Microsoft jdbc driver 6.0 and for sql server full#

IDNs allow your web server to use Unicode characters for server name, enabling support for more languages.

Parameterized queriesД®xtended support for retrieving parameter metadata with prepared statements for complex queries such as sub-queries and/or joins. You can use the JDBC Driver 6.0 to encapsulate rows of data in a client application and send the data to the server in a single parameterized command. TVP support allows a client application to send parameterized data to the server more efficiently by sending multiple rows to the server with a single call. The JDBC Driver 6.0 allows you to specify your AAD credentials in the JDBC connection string to connect to Azure SQL DB. Use AAD authentication to centrally manage identities of database users and as an alternative to SQL Server authentication. Azure Active Directory (AAD)ДЄAD authentication is a mechanism of connecting to Azure SQL Database v12 using identities in AAD. Likewise, use the driver to decrypt your encrypted data. Use the JDBC Driver 6.0 to encrypt plaintext data and store the encrypted data in SQL Server 2016 or Azure SQL Database. If a SQL instance or host machine is compromised, an attacker can only access ciphertext of your sensitive data. You can now transparently encrypt the data in the application, so that SQL Server or Azure SQL Database will only handle the encrypted data and not plaintext values. Always Encrypted is a new SQL Server 2016 and Azure SQL Database security feature that prevents sensitive data from being seen in plaintext in a SQL instance. You can now use Always Encrypted with the Microsoft JDBC Driver 6.0 for SQL Server.

Microsoft jdbc driver 6.0 and for sql server full#

We are pleased to announce the full release of the Microsoft JDBC Driver 6.0 for SQL Server! The updated driver provides robust data access to Microsoft SQL Server and Microsoft Azure SQL Database for Java-based applications. This post was authored by Andrea Lam, Program Manager, SQL Server.