Kellyn Pot'Vin-Gorman in Oracle Oracle’s Limited Cloud Vendor Licensing It’s nothing new for vendors to find ways to lock in customers to their products and cloud services. Oracle recently... 15 April 2025 3 min read
Robert Sheldon in MongoDB Working with MongoDB Shell Throughout this series, I’ve provided a number of examples of how to run commands in MongoDB Shell (mongosh). However, the... 10 April 2025 18 min read
Joe Celko in Theory and design Data Elements on a Nominal Scale “On a scale from 1 to 10, what color is your favorite letter of the alphabet?” –Slogan on a T-shirt... 08 April 2025 10 min read
Ganesh Gopal Masti Jayaram in Databases Data Quality: The Foundation for Business Agility and Growth We live in a world awash with vast amounts of data. Today’s modern enterprises generate and rely on vast amounts... 04 April 2025 14 min read
Grant Fritchey in PostgreSQL Multi-Version Concurrency Control (MVCC) in PostgreSQL: Learning PostgreSQL with Grant It’s a tale as old as time. You want to read data. Your mate wants to write data. You’re stepping... 02 April 2025 15 min read
Joe Celko in Theory and design The CREATE DOMAIN Statement One of the least known, least used features of SQL is the CREATE DOMAIN statement. It does not exist in... 27 March 2025 6 min read
Lee Asher in PostgreSQL The Wide World of GiST Indexes In Parts I (Solving the Overlap Query Problem in PostgreSQL) and II (Overlapping Ranges in Subsets in PostgreSQL) of... 25 March 2025 15 min read
Mercy Bassey in DevOps The Concepts of TestOps There’s no way you talk about software without mentioning testing or software testing. No software should ever be shipped if... 21 March 2025 18 min read
Aisha Bukar in MySQL MySQL vs PostgreSQL – String Datatypes A very common task in creating a database is to store string data. For example, words, paragraph(s) or even documents.... 20 March 2025 22 min read
John Kerski in Cloud The complexity of using Power BI in US Sovereign Clouds “I hate to tell you this, but it’s not available for us yet.” This is an all-too-common phrase I find... 13 March 2025 7 min read
Kathi Kellenberger in Featured Introduction to GitHub Actions Part 1: Getting Started GitHub is one of the most popular services on the planet for storing documents. That includes everything from PowerPoint presentations... 11 March 2025 5 min read
Joe Celko in Theory and design Scales & Measurements If you’re going to work with databases, you probably ought to know something about data. In particular, we don’t put... 07 March 2025 11 min read
Robert Sheldon in MongoDB Importing and exporting data in MongoDB Compass When working with MongoDB, you’ll likely need to import or export document data from time-to-time. You can use MongoDB Compass... 05 March 2025 16 min read
Anil Kumar Moka in Snowflake Implementing Enterprise Data Security in Snowflake: Practical Concepts As a data engineer who’s spent the last few years implementing enterprise-scale security in Snowflake, I’ve witnessed firsthand how challenging... 04 March 2025 16 min read
Jagdish Mohite in Featured Web Browser Security: Evolving Threats, Safeguards, and the Road Ahead Web browsers are essential for navigating the Internet, serving as gateways to online information, services, and applications. However, their ubiquity... 01 March 2025 18 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 3 – Disk I/O and Storage Optimization) So far, in our previous articles on MySQL optimization, we’ve looked at basic configuration management and memory and CPU tuning... 27 February 2025 15 min read
Padmaja U.K in Cloud Beyond Single-Cloud: A Peek into Multi-Cloud The digital landscape is rapidly evolving, and the question has progressed from whether to adopt cloud technology to how to... 25 February 2025 11 min read
Camilo Reyes in .NET The Result Pattern in ASP.NET Core Minimal APIs ASP.NET Core Minimal APIs are a new (as of the end of 2024) way to build web APIs in ASP.NET... 20 February 2025 16 min read
Rodrigo Ribeiro Gomes in T-SQL Programming AI in SQL Server 2025: Embeddings One of the cornerstones of AI is a concept called embeddings. Virtually every AI model, whether for text, video, or... 18 February 2025 48 min read
Lukas Vileikis in MySQL MySQL Index Overviews: Descending B-Tree Indexes Most anyone who works with indexes should be familiar with B-tree indexes. These are the most commonly used data structures... 13 February 2025 11 min read
