XML Escape

Escapes or unescapes an XML file removing traces of offending characters that could be wrongfully interpreted as markup. The following characters are reserved in XML and must be replaced with their corresponding XML entities: ‘ is replaced with ' “ is replaced with " & is replaced with & < is replaced with < > is replaced with > https://www.freeformatter.com/xml-escape.html

Example of AlwaysOn High Availability Setup

Setup Availability Replicas – Select Server Availability Databases – Select Database Availability Group Listeners – Select Listeners (optional) Note Two servers setup in Availability Group. One Primary and one Secondary. (Can have multiple Secondary) Secondary setup as read-only. Listener setup as the pointer. Connection string should point to listener. (Optional) On Primary Server, will display... » read more

Deploying SSIS Packages from SSMS

There are 2 ways to deploy SSIS packages. #1 Directly from Visual Studio #2 From SQL Server Management Studio SQL Server Management Studio Create specific folders under SSISDB. To deploy a project deployment file that you created by building a project in the development environment, select Project deployment file and enter the path to the .ispac... » read more

Adding Signature to Word Document

There are many documents that require a signature like a lease, medical forms, and basically anything official in your life. When you need to make a document that requires a signature, here are the steps to add a signature to your Word document. Place the cursor in your Word document where you want to insert a signature.... » read more

VPN Software

GlobalProtect by Palo Alto Networks, Inc. Cisco AnyConnect Secure Mobility Client NetExtender by SonicWall MotionPro by Array Networks

SSMS Registered Servers Window

Registering a server in SQL Server Management Studio allows you to store the server connection information for future connections.There are three ways to register a server in SQL Server Management Studio. Local instances of SQL Server are automatically registered during the first launch of Management Studio after its installation. You can also initiate the automatic... » read more