<img height="1" width="1" style="display:none;" alt="" src="https://dc.ads.linkedin.com/collect/?pid=204641&amp;fmt=gif">

Common Issues Between Database Management Solutions and PHP Developers

Posted by Lukas Vileikis on Aug 18, 2022 10:00:00 AM

All developers come across at least a couple of issues while they find themselves developing applications for the web. That’s exactly why sites like Stack Overflow, Stack Exchange, and the like exist – that’s developers helping other developers in trouble. 

If you’re a frequent visitor of Stack Overflow though, you will notice that most of the issues related to software engineering have something to do with databases as well – new questions are also posted minutes ago, literally. And the given example only pertains to MySQL – can you imagine how many new questions are posted day-by-day targeting other database management systems? Thousands. 

----------------------------------------------------------------------------------------------

Read More

Topics: database dashboard, database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager, database farm, farmmanagement

Alternative Storage Engines in MySQL

Posted by Lukas Vileikis on Aug 14, 2022 10:46:55 PM

If you’ve been a frequent user of MySQL now or in the past, you know for a fact that there are multiple storage engines MySQL allows us to choose from. The most frequent one is InnoDB which is known as a “high performance” storage engine meaning that if optimized properly via the parameters provided by MySQL in my.cnf, the storage engine can do wonders – MyISAM is considered more obsolete though, but it has its own use cases including providing an exact count of the rows in a specific table and storing database files in a recoverable format since the files provided by MyISAM are not bound to any other files such as ibdata1 provided by InnoDB. 

----------------------------------------------------------------------------------------------

Read More

Topics: database dashboard, database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager, database farm, farmmanagement

Working with MySQL vs. MariaDB – What’s Different?

Posted by Lukas Vileikis on Mar 9, 2022 9:00:00 AM

Everyone has heard of MySQL. Well, probably not everyone – say, everyone in the development and database monitoring space. Do you ever wonder why? MySQL is everywhere. The industries that use MySQL as their primary database management system include the automobile industry (think Volvo, BMW, etc.), the fashion industry (think SheIn and the like), the finance industry uses it heavily, it’s prevalent in the education industry.

----------------------------------------------------------------------------------------------

Read More

Topics: database dashboard, database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager, database farm, farmmanagement

Why do Developers Automate Database Processes?

Posted by Lukas Vileikis on Mar 4, 2022 9:00:00 AM

If you’ve been around the world of development at least for a little while, you will know – automation is everywhere. We mean, it’s 2022: one can find companies automating robotization processes, there are specialized houses with automated processes instead of keys, etc. 

The software sector is not an exception to this rule, either – automation, especially database automation, in the software sector is rampant as well. Some of the processes that are being increasingly automated are related to databases, database monitoring, and database farm management: by automating database processes, people find themselves at ease when working with all kinds of database flavors. 

----------------------------------------------------------------------------------------------

Read More

Topics: database dashboard, database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager, database farm, farmmanagement

Running Databases – Docker vs. Alternatives

Posted by Lukas Vileikis on Mar 2, 2022 9:00:00 AM

These days, Docker is a frequent friend of many developers. Some developers even turn to Docker to run their database systems – applications are safe in containers, containers usually are lightweight, and generally containers allow devs to bundle all the software they use into “boxes” called Docker containers. 

----------------------------------------------------------------------------------------------

Read More

Topics: database dashboard, database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager, database farm, farmmanagement

Microsoft Azure vs. dbWatch to Manage SQL Environments

Posted by Lukas Vileikis on Feb 26, 2022 9:00:00 AM

If you’ve heard of databases of any kind, there’s a good chance you’ve heard (or even worked with) Microsoft Azure, or simply Azure as it called in the development circles. Azure is a frequent friend in the Microsoft circles – partly because it’s developed by Microsoft, but also partly because it’s a very efficient tool in managing all kinds of databases. 

----------------------------------------------------------------------------------------------

Read More

Topics: database dashboard, database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager, database farm, farmmanagement

Deploying Databases Locally vs. In a Live Environment - What to Consider

Posted by Lukas Vileikis on Feb 21, 2022 3:17:03 AM

All developers and database administrators have been in a situation where they need to test their database deployments before going live. There‘s simply no way around it: want to be live? Test your environment in a sandbox before moving onto publicly visible spaces (e.g. the web, etc.) But have you ever wondered what database administrators need to consider before deploying their database environments both locally and live? We will tell you all about that in this blog post. 

----------------------------------------------------------------------------------------------

Read More

Topics: database dashboard, database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager, database farm, farmmanagement

Activity on Your Database Platforms – dbWatch Control Center Edition

Posted by Lukas Vileikis on Jan 17, 2022 9:31:00 AM

If you are a database-conscious developer, chances are that you are keeping an eye out on the things that are happening in your database platforms. Whether you are running a single database instance or a bunch of database instances at once, you are keeping an eye out on your databases nonetheless – one of the things you are inevitably keeping an eye on is the activity that us going on inside of your database platforms.

 

 

----------------------------------------------------------------------------------------------------------

Read More

Topics: database dashboard, database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager, database farm, farmmanagement

What Resources Does Your Database Have? dbWatch Control Center Edition

Posted by Lukas Vileikis on Jan 10, 2022 8:51:00 AM

If you are a databse-conscious developer or a database administrator and especially if you find yourself immersed in the dbWatch blog at least on-and-off, you already know how important it is to monitor your database resources, you know a couple of things about database jobs, and other database functionality. You probably already know a couple of things about your database resources as well – they are vital to improving your database functionality.

----------------------------------------------------------------------------------------------------------

Read More

Topics: database dashboard, database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager, database farm, farmmanagement

What Does Your Database Inventory Look Like?

Posted by Lukas Vileikis on Jan 3, 2022 8:38:00 AM

If you are a database administrator dealing with SQL Server, MariaDB, or other database instances, you probably know a thing or two about database systems. If you found yourself working with certain database platforms in the past, you have probably taken a look at various database “inventories” – you have taken a look at what database instances consist of, what platforms or systems do they support, are they big or small, etc. – in this blog, we are going to tell you a little more about such database inventories. 

----------------------------------------------------------------------------------------------------------

Read More

Topics: database dashboard, database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager, database farm, farmmanagement