Jim's Lib
51 subscribers
70 photos
1 video
40 files
975 links
from A-Z, it's look like AlcatraZ.
be in touch: @suspend
Download Telegram
When it comes to protecting against credentials theft on Windows, enabling LSA Protection (a.k.a. RunAsPPL) on LSASS may be considered as the very first recommendation to implement. But do you really know what a PPL is? https://itm4n.github.io/lsass-runasp
anonymous poll

No, it's the first time I've ever heard about that. – 3
👍👍👍👍👍👍👍 100%

Yes, I was familiar with that.
▫️ 0%

👥 3 people voted so far.
Atomic DDL is not transactional DDL

"Atomic DDL is not transactional DDL. DDL statements, atomic or otherwise, implicitly end any transaction that is active in the current session, as if you had done a COMMIT before executing the statement. This means that DDL statements cannot be performed within another transaction, within transaction control statements such as START TRANSACTION ... COMMIT, or combined with other statements within the same transaction."

https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
What is Implicit Commit in MySQL?
The implicit commit occurs within a session.
So for instance you start a transaction, do some updates and then forget to close the transaction and start a new one. Then the first transaction will implicitely committed.

https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html
زیبخِی اِلَهیم ووآخ نیش بِقا

https://biblehub.com/text/psalms/51-17.htm
Habah l'hargecha hashkem l'hargo
most engineers will work on badly designed systems because most systems turn into badly designed systems over time.
most engineers will work on badly designed systems because most successful/popular systems are badly designed systems, because there is almost no other way to design these systems.
work on badly designed systems will particularly suffer since badly designed systems have unbounded complexity. because most of these systems are built by large group of people over time, and complexity is limited only by human creativity.
Why Delete records with FK might be slow in PostgreSQL?
- PostgreSQL doesn't index FKs by default
- on each FK reference, there is a function call that checks referential integrity violation, for 100 record with 2 FKs it will be called 200 times.

Mitigation:
Index FK with CONCURRENTLY flag on production where Referential Integrity Violation check could be done concurrently.
https://ivdl.co.za/

good personal blog to read in your free times, mostly related to postgresql.
CPU branching and parallelization

“A branch is an instruction in a computer program that can cause a computer to begin executing a different instruction sequence and thus deviate from its default behavior of executing instructions in order.” — Wikipedia

This article will improve array iteration performance in C#, but during that it will explain about CPUs a little bit, branching and SIMD.

https://antao-almada.medium.com/array-iteration-performance-in-c-branching-and-parallelization-d0705adbf425
“never do random reads”
- a wiseman said
https://cedardb.com/

CedarDB is a government funded general-purpose database solution which claims to present more performance with general purpose approach versus postgresql, because re-think in design with these days workload and usecases, hardwares and etc.

All of CedarDB founders are graduated from Technical Univesty of Munich with almost no experience in industry.


read more about them
https://cedardb.com/docs/technology/