Back when it was more difficult to work from home due to bandwidth, I would often head into the office to work for several hours on some weekends and bank holidays like President’s Day. I was a database administrator and was always involved with many projects, but what would make me give up my well-deserved … Read more
MySQL stored procedures are objects containing one or more SQL statements for reuse. They often contain business logic. Robert Sheldon demonstrates how to create and call stored procedures.… Read more
Part 1: What is testable code, why is it important, and first glimpses on practices that can help Anyone familiar with PL/SQL, the procedural language extension to Oracle SQL, knows that the code they are touching is usually business-critical, likely to be around for a long time, and may undergo many revisions in the future. … Read more
What’s the difference between Site Reliability Engineering and DevOps? In this article, Grant Fritchey defines each one and compares them.… Read more
In this article, Jonathan Lewis discusses why you might want to stop the optimizer from unnesting some subqueries and how to control where the optimizer positions each subquery.… Read more
PostgreSQL has an unusually large number of data types. Grant Fritchey reviews each data type and discusses the good and bad points of each.… Read more
Change management is a process to prepare an organization to implement change. In this article, Rohan Kapoor explains the five components of change management.… Read more
After getting a new database in place, the next step is to create tables. In this article, Robert Sheldon walks you through creating tables with SQL Workbench and with scripts.… Read more
The “great resignation” is one of today’s most popular news topics. It’s an employee’s market as companies have difficulty keeping and attracting talent. Folks across the spectrum of careers give varied reasons for leaving, from seeking better benefits and pay to launching a small business they’ve always dreamed about. However, instead of blaming employees, organizations … Read more
You can perform PostgreSQL backups with the pg_dump command. In this article, Grant Fritchey explains how to back up and restore with the pg_dump and pg_restore utilities.… Read more
The first step when getting started with MySQL is to get it installed and running. In this article, Robert Sheldon explains how to install it on Windows and create the first database and table.… Read more
Lately, you’ve heard about DevOps. Is it just another buzzword, or is it something you should investigate? DevOps emerged over ten years ago to solve the problems of the Agile methodology. Not that Agile is bad, but there were often disconnects between developers and the operation teams who had to deploy the software. Software that … Read more
The syntax for creating databases and tables in PostgreSQL is similar to other RDBMS. In this article, Grant Fritchey shows how to create databases and tables.… Read more
December is often a time of reflection, and this year has been more unusual than most. It’s been another year of Zoom calls, still, there have also been signs of recovery and getting back to normal with increased travel, family reunions, the reopening of pubs and restaurants, and some in-person events. This year will also … Read more