SQL Servere database monitoring

Monitoring means to checking database status, settings about who can be the owner, what should be the file names, what should be the file sizes, backup schedules, etc. 
SQL Server databases can be monitored mainly through SQL Server Management Studio or T-SQL, and also can be monitored through various methods  
Database status can be checked whether it is online or in any other state as shown in the following snapshot.

High Availability (HA) of the server of  Database is the solution( process , technology ) to make the application database available 24 x 7 under either planned or un - planned conditions.   

There are five type of options in MS SQL Server to achieve and configure the   setup for high availability solution for the databases. 

Replication 
The source(Main) data will be copied to destination, through replication agents (jobs). Object level technology. 
Main terminology 

1.  Publisher is source server. 
2.  Distributor is optional and stores replicated data in a suitble environemt for the subscriber.  
3.  Subscriber is the destination server. 

Log Shipping 
The source data will be copied to destination through Transaction Log backup jobs. Various Database level technology. 
Main terminology 

1.  Primary server is source server. 
2.  Secondary server is destination server.
3.  Monitor server is optional and will be monitored by log   shipping status.  

Mirroring 
The primary data  will be copied to a secondary through a network transaction basis with  help of mirroring endpoint and port number. Database level  technology. 
Main terminology Uasd 

1.  Principal server is  source server always. 
2.  Mirror server is  destination server always.
3.  Witness server is  optional and can be used to make automatic  failover. 

Clustering 
The data will be stored  in shared location which is used by both primary and secondary  servers based on availability of the server. Instance level technology.  Windows Clustering setup is required with shared storage. 
Main terminology Used

1.  Active node is where SQL Services are running.
2.  Passive node is where SQL Services are not running. 

AlwaysON Availability Groups 
 The primary data will  be copied to secondary through network transaction basisand  Group of database level technology. Windows Clustering setup is required without shared storage for ALwaysON Availibilty Groups. 
Main terminology 

1.  Primary replica is source server.
2.  Secondary replica is destination server. 

Check Java Pattern Program

JAVA Triangle * Pattern Program Logic Sixth Programming Logic and Code with Syntax

JAVA Triangle * Pattern Program Logic Fifth with Code Programming Logic and Code with Syntax

JAVA Triangle * Pattern Program Logic Four Programming Logic and Code with Syntax

JAVA Triangle * Pattern Program Logic Three Programming Logic and Code with Syntax

https://www.dizsweb.com/2019/07/java-triangle-pattern-program-logic-two.html

JAVA Triangle * Pattern Program Logic one Programming Logic and Code with Syntax

JAVA Sqaure * Pattern Program Programming Logic and Code with Syntax

SQL SERVER Installation

With the help of this post you can installl SQL Server in your window oprerating system directly

Step 1: Download the Evaluation Edition from the microsoft website.

Step 2: Double - click on the “SQLFULL_x86_ENU_Install.exe” or  “SQLFULL_x64_ENU_Install.exe” , It will extract  the required files for installation in the “SQLFULL_x86_ENU”  or “SQLFULL_x86_ENU” folder  respectively one by one.

Step 3: Click the “ SQLFULL_x86_ENU ” or “SQLFULL_x64_ENU_Install.exe” folder and double-click “SETUP ” application file.

Step 4: Once we click on ' setup ' application, the following screen will open. It will show the following.

Step 5: Click Installation which is on the left side of the below screen.

Step 6: Click the first option of the  right side seen on the above screen. The following  screen will open and it will take some time for intallation.

SQL SERVER Installation 

Step 7: After finishing the Click OK and the  following screen pops up.

Step 8: Click Next to get  the following screen wait for installation of all.

Step 9: Make sure to check  the product key selection and click Next.

Step 10: Select the checkbox  and  accept the license option and click Next.

Step 11: Select SQL Server  feature installation option  and then  click Next.

Step 12: Select Database engine  services checkbox and then click Next.

Step 13: Enter the named instance ( here I used TestInstance ) and click Next.

Step 14: Click Next on the above screen and the following screen appears you have to select server agent.

Step 15: Select service account names and start-up types  for the above listed services and then click Collation.

Step 16: Make sure the correct collation selection is  checked and then click Next.

Step 17: Make sure authentication mode selection  and administrators are checked and click Data Directories

Step 18: Make sure to select the above directory  locations and click Next. The following screen appears.

Step 19: Click Next on the below screen .

Step 20: Click Next on the below screen to the get the following screen .

 Step 21: Make sure to check the below selection correctly and click Install and finish.

Sql Server Intstallation

SQL Server supports two types of installation: 
1 Standalone 
2 Cluster based 

Checks 
1 - Check RDP access for the server. 
2 - Check OS bit, IP, domain of server. 
3 - Check if your account is in admin group to run setup.exe file. 
4 - Software location.

Requirements 
 Which version, edition, SP and hotfix if any. 
 Service accounts for database engine, agent, SSAS, SSIS, SSRS,      if any. 
 Named instance name if any. 
 Location for binaries, system, user databases. 
 Authentication mode. 
 Collation setting. 
 List of features

Pre-requisites for 2014 
 Setup support files. 
 .net framework 4.0. 
 SQL Server native client. 
 Windows installer 4.5/later version.