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…

2

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…


Early technical preview of JDBC 7.1.1 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 streaming capabilities for Clob.getAsciiStream() #799 Fixed Issues Fixed a bug where calling length()…


Sit Back, Relax, it’s The Friday Five!

Using Excel and Visio to Create Data-Driven Process Mapping Flowcharts Elaiza Benitez is a MVP in Business Applications and works for Barhead Solutions as a Dynamics 365 consultant in Melbourne, Australia. Elaiza began working with Dynamics CRM version 4 in 2009 Elaiza and has loved it ever since. In her spare time she likes to make…


August 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our August 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):