Get the Update Level In SQL Server 2016

Consider you need to install a new Cumulative Update or Service Pack on your current SQL Server, but you don’t know what’s the current update level that already installed on your environment!!

In this article, we will explain

How to detect the current Cumulative Update / Service Pack that was installed on SQL Server.


Detect the Current Cumulative Update / Service Pack Installed

You can use the ServerProperty as a system defined function to return the SQL Server Instance information like the ProductLevel and ProductUpdateLevel

The ProductLevel returns the version level of the SQL Server instance as the following.

  • RTM‘ = Original release version
  • SPn‘ = Service pack version
  • CTPn‘, = Community Technology Preview version

Example 


select SERVERPROPERTY('ProductLevel') as 'Product Level'

Continue reading “Get the Update Level In SQL Server 2016”

Advertisements

Convert Rows To Columns Using Dynamic Pivot In SQL Server

In this article, we will show How to convert rows to columns using Dynamic Pivot in SQL Server.

PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, and performs aggregations where they are required on any remaining column values that are wanted in the final output.

Note: The demo in this article based on database from the TechNet Gallery.


Scenario

We have decided to build a dynamic database by creating only three tables as shown below:

 Continue reading “Convert Rows To Columns Using Dynamic Pivot In SQL Server”

Is SQL Server 2016 SP1 supported for SharePoint 2016?

It’s heavily recommended to check the Hardware and software requirements for SharePoint Server 2016 before you are going to Install SharePoint 2016,

In Hardware and software requirements for SharePoint Server 2016 article, specifically in Database Server requirements section, you will note that the database server requirements is one of the following:

  • The 64-bit edition of Microsoft SQL Server 2014 Service Pack 1 (SP1)
  • Microsoft SQL Server 2016 RTM.

sql-server-2016-with-sharepoint-2016

Actually, that made me puzzled to maintain the compatibility of SQL Server 2014 SP2 or SQL Server 2016 SP1 with SharePoint 2016! until
Continue reading “Is SQL Server 2016 SP1 supported for SharePoint 2016?”