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 = 10.220.126.188
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.

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 "user@example.com", the local part is "user", and the domain part is "example.com".

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.

I got the original part of this information from here

Thank you StackOverFlow

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.

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.

AWS - Impressed

Setup a .NET Core Server in < 5 minutes - http://mmwebs-dev.us-east-1.elasticbeanstalk.com/

Try Amazon Music Unlimited 30-Day Free Trial

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 - https://www.youtube.com/watch?v=SuCUSH0RAVo

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!!!

JavaScript Refresh Time

There are 7 basic types in JavaScript. number for numbers of any kind: integer or floating-point. string for strings. A string may have one more more characters, there’s no separate single-character type. boolean for true/false. null for unknown values – a standalone type that has a single value null. undefined for unassigned values – a standalone type that has a single value undefined. object for more complex data structures. symbol for unique identifiers. The typeof operator allows to see which type is stored in the variable. Two forms: typeof x or typeof(x). Returns a string with the name of the type, like "string". For null returns "object" – that’s the error in the language, it’s not an object in fact. In the next chapters we’ll concentrate on primitive values and once we’re familiar with that, then we’ll move on to objects. New great online tool - http://plnkr.co/ Also Must READ!!!!

How to catch an error and send via email and log to the server (aka simple text file not event log). (VB.NET)

Catch ex As Exception
            'Log to exception table
            Dim strError As String
            strError = Now().ToString() & "Error: (Class=PromoCode;Method=IsEmailRequired)" &
                       ";" & vbCrLf & "PromoId = " & promoCodeId &
                       ";" & vbCrLf & vbCrLf & "Exception " & ex.ToString()

            MiscFunctions.SendExceptionEmail(strError)
            MiscFunctions.WriteLogRecord(strError)

            myPromoCode = Nothing
            Return myPromoCode
        End Try



 '---------------------------------------------------------------------------
    'Description: Email Exception Error
    '---------------------------------------------------------------------------
    Public Shared Sub SendExceptionEmail(ByVal errorException As String)

        Dim myMail As New MailMessage()

        myMail.From = New MailAddress("error@domain.com")
        myMail.Subject = ConfigurationManager.AppSettings("CoreHTTPPath") & " error exception"

        'Create an email from the email addresses in the app.config file
        Dim emailTo As String = System.Configuration.ConfigurationManager.AppSettings("AdminEmails").ToString()
        Dim strEmailArray() As String

        strEmailArray = Split(emailTo, ";")

        For Each email As String In strEmailArray
            myMail.[To].Add(email)
        Next


        Dim sb As New StringBuilder()
        sb.Append("www.domain.com error exception: " & vbCrLf & vbCrLf)

        sb.Append(errorException)


        Dim strBody As String = sb.ToString()
        myMail.Body = strBody

        myMail.IsBodyHtml = False

        Dim smtp As New SmtpClient()


        Try
            smtp.Send(myMail)
            myMail = Nothing
        Catch ex As System.Exception
            WriteLogRecord(Now().ToString() & " Error: (Function Sending errorException) " & ex.ToString)
        End Try

    End Sub

    Public Shared Sub WriteLogRecord(ByVal strErroMsg As String)

        Dim objWrite As IO.StreamWriter
        Dim strDateTime As String = Now().ToString()
        strDateTime = Replace(strDateTime, "/", "-")
        strDateTime = Replace(strDateTime, ":", "")
        objWrite = IO.File.AppendText(System.Configuration.ConfigurationManager.AppSettings("EmailErrorLogs") & "/EmailErrorLog.log")
        objWrite.WriteLine(strErroMsg)
        objWrite.Close()

    End Sub

Count Columns in Table in SQL Server

SELECT COUNT(COLUMN_NAME)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = 'DbName' AND TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = 'TableName'  

IIS App Pool Recycle Logs

If you need to view information about application pool recycle set a custom view in Windows Event Viewer.

1. Start Search Event Viewer

2. Select Custom Views > Actions: Create Custom View

3. Logged what ever time you need

4. Select all event levels

5. By Source (WAS) Very Important


Click OK.

SQL Tips

http://sqlhints.com/2012/05/03/how-to-set-default-database-in-sql-server-mangement-studio-a-time-saving-tip/

Great new site I found above.

Captain SQL Jason also taught this old dawg some new tricks.  He told me I am not allowed to share them.   They help us Veterans in the field keep our jobs.  :)

