Investing in Blue Chip stocks

 I am opening the blog up to more topics.  As I get older it is time to think about retirement.  I received Kiplinger's new letter and this weeks issue has a great article - https://www.kiplinger.com/investing/stocks/blue-chip-stocks/605147/hedge-funds-top-blue-chip-stocks-to-buy-now?utm_term=48CF6E7A-0818-469C-8C1B-542EE879AF82&utm_content=4EDA771E-A95E-4A58-B7B9-916641B388CA

BASH - VIM - Commit message on Windows 11

 To write a git commit, start by typing git commit on your Terminal or Command Prompt which brings up a Vim interface for entering the commit message.

1. Type the subject of your commit on the first line. ...
2. Write a detailed description of what happened in the committed change. ...
3. Press Esc and then type :wq to save and exit.

Blog Comeback

Been a long time since blogging mostly because security in business does not allow access to blogger, which is a good thing.  Over my 20+ years of software development I have seen security to get it right.  This prevents proprietary code details from being posted.  

However, now I am coming back to write up my new adventure with Java, Spring Boot, React and various databases such as mongo or mysql.  Also, on new tool sets such as JetBrains IntelliJ and Visual Studio Code.  

--

Robert Dannelly, Jr. 

Senior Software Engineer

robertdannelly@gmail.com

http://moojjoo.blogspot.com

Twitter: @moojjoo

Skype: robert.dannelly

 

Google AdSense help to increase revenue

 Dear Visitor's, please click on an ad or two to help with creating residual income from Google.  I would even be grateful to know if the Ads are tailored to your searches to ensure the Google Adsense are showing Ads related to your personal preference.  Please add comments below.

Happy New Year 2023

 Happy New Year 2023.  Hope everyone has a wonderful year.

Happy New Year!

 Happy New Year to all this year will be filled with React, Java, and Unit Testing.  And first and foremost God, Family and Friends.

React, Java, Tomcat oh MY!

 Well, it has been a long time since I have posted. Because this year I have been tasked with developing React and Java.  This is a complete flip from the .NET Microsoft platform.  It is an adventure and great to take on new technologies.  Over my years of development, I have learned, "That to survive in this business you have to learn, unlearn and relearn", Doug Cain.  What is crazy is that the king of all the languages is that JavaScript.  Over my 20+ years of development it has always been the top language and they have always kept their promise to "Never break the web".  Also, another reason I have not posted any posts is that my current employer has blogger BLOCKED for security purposes.

