windows - DBplatz

PostgreSQL - default superuser privileges were removed.

Last week a colleague contacted me about a PostgreSQL installation where the privileges of the postgres user suddenly "disappeared". I searched around a bit and found this really useful article in stackoverflow. However, his server was Windows, so I tried and replicated this issue on a Windows 2019 server. First

databases

SQL Server - SSMS exiting immediately after showing the splash screen.

Last year, I installed SQL Server Management Studio 18.0 on a server tested the connection to the SQL Instance and everything looked OK. SSMS was exiting immediately after showing the splash screen. But months later, I tried again and SSMS was not starting. To troubleshoot this, let's cd to

sqlserver

SQL Server - Could not find the Database Engine Startup handle.

A few weeks ago I had the task to install SQL Server 2014 Express Edition and SQL Server Management Studio (SSMS) 18.4 and what it was going to be no more than an hour ended in a 16 hours change. Actually, I did install successfully one of the servers,

db2

SQL1397N The Db2 service failed to logon.

I always install a free version of Db2 on my laptop so I can play a bit in a really safe environment without breaking the real ones. Db2 Express-c has been replaced by the Db2 Community EditionSo a few days ago I tried to start my Db2 instance for testing

mssql

How to install SQL Server Management Studio (SSMS).

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

mssql

How to install SQL Server 2019 on Windows Server 2019.

In a previous post, we learned about installing Db2. Now I'm installing SQL Server. Photo by Tadas Sar / Unsplash I've download SQL Server Developer Edition from here. However, now you don't get the ISO or installation files anymore, what you get is a downloader. So, If the target server does