Using a Subquery in a SELECT statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 10 items […]
Homepage
Snowflake: A Cloud Warehouse Solution for Analytics
This article explains what Snowflake data warehouse is and how it is different from other traditional data […]
Working with MySQL transactions
MySQL transactions provide an effective method for executing multiple statements as a single unit, making it possible […]
Manipulating Data In PostgreSQL: Learning PostgreSQL with Grant
So far in the series I’ve shown how to create databases, tables, constraints, indexes and schema. Now, […]
A Guide to INSERT, UPDATE, and DELETE Statements in Oracle
In this article, we’ll be focusing on three of the most used SQL commands in Oracle: INSERT, […]
SQL Server 2022: Capture SQL Anti-Patterns
One of the new Extended Event available in SQL Server 2022 is the query_antipattern. This extended […]
T-SQL Gap-Filling Challenge
A student of mine sent me a T-SQL challenge involving gap-filling of missing dates and balances. I […]
Data Intelligence on light speed: Microsoft Fabric
This article is based on exciting information just released at Microsoft’s Build conference on May 23, 2023. […]
Optimizing MySQL: Adding Data to Tables
Welcome back to the MySQL optimization series! In case you haven’t been following this series, in the […]
PostgreSQL Basics: A Template for Managing Database Privileges
In the first two articles of this series about PostgreSQL privileges, we reviewed how to create roles, […]
Changing log growth strategy in SQL Server 2022
When I first saw a bullet item stating SQL Server 2022 would support instant file initialization for […]
Uncovering the mysteries of PostgreSQL (auto) vacuum
Welcome to the second blog of the “magic of parameters” series. In the first entry, I covered […]
Importing data into a MySQL database using LOAD DATA
Database and development teams often load data from plain text files into their MySQL databases. The files […]
PostgreSQL Basics: Essential psql Tips and Tricks
Having access to the psql command-line tool is essential for any developers or DBAs that are actively […]
How to secure legacy ASP.NET MVC against Cross-Site(CSRF) Attacks
Cross-Site Request Forgery (CSRF) attacks are widespread, and even some BigTech companies suffer from them. Netflix suffered […]
PostgreSQL Schema: Learning PostgreSQL with Grant
An important aspect of building and managing a database is organizing the objects within your database. You […]
Modifying MySQL data from within Python
In the previous article in this series, I introduced you to how to access MySQL data from […]
GENERATE_SERIES: My new go-to to build sets
I have come across a lot of use cases for manufacturing rows on the fly, aside from […]
Using Virtual Network Data Gateways to Secure Access to Azure ...
Power BI and Azure are two related services, but with a considerable independence between them. Power BI […]
Paging Data in T-SQL
Sometimes when working with very large sets of data, you may not want to return all of […]
The SELECT Statement in Oracle
The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT […]
Are PostgreSQL memory parameters magic?
Configuration parameters are the most mythical creatures in the world of PostgreSQL. Ordinary PostgreSQL users often do […]
Why a monitoring tool is an essential tool for growing ...
When I was a DBA involved with the management of a large number of database servers, I […]
Retrieving MySQL data from within Python
Applications of all types commonly access MySQL to retrieve, add, update, or delete data. The applications might […]
Getting Out of Character
Pre-Unicode Younger programmers have grown up with ASCII and Unicode as the only ways of representing character […]
Find 40 Problems in this SQL Server Stored Procedure
I’ve been at this for a while now, and have a very particular set of rules and […]
PostgreSQL Basics: Object Ownership and Default Privileges
In the first security article, PostgreSQL Basics: Roles and Privileges, I discussed how roles (users and groups) […]
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 […]
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 […]
Using TOP clause in a SELECT statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 9 items […]
PostgreSQL Constraints: Learning PostgreSQL with Grant
PostgreSQL supports constraints much like any other database management system. When you need to ensure certain behaviors […]
Manage Data Over Time with SQL Server MERGE Statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 8 items […]
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 […]
Introducing the MySQL common table expression
This article is part of Robert Sheldon’s continuing series on Learning MySQL. To see all 10 items […]
Don’t Just Chase the Shiny
Fish are beautiful creatures, but they have one minor issue. The main thing I remember from the […]
Azure Function and User Assigned Managed Identities
Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many […]
Resolving to Write in the New Year
It is almost New Year’s Day, that time when the optimistic at heart start thinking about making […]
The Good, The Bad, and Suboptimal of Sticking to What ...
The Good In the late 1990s, one of the world’s most popular technologies was waning. COBOL. Relational […]
Subqueries in MySQL
Part of Robert Sheldon’s continuing series on Learning MySQL. The series so far: Getting started with MySQL […]
Express.js or Next.js for your Backend Project
Backend projects create projects to execute code on a centralized server and then communicate results with a […]
Converting Data Across Time Zones: An In-Depth Primer
If only the entire world used UTC, wouldn’t life be so much easier? We can dream, can’t […]
The Basics of Deleting Data from a SQL Server Table
Greg Larsen’s series on Learning T-SQL so far: The basic T-SQL Select Statement Ordering a result set […]
How to Use Any SQL Database in GO with GORM
Object Relational Mapping is a database abstraction technique that aids developers in manipulating and interacting with SQL […]
Introducing the MySQL UPDATE statement
Entry in Robert Sheldon’s series on Learning MySQL. The series so far: Getting started with MySQL Working […]
Oracle optimizer Or Expansion Transformations
Jonathan Lewis’ continuing series on the Oracle optimizer and how it transforms queries into execution plans: Transformations […]
The Basics of Updating Data in a SQL Server Table
Entry in Greg Larsen’s series on Learning T-SQL. The series so far: The basic T-SQL Select Statement […]
Going to the PASS Data Community Summit this year?
We are just one month away from the PASS Data Community Summit. One month. If you haven’t […]
Backing up MySQL Part 1: mysqldump
mysqldump is one of the most popular database backup tools in the MySQL world. The tool is […]