SQL Identity Column Gaps and Conversion in SQL Server, Oracle and PostgreSQL
Learn about identity column sequence gaps and changing an existing column to an identity column in SQL Server, Oracle and PostgreSQL.
2022-01-19
multi-platform
SQL String functions in SQL Server, Oracle and PostgreSQL
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
Delete SQL Statement in SQL Server, Oracle and PostgreSQL
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
SQL Update Statement with Join in SQL Server vs Oracle vs PostgreSQL
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
Multi-Platform Mobile Development with PhoneGap
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
Blogs
A New Word: Vicarous
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
SQL Server Cross Platform Availability Groups and Kubernetes
Say we have a database that we want to migrate a copy of into...
Using Managed Identities with Azure SQL DB
We are trying to get apps and users off of using SQL accounts to...
Forums
View works for me ...but doesn't return results for a user in SSMS but no errors
Hi I have this view to check if a job is running: SELECT...
Dark mode, other color schemes
All, if you are like me and do not care for the built-in color...
Question of the Day
Internal Checkpoints
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers