SQL Server / Minimum OS Software Requirement

Background

Wanted to tabulate the minimum MS Windows OS Requirement for the various versions of MS SQL Server.

 

Minimum OS Support Matrix

SQL Server Version OS Version – Server OS Version – Desktop Bitness Link
v2017  Windows Server 2012  Windows 8 Minimum: x64 Processor: 1.4 GHz
Recommended: 2.0 GHz or fasterDoes not support 32 bit OS
 Link
v2016  Windows Server 2012  Windows 8 Minimum: x64 Processor: 1.4 GHz
Recommended: 2.0 GHz or fasterDoes not support 32 bit OS
 Link
v2014  Windows Server 2008  Windows 7  x64 Processor
x86 Processor
 Link
v2012  Windows Server 2008  Windows Vista x86 Processor: 1.0 GHz
x64 Processor: 1.4 GHz
 Link
v2008-R2  Windows Server 2003 Windows Vista
Windows XP
x64 Processor
x86 Processor
 Link
v2008  Windows Server 2003 Windows Vista
Windows XP
x64 Processor
x86 Processor
 Link
 v2005  Windows Server 2000  Windows Vista
Windows XP
600-megahertz (MHz) Pentium III-compatible or faster processor
1-gigahertz (GHz) or faster processor recommended
 Link

 Link

 v2000  Windows NT Server 4.0  Windows 98
Link
 

 

 

SQL Server 2017 – Developer Edition – ISO

Background

Currently, I have SQL Server 2014 Developer Edition on my laptop.

Recently found out that since my machine is now Windows 10, I can have SQL Server 2017 Developer Edition.

 

Download ISO

Let us go download v2017 Developer Edition.

v2017 is available here.

Available

Image

Textual

  1. Free Trial Evaluation
  2. Developer edition
  3. Express edition

Developer Edition

If we click on the “Download now” button underneath the “Developer edition“, we will notice that the name of the file that will be availed is SQLServer2017-SSEI-Dev.exe.

Already have that file and it is a small file.

I don’t really want a small file, I want the full ISO.

 

Self-Prepare ISO

Download Bootstrap

To get a nice ISO, please process with downloading SQLServer2017-SSEI-Dev.exe.

 

Prepare ISO

Outline

  1. Select an installation type
  2. Specify SQL Server Installer download
    • Which package will you like to download
      • ISO
      • CAB
    • Click on the Browser folder button
      • Choose an existing folder or create a new folder
      • Click the OK button
    • Click the OK button
  3. Download Media

Screen shot

Select an Installation Type

 

Specify SQL Server Installer download

Browse Folder

Download Media

Download Successful

 

Installed

Once the files was packaged into a nice ISO, was able to install it.

 

Conclusion

So unfortunately, it appears that one cannot download v2017 as a nice offline ISO.

But, please do not let that overly deter you.

Go ahead and download SQLServer2017-SSEI-Dev.exe and run it.

You will be able to prepare an ISO through running that package.

SQL Server Versions / OS Requirements

Background

Still caught in the throng of upgrading MS SQL Server instances to the latest supported by individual applications.

But, in all honesty the holding cell is more likely the age of the machine, bitness (32 or 64 bit),  and the underlying OS.

OS Requirements Matrix

SQL Server Version OS Version – Server OS Version – Desktop Link
MS Windows
SQL 2016 Windows 2012, Windows 2016 Windows 8, Windows 10  Link
SQL 2014 Windows 2016, Windows 2012/R2, Windows 2012, Windows 2008/R2, Windows 2008 Windows 8, Windows 7  Link
SQL 2012 Windows 2012, Windows 2008/R2 Windows 8, Windows 7,
Windows Vista
 Link
SQL 2008-R2  Windows 2012, Windows 2008/R2, Windows 2008, Windows  2003  Windows 7, Windows Vista  Link
SQL 2008 Windows 2012, Windows 2008/R2, Windows 2008, Windows  2003  Windows XP, Windows Vista, Windows 7  Link
SQL 2005  Windows 2003, Window 2000  Windows XP  Link

 

References

  1. Microsoft
    • Docs / SQL / SQL Server / Install
      • Hardware and Software Requirements for Installing SQL Server
        • SQL Server v2016
          Link
        • SQL Server v2014
          Link
        • SQL Server v2012
          Link
        • SQL Server v2008-R2
          Link
        • SQL Server v2008
          Link
  2. Pearson
    • Inform IT
      • v2005
        • SQL Server Robert Beatty, SQL Server 2005 Setup and Deployment
          Link

 

SQL Server Life Cycle Support

 

