Blog

(Articles with tag:xCase data modelling) - Remove Filter

Why do we use data modelling 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 use spread sheet or MS word to keep track of the database design. Other developers use the MS SQL Database Diagrams in MS SQL. Dot net also 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.