Using Docker for an SQL Server database is one way to run the database. Learn how to set up an SQL Server Docker instance in this guide.
Docker can be used to run an Oracle database, which is a good way to run Oracle on a Mac or as an alternative on Windows. Learn how to set it up in this guide.
The SQL DEFAULT constraint is something that can be added to tables to specify a default value for a column.
The Access denied for user ‘root’@’localhost’ error is common in MySQL. Learn what it means and how to resolve it in this article.
Have you heard of the SQL Cross Apply feature but have no idea what it does? Or are you familiar with how both Cross Apply and Outer Apply work but don’t know how they can work in the real world? Learn all about them in this guide.
Learn how to show a list of all databases on your server, on several different vendors, in this guide.
To delete or drop a database you can use the DROP DATABASE command. Learn more about it here.
JSON is a data format that’s well-supported in PostgreSQL. Learn all about working with it in this guide,
Learn how to get a list of all tables in the database, in several different vendors, in this guide.
It’s possible to update data in one table based on the results of another table or query. Learn how to do it in this guide.