Regular Expressions

To match a string that contains only those characters (or an empty string), try

"^[a-zA-Z0-9_]*$"

This works for .NET regular expressions, and probably a lot of other languages as well.

Breaking it down:

^ : start of string
[ : beginning of character group
a-z : any lowercase letter
A-Z : any uppercase letter
0-9 : any digit
_ : underscore
] : end of character group
* : zero or more of the given characters
$ : end of string

If you don't want to allow empty strings, use + instead of *.

EDIT As others have pointed out, some regex languages have a shorthand form for [a-zA-Z0-9_]. In the .NET regex language, you can turn on ECMAScript behavior and use \w as a shorthand (yielding ^\w*$ or ^\w+$). Note that in other languages, and by default in .NET, \w is somewhat broader, and will match other sorts of unicode characters as well (thanks to Jan for pointing this out). So if you're really intending to match only those characters, using the explicit (longer) form is probably best.

http://www.analyticsmarket.com/freetools/regex-tester 

Page size calculation formula

Commit charge:

1. Run Performance Monitor (Perfmon)

2. Go to Data Collector Sets\User Defined

3. Right click on User Defined and select New

4. Select Create Manually and next

4. Check Performance counter

5. Add the following counters:

            Memory\Committed Bytes – Committed Bytes is the amount of committed virtual memory, in bytes.

            Memory\Committed Limit – Amount of virtual memory that can be committed without having to extend the paging file

            Memory\% Committed Bytes In Use – Ratio of Memory\Committed Bytes to the Memory\Commit Limit

Make sure you collect the information over a long period (one week at least), and the server is running at peak usage.

The page file size formula should be:

(Max value of Committed Bytes + additional 20% buffer to accommodate any workload bursts)-RAM size

For example: If the server has 24 GB RAM and the maximum of Committed Bytes is 26 GB, then the recommended page file will be: (26*1.2)-24)  = 7.2 GB

DBA Secret KeyStroke by Jason "CPT SQL" Miller

ALT+F1 with Object Highlighted in SSMS all you ever wanted to know (aka Table Definition) and if your other developers never teach you this, you should beat them with a stick.  I am HAPPY, today is a good day.

Rest hiberfil.sys by Alex --- Awesome article. Source - http://thetechcookbook.com/reset-hiberfil-sys-file/

Reset hiberfil.sys file

• by Alex
 
• September 5, 2014
 
• Windows 7
 
• Comments: 1

If the Hiberfil.sys file located on your local hard is growing quite large it might be time to reset the Hiberfile.sys file to default. This is also handy if you find your machine is not functioning correctly after a Hibernate then it indicates that there may be a corruption inside the Hiberfile.sys file. 

Step One::

Click on Start -> Inside the search field type on CMD -> Right click on cmd.exe and choose Run as Administrator. 

Step Two::

Enter in the following command powercfg -h off -> Press Enter

Restart the computer

Step Three::

Once the machine is turned back on open Command Prompt as admin again and enter in powercfg -h on

Microsoft Azure - www.mmwebs.biz

On the 4th I have moved www.mmwebs.com to use Microsft Azure, still some configuration to go, but thus far everything is running.  Custom domain transfered.  Now I have to get the DBs running.

.NET Authorization note to self

Authorize only 1 person(s) and deny all others and anonymous.



<authorization>    
           <allow users="you@email.com" />
            <deny users="*" />
            <deny users="?"/>
          </authorization>

Moojjoo - nuget.org Package CyberSource Akamai

https://www.nuget.org/packages/UnofficialCyberSourceByMoojjoo/

First NuGet Package Published

Feeling pretty good about my career with my first NuGet Package.  I hope this helps out other .NET Developers with CyberSource Transition on June 30, 2016 - https://www.nuget.org/packages/UnofficialCyberSourceByMoojjoo/

Update Incrementer with T-SQL instead of using a cursor

SQL TIP: Auto Increment in an UPDATE statement. - Credit - http://haacked.com/archive/2004/02/28/sql-auto-increment.aspx/ 

DECLARE @counter int SET @counter = 0 UPDATE #tmp_Users SET @counter = counter = @counter + 1

Thank you XML and NotePad++

Use the XML Tools plugin for Notepad++ and then you can Auto-Indent the code with Ctrl + Alt + Shift + B .For the more point-and-click inclined, you could also go to Plugins --> XML Tools --> Pretty Print. Search "XML TOOLS" from the "Available" option then click in install.Jan 28, 2015

