MS SQL Server

 Data is a collection of facts and figures and we have humungous data available to the users via the internet and other sources. To manipulate the data, SQL in short has been introduced years ago. There are different versions of SQL available in the market provided by different organizations. In this article, we shall see the version of SQL provided by Microsoft. 

Introduction : 
 

  1. Microsoft SQL Server or MS SQL Server for short is the query language provided for data definition and manipulation. 
     
  2. SQL Server is a Relational Database Management Systems which was developed and marketed by the Microsoft company. 
     
  3. SQL and SQL servers are built as two layers where the SQL server is on the top for interacting with the relational databases. 
     
  4. MS SQL Server also has T-SQL or Transact-SQL and the main focus of T-SQL is to handle the transactions. 
     
  5. As it is a Microsoft’s developed system, it worked only on Microsoft’s environment until it was made available on Linux platforms in the year 2016. 
     

SQL Server is composed of: Database engine, and Relational engine, and Storage engine. These are explained as following below. 

1. Database Engine – 
Database is a collection of various data items on which the user can perform any kind of manipulations. 
 

  1. The database engine has a relational engine on which a user can perform queries and it also comes with a storage engine which manages the data files, indexes and procedures. 
     
  2. The database engine also creates and executes objects like triggers, views, procedures etc. 
     

2. Relational Engine – 
Relations are the connections between the two different databases or within the same database. It is stored in the form of a row and column intersection named tables. 
 

  1. It manages query processing, memory management, buffer management, threads, and much more. 
     
  2. It has another layer named storage engine. 
     

3. Storage Engine – 
 

  1. It looks upon the storage of data. 
     
  2. It is done using systems like disks and Storage Area Network or SAN. 

Comments

Post a Comment

Popular posts from this blog

Terraform

Image
  Terraform is an infrastructure as code tool that lets you build, change, and version cloud and on-prem resources safely and efficiently. HashiCorp Terraform is an infrastructure as code tool that lets you define both cloud and on-prem resources in human-readable configuration files that you can version, reuse, and share. You can then use a consistent workflow to provision and manage all of your infrastructure throughout its lifecycle. Terraform can manage low-level components like compute, storage, and networking resources, as well as high-level components like DNS entries and SaaS features. How does Terraform work? Terraform creates and manages resources on cloud platforms and other services through their application programming interfaces (APIs). Providers enable Terraform to work with virtually any platform or service with an accessible API. HashiCorp and the Terraform community have already written  thousands of providers  to manage many different types of resources and services.
Read more

Scrum Master Interview help - Bootcamp

Understanding the MoSCoW prioritization | How to implement it into your project Projects, irrespective of their size or complexity, often juggle numerous tasks and requirements. In such a scenario,  MoSCoW prioritization  becomes essential to ensure the successful completion of the project.  Besides, it is also a very effective way to manage project priorities. With a straightforward and adaptable approach, the MoSCoW method helps manage stakeholder expectations and improve project outcomes. What is the MoSCoW prioritization technique?  The MoSCoW method is a prioritization matrix widely used in project management and software development. The term MoSCoW is an acronym that stands for  Must have ,  Should have ,  Could have , and  Won’t have , each denoting a level of priority. Here is the breakdown of the MoSCoW method:  Must have:  These are critical requirements that the project cannot be completed without them. If these are not fulfilled, the project is con
Read more

Kubernetes

  Using containers to host applications and other processes has gone mainstream. As more and more workload is moved into containers, management systems are needed to handle the demands of containerized applications at scale. One of the most popular options for managing  container-based workload is Kubernetes . Kubernetes combines container management automation with an extensible API to create a cloud-native application management powerhouse. At its core, Kubernetes manages the placement of pods, which can consist of one or more containers, on a Kubernetes cluster node. Additionally, if one of these pods crashes, Kubernetes can create a new instance of it. If a cluster node is removed, Kubernetes can move any affected workload to a different node in the cluster. On top of that, Kubernetes pods can be scaled to provide more or less throughput to meet scale demands and these scale operations can be triggered manually or automatically using Kuberentes horizontal pod auto-scaling. Finally,
Read more