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.
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.
Topics: Data Modeling Products: ER/Studio Data Architect