Creating Connectivity Between R Studio & SQL Server 17

January 1, 2019

Intro:

For Data Science, SQL Server 17 has optional built in R functionality. It also has the ability to call R Studio from within SQL Server. The prerequisite is reliable connectivity between SQL Server and R Studio.

Here are the steps to configure SQL Server and R to work with each other.

——————————————————-

Initial Technology Stack To Install:

Read the rest of this entry »

Advertisements

Identifying the Correct Name Of Your SQL Server

January 1, 2019

Intro:

One of the key concepts in relational databases is that of the unique identifier. You would hope that this would apply to technical terms also.

But I’ve recently discovered that, after a simple installation of SQL Server 17, on my Windows 10 laptop, I now have three different names for my host machine. And two different names for my SQL Server.

These have caused me a lot of grief and wasted time.

Here are some methods to identify the different names, and help you troubleshoot the associated issues.

Installation History: Read the rest of this entry »


Successfully Installing and Running Movica on Windows 7

November 11, 2018

Movica is a nice little program for video editing on Windows. It allows you to edit MPEG, FLV, and Windows Media (.wmv) video files.

I’ve mainly used it to work on large Mpeg files. Cut out portions. Split the file up. Join two or more Mpeg files together. Users on Videohelp.com rate it 9.7/10.

But Movica was originally designed to work on Windows XP 32 bit, with the .NET framework. The last software update was in 2013.

Recently, I tried to use it on Windows 7. While it installed easily enough, when I tried to use it, I kept getting the Windows error message box, with the option to close the program. Sigh.

Here’s how I installed Movica on Windows 7 and got it to work.

Read the rest of this entry »


Uniface Quick Reference Guides – PDF

October 17, 2018

Recently I found some old Uniface Quick Reference Guides that I once used. Uniface Version 5.2, and 6.1.

UnifaceQuickReferenceGuideV5_2

They were always very useful.

So, I’ve scanned them into PDF files and uploaded them here, for anyone that might find them useful.

Uniface Quick Reference Guide V5.2

Uniface_v5_2_Quick_Reference

Uniface Quick Reference Guide V6.1

Uniface_v6_1_Quick_Reference

Enjoy!

If you’d like the actual books, please contact me.


Online Characters: Trolls, Speculators, Snobs, Team Players

September 23, 2018

Forums: Trolls, Speculators, Snobs, Team Players

Sometimes, when I’m working on software issues, I’ll post a question on a forum. This I usually do only after a few hours of struggle. If you read my blog, you’ll find many tech struggles that I’ve had.

Occasionally, I’ll have to register with a website first, and then wait for approval. Login again. Document my long struggle concisely. Then ask the question on a complex subject that I’m only just becoming familiar with, to elicit a good answer.

And so often, I’ll have an awful experience with the online characters. I’ve categorized them in a quadrant, with the two axis: Helpful vs Knowledgeable/Competent

 

Forums_Trolls_Etc

 

—–

Trolls:

Too many times, I’ll get the trolls. They are NOT helpful, nor are they knowledgeable or competent.    Read the rest of this entry »


Macro Photography – Classic Prime SLR lenses vs Cell Phone with a Loupe

January 28, 2018

The capabilities of cell phone cameras are amazing, performing better than my classic SLR lenses. Here is how I used a simple analog loupe with my cell phone to do some great macro photography.

 

Recently I went to change the keyboard of one of my Acer laptops. As I disassembled it, the tiny mainboard connector part came off . It clamps the keyboard ribbon to the laptop’s mainboard.

It just wasn’t going back on. Part of the issue was that I was not sure which way it went back together. This side down, or the other side?

So I got out my photographer’s 35mm loupe to take a look. I could see a lot of very tiny teeth that had to be matched up. Read the rest of this entry »


Trying and Cracking Steganography

January 4, 2018

Once I read about how some spies were saving messages in pictures. Cool. So I thought I’d try it just for fun.

Steganography

It was a lot different from invisible ink we played with as kids. 🙂

First I looked at an article on StackOverflow

Read the rest of this entry »


%d bloggers like this: