16 March 2023
16 March 2023

The SELECT Statement in Oracle

0
27
The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT statement, a tabular result is held in a result table (called a result set). It allows you to select the table columns depending on a set of criteria. SELECT statements might be as straightforward as selecting a few … Read more
0
27

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 PostgreSQL configuration parameters exist, let alone what they are and what they mean. There is a good reason for such ignorance since, in real life, ordinary users don’t have any say in how these parameters … Read more
10 March 2023
10 March 2023

Build a Better WordPress Archives Page Using MySQL

0
0
Uncategorized
I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data from an events table (part 1 and part 2). This technique could be used to overlay any type of data onto calendars, but my specific goal was to make the monthly archives page on my … Read more
0
0
Uncategorized
02 March 2023
02 March 2023

Retrieving MySQL data from within Python

0
3
Applications of all types commonly access MySQL to retrieve, add, update, or delete data. The applications might be written in Python, Java, C#, or another programming language. Most languages support multiple methods for working with a MySQL database and manipulating its data. The approach you take when accessing MySQL will depend on the programming language … Read more
0
3
21 February 2023
21 February 2023

PostgreSQL Basics: Object Ownership and Default Privileges

In the first security article, PostgreSQL Basics: Roles and Privileges, I discussed how roles (users and groups) are created and managed in PostgreSQL Depending on your background with permissions, particularly in other database products, some of those nuances in how permissions work may have been surprising. Understanding how roles and privileges work in Postgres is … Read more
15 February 2023
15 February 2023

Azure Machine Learning Introduction: Part 1 Overview and prep work

The five-part series is designed to jump-start any IT professional’s journey in the fascinating world of Data Science with Azure Machine Learning (Azure ML). Readers don’t need prior knowledge of Data Science, Machine Learning, Statistics, or Azure to begin this adventure. All you will need is an Azure subscription and I will show you how … Read more
09 February 2023
09 February 2023

Firebase and Supabase: Key differences you need to know

The tools classified as “Realtime Backend / API“, or tools that can rapidly process an API call and in this case, store data, include Firebase and Supabase. Firebase is a NoSQL database, while Supabase is a relational database. The Firestore database, which lets you store “documents,” is the core of Firebase. These are collections of … Read more
06 February 2023
06 February 2023

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 of the complete set. This might be useful if you want to just validate a selection criteria or a few rows of data. For whatever the reason the TOP clause can be used to return a specific number or a percentage of rows from a result set. This article will cover using the TOP clause in a SELECT statement and how it can be used to return a partial set of records.… Read more
02 February 2023
02 February 2023

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 is well defined and consistent. Some aspects of that are ensured through the relational data structures you design. Another piece of control is using the correct data type. Then, we get to constraints. A constraint is a way to validate data prior to adding it to your database. This is one more tool in the toolbox that helps you maintain good data.… Read more
31 January 2023
31 January 2023

Optimizing Queries in MySQL: Optimizing Reads

0
4
Optimizing read operations is one of the most prominent problems concerning any database administrator. No matter what kind of database management system is in use – MySQL, its flavors like Percona Server or MariaDB, MongoDB, TimescaleDB, SQL Server, or others, read queries are a concern. The primary read query example is SELECT queries, but a lot of this pertains to UPDATE and DELETE as well since they too have to fetch rows to be operated on.… Read more
0
4
25 January 2023
25 January 2023

AWS Lambdas with C#

0
4
Serverless computing is pushing C# to evolve to the next level. This is exciting because you pay-per-use and only incur charges when the code is running. This means that .NET 6 must spin up fast, do its job, then die quickly. This mantra of birth and rebirth pushes developers and the underlying tech to think … Read more
0
4
23 January 2023
23 January 2023

Testing before coding: shifting farther left

A term I have only recently learned is "shift left testing." You can read more about this on Wikipedia here. The term was coined in 2001 and generally means testing earlier in the development lifecycle. Hence, shifting your testing left in the timeline. Just how left should you shift your testing, though? In my mind, so early, the rooster hasn't entirely fallen asleep yet.… Read more
19 January 2023
19 January 2023

PostgreSQL Basics: Roles and Privileges

Information security, whether in databases, applications, or larger IT systems, is based on the principles of Authentication and Authorization, often referred to as AuthN and AuthZ respectively. Likewise, PostgreSQL security involves creating roles that allow access to server resources (AuthN) and then granting privileges to database objects appropriately (AuthZ). Understanding how each of these components work together is essential to effectively manage security in a PostgreSQL cluster.… Read more
17 January 2023
17 January 2023

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 records will need to be updated, and/or deleted. To keep data maintained, the insert, update or delete actions may need to be performed. This article will show how those three data manipulation language (DML) actions can be synchronized together within a single basic MERGE statement.… Read more