In this article, we will explain
- How to get the SQL Server Instance Information using “SERVERPROPERTY”?
- How to get the SQL Server Instance Information remotely?
What’s the SERVERPROPERTY?
SERVERPROPERTY is a System Defined function used to return the SQL Server Instance Information.
“propertyname“ is one of the following values.
Continue reading “SQL Server: Get the Detailed Information Via SERVERPROPERTY”
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 in 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
select SERVERPROPERTY('ProductLevel') as 'Product Level'
Continue reading “SQL Server: How to get the current installed update level”
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.
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”
In this article, I will explain How to
Which version of SQL Server is supported for SharePoint 2016?
First, 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.
Actually, that made me puzzled to maintain the compatibility of SQL Server 2014 SP2 or SQL Server 2016 SP1 with SharePoint 2016! So
In this article, I will elaborate How to Scale Out SQL Reporting Service (SSRS) to work with two Database Server (Always-on)?
I have a 2-Tire SharePoint 2013 Farm
- 2 WFE+ APP Servers.
- 2 Database Servers (Always-on).
If you need to use Reporting Services with SharePoint. it’s recommanded to configure SSRS SharePoint integrated mode with Reporting service application service on an indpenedent reporting server to ensure the Performance, Manageability and Security.
But in my case, the customer budget is not enough to apply the best practice, Meanwhile configuring SSRS SharePoint integrated mode with Reporting service application service on the same WFE + APP server lead to low performance.
So I have decided to work with SSRS Native mode to ensure at least the performance and show reports inside SharePoint via:
And in this case, I should configure SSRS Native mode on both SharePoint WFE Servers because as we know the Database Servers are not accessible over the internet,
Note: If you configured SSRS native mode on only one WFE server. you will get it worked properly. but sometimes when browsing the Report Manager URL you will get 404 error!
Continue reading “Scale-Out Deployment for SQL Reporting Service (SSRS)”
After installing and configuring SQL Server Reporting Service.I tried to open Report Manager URL but unfortunately, I got the following error:
User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
The current user doesn’t have a sufficient permission to access Report Manager URL.
SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).
In this article, I will elaborate
How to install and configure SQL Server Reporting Service (SSRS) Native Mode.
- SQL Server Reporting Services SSRS 2016.
- SQL Server Reporting Services SSRS 2014
- SQL Server Reporting Services SSRS 2012.
- SQL Server Reporting Services SSRS 2008.
Continue reading “Install and Configure SQL Server Reporting Service (SSRS)”