Database

What is a server? One term, two definitions

When talking about web hosting, it is impossible to avoid the term ‘server’. So what is a server? And how does it work? In IT, there are actually two definitions of the term. The traditional server is the software for network services, but more recently the word has also been used to describe the corresponding hardware used to carry out server programs. Here is our overview of the most common types of servers. [...]  

WordPress Migration: Tips for server migration

There is much more going on behind WordPress blogs than the average visitor is aware of. In addition to texts, pictures and other graphics, it is primarily the behind-the-scenes aspects like plugins and user settings that make the site what it is. All of these features have to be taken into account when migrating from A to B. Thanks to tools like migration plugins, moving your WordPress blog to a different server is now a manageable feat, even without professional support. [...]  

Server migration - transfer without data loss

Moving to a new server can become a real challenge even when you’re not changing provider. You need to take care and plan your strategy well. This is the only way to ensure the integrity of the data transferred to a new server and to keep downtime to a minimum. But what exactly is server data migration? And what problems can be expected during implementation? [...]  

Raspberry Pi at a glance: 10 great Raspberry Pi projects

Raspberry Pi is an inexpensive small form factor PC that can behave like a standard computer in many respects. Users can use this innovative mini-computer for all kinds of functions, from setting up an operating system to surfing the web, to using it as a server or a media center, and much more besides. Discover 10 interesting Raspberry Pi projects to try out at home. [...]  

Microsoft Access alternatives at a glance

MS Access is widely used office software and enables people with no prior programming knowledge to work with databases. The license for the program, however, is not exactly cheap. Several free alternatives to Microsoft Access promise to do essentially the same thing. But which are the best Microsoft Access alternatives? And can they actually keep up with the range of functions and standard of operation that MS Access offers? [...]  

DWH | What is a data warehouse?

More and more businesses are adopting dispositive data with the aim of making strategic decisions shaped by reports, prognoses, and patterns. The database is usually supplied by an information system that functions as a central data repository, separate from a data operating system. This is known as a data warehouse, or a DWH for short. A data warehouse is a modularly built system made up of various tools for data entry, data processing, and data retention. Our digital guide offers an insight into the structure of a typical DWH architecture, introduces you to commercial suppliers of established data warehouse systems, as well as showing you some open source alternatives. [...]  

Finding a website host: how to search successfully

If you want to release a new web project today, you need to find the right host. Hosts have become a popular alternative for large companies, since they enable convenient outsourcing of certain work areas or data, saving company resources. But how do you know which host and which hosting package best meets your needs? And why is the provider’s security concept such a crucial criterion nowadays? [...]  

Set up ownCloud with Raspberry Pi

With ownCloud software, your Raspberry Pi can be used as a private cloud, performing the same kind of tasks as clouds from major providers such as Google, Amazon, and Dropbox. Cost-effectiveness is just one of many the benefits of creating your own personal cloud; another is the privacy and security of your data. This step-by-step Raspberry Pi cloud tutorial explains how to set up ownCloud. [...]  

MongoDB tutorial: first steps

MongoDB is a document-based database system that competes with the more traditional relational systems. The setup and configuration is comparable to classics like MySQL, making it fairly straightforward to switch over. So how do you save and call up data with this modern software? Our MongoDB tutorial will explain the installation process and first steps to get you started on this open source database. [...]  

SQL injection: Fundamentals and safeguards

There are daily reports on how security gaps in applications are exploited – because hardly a day goes by without a new gap being discovered or a known gap being closed. One attack method, which has always been based on exploiting such weak points, is called SQL injection. But what is actually hidden behind the malicious database exploitation and how can you protect your database system from it? [...]