icon

Apr 3, 2023

Office 2016 Product Activation

Steps

cd /d %ProgramFiles%\Microsoft Office\Office16

cd /d %ProgramFiles(x86)%\Microsoft Office\Office16


for /f %x in ('dir /b ..\root\Licenses16\proplusvl_kms*.xrm-ms') do cscript ospp.vbs /inslic:"..\root\Licenses16\%x"


cscript ospp.vbs /inpkey:XQNVK-8JYDB-WJ9W3-YJ8YR-WFG99

cscript ospp.vbs /unpkey:BTDRB >nul

cscript ospp.vbs /unpkey:KHGM9 >nul

cscript ospp.vbs /unpkey:CPQVG >nul

cscript ospp.vbs /sethst:e8.us.to

cscript ospp.vbs /setprt:1688

cscript ospp.vbs /act


Mar 27, 2023

C drive has filled up, Delete dump files from mssql server

When there is something “unexpected”, SQL Server kills the SPID and generates a dump. Due to this, C drive has filled up and database is about to crash or has stopped processing.

Checklist to free space

1. cycle the SQL errorlog to remove large error log files from the C drive - see script below

2. clear out old mdf and ldf files from the \Data directory

3. clear out old stack dumps and crash dumps from \LOG directory

4. remove any redundant backup files

5. delete old roaming user profiles from C:\documents and settings

6. check any \temp directories and .tmp files for files to delete

7. empty the Recycle Bin


Here is an image with location


Delete the Log Files.


Jan 25, 2023

Essential Safety Tips for Smartphone Users



  • Use a complex password or PIN to lock your phone: This will protect your phone from unauthorized access if it's lost or stolen.
  • Keep your software updated: Regularly check for and install updates for your phone's operating system and installed apps to ensure optimal performance and security.
  • Be careful with public Wi-Fi: Public Wi-Fi networks are often unsecured, so avoid accessing sensitive information when connected to one.
  • Be wary of suspicious text messages and emails: Scammers often use text messages and emails to trick people into giving away personal information.
  • Be cautious when downloading apps: Only download apps from reputable sources and be sure to read the app's permissions before installing it.
  • Use a VPN: Use a virtual private network (VPN) to encrypt your internet connection and protect your data when using public Wi-Fi or accessing sensitive information.
  • Use anti-virus and anti-malware software: Regularly scan your phone for viruses, malware, and other security threats to protect your data and personal information.
  • Keep your personal information private: Be careful about sharing personal information on social media or in online forums.
  • Don't leave your phone unattended: Keep your phone with you at all times and be aware of your surroundings when using it in public places.
  • Be prepared for loss or theft: Keep a record of your phone's IMEI number (International Mobile Equipment Identity) and contact your service provider and local authorities immediately if your phone is lost or stolen.

ChatGPT (Generative Pre-trained Transformer)

ChatGPT is a large language model developed by OpenAI. It is based on the GPT (Generative Pre-trained Transformer) architecture and has been trained on a massive dataset of human text to generate human-like responses to text inputs. It can be used for a variety of tasks such as language translation, question answering, and text generation.



Feb 22, 2022

Excel textjoin() add-in for 2013


Steps:

1. Open a blank workbook

2. Press ALT+F11 to open the VBA editor

3. In the Project window on the left, right-click on the workbook name and choose Insert ->Module

4. Paste this code in the resultant window

Option Explicit
Function TEXTJOIN(delimiter As String, ignore_empty As String, ParamArray textn() As Variant) As String
    Dim i As Long
    For i = LBound(textn) To UBound(textn) - 1
        If Len(textn(i)) = 0 Then
            If Not ignore_empty = True Then
                TEXTJOIN = TEXTJOIN & textn(i) & delimiter
            End If
        Else
            TEXTJOIN = TEXTJOIN & textn(i) & delimiter
        End If
    Next
    TEXTJOIN = TEXTJOIN & textn(UBound(textn))
End Function

5. Save the workbook as an add-in type (.xlam)

6. Load the add-in into Excel (File ->Options ->Addins)


Syntax


TEXTJOIN( delimiter, ignore_empty, text1, [ text2, ... text_n ] )

Parameters or Arguments

delimiter

A string inserted between each text value in the resulting string. Most commonly, you would use a delimiter such as a comma or space character.

ignore_empty

Determines whether empty values are included in the resulting string. TRUE ignores empty values and FALSE includes empty values in the result.

text1, text2, ... text_n

The strings that you wish to join together. There can be up to 252 strings that are joined together.

Returns

The TEXTJOIN function returns a string/text value.