Friday, March 16, 2018

SQL Connection Validation

  1. SQL Server 2014
  2. SQL Server 2014 SP2
  3. Installed SQL Server 2014
    1. Arpit, Rick and Robert are SQL Server Admins
  4. Installed SQLServer 2014 SP2
  5. Configure CLMCRPOC2 SQL Server 2014 to accept incoming remote SQL connections
    1. IP address for CLMCRPOC2 =
  6. Open SQL Server Configuration Services
    1. Expand SQL Server Network Configuration
      1. Protocols for MSSQLSERVER and enable TCP/IP
  7. Create a blank file on your desktop name it SQLConnectionTest.udl
  8. Then open and test your connection.

Friday, February 16, 2018

The maximum length of an email address 254

The maximum length of an email address is 254 characters.
Every email address is composed of two parts. The local part that comes before the '@' sign, and the domain part that follows it. In "", the local part is "user", and the domain part is "".
The local part must not exceed 64 characters and the domain part cannot be longer than 255 characters.
The combined length of the local + @ + domain parts of an email address must not exceed 254 characters. As described in RFC3696 Errata ID 1690.

Thank you StackOverFlow

Thursday, February 01, 2018

SharePoint 2013 Development from local workstation

A great co-worker showed our team the following NUGET package that allows you to work directly from your work station instead of needing a full SharePoint 2013 Development Environment and I am sure it would work for SharePoint 2016.  See the image below.

Thanks to Joe.

Friday, December 22, 2017

Merry Christmas to All!

Friday before Christmas 2017, wanted to let all my readers know I wish them a very Merry Christmas and hope Santa brings them there wish list. You must Believe to Receive! Merry Christmas!

C# reminder of the day sealed

When the keyword "sealed" is applied to a class, the sealed modifier prevents other classes from inheriting from it. In the following example, class B inherits from class A, but no class can inherit from class B Code sample class A {} sealed class B : A {} Source - MSDN

SharePoint 2013 --- I'm Back

Wow, back at developing in SharePoint, who knew... Well my new co-working SharePoint Kerry, gave me some insight on SharePoint Application Permissions DUH! I an knocking the cobwebs out of my head using SharePoint Again. Central Admin > Application Management > Select the "App" > On the ribbon User Policy --- *DUH*! Adding or updating Web application policy with new users or groups will trigger a SharePoint Search crawl over all content covered by that policy. This can reduce search crawl freshness and increase crawl load. Consider using security groups at the policy level and add/remove users from security groups to avoid this.

Monday, July 10, 2017

SQL Server Configuration Manager error: Cannot connect to WMI provider Permission Denied

1. Open CMD as Administrator 2. Change Directory to cd C:\Program Files (x86)\Microsoft SQL Server\110\Shared --- ENTER 3. mofcomp sqlmgmproviderxpsp2up.mof Try to open SQL Server Configuration Manager --- CREDIT -

Wednesday, June 14, 2017

Perfmon how to resize counter frame at bottom of the window

Workaround: When Performance Monitor opens, one or more default counters are in the legend pane and only the first is visible. The legend pane is not resizable. Right click in the legend pane and select Remove All Counters. Re-add the desired counters and and the legend pane resizes to fit all/most as needed.

Father's Day this Sunday

Shop Amazon Devices: Echo Father's day deals starting at $39.99

Visual Studio 2017 Rocks

Just switched over to Visual Studio Professional 2017 and it rocks!!!