Monthly Archives: February 2017

SQL Connectivity Behavior

Connecting over the Network By default, the default protocol for SQL Server clients is TCP/IP. If the connection cannot be made using TCP/IP, the other enabled protocols are attempted. A shared memory connection cannot be made over a network. Use … Continue reading

Posted in develop | Tagged , | Leave a comment

VPN

https://www.expressvpn.com/

Posted in tools | Tagged | Leave a comment

Vodafone 6 Ultra OTA

This is Vodafone Smart Ultra 6 official firmware package. Download from the link below and use flashing instructions found at the end of the post to install the stock ROM to your smartphone. Downloads: Vodafone Smart Ultra 6 – Download … Continue reading

Posted in tools | Tagged , , , , | Leave a comment

Set an environment variable to the current working directory

The current directory is in the “shadow” variable cd called var. set “var=%cd%” set var

Posted in develop | Tagged , | Leave a comment

Remove SQL Server components

From https://www.mssqltips.com/sqlservertip/4050/cleanly-uninstalling-stubborn-sql-server-components/ Prerequisite MSI Inventory tool, which you can download msiinv_new.zip You can get the GUID associated with each installed product by searching around the registry, but I would rather use the MSI Inventory tool, which you can download (msiinv_new.zip) … Continue reading

Posted in tools | Tagged , , , , | Leave a comment

WinRAR compress certain files with relative paths

Select tdp and Add to archieve… Click Add > select tab Files , and add the something similar to the following in the Files to add field: E:\code\tsm\tdp\..\*dbmanager.csproj E:\code\tsm\tdp\..\*dp.client.csproj E:\code\tsm\tdp\..\*fm.smo.csproj E:\code\tsm\tdp\..\*fm.smo.unittests.csproj E:\code\tsm\tdp\..\*tdpsqlc.vcxproj E:\code\tsm\tdp\..\*dpsqlengine.vcxproj  

Posted in tools | Tagged | Leave a comment

Compact the VDI disk

cd /d “C:\Program Files\Oracle\VirtualBox” To list the VM’s details run: VBoxManage.exe list -l vms … Name:            RHINO W2012R2 … SATA (0, 0): D:\VirtualBoxVMs\RHINO W2012R2\Snapshots/{57f6550e-f818-4bcd-9d46-9b99ef168e5f}.vdi (UUID: 57f6550e-f818-4bcd-9d46-9b99ef168e5f) … Name:            JACK W2012R2 … SATA (0, 0): D:\VirtualBoxVMs\JACK W2012R2\Snapshots/{426e12f0-968a-4756-af0b-85f5bc22d466}.vdi (UUID: 426e12f0-968a-4756-af0b-85f5bc22d466) … To … Continue reading

Posted in tools | Tagged , , | Leave a comment