Welcome to our blog post on SQL Server! In this article, we will explore the Admin section of SQL Server and learn about its important features and functionalities.

Before we dive into the Admin section, let’s quickly recap on how to install SQL Server on your local machine. Once the installation is complete, you can access the SQL Server Console by typing the following URL in your browser: http://localhost:8080/

Upon accessing the SQL Server Console, you will be greeted with a Start QuickStart button. Clicking on this button will take you to a screen displaying important information about Domain and Database Settings. It is crucial to read and understand this information before proceeding further.

Once you have familiarized yourself with the Domain and Database Settings, you can click on the Create Database button to start creating a sample database. SQL Server will then initiate the creation process, starting with the Storage Manager and followed by the Transaction Engine. Once the engine is up and running, it will create a schema and populate the database with sample data.

Upon successful creation of the sample database, you will be presented with a screen indicating the completion of the process. Now, it’s time to explore the Admin section of SQL Server. By clicking on the Admin button, you will be prompted to enter your login credentials.

Once logged in, you will notice that the Admin section is divided into two main areas: the left side displays information about SQL Server and the Admin Console, while the right side provides an overview of the domain.

From the Admin section, you have the ability to perform various tasks, including:

• Create a view of the entire domain
• Add and remove databases
• Start and stop SQL Server Transaction Engines and Storage Managers
• Monitor transactions across all SQL Server databases

On the right side of the Admin section, you can find valuable information about the SQL Server domain. This includes alerts, the number of host machines provisioned for the domain, and the number of databases and processes currently running.

Clicking on the “1 host” link will provide you with detailed information about the processes, CPU usage, and other relevant data. You can also access statistical details and charts for further analysis.

The Admin section of SQL Server is not only a place for administrative activities but also allows you to create and manage new databases. Additionally, you can customize the dashboard by adding different monitor charts to suit your needs.

We hope this tutorial has given you enough confidence to explore the Admin section of SQL Server and perform various administrative tasks. Stay tuned for our next blog post, where we will delve into the Explorer section of SQL Server, which allows you to run SQL queries and write SQL code.

For more information about SQL Server architecture and the roles of Storage Managers and Transaction Engines, we recommend checking out the official documentation provided by Microsoft.

Thank you for reading and happy exploring with SQL Server!