How to indent HTML tags in Notepad++ - Stack Overflow

stackoverflow.com/questions/.../how-to-indent-html-tags-in-notepad

Windows 7 - Change Login Screen

Reference and Credit - http://www.tomshardware.com/forum/52395-63-change-windows-splash-screen-lock-screen

click start type regedit and hit enter
right click on HKEY_LOCAL_MACHINE and select find 
type OEMBackground and hit enter
(the path should be Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Authentication\LogonUI\Background )
(if it is not there you need to create it*right click on background and select new DWORD name it OEMBackground set it from 0 to 1)
double left click on OEMBackground and change the value from 0 to 1
click start and type %windir%\system32\oobe
in the oobe folder create a folder named info
in that folder create a folder named backgrounds

now rename your picture that you want displayed durning logon/lock screen backgroundDefault.jpg

everything is case sensitive so if you have to copy and paste the names. the picture needs to be under 244kb.

trick to get a picture under the 244kb
right click on the picture and select open with > select paint
press ctrl+w
this will bring up a box under horizontal and vertical select the amount you want to reduce the picture in %

=)

Fancybox Modal Window onFocus or $('#ID').onFocus();

How to give focus to a modal window?

Be patient.  Add a timer.  That did it for me.

This was a 2 day R&D problem. After adding the timeout BAM --- Focus achieved.  This really was a tricking thing to figure out, but think about it if the HTML DOM ELEMENT is not there it cannot set focus.

$(document).ready(function setFocus() {
         setTimeout(function () {
             $('#txtEmailAddress').focus();
         }, 420); // After 420 ms
         return false;
     });

BootStrap, JQuery, and JavaScript Validation Oh My... Nice Solution.

You need jQuery library and bootstrap to perform the following code.


Nice Page Header ON TOP

<div id="message">
    <div>
        <div class="alert alert-danger alert-dismissable">
            <button type="button" class="close" data-dismiss="alert" 
aria-hidden="true">×</button>
             <span id="alertMsgTxt" style="font-size:1.5em;font-weight:bold" ></span>
        </div>     
    </div>
</div>

Next is the server control or button either one.

<asp:TextBox ID="txtEmailSignup" TextMode="email"  
runat="server" CssClass="form-control" 
title="Email Sign Up SHOE SHOW Sales and News" placeholder="Enter your email address" />

Finally the nice jQuery

