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 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
select SERVERPROPERTY('ProductLevel') as 'Product Level'
Continue reading “Get the Update Level In SQL Server 2016”
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 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.
Solution: Continue reading “SSRS Permission Issue: User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.”
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)”
In some situation, you may need to check the SQL Server Instance connectivity from the application server to database server for a specific user especially when you don’t have access to SQL Servers on your farm based on your company policy.
You may try to perform Ping cmdlet for the SQL Server IP and Telnet to SQL TCP port.but that means There’s a network connectivity between two servers and you can reach the database server from the application server.
But what about if you need to test connectivity to SQL Server Instance for a specific user without using SQL Server Management Studio?
In this case, you can test connectivity to SQL Server Instance by creating a data link UDL file as I have mentioned below:
Steps: Continue reading “How to Check SQL Server Instance Connectivity from the application server to database server for a specific user without using SQL Server Management Studio”