MS SQL Server

This blog post will break down the provided PowerShell code, explaining how it works to retrieve Windows Server reboot history. We'll also discuss how to interpret the results and potential enhancemen...

This blog post will break down the provided PowerShell code, Understanding when and why your server rebooted is crucial for troubleshooting performance issues, security incidents, and overall system h...

 Here’s a fantastic PowerShell script that can simplify our daily tasks by helping us search for events in the Windows Event Viewer. To use this script, open PowerShell ISE and run it. The output...

Here is another good PowerShell script that can make a SQL Admin’s life easier. This script can be used to check the health of SQL servers and retrieve information about them. The collected data will ...

what is this yar contenteditable="true" SELECT @@servername,getdate() ,command, r.session_id, r.blocking_session_id,s.text, start_time, percent_complete, CAST(((DATEDIFF(s,start_time,GetDa...

use master go BEGIN SET nocount ON IF EXISTS (SELECT 1 FROM tempdb..sysobjects WHERE = Object_id('tempdb..#DBFileInfo')) BEGIN DROP TABLE #dbfileinfo END IF EXISTS (SELECT 1 FROM tempdb..s...

 Hello this is the code test  we are now adding tsql code test here SELECT @@servername,getdate() ,command, r.session_id, r.blocking_session_id,s.text, start_time, percent_complete, CAS...