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