Webcast : MSSQLTips | SQL Server Data Modeling Best Practices

The database schema is like a solid foundation for a house, if you want an application that will scale, perform well and be able to support the application growth, then you need to have a strong database design.

What is important when you are designing a new data model that needs to support thousands of users and terabytes of data? How does the schema design impact the server resources like IO requests and the memory efficiency? How do the SQL Server features like data compression, new data types and in-memory capabilities impact your database design?

By the end of this session, you will have a solid understanding on how you can design a data model that will take advantage of your infrastructure and leverage the new SQL Server features.

Here is your download link for ER/Studio Data Architect!

Please choose the file that meets your system requirements:

You’ll also receive a confirmation email with a download link for your product. To ensure email delivery, please whitelist [email protected]. If you do not receive your email, please be sure to check both your inbox and filters for a message from [email protected].

Topics :

Products :

Ben DeBow

Ben DeBow is an experienced consultant who works with customers of all sizes on their mission critical applications and SQL Server deployments. His versatility allows him to assist with everything from virtualization and consolidation to schema design, performance tuning, disk architectures, and everything in between. He has tuned and deployed some of the largest and most complex SQL Server solutions in the world. An active member of the SQL Server community, Ben is also the Founder and CEO of Fortified Data and can be reached at www.fortifieddata.com.

See ER/Studio Enterprise Team Edition in action



Document and enhance data from multiple database platforms with ER/Studio Enterprise Team Edition. We can help you build and maintain enterprise data models and metadata.

Request Demo