(Frederic Descamps) As you know, Oracle Cloud Infrastructure (aka OCI) becomes more and more popular. You can find OCI data centers almost everywhere and the price is very attractive.
Community
SQL Server UPDATE lock and UPDLOCK Table Hints
(Sergey Gigoyan) In SQL Server databases with actively running transactions, it is a common situation when more than one transaction tries to modify the same data simultaneously. In such instances, SQL Server deadlocks are often quite possible, which can be a real issue in terms of performance.
How to Check Password Strength Meter in Angular 8
(Siddharth Gajbhiye) In most applications, there is a field while registering to enter a valid password that should contain at least one digit, one number and one special symbol.
Collation Conflict with Extended Events
(Jason Brimhall) Have you ever run into an error like this? Cannot resolve the collation conflict between “pick a collation” and “pick another collation” in the equal to operation.
Change the size of the grid results view in SSMS
(Kenneth Fisher) After my post last month about configuring your tools I’ve been on a make my life easier kick and one of the things that gives me grief every day is that my eyesight is at best mediocre and some days it’s worse than others.
12.2.0.1 vs. 18.9 Data Dictionary Changes
(Liron Amitzi) In this post I’ll compare the Data Dictionary tables and columns between 12.2.0.1 and 18.9.
network ip calculation with ifconfig
(Laurent Schneider) Most *nix are different. I’ll start with a plain Linux output
PART 4: Implementing Oracle Database Single Sign-On Using Kerberos, Active Directory, And Oracle CMU
(Simon Pane) This is the fourth and final article in a four-part series related to testing Oracle Database 18c Centrally Managed Users (CMU) by leveraging the Oracle Cloud Infrastructure (OCI) for Oracle DBAs to create a lab or testbed.
Create Empty Optional SQL Clauses with jOOQ
(lukaseder) When using jOOQ to create dynamic SQL statements (one of jOOQ’s core value propositions), it is often necessary to add query elements conditionally, with a default “No-op” behaviour.
Guru Classic: Tuning SQL Environments On i
(Paul Tuohy) One of the frustrating things about being a speaker at conferences is that when you want to attend another session with a topic that piques your interest, it invariably clashes with when you are speaking.