Databases

20 March 2023 10 min read

Greg Larsen in T-SQL Programming

Paging Data in T-SQL

Sometimes when working with very large sets of data, you may not want to return all of the data at...

Oracle

Chandra Rawat in Oracle

The SELECT Statement in Oracle

The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT statement, a tabular...

16 March 2023 19 min read

13 March 2023 10 min read

Henrietta Dombrovskaya in PostgreSQL

Are PostgreSQL memory parameters magic?

Configuration parameters are the most mythical creatures in the world of PostgreSQL. Ordinary PostgreSQL users often do not know that...

Louis Davidson in T-SQL Programming

Optional Code in T-SQL Scripts using SQLCMD

When you are writing T-SQL scripts to save away, for example one to create a new database, there are often...

06 March 2023 6 min read

02 March 2023 19 min read

Robert Sheldon in MySQL

Python MySQL: How to Query & Retrieve Data

Learn how to connect to MySQL from Python and retrieve data using MySQL Connector. Covers connections, cursors, fetchall/fetchone, parameterized queries,...

Theory and design

Joe Celko in Theory and design

Getting Out of Character

In this article, Joe Celko gives us a history of the different character sets that are used in computing and...

28 February 2023 13 min read

23 February 2023 22 min read

Aaron Bertrand in T-SQL Programming

40 Common Stored Procedure Problems in SQL Server

Review 40 real stored procedure problems in SQL Server: naming conventions, error handling, NOCOUNT, temp table usage, sargability, schema binding,...

Ryan Booz

PostgreSQL Object Ownership and Default Privileges: A Practical Guide

Solve PostgreSQL permission problems: understand object ownership, the ALTER DEFAULT PRIVILEGES command, and how to configure permissions so multiple developers...

21 February 2023 16 min read

Learn SQL Server

Greg Larsen in Learn SQL Server

Using TOP clause in a SELECT statement

There might be a time when you might want to return just a few rows of a result set, instead...

06 February 2023 11 min read

02 February 2023 23 min read

Grant Fritchey in PostgreSQL

PostgreSQL Constraints: Learning PostgreSQL with Grant

One of the most important aspects of data management is the ability to ensure that the data in your database...

31 January 2023 28 min read

Lukas Vileikis in MySQL

Optimizing Queries in MySQL: Optimizing Reads

Optimizing read operations is one of the most prominent problems concerning any database administrator. No matter what kind of database...

19 January 2023 20 min read

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...

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

09 January 2023 15 min read

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...

05 January 2023 23 min read

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...

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

02 December 2022 22 min read

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,...