O'Reilly logo

SQL Server 2017 Administration Inside Out, First Edition by Randolph West, William Assaf, Sven Aelterman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3Designing and implementing a database infrastructure

This chapter covers the architecture of a database infrastructure, including the different types of database files as well as how certain features work under the hood to ensure durability and consistency, even during unexpected events. We cover what certain configuration settings mean, and why they are important.

Next, we look at some of these same concepts in the context of Microsoft Azure, including Microsoft SQL Server on Virtual Machines (infrastructure as a service), and Azure SQL Database (database as a service, a component of the larger platform as a service).

Finally, we investigate the hybrid ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required