Software Nuggets

How to Add hexadecimal numbers the easy way. Step-by-step.

Calling Extern Printf() In Assembly Code: Code up a Small app to learn the steps!

How to use the Postgresql pl/sql FOR LOOP statement- 6 Examples including keywords EXIT and CONTINUE

#23 PostgreSQL - ARRAY - Overlap Operator. How to use the && operator in SQL statement.

Learn how to use the class SqlBulkCopy from Data.SqlClient to load data into SQL Server with ease.

How to implement Transactions (COMMIT / ROLLBACK) using SQL SERVER.

SQL Server: L16) Timestamp has been deprecated, but still being used.

Vid 4 - Use INFORMATION_SCHEMA and SYS.Objects to get the Schema and Table Name from SQL Server.

#10 PostgreSQL ARRAYS, using UNNEST, string_to_array, array_to_string, remove null values,

Use the DEVART ODBC Driver to create a USER DSN for PostgreSQL.

DATE_BUCKET in SQL Server 2022

C# Load JSON into Datagrid. How to use Newtonsoft to Serialize and Deserialize Data.

PostgreSQL: Scalar Function. How to write and use a SQL Scalar function.

Python - How to use strftime(), to format date and time values.

#5 ARRAY_Length, PostgreSQL - how to compute the length of an array.

SQL Server: (L12) How to use the UniqueIdentifier data type.

Excel VBA #9 - On Error goto ErrorHandler.

03: Typescript Interface. Add Optional or Read-Only Properties, Extend an Interface, Inherit.

SQL String_SPLIT function : convert comma-delimited to json. SQL Server.

How to setup a Foreign Key Constraint on a SQL Server 2019 database.

User-Defined Data Types. Detailed instructions on how to create, use, reverse engineer, and drop.

A Python Tutorial using the Datetime and pytz modules. Dates, Times, Timedeltas and timezones.

Vid 27 - PostreSQL Arrays - Select UNIQUE Elements from two arrays.

How to use SQLite3 database in Python (Create Database (Memory|Disk), Table, Insert and Select)

#8 PostgreSQL - ARRAY, sort the elements, how to use UNNEST,

How to convert c# object to json, and json to c# object. Read and write C# Object/Json.

How to Remove Dups rows from a Table in SQL Server, using a CTE statement.

C Programming. Write a Variadic sum the numbers function.

#14 JSON_build_object : PostgreSQL - JSON Object Creation Made Simple - Explained.

Rust #5 - Declare String - How to declare a variable of type String.

Create A Tkinter Listbox In Python: Learn To Build A Reusable Component

Rust #4 - Signed Integer - How to declare a variable of type Signed Integer.

#3 PostgreSQL - ARRAY_AGG, returns an array of values

Part 4: How to Reverse Engineer a SQL Server Foreign Key Constraint

How to write a Cursor for PostgreSQL. Learn how to Open, Move, Fetch, Close., and Update/Delete DB.

HackerRank: How to Master SQL Joins and Grouping for Advanced Data Analysis. 🚀

Lesson 21: C Programming - How to display memory address of integer variable.

HackerRank: Solution for Interviews, a problem for SQL Server.

MongoDB Pro Tip: How to insert JSON file into MongoDB using MongoImport.

How to Download PowerBall Numbers, Convert and Load into SQL Server using Bulk Insert.

PostgreSql Enum: A Beginner's guide to Implement and Use ENUMS in a function.

Step-by-step instructions to Download and Install SQL Server 2022 Developer License on Windows 10.

ASM Language: How to Call an Assembly Language Subroutine. Lesson 3. Intel-Syntax.

Lesson 8: C Programming - Understand If-Else Statement, when condition is false.

Lesson 35: How to pass an ARRAY to a Function in C.

Python - Two-Sum Algorithm: Find Pairs in Array with Target Sum

#25 PostgreSQL - JSONB, contains operator to work with JSONB data. JSONB SQL.

#20 ROW_TO_JSON: Postgresql, How to build JSON using row_to_json function from two related tables.

Vid 16 - How to Create a Temporary Stored Procedure in SQL Server.

How to use SQLite3 Database, using AutoIncrement Integer datatype.

POSTRESQL - Load CSV file with an ARRAY data type into a table.