by George Chrysovaladis Grammatikos | May 8, 2018 | SQL Server, Troubleshooting
Reading Time: 2 minutesSQL 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... 
by George Chrysovaladis Grammatikos | May 8, 2018 | SQL Server, Troubleshooting
Reading Time: 2 minutesPssdiag 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... by George Chrysovaladis Grammatikos | Apr 19, 2018 | SQL Server, Troubleshooting
Reading Time: < 1 minuteBelow 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... 
by George Chrysovaladis Grammatikos | Apr 19, 2018 | SQL Server, Troubleshooting
Reading Time: < 1 minuteIf 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... by George Chrysovaladis Grammatikos | Apr 19, 2018 | SQL Server, Troubleshooting
Reading Time: < 1 minuteIf there is a break in the restore process then we can follow the steps below to try solve the problem. First, Open SSMS and execute the following command to look at database Status. SELECT NAME, STATE_DESC FROM SYS.DATABASES As soon as you... by George Chrysovaladis Grammatikos | May 17, 2017 | SQL Server, Troubleshooting
Reading Time: < 1 minuteHeap table are the tables which they don’t have any clustered index. : — List all heap tables SELECT SCH.name + ‘.’ + TBL.name AS TableName FROM sys.tables AS TBL INNER JOIN sys.schemas AS SCH ON TBL.schema_id =...
