Louis Davidson in Editorials

Art and Science and of course AI

There is a classic argument that goes like this, “is programming art or a science?” In its purest form, science...

03 February 2025 5 min read

Louis Davidson in SQL Server

Dark Mode in SSMS 21 and overall first impressions

Let me cut to the chase. If you are like me, you may have been searching for: How to turn...

02 February 2025 4 min read

Goodness Woke in Web

Frappe and Laravel: Database Management and Migrations

In this second installment of our series comparing Frappe and Laravel, we probe into critical aspects of database management and...

01 February 2025 14 min read

Phil Factor in Editorials

Accessibility, and the Need for Ingenious Simplicity in Computer Scripts, Languages and Programs

I’m very keen on accessibility in computer systems. Nowadays we tend to take a rather superior attitude to this problem,...

30 January 2025 12 min read

Dennes Torres in Blogs

SQL Endpoint Secrets you need to know

Recently I had a severe problem with SQL endpoints and I was required to build a quick workaround for this....

29 January 2025 5 min read

Robert Sheldon in MongoDB

Creating Time Series Collections in MongoDB

Throughout this series, I’ve introduced you to different features in MongoDB and provided examples to help demonstrate how the database...

27 January 2025 15 min read

Louis Davidson in Blogs

Weekly Blogging

I spent a few weeks away from the office in early January, just like last year, mostly on vacation. Something...

27 January 2025 3 min read

Joe Celko in Theory and design

Temporary Tables

There is a feature of SQL I have not seen used much and probably with good reason. It’s the use...

24 January 2025 9 min read

Dennes Torres in Blogs

Azure SQL Serverless: Discover What’s new and Increase Your Savings

Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure SQL Serverless? The...

22 January 2025 3 min read

Louis Davidson in Editorials

Nostalgic Memory Loss

Today’s topic pertains to 99.999% of all people, young, old, and all age ranges . I am also not talking...

20 January 2025 4 min read

Koen Verbeeck in General Analytics

Loading Models from Source Data with dbt

The data transformation tool dbt (data build tool) has become more and more popular over the past years. It focuses...

20 January 2025 8 min read

Chisom Kanu in MySQL

MySQL Shell Basic Configuration Management (Part 2 – Memory and CPU)

In the first part of the series article, we introduced MySQL Shell as a tool for managing and optimizing MySQL...

17 January 2025 17 min read

Mercy Bassey in Security and Compliance

Using Snyk for CI/CD Security Scanning

Security is important regardless of your industry, whether it’s finance, retail, e-commerce, or the broader world of IT. A little...

16 January 2025 19 min read

Dennes Torres in Blogs

Fabric Copy Job: What’s new in it

At first sight, the new Copy Job may seem only one more redundancy: Why do we need this? We have...

15 January 2025 2 min read

Joe Celko in Theory and design

VIEW Objects

A view is a virtual table, created when it’s invoked by the < view name>. The goal we had in...

13 January 2025 7 min read

Hacking MySQL - Breaking, Optimizing, and Securing MySQL for Your Use Case

Lukas Vileikis in Blogs

I Wrote a Book on How You Broke Your Database – Here’s Why You Should Read It

This blog introduces the book "Hacking MySQL: Breaking, Optimizing, and Securing MySQL for Your Use Case" by Lukas Vileikis.…

10 January 2025 7 min read

Edward Pollack in SQL Server

Customizing the Export and import of Parquet Files in SQL Server

Previously, we introduced and discussed the Parquet file format and SQL Server and why it is an ideal format for...

10 January 2025 10 min read

Microsoft Fabric

Dennes Torres in Microsoft Fabric

High Concurrency Data Pipelines in Fabric

Data Pipelines can orchestrate many activities, creating a flow for data ingestion. One of these activities is the notebook execution...

08 January 2025 2 min read

Ben Johnston in Blogs

A Use Case for Memory-Optimized Tempdb Metadata

I recently had an interesting production SQL Server issue that turned out to be very easy to fix. The fix...

08 January 2025 10 min read

Kellyn Pot'Vin-Gorman in Oracle

Oracle Architecture Overview

I often fall back to the tried-and-true methods to understanding Oracle environments. Yes, sometimes the older ways are best, but...

02 January 2025 24 min read

Register for Simple Talk

Articles

Art and Science and of course AI

Dark Mode in SSMS 21 and overall first impressions

Frappe and Laravel: Database Management and Migrations

Accessibility, and the Need for Ingenious Simplicity in Computer Scripts, Languages and Programs

SQL Endpoint Secrets you need to know

Creating Time Series Collections in MongoDB

Weekly Blogging

Temporary Tables

Azure SQL Serverless: Discover What’s new and Increase Your Savings

Nostalgic Memory Loss

Loading Models from Source Data with dbt

MySQL Shell Basic Configuration Management (Part 2 – Memory and CPU)

Using Snyk for CI/CD Security Scanning

Fabric Copy Job: What’s new in it

VIEW Objects

I Wrote a Book on How You Broke Your Database – Here’s Why You Should Read It

Customizing the Export and import of Parquet Files in SQL Server

High Concurrency Data Pipelines in Fabric

A Use Case for Memory-Optimized Tempdb Metadata

Oracle Architecture Overview