• Search for:

    1. Home
    3 Oct, 2022
    T-SQL script to find active processes in SQL Server 0 (0)
    MSSQL , ,

    SELECT SPID = er.session_id
    ,DBName = DB_Name(er.database_id)
    ,Host = ses.host_name
    ,STATUS = ses.STATUS
    ,BlockBy = er.blocking_session_id
    ,CommandType = er.command
    ,ObjectName = OBJECT_NAME(st.objectid)
    ,CPUTime = er.cpu_time
    ,StartTime = er.start_time
    ,wait_type =er.wait_type
    ,last_wait_type =er.last_wait_type
    ,TimeElapsed = CAST(GETDATE() – er.start_time AS TIME)
    ,SQLStatement     … Read the rest

    5 Sep, 2022
    How to Become a Database Administrator(DBA): A Complete Guide 5 (1)
    Uncategorized , , , , , , , , , ,

    Have you ever heard this DBA terminology before ? Perhaps YES or NO. Yes for those who are already into IT industry for sometime now. NO for those who are not part of IT industry. They are either FRESHERS or … Read the rest

    31 Aug, 2022
    SQL On Linux: CU Upgrade from CU12 to CU17 0 (0)
    MSSQL, SQL On Linux , , , ,

    Below 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

    26 Aug, 2022
    How to Configure SQL Server Always On High Availability Group 0 (0)
    MSSQL , , ,

    What 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

    17 Aug, 2022
    Understanding SQL Server Always On Basic Availability Groups 0 (0)
    MSSQL , , ,

    In today's competitive world, it is very necessary to keep the critical applications available 24*7 to the business as well as to the customer. All the organizations have to design their Infrastructure in such a way, so that they can … Read the rest

    15 Oct, 2021
    Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. 0 (0)
    MSSQL , ,

    Problem Description:

    Application job failed with timeout error seen in application log.

    Cause:

    There are different scenarios in which query can be timed out and below are the possible reasons from database end.

    1. Database blocking
    2. Overall load on database server
    … Read the rest
    3 Jul, 2021
    T-SQL Script to change compatibility level of all databases in SQL Server 0 (0)
    MSSQL , ,

    declare @CompatibilityLevelUpdate varchar(255)
    set @CompatibilityLevelUpdate = "
    select @CompatibilityLevelUpdate =@CompatibilityLevelUpdate +
    'alter database [' + name + '] set compatibility_level =150;' + char(15)
    from sys.databases
    where database_id4 — exluding system databases
    exec (@CompatibilityLevelUpdate)

    — Verify compatibility level

    select name … Read the rest

    1 Jul, 2021
    T-SQL Script to restore multiple databases using backup files in SQL Server 1 (1)
    MSSQL , , ,

    Below query can be used to restore multiple SQL Server databases using backup files.

    SET NOCOUNT ON
DECLARE
@foldername Varchar (255) = 'D:\MSSQL\MSSQLSERVER', --path where .bak files are placed
@DataFileLocation Varchar(255) = 'E:\MSSQL' , -- Optional, Specifies the folder for
    … Read the rest