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.
Visual Studio provides some basic capabilities on the database design. But is that the most productive tool to use?
When interview some developers for my company with ten years of experience or more, some did not know the difference between clustered index or a regular index. Clustered index is a whole subject on its own. Why custom software developers neglect their database design skills? Not so sure I get it.
Some of the software developers told me that they did not deal with complicated database and the need was not there to use a tool to design any database. Well, I am not convinced of that excuse.
Sometimes I see developers that don’t even optimized their stored procedures and don’t even bother to use an execution plan to see how the performance of the stored procedure can be improved. Here is a free tool that can do just that: SQL execution plan viewing and analysis and made by ApexSQL.
I would use a data modelling tool to design any database what so ever whether it is a simple one or complicated. The productivity gained is tremendous. Not only that you get a global view on the entire system, it will create the scrip for every change you do within the database. Why not to use such a tool to automate the process?
It handles Stored Procedures, triggers, views, indexes, tables and relations. The nice thing about the relation is that you can add text in in any relation between each entity and in different color.
This is an actual data base design we did while using xCase data modelling tool.
If you make mistakes it lets you know. It is graphical interface and easily you can track down all relations from one entity to another and simply just follow the color. So why wouldn’t you use this type of tool to design your database? This is mine bundling for me. For our company our favorite tool is xCase, Toad could be another nice option to use. See this free data modeling tool that can get you started: Design SQL Server Data model diagrams integrated with SSMS, Visual Studio and source control and it was created by ApexSQL.
You can easily reverse database engineering and grab all the details of the entire database in record time. Check this article to see a video we did on that subject: Reverse Database Engineering and Database Design.
In general, we provide Remote Database Administrator services and also known as Remote DBA and efficiency the way we work is a must. Design the database the right way is extremely important before you write any code in the back end or the front end. This way your stored procedure can be easily optimized with the correct database design. Part of it is due to the features set that allows you to take advantage of a data modelling tool design capability.