THE BEST

  MS SQL Server is a client-server architecture. MS SQL Server process starts with the client application sending a request. The SQL Server accepts, processes and replies to the request with processed data. Let's discuss in detail the entire architecture shown below: As the below Diagram depicts there are three major components in SQL Server Architecture: Protocol Layer Relational Engine Storage Engine SQL Server Architecture Diagram Let's discuss in detail about all the three above major modules. In this tutorial, you will learn. Protocol Layer - SNI MS SQL SERVER PROTOCOL LAYER supports 3 Type of Client Server Architecture. We will start with " Three   Type   of   Client Server Architecture"  which MS SQL Server supports. Shared Memory Let's reconsider an early morning Conversation scenario. MOM and TOM - Here Tom and his Mom, were at the same logical place, i.e. at their home. Tom was able to ask for Coffee and Mom was able it serve it hot. MS SQL SERVER - ...

  Pre-Requisites Principally, MS SQL server requires: .Net Framework,1GB of recommended memory, and NTFS system. How to download SQL Server Setup Step 1)  Go to URL :   https://www.microsoft.com/en-in/sql-server/sql-server-downloads Microsoft provides  two specialized free editions  to work on MS SQL server: Developer  – It has all feature which MS SQL server offers but we cannot use it in production. From the learning perspective, is it an ideal candidate to start. Express : This is also a free version but with the limited set of features with no business intelligence applications. We will select the  Developer edition  for installation. Step 2)  Click on  "Download now" We will get set up as  'SQLServer2017-SSEI-Dev.exe'. How to Install SQL Server Step 1)  Double click on  "SQLServer2017-SSEI-Dev.exe".  Below screen will appear with three options: Basic, Custom and Download files. Step 2)  Choose the basic vers...

  What is SQL Server? SQL SERVER  is a relational database management system (RDBMS) developed by Microsoft. It is primarily designed and developed to compete with MySQL and Oracle database. SQL Server supports ANSI SQL, which is the standard SQL (Structured Query Language) language. However, SQL Server comes with its own implementation of the SQL language, T-SQL (Transact-SQL). T-SQL  is a Microsoft propriety Language known as  Transact-SQL.  It provides further capabilities of declaring variable, exception handling, stored procedure, etc. SQL Server Management Studio (SSMS) is the main interface tool for SQL Server, and it supports both 32-bit and 64-bit environments. In this tutorial, you will learn. Version History SQL Server Microsoft and Sybase released version 1.0 in 1989. However, the partnership between these two ended in the early 1990s. Microsoft maintained ownership rights to the name SQL Server. Since the 1990s, subsequent versions of SQL Server hav...