Six Tips for Getting your Database Design Off to a Good Start
The database is the anchor of any application that has to transact against data. If the database design has errors or is incomplete, the application will sooner or later begin to fail or become problematic, either because it will replicate database design bugs or because it will store or update…
READ MORE
How to Customize the Default Table View in SQL Server Diagrams
When designing a SQL Server database, I like to define foreign-key (FK) relationships using database diagrams. I also like the tables in my diagrams to display the column names and their data types, for easy review and also because data-type mismatches are a common error when defining FKs and I…
READ MORE