SQLServer - Revision history

Aleks at 11:34, 10 May 2024

2024-05-10T11:34:04Z

← Older revision		Revision as of 12:34, 10 May 2024
Line 40:		Line 40:

	== SQL Server Upgrade ==		== SQL Server Upgrade ==
			get current version of SQL server: <syntaxhighlight lang="t-sql">
			SELECT @@VERSION;
			</syntaxhighlight>Can use the following spreadsheet to work out what build the SQL server is on and what it can be upgraded to:

			[https://view.officeapps.live.com/op/view.aspx?src=https%3A%2F%2Fdownload.microsoft.com%2Fdownload%2Fd%2F3%2Fe%2Fd3e28f3d-6a4f-47ce-aaa5-9d74c5590ed6%2FSQLServerBuilds.xlsx&wdOrigin=BROWSELINK SQLServerBuilds]

			There are GDR builds, RTM builds and CU updates. You can upgrade the GDR builds with security updates and go from one GDR build to the next OR do CU updates that contain all the changes. Once you use a CU update from a GDR build you cant go back to GDR. GDR+RTM builds contain all security and updates.

	See the following articles on upgrading SQL server:		See the following articles on upgrading SQL server:

2024-03-18T10:47:49Z

← Older revision		Revision as of 11:47, 18 March 2024
Line 38:		Line 38:
	,@p3 = N'licensing'		,@p3 = N'licensing'
	</syntaxhighlight>		</syntaxhighlight>

			== SQL Server Upgrade ==
			See the following articles on upgrading SQL server:

			[https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-sql-server?view=sql-server-ver16 Upgrade SQL Server]

			Start planning SQL server upgrade by running the Data Migration Assistant: [https://www.microsoft.com/en-us/download/details.aspx?id=53595 Data Migration Assistant Download Page]

2024-02-23T09:27:23Z

← Older revision		Revision as of 10:27, 23 February 2024
Line 26:		Line 26:

	[https://www.nocentino.com/pure-storage-links/ Pure Storage Links - Anthony Nocentino's Blog]		[https://www.nocentino.com/pure-storage-links/ Pure Storage Links - Anthony Nocentino's Blog]

			== SQL Licencing ==
			Check SQL licencing with the following query:<syntaxhighlight lang="sql">
			SELECT SERVERPROPERTY('productversion') AS ProductVersion,
			SERVERPROPERTY('productlevel') AS ProductLevel,
			SERVERPROPERTY('edition') AS Edition;
			SELECT SERVERPROPERTY('LicenseType') AS LicenseType,
			SERVERPROPERTY('NumLicenses') AS LicenseNumber;
			EXEC sp_readerrorlog @p1 = 0
			,@p2 = 1
			,@p3 = N'licensing'
			</syntaxhighlight>

2023-11-23T12:44:02Z

SQL Server Performance

← Older revision		Revision as of 13:44, 23 November 2023
Line 25:		Line 25:
	see the following blog for some info:		see the following blog for some info:

	[https://www.nocentino.com/pure-storage-links/ ~~https://www.nocentino.com/posts/2021~~-~~10-06-sql-server-file-latency/~~]		[https://www.nocentino.com/pure-storage-links/ Pure Storage Links - Anthony Nocentino's Blog]

2023-11-23T12:43:31Z

SQL Server Performance

← Older revision		Revision as of 13:43, 23 November 2023
Line 25:		Line 25:
	see the following blog for some info:		see the following blog for some info:

	https://www.nocentino.com/posts/2021-10-06-sql-server-file-latency/		[https://www.nocentino.com/pure-storage-links/ https://www.nocentino.com/posts/2021-10-06-sql-server-file-latency/]

2023-11-23T12:42:20Z

← Older revision		Revision as of 13:42, 23 November 2023
Line 21:		Line 21:
	==SQL Server Service Accounts==		==SQL Server Service Accounts==
	See useful info here [https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-ver16 MS Learn]		See useful info here [https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-ver16 MS Learn]

			== SQL Server Performance ==
			see the following blog for some info:

			https://www.nocentino.com/posts/2021-10-06-sql-server-file-latency/

2023-11-15T20:32:21Z

5 revisions imported

← Older revision	Revision as of 21:32, 15 November 2023
(No difference)

2023-08-24T10:50:26Z

← Older revision		Revision as of 11:50, 24 August 2023
Line 18:		Line 18:

	[https://www.microsoft.com/en-us/download/details.aspx?id=39046 Microsoft® Kerberos Configuration Manager for SQL Server®]		[https://www.microsoft.com/en-us/download/details.aspx?id=39046 Microsoft® Kerberos Configuration Manager for SQL Server®]

			==SQL Server Service Accounts==
			See useful info here [https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-ver16 MS Learn]

2023-08-24T08:29:23Z

SQL Server Authentication troubleshooting

← Older revision		Revision as of 09:29, 24 August 2023
Line 15:		Line 15:

	==SQL Server Authentication troubleshooting==		==SQL Server Authentication troubleshooting==
	If having issues with kerborous authentication you can use this tool to check spn + other possible issues:[https://www.microsoft.com/en-us/download/details.aspx?id=39046 Microsoft® Kerberos Configuration Manager for SQL Server®]		If having issues with kerborous authentication you can use this tool to check spn + other possible issues:

			[https://www.microsoft.com/en-us/download/details.aspx?id=39046 Microsoft® Kerberos Configuration Manager for SQL Server®]

2023-08-24T08:29:08Z

← Older revision		Revision as of 09:29, 24 August 2023
Line 13:		Line 13:

	[https://github.com/microsoft/CSS_SQL_Networking_Tools/wiki/ SQL Networking tools wiki]		[https://github.com/microsoft/CSS_SQL_Networking_Tools/wiki/ SQL Networking tools wiki]

			==SQL Server Authentication troubleshooting==
			If having issues with kerborous authentication you can use this tool to check spn + other possible issues:[https://www.microsoft.com/en-us/download/details.aspx?id=39046 Microsoft® Kerberos Configuration Manager for SQL Server®]