SQL Server Administration Part 1
  • What is a Domain
  • Software to download and install
  • POST ADDENDUM
  • APPS NEEDED
  • CREATE VM
  • INSTALL SQL SERVER 2017
  • ADVENTUREWORKS 2017 DB
  • COMPARISON OF SQL 2014 VS 2017
  • Create Virtual Machine Domain Controller
  • Promote Domain Controller to Active Directory
  • Create Vm for SQL Server 2012 Install Part1
  • Create Vm for SQL Server 2012 Install Part 2
  • Install SQL On Separate Drive with Service Accounts Part 1
  • Install SQL On Separate Drive with Service Accounts Part 2
  • Installing Service Packs and Fixes (SP2)
  • Touring SQL Server Management Studio (SSMS)
  • Introduction to System Databases
  • SQL Server Data and Log Files
  • Detail Transaction log ATM Example
  • Auto Growth and sizing of transaction log
  • Types of Recovery Models
  • Function fn_dblog to view inside a transaction log
  • What is virtual log file (VLF)
  • Create a SQL database
  • The importance of Tempdb
  • Attach and detach a database
  • Introduction to Backups
  • Full Database Backup
  • Transactional Log Backups
  • Differential Backups
  • Introduction to Restore
  • Restore database with GUI
  • Restore database using differential
  • Recovery mode with tail log backup
  • Backup using Maintenance plan
  • Backup database using Maintenance plan
  • Maintenance Plan Tasks
  • Don’t shrink a database
  • The importance of using SQL Server Agent
  • Create a simple backup job using SQL Server Agent
  • The importance of DBCC CheckDB
  • Using SQL Server Agent with multiple steps
  • Setting up SQL Database Mail
  • Setting up SQL Database Mail Part2
  • Setting up alerts Severity Errors from 17 to 25
  • Central Management with SQL Server Agent (CORRECTION)
  • Central Management with SQL Server Agent
  • Installing free VMware Pro Player for virtualization
  • Introduction to SQL Server Security
  • Demonstration of Users Logins Roles
  • Managing security with T SQL
  • Selecting Authentication or Mixed Mode security
  • Accessing SQL Server using SQL Login
  • Understanding SQL Server Roles
  • Managing SQL Server Roles via TSQL
  • SQL Server Roles Demonstration
  • Managing SQL Server Permissions
  • Best SQL Server Practice Security
  • SQL ADMINISTRATION PART 2 TABLE OF CONTENT