Utilizing Conditional Logic with `sp_MSforeachtable`

SQL Server Performance Troubleshooting: Navigating Common Issues

Write a script ensures you get row counts for all tables in all user databases, excluding the system databases. We can use the...

SQL Server - Where do my SQL Database files reside?

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

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

Learn how to manage SQL Server space used by individual tables with this tutorial. Read more here.

Execute the sys.dm_exec_requests DMV in SQL Server Management Studio to get the status of the backup or restore operations.

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

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

This article will demonstrate the method to store comma-separated values into different columns using SQL Server(T-SQL) query.

Learn how to change the Master Key encryption password for an SQL Server Integration Services Catalog (SSISDB) database in SQL Server.

This article will describe how to get a list of SQL Server agent jobs without notifications using T-SQL . Read more here

SQL Server has a very useful function called DATEDIFF. This function is used to calculate the difference between the two dates. Read more he

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

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.

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 .

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.

The Windows application logs are used by various applications to write new events. This blog exporting these logs into CSV format

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