2. SQL Server Fundamentals

This chapter provides a focused look at SQL Server and builds on the database concepts covered in Chapter 1. We begin by taking a look at how SQL Server came to be, the different SQL Server versions and their respective architectures, and the different SQL Server editions you may encounter in the field.

From there, we integrate our knowledge of databases and look at how SQL Server stores and processes data. It’s also important to understand how SQL Server protects this data; to do so, we examine SQL Server’s integrated security and encryption features as well as database logging, troubleshooting, and memory management. It’s important that you understand the content of this chapter, because the SQL Server forensic ...

Get SQL Server Forensic Analysis now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.