MySQL Robert Sheldon in MySQL MySQL Common Table Expressions (CTEs): WITH Clause, Recursive Queries Use MySQL common table expressions (CTEs) to simplify complex queries with the WITH clause. Covers basic CTEs, multiple CTEs in... 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 MySQL Subqueries: Scalar, Correlated, Row, Column, and Derived Tables Complete MySQL subquery guide: scalar subqueries for single values, correlated subqueries that reference the outer query, row and column subqueries,... 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 SQL Server Time Zones: AT TIME ZONE, SWITCHOFFSET, DATETIMEOFFSET, and Daylight Saving Complete primer on SQL Server time zone conversion - the components of a time zone (bias, daylight saving rules), how... 21 November 2022 28 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 GORM Tutorial: Using the Go ORM with MySQL, PostgreSQL, SQLite, and SQL Server – Connections, Models, Automigrations, and CRUD A complete GORM tutorial covering how to use the Go ORM with any SQL database: connecting to MySQL, PostgreSQL, SQLite,... 05 November 2022 12 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 Or-Expansion Transformation: How the Optimiser Rewrites OR Predicates into UNION ALL for Index Access Oracle's Or-Expansion transformation - how the cost-based optimiser rewrites queries containing OR predicates into UNION ALL branches that can each... 26 October 2022 16 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, it 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
