Announcing the JDBC Driver 7.2 RTW!

We are pleased to announce the production release of the Microsoft JDBC Driver 7.2 for SQL Server! The 7.2 Release To World (RTW) includes the following items since the previous RTW release: Added Added APIs for DataSourceFactory and OSGI Framework #700 Added support for OffsetDateTime to be passed as ‘type’ in ResultSet.getObject() #830 Added support for Active…


Early technical preview of JDBC 7.1.4 for SQL Server released

We have a new early technical preview of the JDBC Driver for SQL Server. Precompiled binaries are available on GitHub and also on Maven Central. Below is a summary of the new additions to the project, changes made, and issues fixed. Added Added APIs for DataSourceFactory and OSGI Framework #700 Added support for OffsetDateTime to be…


How to get earlier versions of the Dynamics NAV development environment to work with TLS 1.2

Some of you have been struggling to get your version of Dynamics NAV to work with a SQL Server database that has implemented the latest version of Transport Layer Security. TLS 1.2 support on SQL Server is explained in more detail in this article. As stated there, several known vulnerabilities have been reported against Secure…

3

Early technical preview of JDBC 7.1.3 for SQL Server released

We have a new early technical preview of the JDBC Driver for SQL Server. Precompiled binaries are available on GitHub and also on Maven Central. Below is a summary of the new additions to the project, changes made, and issues fixed. Added Added a new SQLServerMetaData constructor for string values of length greater than 4000 #876…


How to Encrypt SQL communication on the wire

While on-premises, most applications did not take advantage of securing communications to the database on the wire just because of the inherent isolation advantages of having the application ONLY on the internal LAN. However, as more and more of these applications start moving to the cloud, the security of data over the wire is rightfully starting to gain increased importance.


Check out this week’s top reads, it’s the Friday Five!

SQL Server Replication – Of The Duplication Kind Warwick Rudd is a Data Platform MVP, Microsoft Certified Master – SQL Server 2008, Founder and Principal Consultant at SQL Master Consulting. With over 15 years of experience beginning with the release of SQL Server 6.5, he has worked in both Australia and England from small start-ups to Multi-National…


Early technical preview of JDBC 7.1.2 for SQL Server released

We have a new early technical preview of the JDBC Driver for SQL Server. Precompiled binaries are available on GitHub and also on Maven Central. Below is a summary of the new additions to the project, changes made, and issues fixed. Added Added support for JDK 11 #824 #837 #807 Updated SQL keywords in DatabaseMetaData #829 Improvements in DatabaseMetadata…


September 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our September top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions. This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. The following continues to be the points hierarchy (in decreasing order of points):

1

Friday Five: Posting SQL Server notifications to Slack and More!

Comparing Azure Functions and AWS Lamba Herve Roggero is recognized for his thought leadership and passion for providing accessibility to data in the tech space. Herve’s knack for distilling complex real-time data consumption challenges and presenting digestible solutions make him the ideal speaker, teacher, and teammate.  Herve is the Co-Author of PRO SQL Azure, PRO Windows Azure SQL Database…


AzureCAT – Technical Customer Stories

Last Updated: 2/11/19 Over in this blog post, we mentioned why we’re named AzureCAT: CAT stands for “Customer Advisory Team.” We work with customers who act as feedback Advisors back to our product teams, by working on engagements with those customers and building ground-breaking solutions!   While we help customers architect those solutions, we learn…