Google Drive – Google Sheets – Pasting Tables



We all take for granted how seamlessly Microsoft Products work together.

Take for instance, I use Microsoft SQL Server Management Studio to run a query and I will like to prepare a document from the query’s result.

I simply copy the Output Grid’s content, launch Microsoft Word or Excel, and pasted it.

Through the magic of OLE or whatever they call it these days, the data is well received and formatted in the receiving Office App.


Google Drive

These days my main sharing tool is WordPress for public consumption and Google Docs for private data.


Here is the genesis of our Problem

SQL Server Management Studio ( SSMS )


Here is output of a query I ran in SSSM



  1. Nice and visually appealing for an Engineer


Google Drive – Google Docs

Here is what things look like when pasted into Google Docs..



What to do

  1. Looked for Convert to Table
  2. Insert Text as table
  3. Import Text


Nothing helpful.


Solution – 01

Google Drive – Google Sheets

Created a new file, rather than Document went with Sheets




  1. Making progress
    • Kept the grid or columns paradigm
    • That is things are not jumbled well, with text intertwined together


Google Drive – Copy From Google Sheets Into Google Docs

Here we copied the cells from Google Sheets Into our original Google Docs




  1. Thankfully things are kept neatly arranged in a Columns
  2. Need to get rid of some extra columns and that is doable


Google Drive – Google Docs – Table – Delete Extra Columns

Got rid of the extra columns using the menu item Table / Delete Columns.


  1. Inside the Google Doc
  2. Select the extra columns
  3. And, use menu item Table / Delete Columns



Format the Table

One of the great things about these Google Products such as Chrome and Google Drive is that they are extensible and have such a nice and rich 3rd party ecosystem.


Adds On

Table Formatter

I already have Table Formatted installed and so let us initiate it by accessing Google Docs menu items “Add-ons” \ “Table Formatter”.


Google Docs – Menu – Add-Ons



Add-On – Table Formatter – Default Templates

Here are some of the Default Templates available


Customize Table with Add-On – Table Formatter

Select the Google Docs’s tale and choose the one of the Formatting Choices.

Here is our colored layout.




  1. Copy SSMS Grid Data into Clipboard
  2. Create a new Google Sheet ou use existing one
    • Paste copied into Sheet
  3. Create a new Google Doc
    • Select data from Google Sheet
    • Copy into Clipboard
    • And, paste into Google Doc
  4. In Google Docs
    • Using 3rd Party Add Ons such as Table Formatter format Table

Solution – 02


  1. Copy SSMS Grid output into Clipboard
  2. Use Microsoft Excel
    • Launch Microsoft Excel
    • Copy Grid’s data into Excel
    • If you like the way Excel Formats Table, use Excel’s Table Formatting functionality
      • Using F8, make Sheet’s column into actual table
        • Be sure you have Column Headers and all
  3. Create or use New Google Docs
    • Copy Table’s content from MS Excel
    • Paste into Google Doc


In MS SSMS, Copying with Headers




In MS Excel, Pasted SSMS Grid



In MS Excel, Create Table

Here is the panel displayed upon clicking on F8 and thus initiating the “Create Table” options



  1. Please pay attention to the “My table has headers” option


In MS Excel, Formatted Table


Chrome on Older OSes ( MS Windows 2003 )


One of the side-effects of auto-updated software such as Google’s Chrome is one no longer has access to the Install Binaries.

If you find yourself needing to download and install Google Chrome on an out of service OS, please take to the Internet and search out an offline installer.

Here are ones I have found for the last available version of Chrome for MS Windows 2003.

BTW, the version of MS Windows 2003 is 49.0.2623.112.


Download Links

Version = 49.0.2623.112


Web Site Write Up Targeted OS Media Link
 x32 Link
Software Mirrors Link Link




Application Files

The media listed here are not the actual installers, but the application files themselves.


The app files are bundled into a self ex-tractable exe.

Web Site Write Up
SlimJet  Link




Here is how SlimJet describes its delivery mechanism:

