Celebrating 30 years of PostgreSQL, A Thank you message
A Thank You message to the original founds of the PostgreSQL project and members of the community that have been working so hard for 30 years.
A Thank You message to the original founds of the PostgreSQL project and members of the community that have been working so hard for 30 years.
Do meetings and paperwork take a toll on administrators? Steve draws a comparison to some of the changes in the US healthcare system.
SQL Server 2022 brought powerful new T-SQL functions that eliminate long-standing workarounds. This article walks through five of the most impactful additions — GENERATE_SERIES, GREATEST/LEAST, DATE_BUCKET, the WINDOW clause, and IS NOT DISTINCT FROM — with practical code examples you can use immediately.
It is not existing knowledge but the skill of acquiring new knowledge rapidly that will help you overcome imposter syndrome.
Data build tool (dbt) is an open-source command line tool that helps analysts and engineers transform data within their warehouses. It already assumes that data is extracted and loaded into raw tables. The dbt core framework is written in Python with the translations defined as a combination of SQL scripts, Jinga Template Language, and YAML […]
Learn how to choose which application to move first in a cloud migration with five practical guidelines
Books used to be the source of knowledge, but times have changed.
Learn about how you can better prompt your AI Assistant in solving problems and producing code.
Learn how to efficiently run SQL Server using Amazon Elastic Container Service for a hassle-free Docker container experience.
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
Comments posted to this topic are about the item No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers