Blog

(Articles with tag:Database Design) - Remove Filter

MySQL Remote DBA Consultant helped the client to scale up

We got an urgent call from a new client that has many clients of its own. They do have a SaaS application with more than 1000 clients. Our consulting firm provides MySQL and MS SQL as remote dba services. They needed help with MySQL database right away. Imagine the client has SaaS app with more than 1000 clients of his own. For every client there is one dedicated database. Obviously, the client created a nightmare maintenance for himself. Just to spice up the situation every database seems different then the other one. Either the indexes are different, or in some cases some columns in certain tables are different. A Real mess!

Why do we use data modeling tool for database design for MS SQL or MySQL or MS Access databases?

While working with different software developers, I noticed that some of them still using spreadsheets or MS Word to keep track of the database design. Other developers use the MS SQL Database Diagrams in MS SQL. Visual Studio provides some basic capabilities on the database design. But is that the most productive tool to use?

Can you optimize my ms sql or mysql database?

Probably the most common request a DBA can get is to optimize a database or to perform a performance audit, which is really just another way of saying the same thing. The idea behind this request seems simple enough – you're the expert on databases. I have a database, please tell me if my DB is running as it's supposed to.