Good morning.
I am looking for an experienced professional to perform an SQL Server 2019 installation WITH ***PowerShell Desired State Configuration***.
I will supply you 1 (Windows Server 2019 Server Core) VM to install SQL Server 2019 on.
I prefer PowerShell Core DSC over regular PowerShell DSC.
The main deliverable is 1 PowerShell DSC script which should perform all the installation and configuration tasks, from a cleanly installed Windows Server 2019 Server Core VM to a completely installed and configured SQL Server setup. This includes installing the Windows and SQL Server pre-requisites.
These are the components/settings you need to install/configure with the PowerShell DSC script:
-- SQL Server Database Engine and Full Text Search
- Collation
- Instance Name and Instance Id
- Instance Root directory
- Shared Features directory
- Shared Features directory (x86)
- SQL Server (domain) service account
- SQL Server Agent (domain) service account
- Auto-start of the SQL Server service
- Auto-start of the SQL Server Agent
- Auto-start of the SQL Server Browser
- Grant Perform Volume Maintenance Tasks privilege
- Mixed Mode authentication (with current user as administrator; and sa password)
- Data directory
- Logs directory
- TempDB directory
- Quantity and size of TempDb datafiles
- Size of TempDb logfile
- MaxDop number
- Allow remote connections
- Use Named Pipes and TCP/IP for SQL Server
Preferrably I would like these ones given by the user (console input or configuration file):
- Collation
- Instance Name and Instance Id
- SQL Server (domain) service account
- SQL Server Agent (domain) service account
- SA password
- Data directory
- Logs directory
- TempDB directory
- Quantity and size of TempDb datafiles
- Size of TempDb logfile
- MaxDop number
You should also deliver a textfile describing the instructions to execute to run the DSC script and how to specify the user-given parameters.
After your delivery, I will run the PowerShell Desired State Configuration script on my other server and expect to get one SQL Server installed, configured, and fully working, according to the abovementioned requirements.
The budget is around USD 30 (plus USD 5 for the fee).
Please place your bids.
Thanks.
Hello,
I have 8+ years of experience in Database Administration.
I can provide support remotely to all type of DBA activities.
I have production server working experience on all below listed tasks:
SQL Server DBA and Azure Training SQL server installation and configuration,
Issue resolution SQL Server upgrades Microsoft azure
SQL Cluster
HA and Disaster recovery
Backup and Recovery
Performance Tuning
Documentation
Please review my profile and contact me.
Regards
Omkar