<script>
        $(document).ready(function () {
            $(document).on('click', '#lnkEmailSubmit', function () {
                var emailaddress = '';
                emailaddress = $('#txtEmailSignup').val();
                if(!validateEmail(emailaddress) || emailaddress === ''){
                    $('.alert').show();
                    window.scrollTo(0, 0);
                    $('#alertMsgTxt').html('Invalid Email, please 

click here
 to try again.');  
                }
            })
        });
 
        function setFocus() {
            $('.alert').hide();
            document.getElementById("txtEmailSignup").focus();            
        }
 
        function validateEmail($email) {
            var emailReg = /^([\w-\.]+@([\w-]+\.)+[\w-]{2,4})?$/;
            return emailReg.test( $email );
        }
    </script>

CodeMonkey

ASP.NET Web Forms set default button on page load

In the Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Main_Form.DefaultButton = "lnkLookUpGuestOrders"
 
    End Sub

How to CACHE using .NET

Add <?xml .... >  script below to the directory you want to CACHE for 365 days - if it is static than why have the client retrieve it, over and over again --- BAD HIT ON SPEED OF SITE.  Note for CSS and Scripts it is best practice to have a version number on the file and update the reference.

Example

<link rel="stylesheet" type="text/css" href="/framework/css/global.min.css?v=2.0" media="screen, print" />

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <system.webServer>      
        <staticContent>
            <clientCache cacheControlMode="UseMaxAge" cacheControlMaxAge="365.00:00:00" />
        </staticContent>
    </system.webServer>
</configuration>


Always add ?v=x.x and increment when you make changes to the css or js files.  If not end-users will get older versions of your CSS or JS and will cause a nightmare and lose potential customers or clients.

Check your SQL STATISTICS TIME

SET STATISTICS TIME ON

RUN T-SQL

SET STATISTICS TIME OFF

Windows Run --- msinfo32.exe

Find out all you need to know about your system with msinfo32.exe

Check LIVE TEMP Tables

SELECT TABLE_NAME FROM tempdb.information_schema.tables

SQL Server Queries are spilling out to tempdb

-- How to rid yourself of tempDB spilage if SORT causing issues Create a Temp Table with a CLUSTERED INDEX

IF OBJECT_ID('tempdb..#tempSizes') IS NOT NULL DROP TABLE #tempTable

SELECT DISTINCT
IDENTITY(INT,1,1) AS ID,
Products.Name,
Product_Families.Parent_Family_Name,

INTO #tempTable
FROM Products
LEFT JOIN Product_Families ON Products.Product_Family_ID = Product_Families.Product_Family_ID
WHERE Products.Discontinued = 0
AND Quantity > 0

CREATE CLUSTERED INDEX IX_ID ON #tempSizes(ID)

SELECT * FROM #tempTable

Definition of Done in Computer Programming

Thank you Plural Sight.

Quiz Question of the day - HOW TO GEEK

Is 0445567892 a INTEGER?

IIS ApplicationPoolIdentity - Credit - http://stackoverflow.com/users/419/kev

The ApplicationPoolIdentity is assigned membership of the Users group as well as the IIS_IUSRS group. On first glance this may look somewhat worrying, however the Users group has somewhat limited NTFS rights.

For example, if you try and create a folder in the C:\Windows folder then you'll find that you can't. The ApplicationPoolIdentity still needs to be able to read files from the windows system folders (otherwise how else would the worker process be able to dynamically load essential DLL's).

With regard to your observations about being able to write to your c:\dump folder. If you take a look at the permissions in the Advanced Security Settings, you'll see the following:

See that Special permission being inherited from c:\:

That's the reason your site's ApplicationPoolIdentity can read and write to that folder. That right is being inherited from the c:\ drive.

In a shared environment where you possibly have several hundred sites, each with their own application pool and Application Pool Identity, you would store the site folders in a folder or volume that has had the Users group removed and the permissions set such that only Administrators and the SYSTEM account have access (with inheritance).

You would then individually assign the requisite permissions each IIS AppPool\[name] requires on it's site root folder.

You should also ensure that any folders you create where you store potentially sensitive files or data have the Users group removed. You should also make sure that any applications that you install don't store sensitive data in their c:\program files\[app name] folders and that they use the user profile folders instead.

So yes, on first glance it looks like the ApplicationPoolIdentity has more rights than it should, but it actually has no more rights than it's group membership dictates.

An ApplicationPoolIdentity's group membership can be examined using the SysInternalsProcess Explorer tool. Find the worker process that is running with the Application Pool Identity you're interested in (you will have to add the User Name column to the list of columns to display:

For example, I have a pool here named 900300 which has an Application Pool Identity of IIS APPPOOL\900300. Right clicking on properties for the process and selecting the Security tab we see:

As we can see IIS APPPOOL\900300 is a member of the Users group.

Repost - http://stackoverflow.com/users/419/kev 

FTP Certificate TLS Encryption fix

• Windows 2008 R2 - IIS 7.5 using FTP
• FileZilla (Protocol=FTP; Encryption=Require explicit FTP over TLS; Logon Type:=Normal; UserName=****; Passwword=****** Currently there are 3 virtual drives and when I connect via FileZilla they all display fine, however when I try to configure a 4th virtual directory it will not display in FileZilla.

I am actually getting a sporadic failure all together after the directory is created:

Command: LIST Error: GnuTLS error -110: The TLS connection was non-properly terminated. Status: Server did not properly shut down TLS connection Error: Transfer connection interrupted: ECONNABORTED - Connection aborted Response: 550 Keyset does not exist Error: Failed to retrieve directory listing

If I delete the Virtual Directory the directories will display again. What is wrong, all the permissions are identical. Is there something with the SSL that has to be configured on the directory? Any assistance would be great.

http://serverfault.com/questions/655968/iis-7-5-ftp-and-virtual-directory/690420#690420

ANSWER - The "550 Keyset does not exist" error message may be caused by the pass-through authentication settings for the virtual directory. If pass-trough authentication is configured to use a 'specific user' rather than the default setting of 'application user' then the 550 error will be returned unless(probably) the 'specific user' is granted permission to access the Machine Keys for certificates.

Granted READ ONLY Access to the C:\ProgramData\Microsoft\Crypto\RSA directory for the particular FTP User Account

Reads of the week

Finding the Causes of Poor Performance in SQL Server, Part 1 & 2

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/