Chapter 4. Managing databases
Databases are the basic unit of management and work within SQL Server. A database is an almost entirely self-contained package that bundles security settings, configuration settings, your actual data, and much more. That makes databases a good place to start your education in SQL Server maintenance. Some of the things you’ll look at in this chapter will need a much more complete explanation, which will come in later chapters; the goal right now is to focus on the database container itself. We’ll be covering database configuration options and some basics of how to manage databases.
4.1. Configuring database options
If you don’t have it open, get SQL Server Management Studio on your screen. Right-click a database, ...
Get Learn SQL Server Administration in a Month of Lunches 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.
