What to do before installing SQL Serverīefore running the SQL Server installer on your Windows Server, there are a number of factors and settings to consider, some of which you cannot easily change after installation. This chapter, however, focuses on server-level setup and settings. In Chapter 6, “Provisioning and configuring SQL Server databases,” we’ll cover the initial creation and configuration of databases inside the SQL Server instance.
They are, after all, still very much the same SQL Server product that has always existed on Windows. Many recommended settings in this chapter still apply for server-based platforms of SQL Server, such as in Docker containers or SQL Server on Linux. The installation or creation is vastly simplified for an Azure SQL Database, Azure SQL Database managed instance, SQL Server on Linux, SQL Server in Docker containers, or Azure VMs running SQL Server. The SQL Server Setup tool content of this chapter mainly applies to SQL Server installations on Windows operating systems. We review a post-installation checklist for you to verify every time and, when necessary, direct you to where you can find other sources of information and details for critical steps elsewhere in this book. We pay special attention to new features introduced in SQL Server 2019, and other recent features you may not have noticed in SQL Server 2017. In this chapter, we review the process of installing and configuring a Microsoft SQL Server instance as well as the creation or migration of databases. Post-installation configuration of other features
0 kommentar(er)
