(Annamalai Gurusami) In this article, I’ll explain about the multi version concurrency control (MVCC) of large objects (LOBs) design in the MySQL InnoDB storage engine. MySQL 8.0 has a new feature that allows users to partially update large objects, including the JSON documents.
Other News
A generic logger factory facade for classic ASP.NET
(Jürgen Gutsch) ASP.NET Core already has this feature. There is a ILoggerFactory to create a logger. You are able to inject the ILoggerFactory to your component (Controller, Service, etc.) and to create a named logger out of it.
Tips for Delegating Work
In the past few weeks, several busy professionals have asked questions about how to best delegate work. This article contains the answers to their various questions. Is there a right time for one to delegate and at what point should an entrepreneur feel comfortable enough to delegate? When it comes to delegating tasks, what advice can you give to get...
Introduction to Java Collections Framework
(Anthony Jose) Want to learn more about using the Java collections framework? Check out this post about collections, as well as different Java classes and interfaces.
SQL SERVER – gMSA: The Service Did Not Start Due to a Logon Failure
(Pinal Dave) This is one of the most common errors which is seen my most DBA when they are using a domain account as the service account. In this blog, we would learn about the cause and solution of error The service did not start due to a logon failure while using gMSA.
Quickly Change SQL Job Owners
(Jason Brimhall) It is not unusual to find a server where some random user created a bunch of jobs to be run by SQL Agent.
Connect SQL Server to AS400 with a Linked Server
(Jack Vamvas) Question: I need to set up a Linked Server between SQL Server 2016 and AS400 to extract data from a file and import the data onto a table on a SQL Server database.
Performance implications of default struct equality in C#
(Sergey Teplyakov) If you’re familiar with C#, then you most likely heard that you should always override Equals and GetHashCode for custom structs for performance reasons. To better understand the importance and the rationale behind this advice we’re going to look at the default behavior to see why
Big Data Analytics on Current Data
(Lockwood Lyon) Typical big data applications have a load phase, where a snapshot of data is extracted from operational systems, transformed and cleaned, and then loaded into your big data appliance. Analysts and data scientists can then execute business analytics (BI) queries against the data store
Implementing A ‘Show Password’ Checkbox On A Login Form In JavaScript
(Ben Nadel) More and more, I’ve been seeing a pattern emerging on login forms where the user is presented with a “show password” toggle. Clicking on this toggle will change the password field from an obfuscated input to a plain-text input where the user can clearly see what value they are typing.