Large Scale Deployment Using SQL FineBuild

Previous SQL Server Always On Install	SQL Server Deployment Architecture Next

This section describes how deployments of standardised builds of SQL Server to a large number of machines can be done and suggests an architecture that can be used.

The information given in the sections below is suitable for someone with limited skills in deploying SQL Server, but the information is also of use to experienced staff.

Item	Comment
	SQL Server Architecture
SQL Server Deployment Architecture	Introduction to suggested Reference Architecture for SQL Server
Development, Test and Production Environments	Dedicated environments for each stage of deployment
Scale Up and Scale Out	Choosing Correct Architecture for Line of Business and Business Continuity
SSAS and PowerBI Optimisation	Optimising SSAS and PowerBI CPU and Memory Use
SQL Server Version and Edition	Exploiting the best features of SQL Server
Connection String Stability	Maintaining Connection String stability across changes to the SQL Server topography
	Deployment Planning
Large Scale Deployment Overview	Overview of items needed for Large Scale deployment
Site SQL Files Folder	Repository of files used to run SQL FineBuild
Sample Role Files	Examples of possible Role Files
Design Site SQL Server Estate	Defining the logical Roles and Service Tiers, and the Physical server layout
	Deployment Process
Installing SQL Server on Windows Core	Limitations when installing SQL Server on Windows Server Core
Install SQL Server Using Altiris	Using SQL FineBuild with a deployment tool

Copyright FineBuild Team © 2014 - 2021. License and Acknowledgements

Previous SQL Server Always On Install	Top	SQL Server Deployment Architecture Next