Tag Archives: cmdline

‘systeminfo’ – Information about Windows, uptime, etc.

If you need to find out when Windows last rebooted, due to Windows Updates etc, open a Command Prompt, and issue: systeminfo A sample of the output is as follows: C:\Users\sburke>systeminfo   Host Name:                 SSITECH OS Name:                   Microsoft Windows 7 … Continue reading

Posted in System Information | Tagged | Leave a comment

SQL Activity Monitor – Debug high CPU Usage for SQL Server

START -> All Programs -> Microsoft SQL Server 2008 R2 -> SQL Server Management Studio Connect as normal and right-click on the SQL Server (top left) and go “Activity Monitor”. The Activity Monitor will show the queries been run, the … Continue reading

Posted in MS SQL Server | Tagged , | Leave a comment

Allow Domain Admin to Login to SQLServer & have full Access

For some reason when SQLServer 2008 was installed/setup, admins were not added. Therefore when trying to login via SQL Management Studio, an error was obtained: Login failed for user “username”. (Microsoft SQL Server, Error: 18456) I also didn’t know the … Continue reading

Posted in MS SQL Server | Tagged , , , | Leave a comment