AWS Camilo Reyes in AWS AWS Lambdas with C# Serverless computing is pushing C# to evolve to the next level. This is exciting because you pay-per-use and only incur... 25 January 2023 14 min read
Testing Louis Davidson in Testing Testing before coding: shifting farther left A term I have only recently learned is "shift left testing." You can read more about this on Wikipedia here.... 23 January 2023 5 min read
PostgreSQL Ryan Booz in PostgreSQL PostgreSQL Basics: Roles and Privileges Information security, whether in databases, applications, or larger IT systems, is based on the principles of Authentication and Authorization, often... 19 January 2023 19 min read
Learn SQL Server Greg Larsen in Learn SQL Server Manage Data Over Time with SQL Server MERGE Statement Once data is in a table it needs to be maintained. New records will need to be added, and existing... 17 January 2023 13 min read
PostgreSQL Grant Fritchey in PostgreSQL Index Types in PostgreSQL: Learning PostgreSQL with Grant As with any other relational data management system (RDBMS), PostgreSQL uses indexes as a mechanism to improve data access. PostgreSQL... 09 January 2023 15 min read
MySQL Robert Sheldon in MySQL Introducing the MySQL common table expression As with many relational database management systems, MySQL provides a variety of methods for combining data in a data manipulation... 05 January 2023 23 min read
Opinion Louis Davidson in Opinion Don’t Just Chase the Shiny Fish are beautiful creatures, but they have one minor issue. The main thing I remember from the years I fished... 05 January 2023 4 min read
Azure Dennes Torres in Azure Azure Function and User Assigned Managed Identities Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many poorly documented secrets... 03 January 2023 16 min read
Editorials Louis Davidson in Editorials Resolving to Write in the New Year It is almost New Year’s Day, that time when the optimistic at heart start thinking about making changes in their... 19 December 2022 7 min read
Editorials Louis Davidson in Editorials The Good, The Bad, and Suboptimal of Sticking to What You Know From personal observation and experience, most people want to be comfortable in their vocation. Getting comfortable and not keeping up... 05 December 2022 6 min read
MySQL Robert Sheldon in MySQL Subqueries in MySQL A subquery is a type of query that is embedded—or nested—into a data manipulation language (DML) statement. The data returned... 02 December 2022 22 min read
JavaScript Goodness Woke in JavaScript Express.js or Next.js for your Backend Project In this article, I will introduce two JavaScript frameworks that can be used to build backend projects. Backend development is... 25 November 2022 13 min read
T-SQL Programming Edward Pollack in T-SQL Programming Converting Data Across Time Zones: An In-Depth Primer If only the entire world used UTC, wouldn’t life be so much easier? We can dream, can’t we? While some... 21 November 2022 27 min read
MySQL Robert Sheldon in MySQL Introducing the MySQL DELETE statement In the last few articles in this series, you learned about three important data manipulation language (DML) statements: SELECT, INSERT,... 12 November 2022 17 min read
Learn SQL Server Greg Larsen in Learn SQL Server The Basics of Deleting Data from a SQL Server Table Over time data in SQL Server tables needs to be modified. There are two major different aspects of modifying data:... 07 November 2022 12 min read
Other Development Ukeje Goodness in Other Development How to Use Any SQL Database in GO with GORM Object Relational Mapping is a database abstraction technique that aids developers in manipulating and interacting with SQL databases using the... 05 November 2022 10 min read
Editorials Devyani Borade in Editorials Calling all leaders: People matter At the turn of the millennium, I was a young adult, just finished education and starting my very first job... 01 November 2022 4 min read
MySQL Robert Sheldon in MySQL Introducing the MySQL UPDATE statement In the previous two articles in this series, you learned about SELECT and INSERT, two important data manipulation language (DML)... 28 October 2022 21 min read
Oracle Jonathan Lewis in Oracle Oracle optimizer Or Expansion Transformations The previous installment of this series examined aggregate subquery removal and subquery coalescing, describing the latter as similar in some... 26 October 2022 15 min read
Learn SQL Server Greg Larsen in Learn SQL Server The Basics of Updating Data in a SQL Server Table Once data is inserted into a table, data typically needs to be maintained as time goes on. To make changes... 21 October 2022 14 min read
