• Adam Thurgar

Windows 2016 server problem

I was RDP'ing to a Windows 2016 server and when I got onto the server, the start menu and search windows didn't work. Supposedly a known issue.

This made it very hard to run any programs. Luckily I knew the location of SQL Server Management Studio (ssms.exe) so I could run that and save that to the desktop.

But I needed access to the Control Panel and SQL Server Configuration Manager.

It took a bit of research but what I needed to do was change the RDP connection -> Show options -> Local Resources -> Keyboard and change the 'Apply Windows key combinations' to "On the remote computer".

Then when I RDP'd to the server I could do a WIN + R to bring up a run window and then run services.msc and SQLServermanager12.msc etc.


Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t