...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

Wednesday, March 23, 2016

Notepad++ and xml

 Notepad++ is a veritable well of usefulness. Everyday I am finding new nice features.
 Today, it's ability to collapse all nodes in xml document via keyboard shortcut.

 To collapse all nodes:
 To expand all nodes:
 To expand certain level only:
 ALT-SHIFT-2 (for level 2)
 To collapse on certain level only:

 Of course, you do need to install XML plugin to manipulate XML documents, then you can format it and validate and do all kinds of useful things with it.

Thursday, March 3, 2016

Visual Studio search broken after BizTalk installation

 I am not sure who exactly broke my Visual Studio 2013,  either BizTalk ESB Toolkit or PowerTools for TFS broke Visual Studio search.
 Find in Files for a word would return summary only, without actual list of files to go and see - pretty useless.

 Solution is to fix default value for registry key:


C:\Program Files (x86)\Common Files\Microsoft Shared\MSEnv\TextMgrP.dll

It was blank, I've entered the value and it worked without even restarting VS. 

Monday, February 1, 2016

Unable to connect to proxy server error

  This error is very annoying because culprit is IE update.
   Regardless of what browser you are using, IE changes the settings for the proxy internally, blocking every browser.
 Solution is to go to Internet Options, then to Connections, LAN and then uncheck proxy option there.
  One of those issues that underlies why Microsoft was sued for antitrust violations. I almost never use IE (except for testing) and yet, this silent update blocks everything else.


Monday, January 11, 2016

AppPool identity

 To be able to give App Pool identity permission on the folder, you need to search for:

  IIS AppPool\DefaultAppPool

 Otherwise you will not find it.