Microsoft SQL server 2022
Last updated
Last updated
Microsoft sql server often known as MSSQL 2022 is one of the most used and popular database management engine used to deploy databases with ease & with tier based microsoft support.
We will be installing microsoft SQL server 2022 express installation type for this section as it is free to use and deploy in any small sized and medium sized (50 endpoints) organizations. We can also go for premium installation options for better security , optimization and exclusive support systems from Microsoft.
The detailed video and source of video is linked here :
Microsoft SQL is highly integrable with the Azure cloud environment for easy scalability and database management. Now we will be starting the installation below :
Once sql server setup is downloaded we will start the installation process by following the steps given below :
We can choose basic method if deploying the database for testing purpose or not for any production requirements, We can opt for custom & installation media type to install with more granular controls and system tuning needs best for the production needs. We are moving for basic installation for ease of installation for this section
We will be selecting the SQL server installation path for storing the configuration and database files.
We can configure the installation directories to keep account on database logs, database features, versions and other requirements. Then clicking connect now to ensure database is successfully configured and running. Now we have the option to install the SSMS (SQL server management studio) tool which is used to graphically manage the SQL database in Microsoft.
Once downloaded we will start the installation process
Once installation is completed we will enter the database credentials and connect with the database and start working for production needs.
Now our database is installed and configured correctly and we will move into configuring our production environment.
