SQL Server on Linux

Troubleshoot and fix sp_msforeachtable QUOTED_IDENTIFIER error

prashantj42000

Jun 111 min read

Troubleshoot and fix sp_msforeachtable QUOTED_IDENTIFIER error

65 views1 comment

Troubleshoot SQL agent on Linux not starting

rajendra gupta

Apr 5, 20231 min read

Troubleshoot SQL agent on Linux not starting

Troubleshooting SQL Server Agent on Linux

413 views0 comments

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

Jan 13, 20221 min read

SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup

60 views0 comments

Jan 11, 20221 min read

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

32 views0 comments

Jan 10, 20221 min read

T-SQL script to get user session count with client IP address

Download a T-SQL script for SQL Server that will aggregate the number of active sessions for each unique IP address. This is useful for dete

134 views0 comments

Jan 10, 20221 min read

SQL Server Missing Index Script

If you ever find yourself in a situation where you're trying to troubleshoot performance on a SQL Server, then it's a good idea to look at

197 views0 comments

Jan 7, 20221 min read

Script SQL Database Permissions for database refresh

1,632 views0 comments

Jan 7, 20221 min read

SQL Server Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’

In SQL Server Always On Availability Group environment endpoint connection issue is a common problem and it needs to be resolved by...

8,364 views0 comments

Jan 7, 20221 min read

T-SQL Script to find out Nth highest salary

It is a standard SQL interview question where the interviewer asks to write a query that finds Nth highest salary from the employee table. H

53 views0 comments

Jan 5, 20221 min read

Drop Database in SQL Server

30 views0 comments

Jan 5, 20222 min read

Disable and Enable SQL Server Indexes

This article explains how to disable an Index in SQL Server.

341 views0 comments

Jan 5, 20221 min read

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

155 views1 comment

Jan 4, 20222 min read

Learn SQL SELECT TOP statement

This SQL tutorial will understand how to use the SQL SELECT TOP queries using various examples.

34 views0 comments

Jan 4, 20221 min read

"Invalid Object Name" Error in SSMS for recently created objects

Suppose you created a new table in SQL Server or Azure SQL Database, and the query editor shows you the error message "Invalid Object Name"

221 views0 comments

Jan 4, 20222 min read

How to stop logging successful backup messages in SQL Server error logs

This article guides you to stop logging successful backup messages in SQL Server Error Logs.

162 views0 comments

Dec 26, 20212 min read

Generate Blocking tree in SQL Server and Azure SQL Database

207 views0 comments

Dec 26, 20211 min read

Query To Kill All Active Connections in Azure SQL Database

252 views0 comments

Dec 26, 20212 min read

SQL Server Error 9002 – The transaction log for database <DBName> is full due to 'Replication.'

SQL Server Error 9002 – The transaction log for database <DBName> is full due to 'Replication'

178 views0 comments

Dec 26, 20211 min read

SQL Script to check database connections and their status

223 views0 comments