Enterprise Manager to administer SQL - Server

Create a New Database

You can create a database using GUI or T-SQL.

1. Using the GUI
   1. Right-click Databases in Object Explorer → New Database
   2. Enter a Database name
   3. Optionally configure:
      • Initial size
      • Autogrowth
      • Filegroups
      • Path to .mdf and .ldf files
   4. Click OK
2. Using T-SQL
   1. Open a new query window (Click New Query)
   2. Paste and run:

      CREATE DATABASE TimesheetDB
      ON PRIMARY (
          NAME = TimesheetData,
          FILENAME = 'C:\SQLData\TimesheetData.mdf',
          SIZE = 10MB,
          MAXSIZE = 100MB,
          FILEGROWTH = 5MB
      )
      LOG ON (
          NAME = TimesheetLog,
          FILENAME = 'C:\SQLData\TimesheetLog.ldf',
          SIZE = 5MB,
          MAXSIZE = 50MB,
          FILEGROWTH = 5MB
      );
      

Verify Database Creation

• Expand Databases in Object Explorer
• Your new database (e.g., TimesheetDB) should appear

Create Tables and Relationships

• Right-click the Tables folder under the new database → New Table
• Define column names, data types, and constraints
• Save the table with a meaningful name

Alternatively, use T-SQL:

USE TimesheetDB;
GO
CREATE TABLE Employees (
    EmployeeID INT PRIMARY KEY,
    Name NVARCHAR(100),
    Role NVARCHAR(50),
    HourlyRate DECIMAL(10,2)
);

Run Queries and Test

• Use Query window for SELECT, INSERT, UPDATE, DELETE, JOINs, etc.

SELECT * FROM Employees;

Enable Advanced Features (Optional)

• Configure features like:
  • Query Store
  • Columnstore Indexes
  • Temporal Tables
  • Memory-optimized tables