dbForge Studio logo

Database modelling in a post-SSMS world: dbForge Studio

A few months ago, Microsoft announced that SQL Server Management Studio (SSMS) will no longer include the visual Database Diagrams feature from v18.0 onward. [Edit: Microsoft reversed this decision with SSMS 18.1, and the designer is back. Apparently a lot of people missed it. Keep reading for the original post.] When releasing a new version
-> Continue reading Database modelling in a post-SSMS world: dbForge Studio

Post image

Normalization, The Sequel

If there’s one thing that SQL Server is really good at, it’s relationships. After all, a relational database management system without the relationships is nothing more than a place to store your stuff. Last week we briefly looked at a denormalized table, and then I suggested that breaking it up into five separate tables would
-> Continue reading Normalization, The Sequel