by George Grammatikos | Oct 18, 2018 | Azure, Virtualization, VM
At this post, we are going to describe the ways that we can handle Windows Update issues in an Azure VM and of course in any other Windows OS. Important In any of the following ways, we MUST be very careful because in some cases we need to change the system files or... 
by George Grammatikos | May 8, 2018 | SQL Server, Troubleshooting
SQL Nexus is a very useful utility that helps to identify SQL Server performance issues, by visualizing data logs using chart and reports. You can read how to collect diagnostics data using pssdiag in my previous article here. Before you install SQL Nexus, you must be... 
by George Grammatikos | May 8, 2018 | SQL Server, Troubleshooting
Pssdiag is a data collection utility that Microsoft gives to us to collect useful data and log files for SQL Server installations. Before, start the steps you need to follow to configure all the mandatory parameters you should first download the utility latest... by George Grammatikos | Apr 19, 2018 | SQL Server, Troubleshooting
Below you can find an easy explanation, how to reset sa account password. Download the PsExec tool from the Sysinternals suite. Open with elevated CMD or Powershell privileges and run the following command CMD: C:\PsExec.exe -s -i "C:\Program Files (x86)\Microsoft... 
by George Grammatikos | Apr 19, 2018 | SQL Server, Troubleshooting
If there is a problem during the upgrade process of a SQL Instance, then follow these instruction, Check the archive Summary.txt, which is located at C:\Program Files\Microsoft SQL Server\XXX\Setup Bootstrap\Log directory The second file that keeps logging important...
