Fraud Blocker

SQL condition IN

The SQL condition IN (sometimes called the IN operator) makes it easy to check if the expression matches a value in the list of values. It is used to …

Continue Reading

Sql Count Function

The number of rows returned by the SELECT operator is determined using the SQL Count Function – COUNT….

Continue Reading

Oracle FIRST_VALUE function

The Oracle/PLSQL FIRST_VALUE function returns the first value in an ordered set of values from the analytical window. It shares some similarities with…

Continue Reading

9 best tools for working with Microsoft SQL Server

This information gives a summary of the top nine tools used by administrators and programmers to work with Microsoft SQL Server….

Continue Reading

THE ART OF COPYING WITHOUT COPYING: FORKING DATABASES

A query about how to fork PostgreSQL databases like you can on Heroku was sent to me. Since I could not find any good examples of how to do this, I ma…

Continue Reading

🎉 Thank you for subscribing!

You're now on the list for database FinOps strategies and performance insights.