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

Aaron Bertrand in T-SQL Programming

Five changes to SQL Server I’d love to see

I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very few of my...

01 January 2025 5 min read

Louis Davidson in Editorials

Simple Talk 2024 Year in Review

Edit: Added pictures to the PASS section of the Redgate Hub Happy New Year to all of the Simple talk...

31 December 2024 7 min read

Chisom Kanu in MySQL

Introduction to MySQL Shell and Basic Configuration Management (Part 1)

The database is an important part of any application and setting it up correctly is key to ensuring smooth performance....

27 December 2024 23 min read

Goodness Woke in Other Development

Frappe’s Configuration vs Laravel’s Code-Centric Customisation

This article compares the Frappe and the Laravel frameworks, focusing on key technical differences in customization, database management, and API...

23 December 2024 23 min read

Bravin Wasike in DevOps

Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real World Examples of CI CD

This article covers examples of how some larger companies have successfully implemented CI/CD practices to transform their development processes. Through...

20 December 2024 12 min read

John Kerski in Data Science

Comparing Groups for Similarities in Power Query – Using Cosine Similarity

I’ll admit upfront—I am not a data scientist by trade. Instead, I’ve picked up my data science skills over time,...

17 December 2024 7 min read

Anil Kumar Moka in Snowflake

When Should You Employ Snowflake Materialized Views?

I’ve used both Snowflake views and materialized views with varying degrees of success. Both have their place and it’s on...

16 December 2024 16 min read

Phil Factor in Other Development

Data Documents and Common Sense

What can be so difficult in creating a sensible standard for Structured Data Documents? To understand why they tend to...

13 December 2024 5 min read

Louis Davidson in Career

TSQL Tuesday #181 – The first SQL Server Feature that made me go “Wow!”

First off, thank you to Kevin Chant for hosting TSQL Tuesday this month. And equally, thank you for not putting...

11 December 2024 4 min read

Koen Verbeeck in General Analytics

A gentle introduction to dbt

In a typical data warehouse project, data is loaded, transformed and stored into a data store using an ETL (extract...

10 December 2024 12 min read