SQL 4/7

SQL Database Backups using DBATools PowerShell Module

rajendra gupta

Feb 8, 20221 min read

SQL Database Backups using DBATools PowerShell Module

Want to learn how to set up a PowerShell DBA environment? Here's how to configure it for SQL Server backups. T

616 views0 comments

Space used by Individual tables in SQL Server

rajendra gupta

Feb 1, 20221 min read

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.

306 views0 comments

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

rajendra gupta

Feb 1, 20222 min read

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.

729 views0 comments

Get SQL Server Configuration using T-SQL

rajendra gupta

Jan 28, 20221 min read

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

618 views0 comments

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

rajendra gupta

Jan 28, 20221 min read

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

1,196 views0 comments

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

rajendra gupta

Jan 28, 20221 min read

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.

3,622 views0 comments

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

rajendra gupta

Jan 28, 20221 min read

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.

620 views0 comments

SQL Server agent jobs without notification using T-SQL

rajendra gupta

Jan 28, 20221 min read

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

760 views0 comments

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

rajendra gupta

Jan 27, 20221 min read

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

2,628 views0 comments

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

rajendra gupta

Jan 25, 20221 min read

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

4,263 views0 comments

Identify When your SQL Database Was Last Used - SQL Server

rajendra gupta

Jan 25, 20222 min read

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.

17,239 views4 comments

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

rajendra gupta

Jan 19, 20221 min read

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 .

936 views0 comments

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

rajendra gupta

Jan 19, 20221 min read

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.

1,318 views0 comments

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

rajendra gupta

Jan 19, 20221 min read

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.

335 views0 comments

How to disable current line highlight in SQL Server Management Studio(SSMS)?

rajendra gupta

Jan 19, 20221 min read

How to disable current line highlight in SQL Server Management Studio(SSMS)?

146 views1 comment

Export Windows applications logs in CSV format using SQL Server query

rajendra gupta

Jan 19, 20221 min read

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

215 views1 comment

T-SQL script to Backup database SQL Server with TimeStamp

rajendra gupta

Jan 19, 20221 min read

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-...

2,956 views0 comments

Troubleshoot SQL Server Backup Error Msg 3231, Level 16, State 1

rajendra gupta

Jan 18, 20221 min read

Troubleshoot SQL Server Backup Error Msg 3231, Level 16, State 1

When you are experiencing SQL Server Error Msg 3231, Level 16, State 1 while backing up SQL Database, it is important to troubleshoot the er

172 views0 comments

Troubleshoot SQL Server Error for backups–: Msg 3136, Level 16

rajendra gupta

Jan 18, 20221 min read

Troubleshoot SQL Server Error for backups–: Msg 3136, Level 16

Is it possible to use COPY_ONLY backup for restoring differential backups? No, if you try to do so, SQL Server raises error Msg 3136, Level

39 views0 comments

rajendra gupta

Jan 18, 20222 min read

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

47 views0 comments