Webcast : ER/Studio Data Architect
MSSQLTips | SQL Server Data Modeling Best Practices
Presenter: Ben DeBow
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.
- Whitepaper: Agile Data Modeling: Not an Option, but Essential
- Whitepaper: Enterprise Data Modeling for Business Intelligence Applications
- Whitepaper: Improve Your Data Modeling Skills
- Whitepaper: Is your Data Modeling Workflow Agile or Fragile?
- Whitepaper: Mastering Data Modeling for Master Data Domains
- Whitepaper: Model Behavior: An Introduction to Data Models
- Whitepaper: The ROI of Data Modeling
- Webcast: A Perfect Ten: The Data Model
- Webcast: A Photographer and a Data Modeler Walk Into a Bar…
- Webcast: Agile Data Management vs. Agile Data Modeling
- Webcast: Becoming a Better Data Modeler: Part 1 (Data Modeling Certification)
- Webcast: Becoming a Better Data Modeler: Part 2 (Faulty Design Patterns)
- Webcast: Data Modeling and Blockchain
- Webcast: The Importance of Data Model Change Management
- Webcast: You’ve Just Inherited a Data Model – Now What?
- Webcast: Principles of Data Modeling
- Webcast: Put Together the Pieces of your Data Model Puzzle
- Infographic: Improve Your Data Modeling Skills
- Infographic: Data Modeling and Collaboration with ER/Studio
Topics : Data Modeling,
Products : ER/Studio Data Architect,