• Adam Thurgar

Installing SQL Server - Part 1 Pre-installation

This is the first part of a series on installing SQL Server.

You could use these blogs as the skeleton for an automated build

This is based on an a standalone installation of SQL Server 2017.

This focuses on the pre-installation tasks.

1. Check the drive configurations and volume block sizes

2. Get information on the service accounts that will be used for the SQL Server services

3. Know what components you need to install (e.g. do you need SSAS or PolyBase?)

4. Create all required directories (data, logs, backups etc)

5. Know what network protocols are required and the TCP port (not 1433!)

6. Ensure that the installation media is available locally, this should include the latest CU (CU5 in this case) and that the latest SSMS (17.6 at this time) is downloaded for installation.

4 views0 comments

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t