Author: Harigovind Gupta
-
SQL Server Services
Below are the SQL Server services which might come after SQL installation based on your selection… • SQL Server • SQL Server Agent • Other SQL Services • SQL Server Browser • SQL Server Full Text Search • SQL Server Integration Services • SQL Server Reporting Services • SQL Server Analysis Services
//
-
STEP BY STEP SQL Server Installation
Hey guys, in this blog I am going to explain you about “Step by step New SQL server stand-alone installation” Minimum requirement for SQL server 2019 installation Hardware requirements: Hard disk – It requires a Minimum 6GB of available hard-disk space. Monitor – Super-VGA (800×600) or higher resolution monitor. Memory – Minimum: …
//
-
Stored Procedure in a SQL Server-
Hey guys, In this blog, I am going to explain you about stored procedure and how to implement stored procedure in a SQL Server. Stored procedure – Stored procedure in SQL is a group of SQL statements that are stored together in a database. Based on the statements in the procedure and the parameters you pass,…
//
-
Step by step implementation of SQL Server Always on group
Hey guys, In this blog I am going to explain you Step by Step implementation on SQL Server Always on Availability Group Always on Availability group – The Always On availability groups feature is a high availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012 (11.x), Always on availability groups maximizes…
//
-
Point-in-time recovery in SQL Server
Hey guys, In this blog we will discussed about point-in-time recovery in SQL Server and how to perform it and also we discussed on full, differential and transaction log backup. 1. Full backup – A Full backup is a complete backup of a database. The full backup contains all the data in a database and…
//
-
Trigger Vs Stored Procedure in SQL Server
Hey guys, in this blog we will learn about the differences between Triggers and Stored Procedures. Both perform a specified task but the major difference comes in the execution part. Triggers are called automatically while the stored procedures are invoked explicitly by the user. 1. Execution: We can execute a Stored Procedure whenever we want with…
//
-
Template for formatting Requirements for font size, style, and type and spacing, changing the Default Paragraphs Styles
Section 1: Format Requirement for font size, style, and type and Spacing Font size, style, and type: · The font must be a Standard style that is clear and readable. · All document text with the exception of item embedded in figures must be black. · Font size should be…
//
-
Pages and Extent in SQL Server
Hey guys, In this blog I am going to explain you about Pages and Extent in SQL Server and also different types of pages in SQL Server Pages – A page is a unit of data storage in SQL. The size of a page is 8Kb. The data rows are put on the page serially after…
//
-
SQL Server Network Configuration
Hey guys, hope you are doing great. In this blog I am going to explain you about SQL Server Network Configuration and enabling/disabling different protocols. SQL Server Network Configuration – SQL Server Network Configuration involves enabling the protocols that manage the connection to the SQL Server and configuring the available options for these network protocols. It…
//
-
Azure Azure SQL Database Azure SQL Database High Availability L1 DBA Monitoring pg_ High Availability PostgreSQL SQL Server
New features of SQL Server 2022
Hello guys, hope you are doing well. In this blog I’m going to discuss about the “New features of SQL Server 2022” The release of the SQL Server 2022 is much anticipated by the audience since the announcement of it being in the works on November 2nd, 2021. Although the complete details of this brand-new version will…
//
-
Step by Step Implementation of Instant File Initialization
Hello guys, In this blog, I will discuss about step by step implementation of “Instant File Initialization” in SQL Server STEP- 1: You must first open the instance in SSMS, then do the following query: Fig-1 This is the result of executing a query: Fig-2 You must update Y to N in the Instant _File Initialization…
//
-
Buffer Cache Hit Ratio
Hey guys, In this blog I am going to explain you about Buffer Cache Hit Ratio Buffer Cache Hit Ratio- It is a pool of memory pages into which data pages are read. In other words, the data pages which are read from Disk are stored in Memory (Cache) to provide data faster. When a Data Read…
//