The old versions of Chrome are packed as 7zip self-extracting executable. Just run the executable and extract the files under any folder on your hard drive. Then launch Google chrome with chrome.exe under the extraction folder.

SlimJet has files for the following OSes:

  • Microsoft ( 32 bit and 64 bit)
  • Linux ( Ubuntu & Debian )
  • Mac OS

Older Versions

Web Site Write Up Versions Available
Old Versions Link Google Chrome Beta – 46.0.2490.80




YouTube – Upload – “Stuck at Processing 95%”


Trying to upload a video segment to YouTube, but the upload is stuck at 95%.


Error Message




Processing 95%


Download Video Segment


Went to and entered the YouTube’s video URL, entered the begin and end time.

Here is the screen progress

Enter Video Segment



Confirm Video Segment



Conversion Progress



Conversion Successful


Save As



Upload Video Segment

Use YouTube

Nothing fanciful here, just using YouTube’s own Video Upload Utility  to upload the download AVI file.

No Error Message…Yet stuck at 95%


Btw, the URL for Youtube’s Upload is



A good workaround is to return back to, enter the URL and Video’s start and end time.

But, use a different video download format.  In our case, we choose MP4 as Conversion Format.


Enter Video Specification



Confirm Specification








So works well to capture youtube videos.  But, one might have to try a different format.
We were trying AVI, but we needed to use MP4.

Google – Chrome – Left over installation files


Ever so often Google’s Chrome install fails and leaves behind huge install files.

Let us see how to identify and remove some of those files.



Depending on the bitness, 32 or 64 bit, the location we will be dealing with will vary.

  1. 32 bit
    • C:\Program Files\Google\Update\Install
  2. 64 bit
    • C:\Program Files (x86)\Google\Update\Install


MS Windows

Using Window Search, here are the files we identified



Space Sniffer



Files Details






Accumulated File Size


Function sizeFolder($path) # Return the size in MB.
    $objFSO = New-Object -com  Scripting.FileSystemObject
    ("{0:N2} MB" -f (($objFSO.GetFolder($path).Size) / 1MB))

$path = "C:\Program Files\Google\Update\Install"

sizeFolder $path



Remove Files

Dos Batch:

@Rem Remove Installer Files
dir "C:\Program Files\Google\Update\Install\*_Chrome_Installer.exe" /s
del "C:\Program Files\Google\Update\Install\*_Chrome_Installer.exe" /s

@Rem Remove Updater Files
dir "C:\Program Files\Google\Update\Install\*_Chrome_Updater.exe" /s
del "C:\Program Files\Google\Update\Install\*_Chrome_Updater.exe" /s

Revisit Folder Size




Special Mention

Though, the point is clearly missed here, but I really do like the SpaceSniffer software; as it is very good at locating storage hoggers when they are hidden in nested locations or just spread across various relatively smaller files.

The interface is nice and it really should not be freeware, but for the heart of Uderzo Umberto.

Maintaining Windows Installer SecureRepairWhitelist through Powershell


Here is a quick follow-up to a recent post, where we discussed options for getting rid of a pesky MS Windows Installer error “Product: Google Update Helper — Error 1260. Windows cannot open this program because it has been prevented by a
software restriction policy“.

Original Remediation

The redemptive process involved setting RemappedElevatedProxiesPolicy to 1.


Re-Install/Install Microsoft Hotfixes

Let us go ahead and install the “problematic” Microsoft hot-fixes that we studiously avoided last time.

  1. Security Update for Windows Server 2003 ( KB3072630 ) [ released on 2015-July -15 ]


Opt-Out Affected Programs


Another option is to opt-out selected applications.


Code Analysis

  1. Launch Registry
  2. Transverse to
  3. Add / Update new key named SecureRepairPolicy to 2
  4. Add the MSI’s product code for each application that you will like skip


Configuration File and Code

Configuration File

<?xml version="1.0"?>
<?xml-stylesheet type='text/xsl' href='style.xsl'?>
<!--Product Key List-->
 <!--Google Update Helper>
 <Product GUID="Google Update Helper">
  <Vendor>Google Inc.</Vendor> 
  <ProductName>Google Update Helper</ProductName>
  <CodeSegment info3="another attribute">
	<![CDATA[this is untouched code and can contain special characters /\@<>]]>

