mssql

How to install SQL Server Management Studio (SSMS).

DBplatz Support

Mar 18, 2020 — 2 min read

In this post, we will install SQL Server Management Studio on a Windows Server 2019.

We've downloaded the installation from here

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database.

So once the installation file is on the server. We just double-click on the installation file. (SSMS-Setup-ENU.exe)

This is what you will see and if you are happy with the default path, go for it. However, if there are more drives, perhaps it is recommended to select E:\, F:\, etc.

In our particular case, this is a Homelab, so, I click Install.

and the installation starts...

and yes a restart is required. If OK, click on restart.

Once the server is back, let's search for SSMS.

We click on SSMS.

And that's it.

SQL Server Management Studio v18.6 has been installed successfully.

MariaDB failing over primary to the replica.

In a previous post, we set up replication for MariaDB. This time we are failing over manually from the Primary node (master) to the Replica node (slave). Primary - mariadb01 We connect to mariadb01 as Primary. [centos@mariadb01 ~]$ mysql -u root -p --prompt "Primary> " We set all

Setting Up Replication - MariaDB 10.3

In a previous post we learned how to install MariaDB on Centos. In this one we are setting up replication. Official docs are here. So, let's get to it. Installing MariaDB I've used this guide to install MariaDB 10.3 on 2 Hyper-V VM servers called

IBM Db2 restore redirect

In the last article we installed IBM Db2 11.5 on Red Hat, and we also created the SAMPLE database using the db2sampl command, so in this article we will see how to use the restore redirect script to move that database to a different location. So let's

Installing IBM Db2 11.5 on Red Hat.

In this article we are installing IBM Db2 on Red Hat linux. We can download Db2 from here - A free IBM account is required to download Db2 software. Once we've downloaded the software from the IBM website and uploaded to the Red Hat VM. root@redhat:/root&

Read more

MariaDB failing over primary to the replica.

Setting Up Replication - MariaDB 10.3

IBM Db2 restore redirect

Installing IBM Db2 11.5 on Red Hat.