(Martin Bach) Sometimes it is necessary to invoke a SQL script in bash or otherwise in an unattended way.
Community
Quick and easy masking
(Connor McDonald) I had a request from a client a while back regarding masking of data.
Create Linux Swap File
(mdinh) Currently I am using oravirt (Mikael Sandström) · GitHub (https://github.com/oravirt) vagrant boxes.
Read, Enrich and Transform Data with AWS Glue Service
(Maria Zakourdaev) In the first part of this tip series we looked at how to map and view JSON files with the Glue Data Catalog. In this second part, we will look at how to read, enrich and transform the data using an AWS Glue job.
Strange behavior on JSON_VALUE when table contains blank and non-blank values (JSON text is not properly formatted. Unexpected character ‘.’ is found at position 0.)
(Manjuke Fernando) Few days back we had a requirement to search whether a certain value exists in one of the table fields where the values are stored as JSON strings.
Possibly the worst analogy in the world – columnstore and ordering
(Tibor Karaszi) Yeah, the subject is sort of a tribute to the Tenacious D tribute. With a hint of Carlsberg in there.
Discovering patterns with React hooks
(Maciek Pekala) One of the things I enjoy the most about coding is discovering patterns.
Create AutoPostBack Tag Helper In ASP.NET Core
(Bipin Joshi) In one of my past articles I explained how autopostback can be implemented in ASP.NET Core. If you find yourself using autopostback at many places, you can create a custom tag helper that does the job for you.
Scalable Predictive Machine Learning for Invoking Utilities for Db2 for z/OS
(Sridhar Pratik Shanmugam) Db2 for z/OS is constantly providing information on the usage of our objects from the real-time statistics data and for the last few years DBAs have leveraged that information in all sort of ways through in-house applications and full products.
Finding the Binary Gap for a Number in .NET
(Hannes DuPreez) A binary gap is any sequence of consecutive zeros that is surrounded by ones at both ends in the binary representation of the number.