19
Sep, 2022
How to read SQL Server error logs using the xp_readerrorlog
MSSQL, T-SQL Scripts SQL server, SQL Server error log, sql server management studio, SSMS, xp_readerrorlogIn this article, we are going to explore xp_readerrorlog for reading SQL Server error logs using T-SQL command.
Reading SQL Server error log using T-SQL:
xp_readerrorlogxp_readerrorlog Parameters Value Details:
xp_readerrorlog <paramter#1>,<paramter#2>,<paramter#3>,<paramter#4>,<paramter#5>,<paramter#6>,<paramter#7>
Parameter#1:… Read the rest
18
Sep, 2022
How to Install and Configure SQL Server Reporting Services (SSRS)
MSSQL Reporting Services, SQL server, SQL Server Reporting Services, SSRSIn this article, we are going to install and configure Microsoft SQL Server Reporting Services(SSRS) on the Windows machine. Below are step by step process to achieve the same.
What is SQL Server Reporting Services (SSRS)
SQL Server Reporting Services (SSRS) … Read the rest
16
Sep, 2022
T-SQL query to check SQL server agent status
MSSQL, T-SQL Scripts SQL Agent, SQL serverIF EXISTS(
SELECT 1 FROM MASTER.dbo.sysprocesses WHERE LEFT(program_name,8)= 'SQLAgent')
BEGIN
SELECT SERVERPROPERTY('ServerName') AS 'InstanceName',getdate() AS CurrentDate, 'Running' AS 'SQLServerAgent Status'
END
ELSE
BEGIN
SELECT SERVERPROPERTY('ServerName') AS 'InstanceName',getdate() AS CurrentDate, 'Stopped' AS 'SQLServerAgent Status'
END
Sample Output:
13
Sep, 2022
Configure Always On High Availability Group for SQL On Linux
MSSQL, SQL On Linux AG Setup, Always on, availability group, SQL on LinuxWhat is Always On in SQL Server – Always On is High Availability(HA) and Disaster Recovery(DR) solution that maximizes database availability for Business to run as usual with minimum impact. Please go though this link to get more details on … Read the rest
2
Sep, 2022
T-SQL Query to check Drive Space in SQL Server
MSSQL, T-SQL Scripts Disk Space, Drive Space, SQL serverBelow query can be used to check Drive space details in SQL server on Windows platform.
Sample Output:
31
Aug, 2022
SQL On Linux: CU Upgrade from CU12 to CU17
MSSQL, SQL On Linux cumulative update, SQL on Linux, SQL Server 2019, SQL Server CU Upgrade, sql server management studioBelow are step by step process to upgrade Cumulative Updates(CU) in SQL Server 2019 on Linux.
Run below query to check current SQL Server version.
SELECT SERVERPROPERTY('productversion') 'ProductVersion', SERVERPROPERTY ('productlevel') 'ProductLevel', SERVERPROPERTY ('edition') 'Edition'
SQL Server version/CU can be verified … Read the rest