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
Editorials Louis Davidson in Editorials Going to the PASS Data Community Summit this year? We are just one month away from the PASS Data Community Summit. One month. If you haven't yet decided to... 15 October 2022 5 min read
MySQL Lukas Vileikis in MySQL Backing up MySQL Part 1: mysqldump mysqldump is one of the most popular database backup tools in the MySQL world. The tool is prevalent partly because... 14 October 2022 11 min read
MySQL Robert Sheldon in MySQL Introducing the MySQL INSERT statement In the previous article in this series, I introduced you to the SELECT statement, one of several SQL statements that... 07 October 2022 22 min read
Learn SQL Server Greg Larsen in Learn SQL Server The Basics of Inserting Data into a SQL Server Table Before data can be read from of a SQL Server database table, the table needs to contain rows of data.... 04 October 2022 15 min read
Editorials Devyani Borade in Editorials Mighty Tester: Why it doesn’t need to be fixed… … 21 September 2022 1 min read
Editorials Grant Fritchey in Editorials Do not be surprised For the first time in eleven years of travel, I became profoundly sick while on the road. No, I’m not... 01 September 2022 2 min read
