You probably know by now that I am a BIG advocate of Agile methodologies. You can use extended properties on your tables to hold descriptions but, they do not readily appear for the average developer or report writer. Still, a data dictionary with definitions for columns is often valuable. With auto completion in SSMS it makes sense to make your table/column names more descriptive. So, it is often beneficial to use longer table and column names that are more descriptive, even it it means more typing when accessing the data. SQL Server allows 128 characters in table and column names (sysname data type). They make the connections to the other tables by seeing the data in the foreign key columns matching the data in the primary key column of another table.įor both these groups I have found it important to have a data dictionary. This second group (no less intelligent…their brain just works differently) prefers to see a table with data in it. Other people look at a diagram, and it doesn’t confirm the database design as meeting their needs to them.
#Ca database modeling tools code#
They can look at this diagram and find it easy to code applications or consume the data. Some prefer more content in the diagram demonstrating each column, the datatype the column uses, nullability, default or check constraints, etc. Some people can look at a database diagram (entity relationship diagram) demonstrating all of the tables, relationships between those tables, Primary Keys and Foreign Keys and they are good to go. I have found that people have two different ways of understanding a database. So, today I’m going to talk a little bit about Database Modeling and communicating a database design to those who work with it. I came across this gem of a web page with links for dozens of database modeling tools. Workload Tuning is just what it sounds like: tuning the performance of all processes that comprise a database workload in one… ( read more) In this article, you can find some tips to performance tune and optimize SQL Server 2008 transactional replication.
Tips for using SQL Server 2008 Transactional Replication Come join us and learn what the Service Broker can do for you. In his webcast he will be looking at some of the advanced features of SQL Service Broker as well as some of the advanced techniques which can be used to maximize the performance of the SQL Service Broker. You can count on Steve to provide helpful insight to solving real world problems. The webcast doesn’t start until 12:00 pacific giving you plenty of time to get signed up. If you’re not registered you can get there now. Webcast: The SQL Service Broker Advanced Performance Tips and Tricks Webcast is today
0 kommentar(er)
