SQL Server Interview Question Reference

	Essential SQL Interview Questions to Prepare For
	SQL Workload Migration: Data Engineer Interview Questions & Answers for Microsoft Azure Database Platforms
	SQL Server Connectivity Interview Questions & Answers for Database Administrators
	Senior SQL Server Database Administrator Interview Questions & Answers
	Scenario-Based Interview Questions for Junior SQL Server Database Administrators
	Microsoft Azure Administrator: Scenario-Based Interview Questions & Answers
	SQL Server Replication: Interview Questions & Answers
	SQL Server Always On Availability Groups: Interview Questions & Answers
	SQL Server Transaction Log: Interview Questions
	SQL Server Auditing: Interview Questions
	SQL Server Execution Plan: Interview Questions
	Azure Data Factory: Interview Questions & Answers
	Top 25 SQL Interview Questions & Answers on Indexes
	Phone Interview Questions for SQL Server DBAs
	SQL DBA: Interview Questions & Answers (Part 2)

How to find SQL Server installation Date

To find the installation date of SQL Server, we need to examine the creation date of the "NT Authority\\System" login. This login is created during the SQL Server installation process.

-- Query to retrieve the server installation date
SELECT create_date 
FROM sys.server_principals 
WHERE name = 'NT AUTHORITY\\SYSTEM';

-- Alternate query to retrieve the server installation date using SID
SELECT create_date, *  
FROM sys.server_principals 
WHERE sid = 0x010100000000000512000000;

-- Query to retrieve the creation date for the "NT AUTHORITY\\NETWORK SERVICE" login
SELECT create_date 
FROM sys.server_principals 
WHERE name = N'NT AUTHORITY\\NETWORK SERVICE';

For more information, check out the following articles:

• Server Roles & Permissions
• SQL Server OS Information