Pro SQL Server Relational Database Design and Implementation

This book offers a thorough guide to designing effective databases in SQL Server, covering essential concepts and the latest features introduced in SQL Server 2019.

In Pro SQL Server Relational Database Design and Implementation, readers will explore effective and scalable database design techniques tailored for SQL Server 2019 and its recent versions. This revised edition highlights key additions, including SQL graph enhancements, in-memory online transaction processing, temporal data storage, and row-level security. These features are crucial for designing high-quality OLTP databases that maintain data integrity while ensuring fast performance across on-premises, cloud, and hybrid environments.

The journey of designing a robust database using SQL Server is a blend of time-honored skills and the latest technological advancements. This book provides a comprehensive overview, from design logic that resonates with business users to the intricate details of physical implementation within SQL Server. Author Louis Davidson emphasizes best practices and a deep understanding of the theoretical foundations, guiding readers to achieve excellence in SQL Server database design and establish a solid framework for future data utilization.

What you will learn includes developing conceptual models through client interactions, implementing designs adaptable to various environments, recognizing common design patterns, and normalizing data models to enhance long-term scalability. The book also covers data security, effective indexing for query performance, and the fundamentals of concurrency. It caters to both novice programmers and seasoned database administrators eager to harness the latest features of SQL Server 2019, ensuring a comprehensive understanding of modern database design.