Callum 
SQL Server Dynamic Management View(DMV)- sys.dm_exec_requests
You can use the dynamic management view sys.dm_exec_requests to get the status of currently running...
T-SQL statement to Enable and Disable XP_CMDSHELL using SP_CONFIGURE in SQL Server
This article outlines the steps to Enable and Disable XP_CMDSHELL using the SP_CONFIGURE system stored...
T-SQL Query to find SQL database age and number of tables in SQL Server
The following T-SQL statement helps find the SQL Database age based on the created date...
A handy guide for Troubleshooting SQL Server Error 9002 – The Transaction Log for Database is Full
Are you getting the following SQL Server error 9002 for SQL Database with the following...
Configure Max Degree of Parallelism (MAXDOP) for Azure SQL Database
Many factors contribute to the performance of a database, such as server configuration, database design,...
Troubleshoot and fix sp_msforeachtable QUOTED_IDENTIFIER error
When utilizing the sp_msforeachtable procedure to rebuild an index on all tables within a database,...
Troubleshoot SQL agent on Linux not starting
If the SQL Server Agent service on Linux is not starting due to hostname issues,...
T-SQL script to find out SQL Server Logs directory
SQL Server error logs are essential for troubleshooting issues, checking out any warning or errors...
Discovering Miuzo: The Ultimate Guide to This Unique Trend
Have you stumbled upon the term “Miuzo” and wondered what it really means? You’re not...
SQL Server Performance Troubleshooting: Navigating Common Issues
In the realm of data management, SQL Server stands as a pillar of reliability and...