Update Center for Microsoft SQL Server

topic: 

All updates to all supported versions of SQL Server in one place https://technet.microsoft.com/en-us/library/ff803383.aspx

Font and Icons too small when RDP from Windows 10 into Windows 7

topic: 

Since I upgraded my client computer to Windows 10 I would get small Icons and fonts when I have to restart host Windows 7 computer remotely and logging through RDP session. In that case it looks like 125% DPI set on host computer is ignored. If I log locally after restart/reboot first, remote session respects 125% DPI.

One problem, one weekend, eight languages

I have gotten quite complacent about using the same language for solving programming challenge problems such as those on HackerRank. I wanted to take a problem and write the solution in multiple languages to get a feel for them and see if there are any that I prefer to the one that I normally use (ignoring performance considerations for the time being).

How to retrive Outlook default signature

The Outlook signatures are stored in the %APPDATA%\Microsoft\Signatures\ folder in text, RTF and HTML formats. In case of multiple signatures, the default can be found through Word automation. Tested in Outlook 2003 and later.

How to completely uninstall VFP 9.0

topic: 

Uninstalling VFP 9.0 does not remove VFP settings stored in the registry or any files that have been added to installation after the fact. To completely uninstall VFP 9.0

  1. Launch VFP and note directories returned by HOME() and HOME(7) functions
  2. Uninstall VFP
  3. Delete directories from step 1
  4. delete registry key HKEY_CURRENT_USER\Software\Microsoft\VisualFoxPro\9.0

Retrieving VFP runtime DLL name required by EXE or DLL

VFP stores in an EXE/DLL information about what runtime DLL is required to run it.

This is sample code. Add error handling and adjust to your requirements as necessary.

1
2
3
? VfpVersionFromExeOrDll("C:\Program Files\My Company\MyVfpApplication.exe")
? VfpVersionFromExeOrDll("X:\Somefolder\MyVfpDll.dll")

Send email via MSN email account

MSN SMTP server requires SSL connection on port 25.

Sample code below uses CDO 2000 class for sending emails

Send email via Yahoo mail account

Yahoo SMTP server requires SSL connection on port 465.

Sample code below uses CDO 2000 class for sending emails

Remove Structural CDX or Memo flag from a table

The VFP low level file functions (LLFF) can be used to open a table as a file and read/write its header. The Table Header Record Structure is documented in VFP help under Table File Structure.

Deleting pages from PDF file through Acrobat automation

Detailed info on Acrobat automation can be found in Interapplication Communication API Reference from Acrobat 8.1 SDK or Acrobat 9.0 SDK at http://www.adobe.com/devnet/acrobat/?navID=downloads. Free registration may be required.

Pages