Louis Davidson in Editorials

Time to opine in this year’s Redgate’s State of the Database Landscape Survey

Every year, Redgate puts out a survey to technology workers around the globe asking a set of straightforward, non-invasive questions...

23 August 2024 2 min read

Edward Pollack in T-SQL Programming

Effective Strategies for Storing and Parsing JSON in SQL Server

Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or semi-structured data. Because...

23 August 2024 26 min read

Robert Sheldon in NoSQL

Introducing Schema Validation in MongoDB

Similar to other NoSQL database systems, MongoDB is known for its flexible and variable schema models, unlike relational database systems...

21 August 2024 21 min read

Ben Johnston in Blogs

Auditing SQL Server – Part 4 – Database Configuration Audit

This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level hardware audits and...

20 August 2024 15 min read

Joe Celko in Theory and design

LIKE Constraints

In this article, I will cover a bit about the LIKE operator, including how it works, and a bit of...

19 August 2024 10 min read

Lee Asher in PostgreSQL

PostgreSQL Partitioning: The Most Useful Feature You May Never Have Used

Partitioning in PostgreSQL was for many years a feature almost entirely ignored, and even today is often thought of only...

16 August 2024 10 min read

Farooq Aziz in Snowflake

Change Data Capture Pipeline Automation in Snowflake

This article offers technical guidance on automating updates and tracking changes of data examples using Snowflake’s CDC capabilities. The examples...

15 August 2024 12 min read

Louis Davidson in Editorials

PASS Summit Scholarships? Awesome!

This year, PASS is introducing scholarships to support individuals who might not typically have the opportunity to attend the PASS...

15 August 2024 3 min read

Dennes Torres in Blogs

PySpark: The flexibility of a loop

Pyspark has many flexible syntaxes which are not so common to other languages. One of these syntaxes is the loop...

15 August 2024 3 min read

Lukas Vileikis in Blogs

Thoughts Before Speaking at the Software Architecture Conference

This blog shares the thoughts of a conference speaker Lukas Vileikis before speaking at a conference called Software Architecture Conference.…

14 August 2024 3 min read

Aisha Bukar in MySQL

MySQL vs PostgreSQL: Which Open-Source Database is right for you?

When I joined a growing startup company as a backend developer, we were at crossroads choosing between MySQL and PostgreSQL...

12 August 2024 12 min read

Bravin Wasike in CI/CD

Why Every Project Needs a CI/CD Pipeline No Matter How Small

Have you ever experienced a scenario as a developer when a seemingly simple weekend bug fix throws your entire project...

09 August 2024 15 min read

Dennes Torres

Microsoft Fabric: Using Lakehouse data in Real Time Dashboards

Real-Time dashboards are a great feature in Real Time Intelligence experience to monitor our data. However, by default it’s made...

08 August 2024 2 min read

Lukas Vileikis in MySQL

MySQL Index Overviews: B-Tree Indexes

In this first entry in a multipart series on indexes, I will cover the most important index type in MySQL,...

05 August 2024 19 min read

Aaron Bertrand in SQL Server

Days of the Week, Bitwise Edition

I recently had to help support synchronization and distribution of workloads between multiple servers. Some of this work involves Task...

02 August 2024 7 min read

Blogs

Dennes Torres in Blogs

Microsoft Fabric: Differences Between %Run and Notebook.Run

When developing notebooks in Microsoft Fabric, we have two different methods to call one notebook from another: %Run and MSSparkUtils.notebook.run...

31 July 2024 2 min read

Career

Simple Talk Editor in Career

Amplify your Experience – How to Start Writing and Speaking

At PASS Data Community Summit 2023, Tonie Huizer and Tony Davis joined forces to deliver a one-hour session all about...

31 July 2024 6 min read

Steve Jones in Editorials

5 Ways to Spend Your 2024 Learning and Development Budget in the US

Not many data professionals get a personal Learning and Development (L&D) budget that we can use at our discretion. This...

30 July 2024 7 min read

Louis Davidson in Editorials

Fall is around the corner, and hence the PASS Data Community Summit, too

Welcome to the dog days of summer in the Northern Hemisphere. It is hot, so if you are like me...

29 July 2024 5 min read

Marcella McKeown in Editorials

Insights from Redgate’s PASS Senior Program Manager

In today’s editorial, guest writer Marcella McKeown shares some insights from her tenure from working on the program of PASS...

27 July 2024 5 min read

Register for Simple Talk

Articles

Time to opine in this year’s Redgate’s State of the Database Landscape Survey

Effective Strategies for Storing and Parsing JSON in SQL Server

Introducing Schema Validation in MongoDB

Auditing SQL Server – Part 4 – Database Configuration Audit

LIKE Constraints

PostgreSQL Partitioning: The Most Useful Feature You May Never Have Used

Change Data Capture Pipeline Automation in Snowflake

PASS Summit Scholarships? Awesome!

PySpark: The flexibility of a loop

Thoughts Before Speaking at the Software Architecture Conference

MySQL vs PostgreSQL: Which Open-Source Database is right for you?

Why Every Project Needs a CI/CD Pipeline No Matter How Small

Microsoft Fabric: Using Lakehouse data in Real Time Dashboards

MySQL Index Overviews: B-Tree Indexes

Days of the Week, Bitwise Edition

Microsoft Fabric: Differences Between %Run and Notebook.Run

Amplify your Experience – How to Start Writing and Speaking

5 Ways to Spend Your 2024 Learning and Development Budget in the US

Fall is around the corner, and hence the PASS Data Community Summit, too

Insights from Redgate’s PASS Senior Program Manager