WhatsApp Image 2021-11-26 at 4.32_edited.png
WhatsApp Image 2021-12-01 at 1.18_edited.png
  • Home

  • About Me

  • SQL Server

  • Cloud

    • Azure
    • AWS
  • All Blogs

  • Courses

  • More

    Use tab to navigate through the menu items.
    Mail
    • LinkedIn
    • Facebook
    • Twitter
    • Twitter
    Learn SQL NOT IN Operator
    rajendra gupta
    • Mar 29
    • 2 min

    Learn SQL NOT IN Operator

    The SQL NOT IN operator is used to find entries in a table that are not in a list of values. Learn how to use this SQL operator
    43 views0 comments
    Difference between SQL COUNT(*), COUNT(1), COUNT(column_name) In  SQL SERVER
    rajendra gupta
    • Mar 28
    • 2 min

    Difference between SQL COUNT(*), COUNT(1), COUNT(column_name) In SQL SERVER

    What is the difference between COUNT(*), COUNT(1), and COUNT(column_name) in SQL Server? Read all about it here.
    338 views0 comments
    An Overview of the SQL CHARINDEX function
    rajendra gupta
    • Feb 26
    • 1 min

    An Overview of the SQL CHARINDEX function

    The SQL CHARINDEX function is used to find the position of a character or substring within a string.
    33 views0 comments
    T-SQL Query to find SQL database age and number of tables in SQL Server
    rajendra gupta
    • Jan 18
    • 1 min

    T-SQL Query to find SQL database age and number of tables in SQL Server

    SQL Server - The following T-SQL statement helps find the SQL Database age based on the created date and number of tables.
    22 views0 comments
    The SQL NULLIF function
    rajendra gupta
    • Jan 17
    • 2 min

    The SQL NULLIF function

    NULLIF is a SQL function that is used to compare two columns. Use NULLIF to compare two columns and return NULL if they are equal to each ot
    16 views0 comments
    T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
    rajendra gupta
    • Jan 12
    • 1 min

    T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)

    T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
    22 views0 comments
    Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database
    rajendra gupta
    • Jan 10
    • 1 min

    Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database

    Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database
    4 views0 comments
    What is SET NOEXEC ON in the T-SQL statement?
    rajendra gupta
    • Jan 6
    • 1 min

    What is SET NOEXEC ON in the T-SQL statement?

    Do you want to compile the query without executing it? If yes, you can use SET NOEXEC ON at the beginning of the T-SQL statement.
    16 views0 comments
    SQL Server Management Studio Query Commands completed successfully without any Results
    rajendra gupta
    • Jan 6
    • 1 min

    SQL Server Management Studio Query Commands completed successfully without any Results

    I recently came across a strange issue where the query does not return any row in SQL Server Management Studio. How do we solve this issue?
    15 views0 comments
    T-SQL statement to Enable and Disable XP_CMDSHELL using SP_CONFIGURE in SQL Server
    rajendra gupta
    • Jan 5
    • 1 min

    T-SQL statement to Enable and Disable XP_CMDSHELL using SP_CONFIGURE in SQL Server

    This article outlines the steps to Enable and Disable XP_CMDSHELL using the SP_CONFIGURE system stored procedure.
    17 views0 comments
    T-SQL Script to generate Six Digit One Time Password (OTP)
    rajendra gupta
    • Jan 4
    • 1 min

    T-SQL Script to generate Six Digit One Time Password (OTP)

    This blog will give a T-SQL script o create and use Six Digit One Time Password using the SQL Server RAND function
    19 views0 comments
    Drop Database in SQL Server
    rajendra gupta
    • Jan 4
    • 1 min

    Drop Database in SQL Server

    Drop Database in SQL Server
    7 views0 comments
    Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
    rajendra gupta
    • Dec 16, 2021
    • 1 min

    Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database

    Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
    9 views0 comments
    SQL Server table Columns with NULL and NOT NULL values
    rajendra gupta
    • Dec 12, 2021
    • 2 min

    SQL Server table Columns with NULL and NOT NULL values

    This SQL article explains the SQL Server column property that has NULL or NOT NULL keywords specified in the CREATE OR ALTER table...
    14 views0 comments
    Identifying SQL Agent Job from the format -  SQLAgent - TSQL JobStep (Job 0xC4A075BBC7D7FB4993E60371
    rajendra gupta
    • Dec 9, 2021
    • 1 min

    Identifying SQL Agent Job from the format - SQLAgent - TSQL JobStep (Job 0xC4A075BBC7D7FB4993E60371

    This article helps you get the SQL Server agent job name from the hexadecimal Job ID format. Let’s say you have deadlock information that...
    30 views0 comments
    SQL Server - Find Business Days Between Dates
    rajendra gupta
    • Dec 9, 2021
    • 1 min

    SQL Server - Find Business Days Between Dates

    Recently, my client asked me to calculate the date difference, excluding only Sunday. How do you calculate days using the T-SQL script?...
    33 views0 comments
    Find SQL Server Statistics Updated Date
    rajendra gupta
    • Dec 9, 2021
    • 1 min

    Find SQL Server Statistics Updated Date

    This SQL Server Tutorial talks about finding out the last Statistics Update Date in SQL Server. We all know that Statistics are vital for...
    45 views0 comments
    Get a list of supported Time Zones in SQL Server and Azure SQL Database
    rajendra gupta
    • Dec 9, 2021
    • 1 min

    Get a list of supported Time Zones in SQL Server and Azure SQL Database

    Do you want to find out supported time zones in SQL Server and Azure SQL Database? If yes, get the query in this article. The...
    4 views0 comments
    When my SQL Server database was restored ?
    rajendra gupta
    • Dec 9, 2021
    • 1 min

    When my SQL Server database was restored ?

    When my SQL Server database was restored ?
    10 views0 comments
    SQL Script to fix Orphan users in SQL Server database
    rajendra gupta
    • Dec 8, 2021
    • 2 min

    SQL Script to fix Orphan users in SQL Server database

    This blog post explains Orphan user and provides a script to fix Orphan users in SQL Server database. The basic process to create a...
    373 views0 comments
    1
    2

    © 2022 by dbblogger

    Privacy Policy
    CopyRight