
Analyze and Tune SQL Server Statistics
Over the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and […]
Over the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and […]
If you haven’t already heard, SQL 2022 has introduced a new built-in system function called GREATEST. Simply […]
MySQL provides a set of constraints that you can include in your table definitions to help ensure […]
Microsoft is merging Data Factory and Power BI Dataflows in one single ETL solution. It’s not a […]
If you’ve been using MySQL for a while and want to learn how to orchestrate MySQL containers, […]
This article is part of Aisha Bukar’s 6 part series on MySQL Replication. The entries include: Part […]
While there are many features within PostgreSQL that are really similar to those within SQL Server, there […]
The simple answer to this question is “a lot.” The funny part, however, is that everyone who […]
At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical […]
Concurrency control is an essential aspect of database systems that deals with multiple concurrent transactions. PostgreSQL employs […]
In the last blog (When PostgreSQL Parameter Tuning is not the Answer), we compared several execution plans […]
In modern software development, Application Programming Interfaces (APIs) are essential for building scalable and flexible systems. APIs […]
A challenge that reappears periodically in the world of databases (especially database management) is the need to […]
This article is part of Robert Sheldon’s continuing series on Learning MySQL. To see all of the […]
Writing queries to retrieve the data from a database is probably the single most common task when […]
In the previous parts of these MySQL optimization series, we’ve told you how queries work on a […]
In coming up with a strategy for managing test data, first you need to understand what the […]
When you’re learning SQL DML, the most complicated clause is typically the GROUP BY. It’s a fairly […]
So much about parameters tuning, but does it always help? Welcome to the third and final blog […]
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 10 items […]
This article explains what Snowflake data warehouse is and how it is different from other traditional data […]
MySQL transactions provide an effective method for executing multiple statements as a single unit, making it possible […]
So far in the series I’ve shown how to create databases, tables, constraints, indexes and schema. Now, […]
In this article, we’ll be focusing on three of the most used SQL commands in Oracle: INSERT, […]
One of the new Extended Event available in SQL Server 2022 is the query_antipattern. This extended […]
A student of mine sent me a T-SQL challenge involving gap-filling of missing dates and balances. I […]
This article is based on exciting information just released at Microsoft’s Build conference on May 23, 2023. […]
Welcome back to the MySQL optimization series! In case you haven’t been following this series, in the […]
In the first two articles of this series about PostgreSQL privileges, we reviewed how to create roles, […]
When I first saw a bullet item stating SQL Server 2022 would support instant file initialization for […]
Welcome to the second blog of the “magic of parameters” series. In the first entry, I covered […]
Database and development teams often load data from plain text files into their MySQL databases. The files […]
Having access to the psql command-line tool is essential for any developers or DBAs that are actively […]
Cross-Site Request Forgery (CSRF) attacks are widespread, and even some BigTech companies suffer from them. Netflix suffered […]
An important aspect of building and managing a database is organizing the objects within your database. You […]
In the previous article in this series, I introduced you to how to access MySQL data from […]
I have come across a lot of use cases for manufacturing rows on the fly, aside from […]
Power BI and Azure are two related services, but with a considerable independence between them. Power BI […]
Sometimes when working with very large sets of data, you may not want to return all of […]
The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT […]
Configuration parameters are the most mythical creatures in the world of PostgreSQL. Ordinary PostgreSQL users often do […]
When I was a DBA involved with the management of a large number of database servers, I […]
Applications of all types commonly access MySQL to retrieve, add, update, or delete data. The applications might […]
Pre-Unicode Younger programmers have grown up with ASCII and Unicode as the only ways of representing character […]
I’ve been at this for a while now, and have a very particular set of rules and […]
In the first security article, PostgreSQL Basics: Roles and Privileges, I discussed how roles (users and groups) […]
The five-part series is designed to jump-start any IT professional’s journey in the fascinating world of Data […]
The tools classified as “Realtime Backend / API“, or tools that can rapidly process an API call […]
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 9 items […]