DBblogger | Rajendra Gupta

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

3,342 views0 comments

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.

15,758 views4 comments

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 .

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,145 views0 comments

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.