Category: L1 DBA
-
Cache Memory
Hey guys, In this blog I am going to explain you about Cache Memory Cache is a small amount of high-speed random-access memory (RAM) built directly within the processor. It is used to temporarily hold data and instructions that the processor is likely to reuse. This allows for faster processing as the processor does not…
//
-
Read a big file using PowerShell
Get-Content C:\MySQL_Dump_8April2022\agii-tdsqlpw01_08April_11PM.sql | Select-Object -skip 0 -first 100
//
-
Step by Step implementing Log Shipping
Log Shipping enables you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually. ADVANTAGES OF LOG SHIPPING- DISADVANTAGES OF LOG SHIPPING- TYPES OF LOG SHIPPING –…
//
-
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: …
//
-
Methods to change windows authentication to mixed mode (windows and SQL server authentication)
Hey guys, In this blog I am going to explain you about different methods to Enable Mixed Mode authentication Ø Enable Mixed mode authentication using Management studio Ø Enable Mixed mode authentication using Registry editor 1. Enable Mixed mode Authentication using MANAGEMENT STUDIO- STEP-1: Open a server in Management studio. Go to server -> right click -> instance ->properties…
//
-
Trigger in SQL Server
Hello guys, In this blog, I am going to explain you about a Trigger and how to perform a trigger inside the database. Trigger- A SQL trigger is a database object which fires when an event occurs in a database. We can execute a SQL query that will “do something” in a database when a…
//
-
Step by Step Configure Windows failover cluster on windows 2019
Step by Step Configure Windows failover cluster on windows 2019- Step 1- First you need to login at the server and go to manage->add roles and features-> add failover clustering and install the features on the server and restart the server. Fig.1 Fig.2 Fig.3 Step-2 Go to failover cluster manager-> create cluster->enter server name -> run…
//
-
View in SQL Server
Hello guys, In this blog, I am going to explain you about a view and how to create a view inside the database. View– A VIEW in SQL Server is like a virtual table that contains data from one or multiple tables. It does not hold any data and does not exist physically in the…
//
-
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…
//
-
Database Maintenance Plan
Hii guys, I hope you are doing great, today here I am going to explain you about the Database Maintenance Plan. Database Maintenance Plan- A database maintenance plan is a set of specific, proactive tasks that need to be performed regularly on databases to ensure their adequate performance and availability. Uses of Maintenance plan– The…
//
-
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…
//