SQL

Network Design And IP Node Name Management IP Role DC01 10.10.101.5 AD/Dns Server SQL0A 10.10.101.12 SQL Server SQL0B 10.10.101.13 SQL Server SQLCL0A 10.10.101.10 Cluster Name Object (CNO) SQLAGL0A 10.10.101.11 SQL Availability Group Listener Requirement SQL Server requires a minimum of 20 GB of available hard drive space. Windows Server 2019 or greater Ensure that the system isn’t a domain controller. Ensure that each computer is running Windows Server 2019 or later versions with latest patches....

I assume you ahve already installed the SQL server and IIS (including CGI feature). PHP Installation. Download the latest PHP and WinCache extension to the following link. Php For Windows Extract .zip file, and rename it php. Move the folder to C:\. So the full path of the PHP folder will be C:\php Go to C:\php and copy the C:\php\php.ini-production to C:\php\php.ini Enable th following extension: extension=curl extension=gd extension=mbstring extension=pdo_mysql Windows Cache Extension for PHP installation....

Introduction Windows Server Core: This is a minimal installation option for the Windows Server operating system. It doesn’t include the traditional graphical user interface (GUI), reducing the system’s footprint and attack surface. Administrators typically manage Server Core installations using the command line or remote management tools. Installing SQL on Windows Core. SQL is supported to be installed on Windows Core. Check the following example command to install it. Feature parameters Parameter and values Description /FEATURES=SQLEngine Installs only the Database Engine....

Create Firewall Rule to open 1433 Port New-NetFirewallRule -DisplayName "SQLServer Default instance" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action Allow Check Version : SELECT @@VERSION Find Current Location of Data and Log File of All the Database SELECT name, physical_name AS current_file_location FROM sys.master_files Comment-ing on SQL query /* COMENT A COMENT B */ Database Management Create Databases CREATE DATABASE dbtestb; List All databases; SELECT * FROM sys.databases; SP_DATABASES; Use Specific Database USE dbtestb; Delete Specified Database; DROP DATABASE dbtestb; Creating and Displaying Tables; Displaying Tables SELECT * FROM sys....