If you’ve ever had to format dates and times in SQL, you’ve probably come across one of the most jarring realities of working across platforms: every major RDBMS does it differently and sometimes confusingly. What’s a TO_CHAR() in Oracle becomes FORMAT() or CONVERT() in SQL Server, and its sort of the same in PostgreSQL… but […]
2025-07-11
156 reads
Learn about identity column sequence gaps and changing an existing column to an identity column in SQL Server, Oracle and PostgreSQL.
2022-01-19
In this article we look at how to use string functions to concatenate, replace, trim and get substrings in SQL Server, Oracle and PostgreSQL.
2021-10-25
Learn about the differences and similarities when deleting data from SQL Server, Oracle and PostgreSQL with the several examples in this article.
2021-03-16
In this article we look at the different SQL syntax you need to use when updating data when joining tables for SQL Server, Oracle and PostgreSQL.
2021-01-29
Of course it seems a great idea to have your application on all the main mobile platforms as well as on the desktop. However, as Arkadiusz Pachucy knows all too well, this can ultimately leave you with a full-scale maintenance nightmare. In this article he looks at whether technologies like PhoneGap/Cordova or Adobe Air could be the perfect compromise - and if so, what frameworks to use.
2015-08-24
3,088 reads
By DataOnWheels
Had an incredible time at DevUp in St. Louis this weekend! This conference gets...
By Chris Yates
The textile world is undergoing a transformation, one where creativity meets computation, and tradition...
By Brian Kelley
On August 6, 2025, Microsoft announced a vulnerability with hybrid deployments because of a...
Hi everyone, I’d like to share something from the science side of life rather...
Comments posted to this topic are about the item How to create your custom...
Comments posted to this topic are about the item Storage Enhancements
When I run this on Azure SQL Database, what is returned?
SELECT * FROM sys.fn_builtin_permissions('Server') AS fbp See possible answers