Session Description

A summary and quick how-to of the various admin features in MS SQL Server and other vendors. Topics include: SQL Management Studio, security, SSIS and 3rd party transaction tracking software. Other topics include: creation of new databases, importing/exporting, backups, maintenance, and error checking, as well as query creation and scripting.

Session Content

  • Table basics
  • Microsoft SQL Server is the RDBMS (Relational DataBase Management System) behind Aeries
  • Using SQL Server Management Studio (SSMS) to administer your MS SQL Server Instance
    • Creating a new Aeries Database with its initial structure
    • Managing SQL Permissions for Users and Roles
    • Field Level Permissions
    • Deny Permissions
    • Maintenance Plans
    • Backup, integrity checks, index maintenance, statistics
    • Importing or exporting data within SSMS
  • Adding or removing fields to customizable tables.
  • Using SQL Server Integration Services (SSIS) to export data automatically
  • Using PowerShell to extract data automatically

Related Documentation

PDF documentation for this session is attached.