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
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
10
Sep, 2021
T-SQL Query to get data and log size in SQL Server
MSSQL SQL on Linux, SQL Server database sizeBelow query can be used to get database data and log size details in SQL Server.
Output: