SQL ISNULL() is a practical function for checking the value of an expression. If a value is NULL, the function replaces it with a substitute value that you define in advance. In our dedicated article, we explain how this works using practical examples and reveal some of the…
The SQL EXISTS operator allows you to check whether a subquery contains a specific value. You can incorporate this subquery into a higher-level query and use it as a condition for execution. In this dedicated article, you will learn the structure of SQL EXISTS and find out how to…
ChinnapongShutterstockFor table or column names that are long or difficult to read, it can help to create a temporary alternative name that’s simpler. SQL aliases do just this, providing simplified column and table names for queries. These aliases are only applied while the query is being carried out…
If you no longer need a database, you should permanently remove it using the SQL DROP DATABASE command. This dedicated guide explains how to use this command to get rid of single or multiple databases, explains what you should keep in mind when doing so, and lists the associated…
It’s easy to lose track of things in large datasets. The SQL LIKE operator is an essential tool for searching databases and making efficient queries. In this tutorial, we explain what the SQL LIKE operator is, what it’s used for and how to use SQL wildcards. We also show you…
Ranjit KarmakarshutterstockDo you need to update or change a table in SQL? The SQL UPDATE command allows you to update entries in a table as a whole or carry out changes on selected entries. In this article, we tell you everything you need to know about UPDATE, including its syntax, what it’s useful for…
ellisiaShutterstockBy using custom error pages in Apache, you can ensure a smooth and appealing user experience, even when issues arise. We guide you through the process of configuring the Apache web server to display personalised error pages. From crafting the HTML files to adjusting the…
Elena KharichkinaShutterstockAs CentOS 7 reached its ‘end of life’ (EOL) this summer, users will need to explore migrating to a new operating system to maintain security and performance. We highlight three particularly recommended alternatives to CentOS and thoroughly outline the pros and cons of each option…
Rawpixel.comshutterstockMastodon is a decentralised social network using open-source software. Similar to Twitter, it allows users or organisations to run their own servers (instances). You can scale your Mastodon server as your community grows while maintaining control over your data. We explain…
Want to play Farming Simulator 25 on a server that’s exclusively accessible to you and your friends and tailored to your preferences? In that case, a dedicated FS25 server on rented hardware is the perfect solution. But what hardware requirements need to be met? And how exactly…
Servers are what make up the physical basis of the internet. Setting up your own professional site, putting products online for sale, or connecting multiple company locations with one another: all of these tasks require the support of high-performance computers. And it doesn’t matter if you purchase hardware resources for your own data center or opt for the flexibility of cloud services: operating a server comes with the challenge of independently configuring and administering hardware components. But don’t worry, there’s a lot of support out there for these tasks. In the Server Guide of IONOS’s Digital Guide series, you’ll find regular articles, news, and tutorials on how to operate this indispensable component of today’s IT infrastructure.
Packed with practical tips, our guide covers a wide spectrum of topics primarily aimed at mid-sized companies, freelance developers, and tech hobbyists. While some articles, like ‘What is a server?’ or ‘DNS – name resolution online’ cater more to beginners, experts are by no means left hanging; there’s a wide range of detailed texts and tutorials on important tasks like choosing the best operating system, filling security gaps, or getting the best possible performance out of your software and hardware.
If you take a look, you’ll notice our guide is divided into four different subcategories, each covering a different topic. The ‘KnowHow’ area sets out to familiarise beginners with the basics of operating a server. Details on different server types and how to use them are also laid out here. Tips and tricks on managing server software is found under the keyword, ‘Configuration’. The category, ‘Security’ is all about dealing with potential problems server operators may encounter from online threats. Conventional methods of attack, like viruses, worms, and Trojans, and what you can do to combat them are explained here. And the category, ‘Tools’, provides useful guidance on what resources can help make administering your server a more manageable task.
IONOS is the new price performance leader in cloud computing, as unveiled by Cloud Mercato in July 2024.
