Topics In This Module. Environments Installation of SQL Server SQL Server Instances SQL Server Services Ports, Protocols and Service Accounts. Patching Migration & Upgradation. *** ============================================================================*** Environments There are two types of environments in general they are: Pre-Prod Environments. => Which Involves Dev environment and UAT environment. Prod Environments. => We do have OLAP (Online Analytical Processing) and OLTP (Online Transactional Processing) Servers in production. SQL Server -> Instance -> database -> File groups -> Files -> as two types below The Files in SQL Server are of two types they are Data files -> Extends -> Pages -> Header part, Data part(8060 Bytes), Row off Set Log files -> Virtual logs -> LSN -> ...