(Federico Razzoli) In MySQL and MariaDB, all tables should have a primary key – especially InnoDB tables. I mentioned this in several articles, see Primary Key in InnoDB: how they work and best practices.
Other News
Oracle EBS 12.2 – ADOP patching on a downtime mode with [ERROR] Patch service is not exist or running
(Senthil Rajendran) When applying adop patches on a downtime mode you might see an error that the patch service is not existing or running.
Dropping Table and Index Partition
(Jagruti Jasleniya) Dropping Table partition or Index partition is a part of routine maintenance job of DBA.
What’s Faster? COUNT(*) or COUNT(1)?
(lukaseder) One of the biggest and undead myths in SQL is that COUNT(*) is faster than COUNT(1). Or was it that COUNT(1) is faster than COUNT(*)? Impossible to remember, because there’s really no reason at all why one should be faster than the other.
Getting Started with SQL Server Maintenance Plans – Part 1
(Sergey Gigoyan) Creating SQL Server database maintenance solutions are essential in terms of having a well-organized, safe, and high-performance database environment.
Java Scanner Tutorial
(Rohit Gupta) Java Scanner reads input text in Java. In this tutorial, learn how to use Java Scanner methods and properties to read and parse text.
Tuning SQL Server Reporting Services
(Tim Radney) Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS.
Stop Installing Packages Globally
(Landon Schropp) These days, most front-end projects are going to involve NPM packages of some kind. Occasionally, when browsing documentation for these packages, I’ll see a recommendation to install a package like this.
Docker for PHP: A Start-to-Finish Guide
(Kevin Cunningham) You’ve probably seen mentions of Docker over the past few years. This guide explains the basics so you can get up and running with Docker for PHP in your local development environment.
Inverting Image Colors in .NET
(Hannes DuPreez) I do not know how, but every now and then I return to graphics-oriented projects. Maybe it is because I always wanted to get into games programming, and still linger subconsciously to, but alas, here we are with a nice little project.