(Mads Kristensen) Visual Studio 2017 version 15.8 made it possible to use the PackageReference syntax to reference NuGet packages in Visual Studio Extensibility (VSIX) projects. This makes it much simpler to reason about NuGet packages and opens the door for having a complete meta package containing
Community
Replication from Percona Server for MySQL to PostgreSQL using pg_chameleon
(Avinash Vallarapu) Replication is one of the well-known features that allows us to build an identical copy of a database. It is supported in almost every RDBMS.
SQL Real Time Monitoring pure HTML report (thanks to SQLDeveloper 18.3)
(Martin Berger) Yesterday (from the writing of this post perspective) SQLDeveloper 18.3 came out.
Using Power Query And Microsoft Flow To Automate The Creation Of CSV Files
(Chris Webb) I was super-excited when, a few days ago, the long-awaited integration of Power Query into Microsoft Flow was announced.
How to use parsename with SERVERPROPERTY(‘productversion’)
(Jack Vamvas) Question: I’d like to use SERVERPROPERTY(‘productversion’) for purposes of reporting on current sql server level. I’m using the SERVERPROPERTY(‘productversion’) funcion, but am struggling with how to split the parts of the details, to make it easier for reporting.
The Two Paths to the Db2 for z/OS Distributed Data Facility
(Robert Catterall) It’s been almost two years since the general availability date of Db2 12 for z/OS and, by way of that new version, the availability of Db2’s native REST interface (retrofitted to Db2 11 for z/OS via APARs PI66828 and PI70477).
JShell: A Comprehensive Guide to the Java REPL
(Dustin Schultz) The Java Shell or JShell is an official Read-Evaluate-Print-Loop, or REPL as it’s commonly called, introduced with Java 9.
Simple Paging In ASP.NET Core Razor Pages
(Mike Brind) This article attempts to demonstrate how to implement simple paging functionality in a Razor Pages application.
Playing With RegExp Named Capture Groups In Node 10
(Ben Nadel) A couple of weeks ago, at the NYC Node.js Meetup, Franziska Hinkelmann went over the exciting new features of Node 10, which had just recently entered Long Term Support (LTS).
Speed Up Your Application with SQL Server In-Memory Tables
(Peter Vogel) I’ve said it before and I’ll say it again: If you want to speed up your application, don’t look at your code, look at your data access.