Pagination in SQL Server (Thank you https://www.sqlshack.com/pagination-in-sql-server/)

Select TOP(100) LastName, FirstName FROM Person.Person ORDER BY LastName

DECLARE @PageNumber AS INT
DECLARE @RowsOfPage AS INT
DECLARE @SortingCol AS VARCHAR(100) ='FirstName'
DECLARE @SortType AS VARCHAR(100) = 'ASC'
SET @PageNumber=1
SET @RowsOfPage=50
SELECT LastName, FirstName FROM Person.Person
ORDER BY
CASE WHEN @SortingCol = 'Lastname' AND @SortType ='ASC' THEN LastName END ,
CASE WHEN @SortingCol = 'LastName' AND @SortType ='DESC' THEN LastName END DESC,
CASE WHEN @SortingCol = 'FirstName' AND @SortType ='ASC' THEN FirstName END ,
CASE WHEN @SortingCol = 'FirstName' AND @SortType ='DESC' THEN FirstName END DESC
OFFSET (@PageNumber-1)*@RowsOfPage ROWS
FETCH NEXT @RowsOfPage ROWS ONLY

SET @PageNumber=2
SET @RowsOfPage=50
SET @SortingCol ='LastName'
SET @SortType = 'ASC'
SELECT LastName, FirstName FROM Person.Person
ORDER BY
CASE WHEN @SortingCol = 'Lastname' AND @SortType ='ASC' THEN LastName END ,
CASE WHEN @SortingCol = 'LastName' AND @SortType ='DESC' THEN LastName END DESC,
CASE WHEN @SortingCol = 'FirstName' AND @SortType ='ASC' THEN FirstName END ,
CASE WHEN @SortingCol = 'FirstName' AND @SortType ='DESC' THEN FirstName END DESC
OFFSET (@PageNumber-1)*@RowsOfPage ROWS
FETCH NEXT @RowsOfPage ROWS ONLY

Get Rid of Ants and other Insects and Win the War!!!

Ants (AGGGGGHHHH!!!) sugar ants,  carpenter ants, or fire ants.  At least I can identify fire ants because they are red or are they? Who knows what kind of ants.  Who cares, you just don't want them or other insects in your home.  PERIOD! 

As other homeowners know you have two choices hire an exterminator $$$$$ or do it yourself.  Well, I am here to tell you what is working for our home.

Disclaimer - Safety first, use a respirator, rubber gloves, and rubber boots.

1. Mix as instructed I did two full and an extra 1/2 squeezes to one gallon of water in a pump sprayer, fill slowly with water to get a good mix (stronger is better.  Then spray your entire home around doors, windows, foundation one foot up and two to three feet out -  

Bayer - 4031982 - Suspend SC -Insecticide - 16oz

https://amzn.to/3bYaDNG

2. Sprinkle every 4 feet around the entire perimeter of your home.

Niban Granular Insect Bait 

https://amzn.to/2YplKeA

3. Inside the house issue purchase 

Southern Homewares Pesticide Diatomaceous Earth Hand Bellows Powder Duster - Garden Powder Bulb Applicator - Great Against Bedbugs & Insects

https://amzn.to/3aXCJYb

4. Sprayer I purchased and use a sharping and mark it for safety:

Chapin 20000 1 Gallon Lawn, Sprayer

https://amzn.to/35pKnJv

REPEAT EVERY 2 MONTHS TO ENSURE MAINTAINED DEFENSE.

Debug VS Code HTML5, CSS3 and JavaScript using npm http-server

Prerequisites tools needed:

1. Windows 10
2. VS Code - https://code.visualstudio.com/
3. Node and NPM - https://www.npmjs.com/get-npm

Setup git Code repository:

1. Setup folder for your project as for my preference I use
   C:\Users\moojjoo\Source\Repos\[SolutionFolder]
2. I am a big advocate of git source control - https://git-scm.com/ and the great part is that it is packaged with VS Code so once you have your files setup be sure to
1. git add .
2. git commit -m 'Initial Commit'

// Using Terminal BASH run

npm install http-server -g
http-server ./

As a result you will get the url to run and debug your JavaScript 


// Once successfully running the code you can then create .vscode/lauch.json and 

// update the highlight code.  The great part with running npm http-server ./  

// All changes are updated and reflected in the browser

{
    // Use IntelliSense to learn about possible attributes.
    // Hover to view descriptions of existing attributes.
    // For more information, 

    // visit: https://go.microsoft.com/fwlink/?linkid=830387
    "version": "0.2.0",
    "configurations": [
        {
            "type": "chrome",
            "request": "launch",
            "name": "Launch Chrome against localhost",
            "url": "http://127.0.0.1:8080",
            "webRoot": "${workspaceFolder}"
        }
    ]
}

Git exclude local developer files in exclude file

The current git workflow my development team uses and most other teams are following is to use the master branch as the default and BUILD and DEPLOY aka CI/CD branch. However, only the TEAM LEAD has the authorization rights to PULL into master. So developers create all branches from master and perform the git add [filename] or . and git commit -m 'User Story XYZ', then git push to remote and create a PULL REQUEST.

However, in this situation we have to ensure all developers have their own local configuration files and ensure they are not deployed. Better yet what happens if they were originally added and commited to the master branch? Hopefully this guide will help you.

The files in question are the .config files, which should not be ignored, but need to change per developer workstation.

---

WARNING --- YOU WILL HAVE ISSUES GOING BACK AND FORTH TO PREVIOUS BRANCHES THAT YOU CREATED BEFORE YOU PERFORM THESE STEPS

---

The key is to ensure you are on your master branch and run the following git commands.

 git checkout master

 git pull

 git status

You want to ensure you have a clean working tree...

2 Steps - If the files you want to ignore have never been added to the GIT local repository

1. Add to the exclude file. If using windows open windows explorer and be sure to unhide hidden files and navigate to your repo location in windows we use:
   C:\Users\USERNAME\source\repos\SolutionName\.git\info\exclude

(Note: The exclude file needs to be open with a text editor of your choice Notepad or Notepad++)

The run

 git add 

2. Add the files you need to ignore only as you do the .ignore file, but this is used for your personal developer workstation. Give the full path to the file.
   C:/Users/USERNAME/Source/Repos/SolutionName/{filename}

IF YOU ALREADY HAVE FILES THAT HAVE BEEN ADDED AND COMMITTED AS SHOWN BELOW FOLLOW THESE STEPS

ADD THE FILES To ---

 C:\Users\USERNAME\Source\repos\SolutionName\.git\info\exclude 

Following the same format as above: (Note exclude is a file you need to open with NotePad or NotePad++)

 C:/Users/USERNAME/Source/Repos/SolutionName/{filename}



git add  
git committed -m 'Committing my files to GIT index'

HOWEVER, GO BACK TO GIT AND RUN THE FOLLOWING IF THE FILES HAVE BEEN ADDED AND COMMITED BEFORE

git update-index --skip-worktree 

Reapeat as needed for the files you want to ignore.

Start branching and all should be good in the world. I will come back and provide an update based on this discovery work.

Happy GIT'ing........................

To validate you can run the following Git Command

 git ls-files -i --exclude-from=C:/Users/USERNAME/source/repos/SolutionName

Forgot your Wifi Password - Thank you Reddit

If you ever forget your WiFi password or you want to get your school WiFi password etc. Just type this command into the command line of a computer already connected to that WiFi: netsh wlan show profile WiFi-name key=clear

Automated test gives us greater confidence that the software is working as it should!

Tools needed for Visual Studio for proper testing with NUnit

1. NUnit3TestFramework (Core or .NET Framework)
2. NUnit3TestAdapter (Core or .NET Framework)
3. Microsoft.NET.Tests.SDK

MEAN - MongoDB, Express, Angular, NodeJS

MEAN Development

M - MongoDB - https://www.mongodb.com/
E -  Express - https://expressjs.com/
A - Angular - https://angular.io/
N - NodeJS - https://nodejs.org/en/

IDE of Choice - https://code.visualstudio.com/

Extensions of Choice for VS Code

- Angular Essentials
- Material Icon Theme

Open VSCODE

Ctrl + Shift + `  Opens Terminal Window

Be sure you have installed NodeJS and Angular

Command for Angular is npm install -g @angular/cli

Use the Terminal to Navigate to cd c:/Users/UserName/Source/Repos

Run

https://angular.io/cli/new  ng-new app-name


... More to come

Angular = Components and Components = Uncoupled and resuability

Always work from the ./src/app

Create new folders following the naming structure

+-app
 - app.component.css
 - app.component.html
 - app.component.ts
 - app.component.spec.ts
 - app.module.ts

For new components create new subfolders in the app folder

+-app
 |
 |
 +-my-dog
 - app.my-dog.component.css
 - app.my-dog.component.html
 - app.my-dog.component.ts
 - app.my-dog.component.spec.ts

Update the app.module.ts 

import { BrowserModule } from '@angular/platform-browser';

import { NgModule } from '@angular/core';

import { AppComponent } from './app.component';

import { PostCreateComponent } from './posts/post-create/my-dog.component';

@NgModule({

declarations: [

AppComponent,

MyDog

],

imports: [

BrowserModule

],

providers: [],

bootstrap: [AppComponent]

})

export class AppModule { }

Step by Step gmail filter

How to setup Filters in gmail the easy way.

1. I will use "Vail Resorts Talent"

2. Copy the email for this demo:

3: search what every in my example I am using in:inbox  from:recruiting@vailresorts.com

4. Click Create filter

5. It will show the emails and then like magic they are archived to their folders.

That is how I do it.  

Azure In a Month of Lunches - New Book I am reading

https://azure.microsoft.com/en-us/resources/learn-azure-in-a-month-of-lunches/

How to clear SharePoint People Picker suggestion cache

If you have been SharePoint Site owner long enough, you would have definitely bumped into task like assigning document permission using SharePoint People Picker.
One of the out of the box SharePoint People Picker features is that it auto caches all previous user entry entered/selected by you.

This cached people picker entity is meant to help you to quickly find the user and assign the permission.
It would introduce invalid entry if there is cease of identity provider (for whatsoever reason that the decision made from the IT management needs us to swing the SharePoint identity provider to other platform).

Things could get messier for those who frequently accessing people picker, to be seeing the old cached user.

Another situation that introduce inconsistency is when there is change of user name/job title etc for which is cached and not reflecting the correct info to the end user.

SharePoint People Picker uses LocalStorage to cache the people picker entity. In order to flush the cache, you would need to run a JavaScript to clear the cache. What’s worst is that there is no expiration set.
If you fire up your browser development tool and type in “localStorage” (case sensitive) in the console. You would see the cache key/value for ClientPeoplePickerMRU.

hit F12: For Chrome, IE and Firefox (Note:You must be firing up the developer tool at the SharePoint Page)

Chrome – Resource tab

So what can we do?

If you are developer and techie, you can easily fire up the developer console of your browser and run the below JavaScript

1	localStorage.clear();

If you are helping your end user to flush the cache, one possible way is to provide them a quick custom web part using javascript above to flush their cache. Alternatively, creating a custom JS with leveraging Cookie as expiration check, put it into your home page. Whenever user accessing to your home page, this JS will check from Cookies to see if it is time to Refresh (or clear) the local storage.
The other possible way is to get them clear the Local Storage from their Browser. I couldn’t find where the IE local storage is. If you know, I will be more than happy if you can tell me.

For IE Users who wish to clear the people picker. Here are the steps you may follow
1. Go to page with people picker
2. F12 Developer Tools
a. Console
b. localStorage.clear();
3. Close F12
4. Then refresh the web page to test it.

[Credit goes to Chris for the steps above]

This entry was posted in SharePoint 2013 and tagged cache, JavaScript, people picker on July 14, 2015.

GitHub --set-upstream

git push --set-upstream https://github.com/moojjoo/PlunkerNGClick.git master

git pull

git commit -m 'Another commit'

git push

Nice AdSearch by LanID to populate a form

$('#Domain_ID').focusout(function () {
    $.ajax({
        type: 'GET',
        url: 'https://localhost:44364/api/v1/AdSearch?userId=rdanne1',
        dataType: 'json',
        error: function (xhr) {
            alert("An error occured: " + xhr.status + " " + xhr.statusCode);
        },
        success: function (data) {
            if (data) {
                $('#Domain_ID').val(data.lanId);
                $("#Name").val(data.name);
                $("#Email").val(data.email);
            }
        }
    });
});

SQL RAISEERROR and Log the error

Put all SQL Stored Procedures in BEGIN TRY > BEGIN TRANSACTION > IF  ELSE blocks and use the following as a TEMPLATE

Create an output parameter so the source code can log the error and you can check the DB table for the error.


@ELog_ID int = 0 OUTPUT 

SET XACT_ABORT, NOCOUNT ON;

BEGIN TRY
BEGIN TRANSACTION


IF
            IF EXISTS (SELECT 'x' FROM People_tbl WHERE Email_Address = @Email_Address)
RAISERROR (N'Person is already in the database.',11,11, 'usr_Person_Add')
--PRINT 'Person is already in the database!'

ELSE

-- CRUD work

END TRY

BEGIN CATCH

--PRINT 'In the Catch Statement'
IF @@trancount > 0 ROLLBACK TRANSACTION
PRINT 'Process has reached the CATCH'

EXECUTE dbo.[usr_InsertErrorInfo];

SELECT @ELog_ID = max(ELog_ID)
FROM ErrorLog_tbl;


END CATCH