Intro

My Director has been behind for a while here.

The imperatives are:

  1. Prepare Inventory list of all SQL Server Installs; the server name and current Version Number
  2. Apply latest Service Packs to all SQL Server Instances that are out of compliance
  3. Chart Upgrade path for the next few years to ensure that we narrow the list of versions that we are supporting

 

SQL Server Life Cycle Support

Stated below are the “Release to Manufacturing” (RTM) and Last Service Pack dates for the various versions of SQL Server.

We also noted the End of Mainstream and End of Extended Support where one has been officially announced by Microsoft.

 

Version Service Pack Release Date End of Mainstream End of Extended
SQL 2016 SP1 RTM :-  2016-June-1st
SP1   :-   2016-Nov-16th
 SQL 2014  SP2 RTM :- 2014-April-1st
SP2   :- 2016-July-11th
 SQL 2012  Sp3 RTM :- 2012-Mar-6th
SP3 :- 2015-Nov-23rd
 SQL 2008/R2  SP3 RTM :- 2010-April-21st
SP3 :- 2014-Sept-26th
 July 8th, 2014  July 9th, 2019
 SQL 2008  SP4 RTM :- 2008-April-7th
SP4 :- 2014-Sept-30th
 Jan 14th, 2014  Jan 8th, 2019
 SQL 2005  Sp4 RTM :- 2005-Nov-7th
SP4 :- 2010-Dec-17th
 April 12th, 2011  April 12th, 2016
 SQL 2000  SP4 RTM :- 2000-Nov
SP4 :- 2005-May-6th
 April 2008  April 9th, 2013

 

 

Suggestion

  1. v2005, v2000
    • Upgrade all current installs to 2014 and v2016
  2. v2008 & v2008/R2
    • Identify instances running v2008 and v2008/R2
    • Consult with clients and corresponding vendors
    • Plan and target upgrade for 2nd and 3rd quarter 2017 and First half of 2018

Current Landscape

  1. We do not have any SQL Instances running v2000, v2005, v2008
  2. We have 5 instances running v2008-R2

 

References

Microsoft – SQL Server Release Services

  1. 2008 and 2008-R2
    • End of Mainstream support for SQL Server 2008 and SQL Server 2008 R2
      Link
  2. 2000
    • End of Extended Lifecycle Support for SQL Server 2000 Service Pack 4
      Link

 

Products & Service Pack

SQL Server 2014

  1. SQL Server 2014 – RTM
    Link
  2. Server & Tools Blogs > Data Platform Blogs > SQL Server Release Services
    SQL Server 2014 Service Pack 2 is now Available !!!
    Link

 

Toad World – Release Date Calendar

  1. SQL Server 2008 Release Date Calendar
    Link
  2. SQL Server 2005 Release Date Calendar
    Link
  3. SQL Server 2000 Release Date Calendar
    Link

Microsoft Build Versions

  1. All
    1. SQL Server and Updates Builds Numbers
      Link
  2.  v2016
    • SQL Server 2016 build versions
      Link
  3. v2014

Service Pack List

  1. Microsoft SQL Server Version List
    https://sqlserverbuilds.blogspot.com/

SQL Server – Transact SQL – Query SQL Server for Version Info

Background

Still amazes me that it is difficult to translate SQL Server Version Numbers to the Marketing Name.

Here is one way.

Code

There is nothing special here, but wanted to keep it and come back and update as time goes on.

Query Code



; with cteProductVersion
as
(
	select
			    [productVersion] = serverproperty('ProductVersion')

			 ,  [productVersionMajor] 
					= parseName
					  (
					      cast(serverproperty('ProductVersion') as sysname)
						, 4
					 ) 

			 ,  [productVersionMinor] 
					= parseName
					  (
					      cast(serverproperty('ProductVersion') as sysname)
						, 3
					 ) 

			 ,  [productVersionMajorAndMinor] 
					= cast
						(
							parseName
						    (
								cast(serverproperty('ProductVersion') as sysname)
								, 4
							) 
							+ '.'
							+ parseName
							(
								cast(serverproperty('ProductVersion') as sysname)
								, 3
							) 
							as decimal(6, 2)
						)

)
select


		  [marketing]
			= case ctePV.[productVersionMajorAndMinor] 
						when 12 then '2014'
						when 11 then '2012'
						when 10.5 then '2008-R2'
						when 10 then '2008'
						when 9 then '2005'
						when 8 then '2000'
						else ''
				end 		
 
        , [edition] 
			= cast(serverproperty('edition') as sysname)

        , [engineedition] 
			= cast(serverproperty('engineedition') as sysname)

        , [productLevel] 
			= cast(serverproperty('productLevel') as sysname)

        , [ProductUpdateLevel]
			 = cast(serverproperty('productUpdateLevel') as sysname)

        , [productBuild] 
			= cast(serverproperty('productBuild') as int)

        , [productBuildType]
			 = cast(serverproperty('ProductBuildType') as sysname)

        , [ProductVersion]
            = cast(serverproperty('ProductVersion') as sysname)

        , [@@version] = @@version 

        , [ProductMajorVersion]
            = cast(serverproperty('ProductMajorVersion') as int)

        , [ProductMinorVersion]
            = cast(serverproperty('ProductMinorVersion') as int)

        , [IsXTPSupported]
            = cast(serverproperty('IsXTPSupported') as bit)

        , [InMemory]
            = case isNull(cast(serverproperty('IsXTPSupported') as bit), 0)
                    when 0 then 'No'
                    else 'Yes'
              end

