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
    T-SQL script to configure SQL Database for optimal VLF distribution
    rajendra gupta
    • May 5
    • 1 min

    T-SQL script to configure SQL Database for optimal VLF distribution

    T-SQL script to configure SQL Database for optimal VLF distribution
    27 views0 comments
    Query to list SQL Server indexes in a specific database
    rajendra gupta
    • Mar 31
    • 1 min

    Query to list SQL Server indexes in a specific database

    Sometimes you need to know the list of SQL Server indexes available in the SQL database. There are many ways to get the list of indexes....
    210 views0 comments
    Space used by Individual tables in SQL Server
    rajendra gupta
    • Feb 1
    • 1 min

    Space used by Individual tables in SQL Server

    Learn how to manage SQL Server space used by individual tables with this tutorial. Read more here.
    184 views0 comments
    SQL Server Dynamic Management View(DMV)- sys.dm_exec_requests
    rajendra gupta
    • Feb 1
    • 2 min

    SQL Server Dynamic Management View(DMV)- sys.dm_exec_requests

    Execute the sys.dm_exec_requests DMV in SQL Server Management Studio to get the status of the backup or restore operations.
    135 views0 comments
    Get SQL Server Configuration using T-SQL
    rajendra gupta
    • Jan 28
    • 1 min

    Get SQL Server Configuration using T-SQL

    As a SQL architect or database administrator, it is required to know how to get SQL Server configuration using T-SQL. This post will share
    73 views0 comments
    SQL Server – Retrieve Physical Cores, Physical and Virtual CPUs, and Processor type information
    rajendra gupta
    • Jan 28
    • 1 min

    SQL Server – Retrieve Physical Cores, Physical and Virtual CPUs, and Processor type information

    Today's post describes SQL queries to get the following information about the processors of a SQL Server instance: 1. The total number of ph
    118 views0 comments
    SQL Server - How to comma-separated values into different columns
    rajendra gupta
    • Jan 28
    • 1 min

    SQL Server - How to comma-separated values into different columns

    This article will demonstrate the method to store comma-separated values into different columns using SQL Server(T-SQL) query.
    122 views0 comments
    T-SQL Query to change Integration Services Catalog (SSISDB) database Master Key encryption password
    rajendra gupta
    • Jan 28
    • 1 min

    T-SQL Query to change Integration Services Catalog (SSISDB) database Master Key encryption password

    Learn how to change the Master Key encryption password for an SQL Server Integration Services Catalog (SSISDB) database in SQL Server.
    26 views0 comments
    SQL Server agent jobs without notification using T-SQL
    rajendra gupta
    • Jan 28
    • 1 min

    SQL Server agent jobs without notification using T-SQL

    This article will describe how to get a list of SQL Server agent jobs without notifications using T-SQL . Read more here
    36 views0 comments
    Display dates between two input dates using SQL DATEDIFF function in SQL Server
    rajendra gupta
    • Jan 27
    • 1 min

    Display dates between two input dates using SQL DATEDIFF function in SQL Server

    SQL Server has a very useful function called DATEDIFF. This function is used to calculate the difference between the two dates. Read more he
    55 views0 comments
    T-SQL query to change the job owners for all jobs owned by a specific login
    rajendra gupta
    • Jan 25
    • 1 min

    T-SQL query to change the job owners for all jobs owned by a specific login

    Many SQL Server DBAs manage jobs through the SSMS GUI and do not know about the underlying T-SQL scripts being run. This blog shows how to u
    86 views0 comments
    Identify When your SQL Database Was Last Used - SQL Server
    rajendra gupta
    • Jan 24
    • 2 min

    Identify When your SQL Database Was Last Used - SQL Server

    I've seen several questions on the forums asking how to find out whether the SQL database is in use or not? Let's answer in this article.
    327 views4 comments
    T-SQL Query to find Supported Compatibility Level Values in SQL Server
    rajendra gupta
    • Jan 19
    • 1 min

    T-SQL Query to find Supported Compatibility Level Values in SQL Server

    The question came up on the forum - how do I find all the possible values for a specific compatibility_level in SQL Server? Let's check .
    46 views0 comments
    T-SQL Query to find Orphan data and log files of SQL Databases
    rajendra gupta
    • Jan 19
    • 1 min

    T-SQL Query to find Orphan data and log files of SQL Databases

    Are you a DBA? Then you'll love this free T-SQL script. This script helps you find orphaned data and log files of SQL Databases.
    45 views0 comments
    T-SQL script to Backup database SQL Server with TimeStamp
    rajendra gupta
    • Jan 18
    • 1 min

    T-SQL script to Backup database SQL Server with TimeStamp

    The T-SQL script takes a full backup of all databases(System databases and user databases) in the format of DataaseName-YYYY-MM-DD-HH-MM-...
    75 views0 comments
    Export Windows applications logs in CSV format using SQL Server query
    rajendra gupta
    • Jan 18
    • 1 min

    Export Windows applications logs in CSV format using SQL Server query

    The Windows application logs are used by various applications to write new events. This blog exporting these logs into CSV format
    23 views0 comments
    How to Change Always On availability group mode
    rajendra gupta
    • Jan 17
    • 1 min

    How to Change Always On availability group mode

    This topic describes how to change the availability mode of an availability replica in an Always On availability group in SQL Server by usin
    22 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
    PowerShell Script to restart SQL Services
    rajendra gupta
    • Jan 11
    • 1 min

    PowerShell Script to restart SQL Services

    Learn how to use PowerShell to restart a SQL service. Learn how to use PowerShell to restart an instance of SQL Server.
    70 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
    1
    2

    © 2022 by dbblogger

    Privacy Policy
    CopyRight