1 Introducing SQL Server

 

This chapter covers

  • What you should know about this book
  • The SQL Server index mistake (mistake #0)
  • The C4 model
  • SQL Server’s components, protocols, and platforms
  • The importance of SQL Server skills

Over recent years, DBA has become a catchall term to describe anybody who works with databases. I always feel that this is doing something of a disservice to both the technology and the professionals who work with it. SQL Server is a massive product, and complex data-tier applications require teams to have a range of competencies to harness its full power. Therefore, when we refer to DBA in this book, we will be referring specifically to database administrators.

We will cover topics relevant to people with the following roles:

  • Database administrators (DBAs)
  • Database developers
  • Extract, transform, load (ETL) engineers

This book may also be of interest to members of the following communities if they have overlapping responsibilities:

  • Database architects
  • Data warehouse developers
  • Testers
  • Data scientists
  • Cyber security engineers
  • Business intelligence developers

1.1 The SQL Server index mistake (mistake #0)

1.2 An overview of SQL Server

1.2.1 Overview of the Database Engine

1.2.2 Heterogeneous platforms

1.3 Why we should still care about SQL Server

1.4 Why getting SQL Server right matters

Summary

sitemap