From the course: Microsoft SQL Server 2022 Essential Training

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Database configuration options

Database configuration options - SQL Server Tutorial

From the course: Microsoft SQL Server 2022 Essential Training

Start my 1-month free trial Buy for my team

Database configuration options

“

- [Instructor] The graphical interface here in Management Studio gives us an opportunity to explore some of the other configuration options that are available when creating a new database without having to know all of the intricacies of the create database transact SQL command. To do this, right click on the databases folder underneath your connected instance and then choose new database from the popup menu. That'll open up the new database graphical workflow, and we have a number of different options that we can move through that are separated into these three pages, general, options and file groups. So let's start at the top on the general page. The first thing we need to do is name our new database. I'll create a database for another company that I want to work with called Red30 Tech. Notice that when I fill the name up here in the top, it updates the name of the database files that are going to be created. These…

Contents