Blog

How to Apply the Latest Cumulative Update for SQL Server

This post demonstrates how to apply the latest CU( Cumulative Update ) on SQL server 2019.

1)Download the latest CU4( KB4548597 ) for SQL Server 2019 for Windows here.

2) Record the current SQL 2019 version.

3) Run “SQLServer2019-KB4548597-x64” as Administrator.

a) On “license Terms” page, choose “I accept the license terms and Privacy Statement”.

b) On “select features” page, select all the SQL server 2019 instances, shared features and all installed components.

c) On “Consent to install Microsoft R Open” page, click “Accept”.

d) On “Consent to install Python” page, click “Accept”.

e) On “Check Files in Use” page, stop all the services on the list, and click “refresh check” until no more processes listed.

f) On “Ready to update page” page, review the features list. click “Update” if everything is satisfied.

g) On “Update Process” page, monitor the patching process until it is complete.

Reboot the Windows Server if requested.

4) Verify the upgraded SQL 2019 version.

How to Enable Remote Connections to MSSQL Server

This post shows step by step on how to enable remote connections to a sql server by configuring ports and firewalls , etc.

Subscribe to get access

Read more of this content when you subscribe today.

How to Install SQL Server 2019 on Windows Server 2019 VM of VirtualBox

After Windows server 2019 Oracle VirtualBox VM has been created as per How to Install Windows Server 2019 on Oracle VirtualBox,  now it is time to install SQL server 2019.

Subscribe to get access

Read more of this content when you subscribe today.

How to Install Windows Server 2019 on Oracle VirtualBox

This post illustrates step by step on how to build a Windows Server 2019 evaluation VM server on Oracle VirtualBox, also screenshots are provided for every step in details.

Subscribe to get access

Read more of this content when you subscribe today.

To log in, press the host key plus the Delete key to simulate the CTRL + ALT + DELETE key combination. The host key is the right-CTRL key by default.

How to Clone 19c Oracle RAC Home using Gold-Image

As we know “clone.pl ” script has been widely used for cloning Oracle binaries before 19c. But it is now deprecated since 19c.

This post demonstrates how to clone 19c Oracle Database RAC Home from one database server to another.

Subscribe to get access

Read more of this content when you subscribe today.