Two servers setup in Availability Group. One Primary and one Secondary. Secondary setup as read-only. Listener setup as the pointer. Connection string should point to listener.
.NETAgileAngularArchitectureASP.NETAzureBIBusinessC#DebuggingEncryptionFYIGoogleHardwareInternetInterviewsjQueryLeadershipManagementMicrosoftMobileMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSTeamTestingTSQLVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
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
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
Prior to SQL Server 2012 Availability Group, SQL Server 2008 uses Mirroring and Log Shipping. Database Mirroring Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. A copy of the database is created... » read more
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
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