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

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

Database Cluster

Microsoft Windows Failover Clustering is a high-availability option designed to increase the uptime of SQL Server instances. A cluster includes two or more physical servers, called nodes; identical configuration is recommended. One is identified as the active node, on which a SQL Server instance is running the production workload, and the other is a passive... » read more