Goodness Woke in Security and Compliance Zero-Trust Architecture for Cloud-Based AI Systems Cloud-based artificial intelligence’s growth has transformed how businesses analyze data and get insights, but it has also brought with it... 27 May 2025 25 min read
Louis Davidson in T-SQL Programming DISTINCT and UNION: What happens when you use them together? When I was perusing my LinkedIn feed the other day, I came across this thread about using SELECT *. In... 26 May 2025 11 min read
Joe Celko Data Encoding Schemes You probably noticed that when you get a bill or bank statement, it uses the current modern Western version of... 22 May 2025 15 min read
Simple Talk Editor in SQL Server SQL Server 2025 is in Public Preview! On Monday, May 19, 2025, SQL Server 2025 was announced as finally going to be in public preview. Instead of... 21 May 2025 3 min read
Bravin Wasike in DevOps What are the Key DevOps Performance Metrics You Should Track? Successful DevOps teams rely on data-driven decision-making to continuously improve software delivery and operational performance. Understanding the right DevOps performance... 16 May 2025 28 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 4 – Optimizing MySQL Performance) Welcome back to our journey of understanding MySQL performance tuning using MySQL Shell. So far, we’ve covered essential topics like... 15 May 2025 17 min read
Rodrigo Ribeiro Gomes in Database Administration Recovering data in SQL Server without full backup In more than 10 years of experience, I have dealt with cases where someone has performed incorrect operations on a... 13 May 2025 32 min read
Louis Davidson in Editorials What’s Your Price? Everyone has a price, and that price takes many forms. It could be money, loved ones, comfort, duty, or a... 12 May 2025 7 min read
Farooq Aziz in Snowflake Parent – Child Task Automation in Snowflake via Task Graph In the fast-paced world of business, fast, effective data management is crucial. One of the places where this is the... 09 May 2025 12 min read
Anil Kumar Moka in Snowflake Real-time Data Streaming in Snowflake Real-time data ingestion has become essential for modern analytics and operational intelligence. Organizations across industries need to process data streams... 08 May 2025 24 min read
Dennes Torres in T-SQL Programming Techniques to query Azure SQL’s new JSON Datatype The new JSON field type and new functions in Azure SQL brings a new world of possibilities for JSON manipulation... 07 May 2025 15 min read
Lukas Vileikis in MySQL MySQL Index Overviews: Hash Indexes Welcome back to the MySQL indexing series! We’ve already covered the nuances surrounding indexes in MySQL as well as walked... 06 May 2025 14 min read
Matt Gantz in T-SQL Programming Purging Data from a Large Table in SQL Server Purging data from a table is a common database maintenance task to prevent it from growing too large or to... 01 May 2025 8 min read
Robert Sheldon in MongoDB Working with the MongoDB Database Tools The MongoDB Database Tools are a set of command-line utilities for working with MongoDB instances and their data. You can... 29 April 2025 16 min read
Louis Davidson in Editorials The power of connecting in person To start off I want to be clear, I am a big proponent of telecommuting. Big. It has been at... 28 April 2025 6 min read
Goodness Woke in Web Frappe vs. Laravel: REST API Integration Techniques REST APIs are fundamental in enabling communication between applications. Frappe and Laravel offer large frameworks to build and consume REST... 24 April 2025 17 min read
Koen Verbeeck in General Analytics How to Load a Date Dimension in Microsoft Fabric using Macros in dbt? With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features at our disposal... 23 April 2025 7 min read
Bravin Wasike in DevOps Securing the DevOps Pipeline Part 2: Hardening Kubernetes and Cloud Security Strengthening Deployments and Runtime Protection In Part 1 of this series, we explored the foundational aspects of securing a DevOps... 22 April 2025 16 min read
Kathi Kellenberger in DevOps Introduction to GitHub Actions Part 2: GitHub-hosted runners In the first article of this series, you learned how to set up a GitHub Actions Workflow in a GitHub... 18 April 2025 7 min read
Boris Novikov in PostgreSQL A Method for Managing Hierarchies in PostgreSQL The Postgres database management system was originally designed as object-relational. We remind why PostgreSQL is an object-relational rather than just... 17 April 2025 22 min read
