Author Archives: admin

Windows 10 Changes Keyboard Layout to US and Swaps @ and ” keys

By | |
Leave a comment

I’ve had this happen a number of times and find it really annoying. I don’t even have the English US Language installed, though I suspect you can’t truly uninstall it. I’ve always previously put up with this issue when it has occurred and eventually rebooted to fix it.

Today, I finally worked out how to switch it back. Simply hold down “Windows Key”+Spacebar (Seriously intuitive Eh?) and you get a pop up allowing you to switch between the keyboard layouts.

Clicking back to “English United Kingdom” sorted the problem. I still don’t know how I set it to English (US) though, given I don’t have a language bar and don’t have English US (or anything else) even as an option according to Settings / Preferred Languages.

Anyway, hope this might help someone else being driven mad by this!

Moving an SQlServer database from one machine to a new one with SQLServer 2016

By | | , ,
Leave a comment

I’ve just come to move to a new windows 10 development laptop and need to install a number of SQLServer databases that were on the old one (also windows 10 with various flavours of SQLServer). I have access to all of the .mdf and ldf files in a backup image.

I have restored these files and put them onto a data disk. However, when I came to attach them using SQL Management Studio (right click on databases and choose “Attach”), I was getting access denied errors. It turns out that all you need to do is give “Full Control” to the files “OWNER RIGHTS”.

Do this by selecting each file in turn, right click and choose properties. In the security tab, click “Edit”. Then click “Add”. Type “OWNER RIGHTS” in the box, click “Check Names” and click Ok. Make sure that “OWNER RIGHTS” is now selected in the top list and then check if “Full Control” is checked in the lower list. If it is not, click on the “Full Control” check box to select it.

Finally click OK on the two dialog boxes to dismiss them. You should now be able to attach the database