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. When releasing a new version of a product, Microsoft has the luxury of referencing usage statistics, and obviously this is an underused feature of SSMS. I was a little disappointed at
-> 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