I had a requirement from application team that I should rename a database when the application is running and the transactions were happening. The reason…
Below workaround will help you incase if you wanna control SQL agent job steps based on a SQL query output. For eg: Suppose you have…
Below Query will help you read live file level Disk read and write information. WIll behandy for performance tuning capacity planning. select db.name,files.filename,* from sys.dm_io_virtual_file_stats(NULL,…
Once we had an issue in our environment. We had a maintenance activity on the Database server during a weekend and the server was shutdown…