from cteProductVersion ctePV

Output

v2008-R2

sqlserverengine_v2008r2

 

MS SQL Server – Get Version Information – Base Product

Here are a few ways to get MS SQL Server Version information

–ServerProperty
–Version: MS SQL Server MS SQL Server v2000 and later
http://msdn.microsoft.com/en-us/library/ms174396.aspx
select serverproperty(‘productVersion’) as productVersion
select serverproperty(‘edition’) as Edition
select serverproperty(‘productLevel’) as productLevel
 
–xp_MSver
–Version: MS SQL Server MS SQL Server v2000 and later
http://msdn.microsoft.com/en-us/library/aa260681(SQL.80).aspx
exec master.dbo.xp_MSver ‘ProductVersion’
exec master.dbo.xp_MSver ‘FileVersion’
exec master.dbo.xp_MSver
‘WindowsVersion’

 

sp_server_info
Version: MS SQL Server MS SQL Server v2000 and later
http://msdn.microsoft.com/en-us/library/aa260295(SQL.80).aspx
exec master.dbo.sp_server_info 2  –‘DBMS_VER’
exec master.dbo.sp_server_info 500 –‘SYS_SPROC_VERSION’ 

And, of course, the venerable
  select @@version
 

 

MS SQL Server — Parse @@version

–Parse SQL Server Version
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=84713

select
SQL_SERVER_MAJOR_VERSION =
convert(varchar(40),substring(L1,1,L1_BREAK_1-1)),
SQL_SERVER_VERSION =
convert(varchar(20),substring(L1,L1_BREAK_1+3,L1_BREAK_2-(L1_BREAK_1+3))),
SQL_SERVER_PLATFORM =
convert(varchar(20),substring(L1,L1_BREAK_2+2,L1_BREAK_3-(L1_BREAK_2+2))),
SQL_SERVER_EDITION =
convert(varchar(30),substring(L4,1,L4_BREAK_1-1)),
WINDOWS_VERSION =
convert(varchar(20),substring(L4,L4_BREAK_1+4,L4_BREAK_2-(L4_BREAK_1+4))),
WINDOWS_BUILD =
convert(varchar(20),substring(L4,L4_BREAK_2+2,L4_BREAK_3-(L4_BREAK_2+2))),
WINDOWS_SERVICE_PACK =
convert(varchar(30),substring(L4,L4_BREAK_3+2,L4_BREAK_4-(L4_BREAK_3+2)))
from
(
select
L1_BREAK_1 = charindex(‘ – ‘,L1),
L1_BREAK_2 = charindex(‘ (‘,L1),
L1_BREAK_3 = charindex(‘)’,L1),
L4_BREAK_1 = charindex(‘ on Windows’,L4),
L4_BREAK_2 = charindex(‘ (‘,L4),
L4_BREAK_3 = charindex(‘: ‘,L4),
L4_BREAK_4 = charindex(‘)’,L4),
L1,
L4
from
(
select
L1 =
convert(varchar(100),
rtrim(ltrim(replace(substring(zz,1,charindex(‘#1#’,zz)-1),’Microsoft SQL Server’,”)))
) ,
L4 = rtrim(ltrim(substring(zz,charindex(‘#3#’,zz)+4,100)))

from
(
select
zz = stuff(yy,charindex(Char(10),yy),1,’#3#’)
from
(

select
yy = stuff(xx,charindex(Char(10),xx),1,’#2#’)
from
(
select
xx =stuff(VERSION ,charindex(Char(10),VERSION),1,’#1#’)
from
(
select VERSION = @@VERSION
) a ) a1 ) a2 ) a3 ) a4 ) a4