Database

What is SQL server?

SQL server is an implementation of a relational database. A big pile of data that lots of people can access at once, some maybe reading it, some maybe writing it, some maybe changing it, some maybe doing all three. It’s a highly scalable implementation of a relational database. But it turns out there’s a lot of other things in SQL Server. Really SQL Server cannot be used as pie filling, but it has so many features it’s kind.SQL Server is a collection of services, applications and libraries and when you put them all together we call that SQL Server.

Application

As a developer you may know the application called Microsoft SQL Server Management Studio and it may be a graphical user interface application. SQL Server Management Studio to SQL Server is what Visual Studio is to .NET applications. Working with a GUI sometimes is a very productive way to create applications and SQL Server gives us a couple of application we can use to work from the command line. One is called SQL Command and the other is called PowerShell and PowerShell as the name implies is a command shell. Now PowerShell is not a part of SQL Server directly but SQL Server includes an extension to PowerShell called a PowerShell provider. That customizes its operation for working with SQL Server.SQL Command is just a Command Line application that allows you to access SQL Server from the Command Line.SQL server one tool name SQL Server Profiler and it allows you to make a trace of all the commands that are being sent to SQL Server and it’s also useful when you want to optimize the performance of SQL Server. In fact, the next tool the database engine tuning adviser is used to do just that optimize the performance of SQL Server. Real operations using SQL Server profiler and then feed that data in the database engine tuning adviser to find out how to go and tune up your database.

Provisioning SQL Server Service Accounts

You will need an account for each SQL Server Service,Those should be regular Domain User accounts.you will need the name and password for these account during installation .you can also use Group Managed Service Accounts.

Install and Patch Windows Server 2016

Now Windows Server 2016 Standard Edition is less expensive and it give all features and licences .

Using SSMS

Once SSMS starts running you will see a view that looks something like this, exactly what it looks like is going to…