My random rumblings

Something of everything and nothing at all

Alt+Ctrl+Del through remote-remote-remote… desktop

Found this at https://social.technet.microsoft.com/Forums/en-US/2b67fa96-707b-47c4-90f5-c3a087ba16a9/how-do-i-change-password-when-connected-to-remote-desktop

Press WindowsKey+R (or get the Run box open) – then type OSK (It will open 'on-screen-keyboard in your remote-remote session). Or open on-screen-keyboard in different way.

Then press on your physical keyboard (not on that on screen!!) ctrl and alt keys. Using your mouse tick DEL key on 'On-screen-keyboard'.

Works well for me :)

SQL Server Table Export and Import

The data of a table in SQL Server can be exported using the following command

C:\>bcp "<db name>.<schema>.<table_name>" out "d:\roadinfo.bin" -T -n -S .

A query can also be used by changing out to outquery.

Ensure that the destination table on the destination database has the same layout.

C:\>bcp "<db name>.<schema>.<table_name>" in "d:\roadinfo.bin" -n -S <server_name> -U <username> -P <password>

 

How to change path to executable to a service

Copied from superuser.com:

 

You can use the sc config command to change the path a service points to.

C:\>sc config YourServiceName binPath= "C:\SomeDirectory\YourFile.EXE"

This will update the service called YourServiceName and change the "Path to Executable" entry to C:\SomeDirectory\YourFile.EXE. You will want to restart your service afterwards, which you can do with:

C:\>net stop YourServiceName

C:\>net start YourServiceName

 

Note there is a required space between binpath= and the command

Data Analytics

If you torture the data long enough, it will confess.

  • Ronald Coase, Professor of Economics, Chicago

Science

The most exciting and phrase to hear in science, the one that heralds new discoveries, is not "Eureka!" but rather "Hmm… that's funny…"

  • Isaac Asimov

Network Issues

Sometime when strange network issues prevail it is good to run a ping with a larger buffer size.

Most of the time normal ping sends 32 bytes of data over the network and will make the network appear available.

Most networks have a MTU in the vicinity of 1500 bytes, thus using a buffer size of 2048 will assist in showing if routers on the network is breaking packet and reassembling them correctly.

Suggested reading

Someone suggested the following books that I would like to read somewhere this year.

  1. Quiet: The Power of Introverts in a World That Can't Stop Talking – Susan Cain
  2. The Advantage: Why Organizational Health Trumps Everything Else In Business - Patrick Lencioni