The last month (June 2017), I've met with two of my newly found (thru my Genealogy Research) second cousins (there should be about 7-10 my second cousins). But it was, online only, while we live now very close.
One of them, a writer, sent me some list of interrogatory kind of questions which I had a patience and energy to response.
My guess, that he was unhappy with some my responses.
With another second cousin (travelling with his orchestra violinist), I've exchanged family pictures.
During the last two months (May and June 2017), I've made extensive and intensive Genealogical Research of my Family Tree with Ancestry and Jewishgen (Litvaks database) with the the purpose to locate and establish contacts with my lost (100 years for one branch and 70 years for another) relatives in USA. The last week this Objective was accomplished.
For a while, I've abandoned this Blog getting into my Genealogical Project with Ancestry and Jewishgen. I will post more a little later ..
The last week (Friday), my short-term contract was concluded.
I completely redesigned SQL Server Database of the Client’s Inventory Replenishment (Vendor Managed Inventory - 3rd Party Logistics) Management and Reporting Tools with building normalized database design preventing suppliers’ duplicating, providing efficient suppliers selection tools by various criteria, developed SQL Stored Procedures, SSIS packages for importing data from various sources, compactly and eye-friendly redesigned User Interface with presenting most important data on one screen, automated repetitive users’ tasks with Access Macros and VBA.
The simplified Database redesign is presented below.
In the old database Suppliers were duplicated.
I am working with Microsoft Access 2013 and came to conclusion that Grey Background "MS-DOS style" (Colors "Text 2, Lighter 60%" or "Text 2, Lighter 80%") is much more eye-friendly (for example, for sales persons spending 8 hours daily) than a white or bright background. About Font Color: it's #17365D (dark-blue).
Would you agree with my choice or you know better (for users' eyes) combination?
I continue working on a contract position related to redesign of SQL Server and Access based Supply Replenishment Reporting Tools.
At this point (beginning from the last week of February), I am working on a new assignment related to redesigning a Big Client's Access Database.
1. SQL Server 2014 Developer Edition, fully functional but not for commercial use (producing demos is allowed);
2. Excel 2013 with PowerPivot, fully commercial;
3. Visual Studio 2013 Professional, also fully commercial.
In September-October 2015, I attempted to contact with Microsoft about getting fully commercial license for SQL Server 2014 and its total cast.
Their ballpark estimate was around $12,000 for 2-3 more servers with Windows Server 2012, Azure, SharePoint and some other stuff.
I was not able to get from Microsoft people anything in writing.
So, for now, I am producing various Demos to attract potential customers: small business owners who need various kinds of business reporting that allow timely detect transactional discrepancies, irregularities and unusual activities.