INFORMATICS

MS SQL RELEASE

Release	RTM (no SP)	Latest CU
SQL Server 2019 SQL Server latest version SQL Server 15 codename Aris Support end date: 2025-01-07 Ext. end date: 2030-01-08	15.0.2000.5	CU4 (15.0.4033.1, March 2020)
SQL Server 2017 SQL Server 14 codename vNext Support end date: 2022-10-11 Ext. end date: 2027-10-12	14.0.1000.169	CU19 (14.0.3281.6, February 2020)
Starting from SQL Server 2017 Service Packs will no longer be released
		SP1	SP2	SP3	SP4
SQL Server 2016 SQL Server 13 Support end date: 2021-07-13 Ext. end date: 2026-07-14	13.0.1601.5	13.0.4001.0 or 13.1.4001.0	13.0.5026.0 or 13.2.5026.0
SQL Server 2014 SQL Server 12 Support end date: 2019-07-09 Ext. end date: 2024-07-09	12.0.2000.8	12.0.4100.1 or 12.1.4100.1	12.0.5000.0 or 12.2.5000.0	12.0.6024.0 or 12.3.6024.0
SQL Server 2012 SQL Server 11 codename Denali Support end date: 2017-07-11 Ext. end date: 2022-07-12	11.0.2100.60	11.0.3000.0 or 11.1.3000.0	11.0.5058.0 or 11.2.5058.0	11.0.6020.0 or 11.3.6020.0	11.0.7001.0 or 11.4.7001.0
Obsolete versions – out of support
SQL Server 2008 R2 SQL Server 10.5 codename Kilimanjaro Support end date: 2014-07-08 Ext. end date: 2019-07-09	10.50.1600.1	10.50.2500.0 or 10.51.2500.0	10.50.4000.0 or 10.52.4000.0	10.50.6000.34 or 10.53.6000.34
SQL Server 2008 SQL Server 10 codename Katmai Support end date: 2014-07-08 Ext. end date: 2019-07-09	10.0.1600.22	10.0.2531.0 or 10.1.2531.0	10.0.4000.0 or 10.2.4000.0	10.0.5500.0 or 10.3.5500.0	10.0.6000.29 or 10.4.6000.29
SQL Server 2005 SQL Server 9 codename Yukon Support end date: 2011-04-12 Ext. end date: 2016-04-12	9.0.1399.06	9.0.2047	9.0.3042	9.0.4035	9.0.5000
SQL Server 2000 SQL Server 8 codename Shiloh Support end date: 2008-04-08 Ext. end date: 2013-04-09	8.0.194	8.0.384	8.0.532	8.0.760	8.0.2039
SQL Server 7.0 SQL Server 7 codename Sphinx Support end date: 2005-12-31 Ext. end date: 2011-01-11	7.0.623	7.0.699	7.0.842	7.0.961	7.0.1063
SQL Server 6.5 SQL Server 6.50 codename Hydra Support end date: 2002-01-01	6.50.201	6.50.213	6.50.240	6.50.258	SP4 6.50.281 SP5 6.50.416
SQL Server 6.0 SQL Server 6 codename SQL95 Support end date: 1999-03-31	6.00.121	6.00.124	6.00.139	6.00.151

How to Find a User's SID With WMIC

Open Command Prompt - cmd.exe

wmic useraccount get name,sid 

How to Find a User's SID in the Registry

Lcation SID User's in Registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList

PowerShell Script to convert SID to Domain User

#=========================================================================== 
# Pre-requisite : SID.txt is the text file containing SID's to be resolved 
# Output File   : UID.txt 
#=========================================================================== 
Out-File UID.txt 
foreach ($SID in (Get-Content SID.txt)) 
{ 
    $objSID = New-Object System.Security.Principal.SecurityIdentifier ($SID) 
    Try 
    { 
        $objUser = $objSID.Translate( [System.Security.Principal.NTAccount]) 
        $objUser.Value >>UID.txt 
    } 
    Catch 
    { 
        $SID >>UID.txt 
    } 
} 



-----
another script for Convert Group/User Name to SID:

Syntax:

  $Name = “Group or User Name” 

 (New-Object System.Security.Principal.NTAccount($Name)).Translate([System.Security.Principal.SecurityIdentifier]).value

-------
or

$user ='TestDomainMorgan'
$objUser = New-Object System.Security.Principal.NTAccount($user)
$objSID = $objUser.Translate([System.Security.Principal.SecurityIdentifier])
Write-Host "Resolved user's sid: " $objSID.Value

another script for Convert SID to Group/User Name:

Syntax:

$Name = “SID ID” 

 (New-Object System.Security.Principal.SecurityIdentifier($Name)).Translate([System.Security.Principal.NTAccount]).value

-----------

or

$SID ='S-1-5-21-1924530255-1943933946-939161726-500'
$objSID = New-Object System.Security.Principal.SecurityIdentifier($SID)
$objUser = $objSID.Translate([System.Security.Principal.NTAccount])
Write-Host "Resolved user name: " $objUser.Value

------------------------