In his latest article James Cockayne, Principal Consultant at Triton Consulting gives us his views on key issues for DBAs, the newest active-active availability solutions and how a DBA can ensure they get their all-important beauty sleep!
Community
Tracing Latches: Redo Copy Contention
(Nenad Noveljic) Latch waits are well instrumented in Oracle database. We can see for how long a process was waiting for a latch. We can also identify the latch holder.
Java Records – How to use them with Hibernate and JPA
(Thorben Janssen) A lot of developers complain that Java is too verbose. And I can understand that, especially for all classes that are supposed to be a basic data structure, like JPA/Hibernate entities or DTOs.
#0418 – SQL Server – How to disable Shared Memory connections and configure a SQL Server instance to accept connections only via TCP/IP?
(Nakul Vachhrajani) As part of my normal development activities, I use my trusted developer instance on my local machine.
SQL Server Performance Testing for Check Constraint vs Foreign Key
(Ben Snaidero) In my never ending quest of improving SQL Server database performance I often think about how foreign key constraints can slow down insert performance. While everyone understands why foreign key constraints are required, to protect referential integrity, what if there was some other
Git tip: how to fix an accidental commit on the wrong branch
(Thomas Levesque) Oh no, you just accidentally commited to master, when you were supposed to work on a feature branch! How to fix it? It’s actually pretty easy with Git!
Exploring MySQL Binlog Server – Ripple
MySQL does not limit the number of slaves that you can connect to the master server in a replication topology. However, as the number of slaves increases, they will have a toll on the master resources because the binary logs will need to be served to different slaves working at different speeds.
SSIS in AWS RDS
(Fahd Mirza Chughtai) Whenever migrating a SQL Server database from on-prem to AWS Cloud, my first preference is always to move it to AWS RDS, the managed database service.
Apache Arrow and Java: Lightning Speed Big Data Transfer
(Joris Gillis) By its very nature, Big Data is too big to fit on a single machine. Datasets need to be partitioned across multiple machines. Each partition is assigned to one primary machine, with optional backup assignments.
Angular Components for Beginners
(Rajendra Singh Dodiya) This article discusses how to create a reusable component in Angular js. This tutorial is for beginners/freshers or students. I have created the functionality of component and used in our program.