(Ben Nadel) For the past few years, I’ve been using – and loving – the Sublime Text (ST3) editor. In fact, I find it so enjoyable, that I’ve never even looked at any of the new editors that seem to be gaining popularity.
Other News
3 Things Before Migrating To CloudSQL(MySQL)
(Bhuvanesh) If you are going to migrate your MySQL workloads to GCP’s managed database service CloudSQL, then you have to keep these points in mind.
How to stop and start SQL Server services
(Daniel Farina) There are often times that you need to stop and start SQL Server services, so in this tip we will look at various methods of doing this.
Two-Way Databinding in JavaScript
(Volodymyr Kopytin) This article teaches the basic concepts of databinding tasks. What is the trickiest and the easiest part of databinding.
PART I: Database Transaction
Database Transaction A transaction can be defined as a task group. A single task is the minimal processing unit, which cannot be further divided. ACID Properties of Transaction The small unit of a program which can contain several low-level tasks is called transaction. A database transaction should maintain atomicity, consistency, isolation, and durability. These properties are known as ACID properties....
DROP IF EXISTS
(Kenneth Fisher) It’s amazing the things that SQL can do these days. It’s also amazing how many of them I’ve managed to completely miss over time. I was having a random conversation with a friend on Twitter the other day and they mentioned an acronym DIE.
Query Store for Workload Replays
(John Sterrett) The first script below was updated from setting QDS to “Read_Write” instead of “Read_Only”. Martin thank you for pointing this out in your comment below.
Replay: DevOps for DB2 DBAs with Julian Stuhler
If you missed the DB2Night Show episode, DevOps for DB2 DBAs with guest present Julian Stuhler, our partners DBI Software have made the show available as a replay.
Immutability in JavaScript — When and Why Should You Use It
(Manjunath M) In this article, take a look at immutability in JavaScript and see when and why you should use it.
18.9 vs. 19.6 Data Dictionary Changes
(Liron Amitzi) In this post I’ll show what’s new in 19.6 Data Dictionary. To see comparison between other versions, check this post.