(Ben Nadel) Right now, I’m trying to muscle my way though the odyssey that is “Designing Data-Intensive Applications”. In the book, author Martin Kleppmann discusses database locking; and, posits that applications should really retry Transactions that are timed-out due to a lock.
Author: SSWUG Research
(Agustín) In this blog, we’ll look at ICP counters in the information_schema.INNODB_METRICS. This is part two of the Index Condition Pushdown (ICP) counters blog post series.
(Przemyslaw Magda) Optionals have proven so useful that some devs have taken them out of their native habitat. Here are anti-patterns and code smells to avoid.
(Ahmad Yaseen) During your experience as a SQL Server Database Administrator, you may work with applications that store data as comma-separated values in a single column. To deal with this de-normalized data, you may need to normalize it to work with each single value separately in your SQL Server c
Agile Development gives us the ability to work on multiple features at the same time and change which ones to ship at any point in time, quickly.
(Dimitri Gielis) This post is part of a series of posts: From idea to app or how I do an Oracle APEX project anno 2017
(Marcin Policht) Deploying Infrastructure as a Service (IaaS) solutions in Microsoft Azure offers a number of benefits that leverage agility, resiliency, and scalability built into the underlying platform.
SQL SERVER – Setup Rule: Microsoft .NET Application Security. The computer cannot access the Internet
(Pinal Dave) There are many rules in SQL Server setup which are checked to make sure that the user is not seeing failure at the end of the installation. Most of the rules are generally passed, but few of them are known to generate warnings. One of such rule is Microsoft .NET Application Security whi
(David Fitzjarrell) Oracle offers, in release 220.127.116.11, the option of increasing the maximum string length from the standard 4000 to a whopping 32767; depending on the nls_length_semantics setting this could be in bytes or in characters.
(Lockwood Lyon) Big data applications promise the ability to analyze huge volumes of transactional data for actionable (i.e., profitable) intelligence.