SQLServer: Difference between revisions

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'

SQL Server Upgrade

get current version of SQL server:

SELECT @@VERSION;

Can use the following spreadsheet to work out what build the SQL server is on and what it can be upgraded to:

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:

Upgrade SQL Server

Start planning SQL server upgrade by running the Data Migration Assistant: Data Migration Assistant Download Page

@@ Line 1: / Line 1: @@
 == SQL Server ==
+Check on SQL server activity using:
+*ctrl + alt + A
 ==SQL Server Networking==
@@ Line 10: / Line 13: @@
 [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®]
+==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]
+== SQL Server Performance ==
+see the following blog for some info:
+[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>
+== 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:
+[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]