Powershell Script

The Powershell script has been been uploaded to


I have yet to sufficiently test out this code.

In fact, it has been only been minimally tested on two machines running MS Windows 2003.

We fixed our problem using the option described earlier.

In retrospect, the approach Microsoft offered as a workaround is likely a better option as it balances MSFT offering of a stronger system with the needs of individual Vendors and Applications.




  1. Added some bug fixes
  2. Last Google Chrome update gave us an actual opportunity to see bug recurrence and thus actually test code
  3. Removed code from posting and posted to GitHub

Google Update Helper – Error 1260 – Windows cannot open this program because it has been prevented by a software restriction policy


While chasing down another bug returned back to my Event Viewer and noticed many entries bearing failed “Google Updates“.

Error Message





  1. So basically every hour, specifically at the 55th minute, we are registering an error.


The description for Event ID ( 11260 ) in Source 
( MsiInstaller ) cannot be found. 

Product: Google Update Helper -- Error 1260. Windows cannot open this program because it has been prevented by a 
software restriction policy.





Google Search

Google Matches

Performed the per-functional Google Search, and here is what keep came up:

  1. “Windows cannot open this program because it has been prevented by a software restriction policy” error message when a user tries to open a file in Windows Server 2003

    • Advapi32.dll
      • 5.2.3790.199
      • File Date :- 17-Aug-2004


Download & Install

Downloaded and attempted install of the KB 873419.

Receive the message pasted below.


Setup has detected that the Service Pack version of this system is newer than the update you are applying.

There is no need to install this update.





Google Some More

After a while googled some more.  And, found more promising leads:

  1. ECI DDMS – Removing Windows Security Update KB2918614 & KB3072630
  2. IBM – Error 1260. Windows cannot open this program because it has been prevented by a software restriction policy.
  3. SolidWorks




So following the instructions carefully detailed in the posting by ECI DDMS, here is what we did:

  1. Accessed Windows Registry and enable RemappedElevatedProxiesPolicy
  2. Ensure that hotfix KB3072630 and corresponding hotfixes are no longer offered


Windows Registry Change

Accessed registry branch “HKLM\SOFTWARE\Policies\Microsoft\Windows\Installer” and added/set registry entry for RemappedElevatedProxiesPolicy to 1


Read Value

@REM Reg query
@REM HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Installer RemappedElevatedProxiesPolicy
set "keyName=HKLM\SOFTWARE\Policies\Microsoft\Windows\Installer"
set "valueName=RemappedElevatedProxiesPolicy"
reg query %keyName% /v %valueName%



Effect Change

@REM Reg add
@REM KeyName = HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Installer 
@REM Item = RemappedElevatedProxiesPolicy
set "keyName=HKLM\SOFTWARE\Policies\Microsoft\Windows\Installer"
set "valueName=RemappedElevatedProxiesPolicy"
set "valueType=REG_DWORD"
set "value=1"
reg add %keyName% /v %valueName% /t %valueType% /d %value%






GUI Original



GUI Revised



Say No to KB2918614

There are a couple of avenues that are available for availing KB2918614.  Inclusive are:

  1. Desktop Automatic Updates
  2. Microsoft Update Web Site
  3. Corporate

KB Hotfixes

There are corresponding updates that we need to say No to, as well.  Here is the current list:

KB Title Date
KB3072630 MS15-074: Vulnerability in Windows Installer service could allow elevation of privilege: July 14, 2015 2015-July-14
KB2918614 MS14-049: Description of the security update for Windows Installer Service: August 12, 2014 014-August-12



Desktop Automatic Updates

Access “Automatic Updates” via your Desktop status panel.


Automatic Updates

Choose updates to install

Here is the “Choose updates to install” window once we unchecked “Updates for Windows Server 2003 (KB2661254)”.


Hide Updates

Please check “Don’t notify me about these updates again”.




Please repeat same for hot-fixes listed in this post.



