A Database Administrator is a vital role in almost every organisation. As many companies experience inevitable growth of the data these days, the DBA role is one of the fastest growing occupations.
While we can say the overall goal of a DBA is to keep the Database up at all times, the DBA has many other different responsibilities such as: watching performance, provide users support and access to the required information, creating and documenting procedures and standards, tuning, designing, and supporting new processes.
A DBA has to have knowledge in a broad range of topics, starting from different operating systems, networking, programming, security, and of course, the actual database technology. For the benefit of my students and for those who wish to self-study this field, this page provides a coverage of several DBA aspects in a detailed, logical and well organized manner
- Data Types – Introduction to data types, the motivation of working with different data types, unicode vs non unicode, data type conversions, using Rowversion, using alias data type, using computed columns.
- Designing Tables – System tables, SQL Server schemas, working with Identity, Unique Identifiers, Sequences.
- Indexes – Fragmentations, indexes and data types, composite indexes, ascending and descending index, forwarding points, fill factor, clustered vs. non clustered index.
- Execution Plans – Display estimated and actual execution plans, different access paths.
- Configuring SQL Server Instance – SQL Server instances, memory management, instance configuration, deploying updates, the Resource Governor.
- Configuring SQL Server Databases – Datafiles, extents and pages, database configuration, file placement, system databases.
- Configuring Backups – The Transaction Log, physical and virtual log files, Recovery Models.
- Managing Security – Principals and securables, configuring SQL Server logins and database users, using roles.
- Automation – Configuring SQL Server agent, managing alerts and configuring jobs.