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
Almost five years ago, one of my local SQL Server community friends sent me a text message about an opening at Redgate, editor of Simple Talk. I applied for the position within the hour and told my family that “No one is more qualified than I am to be editor of Simple Talk!” After a … 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
There are several common challenges when creating paginated reports from Power BI datasets. In this article, Adam Aspin explains how to work around several of these issues.… 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
To guarantee the order of a result set, you must use an ORDER BY clause. In this article, Greg Larsen explains what you need to know about ORDER BY.… Read more
We make a special effort in March to acknowledge the accomplishments of women. Women have been making gains in many professions over the past several decades but are still underrepresented in technology. There are several hypotheses about why this is the case, but often women find they are not welcome in the “brogrammer” cultures of … 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