Category Archives for Database

20 Best MySQL GUI Tools

MySQL GUI tools are very important to web developers and have an important role in handling projects of data storage and management. MySQL GUI tools will help improve the quality and functionality of web apps and also help you deliver great results. Most of the MySQL GUI tools showcased in this list have features such as […]

Read More...

Top 10 performance tuning tips for relational databases

Although newer relational databases and faster hardware run most SQL queries with a significantly small response time, there is always room for improvement. This paper lists 10 tips that every developer/DBA should consider when designing their database or writing SQL scripts. It also talks about some common mistakes developers typically make and how to avoid […]

Read More...

Top 10 Most Common Database Scripts

What are the scripts that a working DBA uses so often that they become part of the ‘muscle memory’? Grant Fritchey asked the question on the forums of SQL Server Central. From the large response, Grant was able to pick out the ten most popular T-SQL commands, scripts, or fragments. It seems as if, despite […]

Read More...