(Tomek Poniatowicz) GraphQL was developed by Facebook in 2012 to power up its mobile apps. Since open-sourcing GraphQL specification in 2015, it gained a lot of popularity and is now used by many development teams, including giants like GitHub, Twitter or Airbnb.
Community
Advanced Log Space Management (ALSM) as of Db2 for LUW Version 11.5
(Frank-Martin Haas) Db2 for Linux, UNIX, and Windows Version 11.5 GA comes with the tech preview of a new feature called “Advanced Log Space Management” (ALSM).
A Guide to MySQL Galera Cluster Streaming Replication: Part One
(Paul Namuag) Streaming Replication is a new feature which was introduced with the 4.0 release of Galera Cluster. Galera uses replication synchronously across the entire cluster, but before this release write-sets greater than 2GB were not supported.
GRANT INHERIT PRIVILEGES
(Flavio Casetta) As per Oracle 12.2 SQL Reference:
Native Oracle DB JSON functionality as alternative for using cursor() in AOP (and APEX_JSON)
(Dimitri Gielis) When using external (WEB/REST) services, you often communicate in JSON. So it’s important to be able to generate JSON in the format that is expected by the external service.
Change time zone in Oracle’s DBaaS
(Marco Mischke) Recently I assisted in a project that is utilizing Oracle Cloud Infrastructure (OCI) to provide application servers and Oracle databases. The customer is located in New Zealand, so they obviously wanted to work with dates and times in their local time zone.
SQL SERVER Management Studio – Enable Statistics Time and IO for Every Query
(Pinal Dave) Recently, while working with a large education institute on Comprehensive Database Performance Health Check I was asked a very interesting question about statistics TIME and IO for SQL Server Management Studio, let us discuss that in today’s blog post.
JavaScript Export to Excel HTML Table with Input Tags
(aditya pewekar) This tip gives a brief of how to export a HTML table with input tags into Excel file using JavaScript.
How to test for query regressions when upgrading
(Denny Cherry) One of the things that you want to test for when doing an upgrade of SQL Server is query regressions. Regressions happen when the new version of SQL Server makes a poor decision when running the same code that you can before.
Debugging 3rd Party .NET Code without symbols in Visual Studio
(Michael Shpilt) It’s not so rare to see weird things happen in 3rd party library code. Call some method and you’ve got a strange exception.