Learn SQL basics in just 15 minutes with this tutorial focused on using SQL with MySQL. Topics covered include: - What SQL is ...

Welcome to the SQL Server Language Extensions project! Starting in SQL Server 2019, we have added support for language extensibility, which means that you can now execute code in various languages ...

The Chinook Database is a sample database widely used for learning, practising SQL, and testing database management tools. It is commonly used in tutorials, technical interviews, and courses that ...

With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations. If you have a large data source, such as an Access ...

Have you ever faced a data loss scenario in your SQL Server database? It's a nightmare that no DBA wants to experience. The transaction log plays a crucial role in preventing such disasters. Think of ...

Get up and running—and avoid the setup pitfalls—with this enterprise-class, open-source database available for all major platforms. For years now, PostgreSQL has been one of the best-kept secrets of ...

In my recent article I've reported about a nice free alternative to manage SQL databases, which, from the same UI can manage also MySQL databases. I thought that it might be a good idea to actually ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

Deploying a complex Docker stack isn’t nearly as challenging as you think, at least when Portainer is your GUI of choice. Find out how easy this is with Portainer templates. When you think of ...

Microsoft Office is the most popular office productivity suite and why shouldn’t it be? Microsoft has improved Office from time to time and now offers everything we would have wanted. Since the very ...

Information is stored somewhere. Sometimes it’s not suited for its original location. If you’re running low on disk space, added a new drive array, or just curious; this is a simple procedure to move ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...