Microsoft’s acknowledges there are issues with the KB hotfix.

  1. After you install this security update and try to install any MSI package that uses a mandatory or temporary user profile, the MSI package installation fails, and you receive an error message that resembles the following:
    • The profile for the user is a temporary profile
    • MSI Log :- SECREPAIR: A general error running CryptAcquireContext / Crypt Provider not initialized. Error:-2146893813
  2. After you install this security update, you may receive a User Account Control (UAC) prompt when you try to use remote deployments, centralized deployments, or other local methods to reinstall a program that was already installed before the security update was installed.



Microsoft’s workaround includes using a tool such as ORCA to get the application’s product code.

Once the code is known one can register that product and others under the SecureRepairWhitelist key.

The operability of this approach is a bit reliant on vendors ensuring that their Application’s product code stays same through maintenance and patches.



MSFT continues to be under intense pressure to protect its surface area. Unfortunately, sometimes that will involve breaking working approaches and applications.

And, force vendors to return to Redmond and work towards new working API and understanding.

YouTube – Upload Audio Files – Using Microsoft Movie Maker (v2012)


It seems easy enough.  There are some audio files that I will like to upload to YouTube.

But, Youtube is kicking back that it does not accept Audio Files.


Error Message





The file you uploaded contains only audio and no video. Learn how to easily convert your audio track to a video file type.

The hyperlink directed us to:

Convert audio and image files into a format that will work on YouTube

Microsoft Movie Maker – v2012

Movie Maker is bundled as part of Microsoft Live Essential.

Depending on my OS, I will need a different version of Live Essential.

OS Matrix and Software Version

OS  Product Version Availability
 Windows 8.1, Windows 8, and Windows 7 Windows Movie Maker 2012 ( Windows Essential 2012 ) Available
 Windows Vista Windows Movie Maker 6.0 for Windows Vista (  Windows Essential 2011 ) Bundled in Vista
  Windows Vista  Windows Movie Maker 2.6 for Windows Vista Available
 Windows XP  Windows Movie Maker 2.1 Bundled as part of MS Windows XP SP2 and SP3



Download Location

Thankfully, On a blog post, Microsoft’s Aviraj Ajgekar provided a link for Windows Essential 2012.  The link is


Installed Application

Downloaded and installed Application.



Here are quick steps on how to create a video file out of an audio file.

  1. Avail Audio File
    • For us, we downloaded Ray Stedman’s Audio file on Prayer
  2. Select a background image
    • Choose Ray’s picture from Googling his name
  3. Launch Windows Movie Maker v2012
    • Choose to create a new project ( File / New Project )
    • From the menu access the “Add videos and photos” icon ( AddVidoesAndPhotos )
      • From the File menu, navigate to the folder where our photos were placed
    • From the menu access the “Add Music” icon ( AddMusic )
      • From the File menu, navigate to the Folder where our audio ( mp3 ) files were placed
    • Get duration of the Audio
      • Double click on the Audio
      • Context sensitive information on the selected media is shown at the top of the Application
      • Here is what ours look like ( when we selected the green audio strip )
      • Note the Start and End Point; in our case 0s and 1776 s
    • Set the duration of the Picture element to be same as the Audio
      • Double-click on the Picture Element
      • Again, the top panel reflects specificalities of the chosen element
      • Match the duration
      • Here is what our screen looks like, post matchpictureDurationSet
  4. The window changes to reflect the fact that we have extended the duration of the pictures
  5. Save the movie via the “File” \ “Save Movie” menu option
    Of course, we chose “YouTube”


A little out of place, but here are the pictures we took.

Picture Added


Audio  Added


The difference between this image and the one preceding it is the AudioAdded



We now have a good, well package mp4 file that YouTube will allow us to upload as a movie.


Here are Ray Stedman’s Audio artifacts that we are able to package as video (mp4) files.

Media Audio Video
Ray C. Stedman – The Cirmcumcised Life Audio Video
Ray C. Stedman  – How Prayer Works Audio Video
Ray C. Stedman –  The Furnace and the Lamp Audio Video