SQL Server - The following T-SQL statement helps find the SQL Database age based on the created date and number of tables.

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

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

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

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

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

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

Script SQL Database Permissions for database refresh

This blog will give a T-SQL script o create and use Six Digit One Time Password using the SQL Server RAND function

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

Drop Database in SQL Server

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

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"

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

Generate Blocking tree in SQL Server and Azure SQL Database

SQL Script to check database connections and their status

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

Query To Kill All Active Connections in Azure SQL Database

Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database

This SQL article explains the SQL Server column property that has NULL or NOT NULL keywords specified in the CREATE OR ALTER table...