BTEKS

 

MS SQL SERVER 2012

 

 

Creating a Database
in MS SQL Server 2012


 

 

 

 

 

Creating a MS SQL Server Database using SS Management Studio

 

 

Opening MS SQL Server 2012 Managment Studio (SSMS)

 

Via the Connect to Server window, click “connect” to open SQL Server Management Studio

 

From the Object Explorer, access your Data Warehouse Database.

 

 

 

The initial screen that you will see when viewing SSMS displays below,
showing the initial system installed support configuration.

SSMS Initial opening window
MS SQL Server 2012 installation on my local machine displays the computer name as the installed instance being used.

 

Creating a new MS SQL Server Database:

 

Click on the "+" beside the "Database Folder" to expand the tree.  Then "Right Click" on the word Database and mouse over "New Database" to highlight the box and then click.

 

 

The New Database Window below, displays and 4 steps are required to create a database name and identify the database owner.
Follow the steps below starting with the first dot, then to the next and finally, "ok" to create your Database Name, and identify the database owner.

 

 

Configuring the Database Files steps are below:
Beginning with the "General" selection under the "Select a Page" window, follow the directions to make changes to the database configurations.

 

Select the "Option" word and lets change the recovery model from "Full" to "Simple",
by following the steps below.

 

Select the "Filegroups" selection in "New Database" window and then we will simply accept the default setting by clicking "ok".

 

Clicking OK in the New Database window will successfully create a new database in
MS SQL Server 2012 and you can view the new database and all the associating files
by refreshing the Object Explorer via the "refresh" button
with the green arrows to the right of the word " connect ".

 

After refreshing, expand "Databases" and click on the "+" next to the Database Name that you assigned and your database folders will display as highlighted below.

 

The New Database name is "Test DB BTEKS".

Microsoft SQL Server 2012:

 

As part of the ongoing services that BTEKS offer,

we make sure that we stay abreast of the most recent and current database management skills

and techniques.

 

Microsoft SQL

Server 2012
is one of the most recent database management systems that we have been trained to service

and are ready to provide all the needed associating services to any company that seeks to request our help.

 

We are capable of providing know how and bring added value and expertise to your existing

database team or

lead your team in the management of your MS SQL Server 2012 using the

MS SQL Tools:

 

SQL Server Data Tools

 

SQL Server Management Studio

 

Analysis Services

 

Configuration Tools

 

Integration Services

 

Master Database Services

 

&

 

Performance Tools

 

Data Warehouse Design & Development

 

How To Create a
Fact Table
win SSMS.

 

How to create a Data Warehouse

"Fact Table"