SQL Server Administration On Linux Operating System

Learn to install and manage sql server 2017 on linux, create databases and tables, insert and view data with t-sql, and configure imports, exports, and alerts on ubuntu.

Install and configure a linux lab by downloading and setting up VirtualBox, its extension pack, Ubuntu Server, and Windows Server 2016 with SQL Server 2017 to emulate a mixed environment.

Create and install a Windows Server 2016 64-bit virtual machine in VirtualBox, configure memory and storage, attach installation media, and enable shared folders while noting firewall and server manager considerations.

Install Ubuntu server in a virtual machine, configure storage, and perform initial updates; then optionally install the GNOME desktop and connect via PuTTY for remote management.

Install the gui desktop on an Ubuntu server using tasksel, enabling universal and multiverse repositories, then reboot to launch the desktop gui for demonstrations.

Install SQL Server 2017 on Windows and prepare for Linux deployment using command line, including downloading media, migrating files, and configuring management tools.

Learn to install SQL Server 2017 on Ubuntu via the command line, including repository setup, installation steps, and configuring a complex password with the evaluation edition.

Learn how to install and configure SQL Server on Ubuntu, troubleshoot memory errors, install SQL Server tools, create a test database and inventory table, and run basic queries.

Create a full clone of your Ubuntu virtual machine to safeguard configurations, enable quick recovery, and verify SQL Server access on Linux.

Start, stop, and restart SQL Server services on Windows with icon menus and SQL Server Configuration Manager. Troubleshoot common Windows errors and preview Linux command workflows.

Learn to manage SQL Server on Linux by checking status, starting, stopping, enabling, and disabling services, then log in and run a select on inventory table in the test database.

Demonstrates moving a SQL Server data and log files from the default location to a new folder on Windows, then repeats the process in Linux using scripts and command-line steps.

Learn to migrate sql server data and log files on linux using the Ms SQL dash config file, set a new directory, adjust ownership, and restart Eskil services.

Learn how to download and restore the Adventure Works 2017 database on Windows and Linux, and script backups using a GUI and SQL commands for SQL Server on Linux.

Learn how to download, move, and restore the Adventure Works 2017 database on Linux using SQL Server, verify results with a select, and reverse the process for repeatable practice.

Learn to set up a cross-platform environment for SQL Server 2017 on Windows and Ubuntu, configure networks, enable the SC account, and connect via PuTTY and command line.

Learn to create a database, a table, and insert data using a .sql file in Windows, and execute it from the command line.

Learn to script a full backup of the Adventure Works 2017 database, create a SQL Server Agent job, and share or execute the script on Linux environments.

Discover how to prepare a Linux environment for SQL Server by creating a scripts directory, a SQL file, and setting ownership and permissions to enable an Eskil agent job.

Enable sql server agent on linux by using a script to create a sandbox backup job; configure a daily 10 p.m. schedule to back up data to a linux directory.

Learn how to migrate large data sets from text files to a SQL Server table on Linux using the BCP bulk copy utility, including setup, commands, and verification.

Set up database mail in Windows using GUI or stored procedures, configure server options, create mail accounts and profiles, and test sending via SMTP with Gmail.

Learn to configure SQL Server database mail on Linux with a script-driven setup using nano. Build and test mail profiles and enable alert notifications for performance issues.

Migrate tables and views from Windows to a Linux server using the import/export wizard, with source and destination setup and table mappings.

Install the MSSQL CLI tool on linux and use Seelye, an interactive SQL server command line with IntelliSense and multi-line editing, to connect and query.

Install and use Azure Data Studio on Linux to visually connect to SQL servers, manage databases, run queries, and explore docker-based setups from a cross-platform GUI.

Connect to a Linux SQL Server with Azure Data Studio and SQL Server Management Studio, using IntelliSense to create databases, tables, and insert data.

Learn to monitor a Linux server with htop, a colorized, interactive tool that filters, sorts, and kills processes, and analyzes cpu, memory, and swap usage for performance tuning.

install glances on Linux, then monitor cpu, memory, swap, load, network, and disks with a live dashboard; learn to adjust thresholds and color alerts for proactive resource monitoring.

Learn to monitor Linux I/O with iostat, observing CPU and device utilization, transfers per second, reads and writes, and using options to isolate CPU or device metrics and view trends.

Discover how to use Linux and Docker to replace lengthy Windows Always-On high availability deployments, and see how Eskil servers can be deployed in minutes without virtual machines.

Learn about always on availability groups and Windows cluster architectures to replicate databases to multiple secondary replicas. Discover automatic failover, read-only replicas, and offloading backups for scalable high availability.

Enable always on prerequisites by configuring failover clustering on three servers, setting databases to full recovery or simple as needed, creating a shared backup folder, and registering servers.

Learn how to set up a SQL Server Always On cluster by validating configuration, adding three servers, running tests, creating the cluster, and enabling Always On.

Learn to set up Always On availability groups for SQL Server, migrating databases as a group to a secondary, with synchronous or asynchronous modes and read-only replicas.

discover backing up on secondary replicas in an always on availability group, where only copy-only full backups and transactional log backups are supported with synchronous, readable secondaries.

Create a SQL Server 2017 or 2019 instant testing instance on Linux using Docker containers, avoiding long VMs, with minimal CPU, memory, and disk usage.