Aisha Bukar in MySQL

A Beginners Guide to MySQL Replication Part 5: Group Replication

MySQL Group replication is a remarkable feature introduced in MySQL 5.7 as a plugin. This technology allows you to create...

28 August 2023 7 min read

Other

Louis Davidson in Other

Yet Another Reason to Not Use sp_ in SQL Server Object Names

In 2012, Aaron Bertrand said most everything I knew (and a bit more) about the issues with using the sp_...

25 August 2023 6 min read

PostgreSQL

Grant Fritchey in PostgreSQL

Introducing VACUUM: Learning PostgreSQL With Grant

While there are many features within PostgreSQL that are really similar to those within SQL Server, there are some that...

21 August 2023 11 min read

T-SQL Programming

Aaron Bertrand in T-SQL Programming

Working around schema drift in SQL Server

At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical schema. (By “schema,”...

14 August 2023 10 min read

PostgreSQL

Mohan Saraswatipura in PostgreSQL

Database Concurrency in PostgreSQL

Concurrency control is an essential aspect of database systems that deals with multiple concurrent transactions. PostgreSQL employs various techniques to...

11 August 2023 19 min read

Other

Aisha Bukar in Other

A Beginners Guide to MySQL Replication Part 4: Using GTID-based Replication

Welcome back to another replication series! As a quick reminder, we explored various methods of using MySQL’s replication capabilities in...

08 August 2023 11 min read

PostgreSQL

Henrietta Dombrovskaya in PostgreSQL

What Is an Execution Plan and How to Find It in PostgreSQL

In the last blog (When PostgreSQL Parameter Tuning is not the Answer), we compared several execution plans for a SQL...

07 August 2023 13 min read

SQL Server

Ben Johnston in SQL Server

A practical introduction to Row-Level Security in SQL Server (complete guide, part one)

Row-Level Security in SQL Server lets identical queries return different rows per user. Here's how it works, when to use...

01 August 2023 16 min read

Database Administration

Edward Pollack in Database Administration

Run T-SQL Across Multiple SQL Server Databases: A Reusable Solution

Run T-SQL across multiple SQL Server databases reliably - without sp_MSforeachdb. Build a reusable solution with database filters, object presence...

31 July 2023 15 min read

SQL Server

Ben Johnston in SQL Server

Unmasking SQL Server Dynamic Data Masking, Part 5: Mitigations and Summary

This is the fifth and final part of this series on SQL Server Dynamic Data Masking. In this article, I’ll...

30 July 2023 12 min read

MySQL

Robert Sheldon in MySQL

MySQL SELECT INTO OUTFILE: Export Data to CSV/Text

Complete guide to MySQL SELECT INTO OUTFILE for exporting query results to CSV, TSV, and text files. Covers syntax, FIELDS...

27 July 2023 22 min read

PostgreSQL

Grant Fritchey in PostgreSQL

Querying PostgreSQL: Learning PostgreSQL with Grant

Writing queries to retrieve the data from a database is probably the single most common task when it comes to...

24 July 2023 9 min read

MySQL

Lukas Vileikis in MySQL

Optimizing Queries in MySQL: Optimizing Updates

In the previous parts of these MySQL optimization series, we’ve told you how queries work on a high level, then...

20 July 2023 11 min read

Other

Aisha Bukar in Other

A Beginners Guide to MySQL Replication Part 3: Multi-Source Replication

Welcome back to the world of MySQL Replication! If you’ve been following this series, thank you for your support! And...

18 July 2023 11 min read

Theory and design

Joe Celko in Theory and design

The GROUP BY Clause

When you’re learning SQL DML, the most complicated clause is typically the GROUP BY. It’s a fairly simple grouping based...

10 July 2023 27 min read

PostgreSQL

Henrietta Dombrovskaya in PostgreSQL

When PostgreSQL Parameter Tuning is not the Answer

So much about parameters tuning, but does it always help? Welcome to the third and final blog of the “magic...

06 July 2023 9 min read

SQL Server

Ben Johnston in SQL Server

Unmasking SQL Server Dynamic Data Masking, Part 4, Unmasking Formatted and Unformatted Text

Continuing from the previous entry in this series on security concerns with using Dynamic Data Masking, in this article I...

27 June 2023 30 min read

T-SQL Programming

Greg Larsen in T-SQL Programming

SQL Subquery in SELECT: Examples & Syntax Guide

Learn to embed subqueries inside a SELECT statement in SQL Server. Covers scalar subqueries, correlated subqueries, derived tables, and how...

26 June 2023 15 min read

Snowflake

Pankaj Gupta in Snowflake

Snowflake: A Cloud Warehouse Solution for Analytics

This article explains what Snowflake data warehouse is and how it is different from other traditional data warehouses. This article...

19 June 2023 19 min read

Featured

Robert Sheldon in Featured

MySQL Transactions: BEGIN, COMMIT, ROLLBACK, Autocommit, and Exception Handling in Stored Programs

A practical guide to MySQL transactions - BEGIN, COMMIT, and ROLLBACK; autocommit behaviour and when to turn it off; wrapping...

15 June 2023 20 min read