(Daniel Farina) You work as a SQL Server Database Administrator at a company that is starting to use Linux as its platform to run SQL Server. You need to automatize some tasks which we covered in the previous tip. You know that you can set the MAILTO variable to send the execution results of Cron to
Community
AspNetCore.Security.Jwt – JWT Bearer Token Security Package
(Shantanu) I have built a package which integrates JWT Bearer Token Security into an Asp Net Core 2.0+ application.
SQL SERVER – Get List of the Logical and Physical Name of the Files in the Entire Database
(Pinal Dave) One of the most popular questions I often receive is why do I like to do consultation – my answer is very simple – it gives me an opportunity to learn continuously learn new things from my clients. Here is a script which I have built during my recent Comprehensive Database Performance H
Visual Studio Toolbox: Building Web APIs Part 2
(Robert Green) This is the second of a three part series where I am joined by Chris Woodruff who shows how to build ASP.NET Core Web APIs. In this episode, Chris discusses what to do after building your APIs.
MySQL Replication Data Recovery using ‘mysqlbinlog’ – Part II
(Ivan Ma) The previous post (PART-I) http://mysqlhk.blogspot.com/2018/10/mysql-replication-recovery-from-binlog.html It describes the Replication Recovery from binlog by using those binlog files to be treated as Relay Log.
Introduction to Oracle Digital Assistant Dialog Flow
(Andrejus Baranovskis) Oracle Digital Assistant is a new name for Oracle Chatbot. Actually it is not only a new name – from now on chatbot functionality is extracted into separate cloud service – Oracle Digital Assistance (ODA) Cloud service.
A cron job with nodejs, sails and flickr
(Harish Palaniappan) A simple flickr API image extractor that will construct links to flickr API images.
Using Router Events To Detect Back And Forward Browser Navigation In Angular 7.0.4
(Ben Nadel) This morning, while digging into the “retain scroll” feature that was released with Angular 6, I discovered that the Angular team added a “navigationTrigger” property and a “restoredState” property to the NavigationStart Router event.
Data Masking in MySQL
(Ivan Švaljek) If you’re here, that probably means you’re about to acquire some sensitive data to take care of. Or that you’ve already acquired it and are protecting it, and you want to see how MySQL Enterprise Data Masking and De-Identification features can help you do it in an easier, better and m
Column And Table Redefinition With Minimal Locking
(Jeremy) TLDR: Note to future self… (1) Read this before you modify a table on a live PostgreSQL database. If you do it wrong then your app might totally hang. There is a right way to do it which avoids that. (2) Especially remember the lock_timeout step.