...All those moments will be lost in time, like tears in rain....

- soliloquy from Blade Runner

Bits and bytes do get lost, awash in the rain of data flow that is Internet. They slip away from us, never to found again... some of them will be captured here, many more will not... like tears in rain...

Thursday, March 16, 2017

Orphaned sql users

 If you restore database,there are scenarios when our user gets orphaned.

USE myDb
EXEC sp_change_users_login 'Report'

If you do have orphaned users, you can restore them if they exist but they are not linked to actual logins.

EXEC sp_change_users_login 'Auto_Fix', 'user'

Tuesday, January 17, 2017

How to share local disc when RDP

 Most of the time, copy-paste works seamlessly, until data amount or file is too big to copy. In that case, sharing local disk is perfect solution,

  1. Click Start, point to All Programs (or Programs), point to Accessories, point to Communications, and then click Remote Desktop Connection.
  2. Click Options, and then click the Local Resources tab.
  3. Define your disk as local disk for the connection.
  4.  Connect - it will be available in File Explorer as local disk.

 Wrinkle I encountered was that I had .RDP shortcuts already defined (from Azure) and bringing up properties didn't show me actual remote connection properties. But right click and Edit option did bring options for rdp and allowed me to add local disk to the connection.
 Connection is not permanent - if you stay connected to the machine for a long time, disk can disappear after a while, and should be defined again.

Windows 8 and .NET Framework 3.5

 I had an interesting problem - brand new Windows 8.1 with .NET framework 4.5 installed was not able to connect o windows update to download Framework 3.5. Reason for old framework - SQL Server 2014 requires it.
 After lots of googling, and experimenting, I've finally found option to do silent install, meant for situations where you don't have internet connection, and that worked:

LimitAccess switch is the key to signal Windows to use local dvd (or local ISO in my case) and not connect to internet for that.

DISM /Online /Enable-Feature /FeatureName:NetFx3 /All /LimitAccess /Source:d:\sources\sxs