Database Solutions

Oracle Database 19C Installation on Windows Server 2016 In Database world, Its important to be on the latest version of the database flavor. Though Oracle have release 21c Database as well but by far Oracle 19C is most stable version.( You also check our similar blog for  Installation of Microsoft SQL Server 2016 ) Please do also check out blog for  Oracle 19c New Features to know about Oracle 19c features.  In this blog, We will be installing Oracle 19C DB on Windows Server. 1) Create required directory for Oracle Home and Oracle Base. Oracle Base: E:\app\oracle Oracle Home: E:\app\oracle\db\19.0.0\dbhome_1 2) Move the binary to E:\app\oracle\product\19.0.0 directory and unzip 3) Check unzipped directory. 4)Right Click on setup and  Run Setup as Administrator: 5)   On Configuration Screen, Select Set up software only 6)   On Database Installation Option page, Select Single instance Database installation for stand alone database server. 7)  O...

Uninstallting Microsoft SQL Server 2016 From time to time keep getting request to decommission Database and Uninstall Database Binary. To cater to such kind of request, We have come up with todays blog which discuss about uninstallation of the Microsoft SQL Server 2016. (If you want to install Microsoft SQL Server 2016 , Look at out blog  Installing Micosoft SQL Server 2016 ) 1) Stop Microsoft SQL Server and SQL Agent Service on the server.  2) On Server , Go to Control Panel > Programs > Programs & Features. Right Click Microsoft SQL Server 2016 software. 3) Click on Remove. 4) Remove Microsoft SQL Server Window will pop up and Global Rules will be checked. Click Next. 5) Select SQL Server Instance needed to be uninstalled. And Click Next. 6) Select the Features need to be Uninstalled and Click Next. 7) On Ready to Remove , Check and Verify Summary Screen and Click Remove. 8) Removal Progress Screen will come which will show progress of Uninstallation . 9) Removal...

Installing Microsoft SQL Server 2016 Installation Standards and Prerequisites 1. Hardware and Software Requirement Component Requirement .NET Framework SQL Server 2016 (13.x) RC1 and later require .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication.  Network Software Supported operating systems for SQL Server have built-in network software. Named and default instances of a stand-alone installation support the following network protocols: Shared memory, Named Pipes, TCP/IP and VIA. Hard Disk SQL Server requires a minimum of 6 GB of available hard-disk space.   2. Processor, Memory, and Operating System Requirements Component Requirement Memory At least 4 GB and should be increased as database size increases to ensure optimal performance. Processor Speed Minimum: x64 Process...