SQL Server 2019 comes in five editions: Developer, Express, Enterprise, Standard, and Web. Minimum 6GB disk space and 1GB RAM required. Supports Windows 10 and Windows Server 2016/2019
SSMS is a graphical interface for managing Microsoft SQL Server databases. Essential tool for database administrators, developers, and data analysts. Provides tools for creating, managing databases, running queries, and designing procedures
PostgreSQL is widely used by major companies and is open source. psql is a terminal tool included with PostgreSQL installation. Command line management provides direct database interaction
DROP TABLE IF EXISTS works for permanent tables. INFORMATION_SCHEMA provides cross-platform table deletion functionality. Temporary tables must be deleted from tempdb
Open SQL Server Configuration Manager through Start menu. Click SQL Server Services to view instance name. Default instance is MSSQLSERVER. Connect using . or local as server name
CREATE DATABASE creates new PostgreSQL database. Requires superuser or CREATEDB privilege. Default template is system database template1. Can specify different template using TEMPLATE name