Monthly Archives: August 2016

Check if the Server is pending reboot

I have used this Powershell script to validate if the server is pending a reboot or not. This script can be used to validate server pending reboot status on any other server within the network! https://gallery.technet.microsoft.com/scriptcenter/Get-PendingReboot-Query-bdb79542

Posted in Powershell, Windows Server | Tagged , , | Leave a comment

Install SQL Server Management Studio (SSMS)

Now SSMS (SQL Server Management Studio) can be installed as a stand alone, need not download full version only for SSMS. SSMS can be downloaded and installed from: https://msdn.microsoft.com/en-us/library/mt238290.aspx -Vijred

Posted in Uncategorized | Tagged , , | Leave a comment

QUERY STORE for Azure database performance analysis

Query store can be enabled on Azure SQL Database to analyze any performance issues with SQL Server. Example: Below image¬†indicates one of the SQL statement was executed about 57,000 times along with Query plan to understand what is consuming maximum … Continue reading

Posted in Azure, SQL, Uncategorized | Tagged , , , | Leave a comment