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.  :)