Ryan Booz in PostgreSQL

PostgreSQL Roles and Privileges: Users, Groups, GRANT Syntax, PUBLIC Role, and Best Practices

Complete guide to PostgreSQL roles and privileges - creating user roles and group roles, the PUBLIC role, granting privileges with...

19 January 2023 20 min read

Learn SQL Server

Greg Larsen in Learn SQL Server

Manage Data Over Time with SQL Server MERGE Statement

Once data is in a table it needs to be maintained. New records will need to be added, and existing...

17 January 2023 13 min read

PostgreSQL

Grant Fritchey in PostgreSQL

Index Types in PostgreSQL: Learning PostgreSQL with Grant

As with any other relational data management system (RDBMS), PostgreSQL uses indexes as a mechanism to improve data access. PostgreSQL...

09 January 2023 15 min read

MySQL

Robert Sheldon in MySQL

MySQL Common Table Expressions (CTEs): WITH Clause, Recursive Queries

Use MySQL common table expressions (CTEs) to simplify complex queries with the WITH clause. Covers basic CTEs, multiple CTEs in...

05 January 2023 23 min read

Other

Louis Davidson in Other

Dealing with the Bits of a Binary Value in SQL Server

In this article, I want to talk about a topic that you may never need. The only time I have...

04 December 2022 5 min read

MySQL

Robert Sheldon in MySQL

MySQL Subqueries: Scalar, Correlated, Row, Column, and Derived Tables

Complete MySQL subquery guide: scalar subqueries for single values, correlated subqueries that reference the outer query, row and column subqueries,...

02 December 2022 22 min read

T-SQL Programming

Edward Pollack in T-SQL Programming

SQL Server Time Zones: AT TIME ZONE, SWITCHOFFSET, DATETIMEOFFSET, and Daylight Saving

Complete primer on SQL Server time zone conversion - the components of a time zone (bias, daylight saving rules), how...

21 November 2022 28 min read

MySQL

Robert Sheldon in MySQL

Introducing the MySQL DELETE statement

In the last few articles in this series, you learned about three important data manipulation language (DML) statements: SELECT, INSERT,...

12 November 2022 17 min read

Learn SQL Server

Greg Larsen in Learn SQL Server

The Basics of Deleting Data from a SQL Server Table

Over time data in SQL Server tables needs to be modified. There are two major different aspects of modifying data:...

07 November 2022 12 min read

MySQL

Robert Sheldon in MySQL

Introducing the MySQL UPDATE statement

In the previous two articles in this series, you learned about SELECT and INSERT, two important data manipulation language (DML)...

28 October 2022 21 min read

Oracle

Jonathan Lewis in Oracle

Oracle Or-Expansion Transformation: How the Optimizer Rewrites OR Predicates into UNION ALL for Index Access

Oracle's Or-Expansion transformation - how the cost-based optimiser rewrites queries containing OR predicates into UNION ALL branches that can each...

26 October 2022 16 min read

Learn SQL Server

Greg Larsen in Learn SQL Server

The Basics of Updating Data in a SQL Server Table

Once data is inserted into a table, it typically needs to be maintained as time goes on. To make changes...

21 October 2022 14 min read

MySQL

Lukas Vileikis in MySQL

Backing up MySQL Part 1: mysqldump

mysqldump is one of the most popular database backup tools in the MySQL world. The tool is prevalent partly because...

14 October 2022 11 min read

MySQL

Robert Sheldon in MySQL

Introducing the MySQL INSERT statement

In the previous article in this series, I introduced you to the SELECT statement, one of several SQL statements that...

07 October 2022 22 min read

Learn SQL Server

Greg Larsen in Learn SQL Server

The Basics of Inserting Data into a SQL Server Table

Before data can be read from of a SQL Server database table, the table needs to contain rows of data....

04 October 2022 15 min read

Other

Louis Davidson in Other

Generating Repeatable Sets Of Test Rows

In order to test graph structures, I needed a large set of random data. In some ways, this data will...

30 September 2022 11 min read

MySQL

Robert Sheldon in MySQL

Introducing the MySQL SELECT statement

Use SELECT statements to query a MySQL database. In this article, Robert Sheldon explains how. …

15 June 2022 18 min read

T-SQL Programming

Greg Larsen in T-SQL Programming

Summarizing data in SQL Server using GROUP BY and HAVING clauses

You can summarize data to get counts, averages, sums, and more using GROUP BY in T-SQL queries. Greg Larsen shows...

27 May 2022 11 min read

MySQL

Lukas Vileikis in MySQL

Security in MySQL: Part Two

There’s more to security in MySQL than user account privileges. In this article, Lukas Vileikis explains the other components of...

27 May 2022 10 min read

BI

Dennes Torres in BI

Datamarts and exploratory analysis using Power BI

During Build 2022, Microsoft announced a new feature, Datamarts for Power BI. MVP Dennes Torres explains this new feature and...

25 May 2022 24 min read

Register for Simple Talk

Databases

PostgreSQL Roles and Privileges: Users, Groups, GRANT Syntax, PUBLIC Role, and Best Practices

Manage Data Over Time with SQL Server MERGE Statement

Index Types in PostgreSQL: Learning PostgreSQL with Grant

MySQL Common Table Expressions (CTEs): WITH Clause, Recursive Queries

Dealing with the Bits of a Binary Value in SQL Server

MySQL Subqueries: Scalar, Correlated, Row, Column, and Derived Tables

SQL Server Time Zones: AT TIME ZONE, SWITCHOFFSET, DATETIMEOFFSET, and Daylight Saving

Introducing the MySQL DELETE statement

The Basics of Deleting Data from a SQL Server Table

Introducing the MySQL UPDATE statement

Oracle Or-Expansion Transformation: How the Optimizer Rewrites OR Predicates into UNION ALL for Index Access

The Basics of Updating Data in a SQL Server Table

Backing up MySQL Part 1: mysqldump

Introducing the MySQL INSERT statement

The Basics of Inserting Data into a SQL Server Table

Generating Repeatable Sets Of Test Rows

Introducing the MySQL SELECT statement

Summarizing data in SQL Server using GROUP BY and HAVING clauses

Security in MySQL: Part Two

Datamarts and exploratory analysis using Power BI