(Ben Nadel) I used to believe that when I added a new feature to a web application, said feature had to help all users. But, as I’ve grown older – and I’ve had to operate under greater constraints at work – I’ve come to embrace the idea that solutions don’t have to work for everyone.
Community
Why MySQL tables need a primary key
(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.
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.