Microsoft SQL Server Versions List
MS SQL RELEASE
| Release | RTM (no SP) | Latest CU | |||
|---|---|---|---|---|---|
SQL Server latest version
SQL Server 15
codename Aris Support end date: Ext. end date: |
15.0.2000.5 | CU4 (15.0.4033.1, March 2020) | |||
SQL Server 14
codename vNext Support end date: Ext. end date: |
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 13
Support end date: Ext. end date: |
13.0.1601.5 | 13.0.4001.0 or 13.1.4001.0 |
13.0.5026.0 or 13.2.5026.0 |
||
SQL Server 12
Support end date: Ext. end date: |
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 11
codename Denali Support end date: Ext. end date: |
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 10.5
codename Kilimanjaro Support end date: Ext. end date: |
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 10
codename Katmai Support end date: Ext. end date: |
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 9
codename Yukon Support end date: Ext. end date: |
9.0.1399.06 | 9.0.2047 | 9.0.3042 | 9.0.4035 | 9.0.5000 |
SQL Server 8
codename Shiloh Support end date: Ext. end date: |
8.0.194 | 8.0.384 | 8.0.532 | 8.0.760 | 8.0.2039 |
SQL Server 7
codename Sphinx Support end date: Ext. end date: |
7.0.623 | 7.0.699 | 7.0.842 | 7.0.961 | 7.0.1063 |
SQL Server 6.50
codename Hydra Support end date: |
6.50.201 | 6.50.213 | 6.50.240 | 6.50.258 | SP4 6.50.281 SP5 6.50.416 |
SQL Server 6
codename SQL95 Support end date: |
6.00.121 | 6.00.124 | 6.00.139 | 6.00.151 | |
How to Find a User's SID With WMIC
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
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
------------------------
Batch to Delete File Automatically
Batch to delete file based on extension .txt
echo Batch to delete file
del "D:\temp\*.txt" /s /f /q
echo Done
Save file to del.bat
/s parameter will delete all files contained in the directory subfolders. If you do not want to delete files from subfolders, remove /s parameter.
/f parameter ignores any read-only setting.
/q “quiet mode,” meaning you won’t be prompted Yes/No
Batch to delete all files
echo Batch to delete file
del "D:\temp\*.*" /s /f /q
echo Done
Save file to del.bat





