Architecure

DBMS architecture helps in design, development, implementation, and maintenance of a database.

The database stores critical information for our business.

Determining the correct Database Architecture assists in quick and secure access to this data. Examples are Fail-over Clusters, Quorums, SQL HA, Mirroring.

Design and implementation of all SQL Server environments – Development, Testing, User Acceptance Testing/Training, and Production.

Design

A RDBMS is a system that organizes data into tables called relations, which are further organized into columns (fields) and rows (often called tuples).

The relational model allows data to be queried in a nearly unlimited number of ways.

To ensure we can sort through large volumes of data quickly and efficiently the databases must be designed correctly. Examples are Referential Integrity, Indexes, triggers SPs, functions, queries.

Licensing

SQL Server offers us a variety of licensing options aligned with how we typically purchase specific workloads.

There are two main licensing models that apply to SQL Server

SERVER + CAL: Provides the option to license users and/or devices, with low cost access to incremental SQL Server deployments.

PER CORE: Gives us a more precise measure of computing power and a more consistent licensing metric, regardless of whether solutions are deployed on physical servers on-premises, or in virtual or cloud environments

Installation

Data Services collaborates on the initial installation and configuration of a new SQL Server RDBMS and/or database.

The system administrator sets up hardware and deploys the operating system for the database server, then the DBA installs the database software and configures it for use.

If a new server is needed, the DBA will deal with the transfer of data from the existing system to the new platform.