Despite its steep licensing costs, SQL Server continues to prove its worth over open-source alternatives in some key areas. SQL Server is an expensive part of your IT stack -- SQL Server Enterprise ...

Pairing your on-prem SQL Server with a cloud-based instance for high availability has its challenges, but they can be overcome. Here’s how. The geographic distribution of cloud data centers makes it ...

At some point, you’re going to need to connect to a MySQL 8 database remotely to manage your databases. Here’s how to make this possible. Recently, I was tasked to add a MySQL database GUI for a ...

Replication is one of the most popular features used in RDBMS’s today. Replication is used for disaster recovery purposes (i.e. backup or warm stand-by servers), reporting systems where query activity ...

If you need to allow remote connections to your MySQL server, see how you can easily accomplish that task. If you work with MySQL, there will be instances in which you need to give remote access to ...

While many popular website applications (WordPress, Drupal, Joomla, etc.) are open source and therefore freely available, running these PHP-based apps on a Windows IIS web server requires a bit of ...