top of page
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
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
rajendra gupta
Jan 19, 20221 min read
How to disable current line highlight in SQL Server Management Studio(SSMS)?
How to disable current line highlight in SQL Server Management Studio(SSMS)?
146 views1 comment
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
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
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
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
rajendra gupta
Jan 18, 20221 min read
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
1,383 views0 comments
rajendra gupta
Jan 18, 20221 min read
Troubleshoot SQL Server Backup Error Msg 3132, Level 16
This blog troubleshoots SQL Server Error Msg 3132, Level 16, State 1 while backing up SQL Database.
849 views0 comments
bottom of page