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.
Bean Counting to Burnout
Do meetings and paperwork take a toll on administrators? Steve draws a comparison to some of the changes in the US healthcare system.
Five SQL Server 2022 T-SQL Functions You Should Be Using Right Now
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.
Coping with a working life as an imposter
It is not existing knowledge but the skill of acquiring new knowledge rapidly that will help you overcome imposter syndrome.
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
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 […]
What should you move first in a cloud migration? 5 key guidelines
Learn how to choose which application to move first in a cloud migration with five practical guidelines
Everything I Needed to Know Used to be Found in One Book
Books used to be the source of knowledge, but times have changed.
Stop Prompting Your AI Agent. Give It a Playbook.
Learn about how you can better prompt your AI Assistant in solving problems and producing code.
How to run SQL Server on Amazon Elastic Container Service
Learn how to efficiently run SQL Server using Amazon Elastic Container Service for a hassle-free Docker container experience.
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
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