windows - DBplatz

HomeLab: Creating a domain account and users.

In a previous article we saw how to create a domain controller, now let's create domain users. Let's click on Start and then Server Manager. Go to Tools and then to Active Directory Users and Computers. Click on the domain (netplatz) and then go to users and right-click User. Provide

homelab

HomeLab: Creating a Domain Controller on Windows 2019.

Now that we know how to create a VM using Hyper-V, let's configure a domain controller which is required for our HomeLab SQL Server Always On installation. There is a really helpful guide already here, but I'll be using Windows 2019 instead. So, once our VM is up and running,

homelab

HomeLab: Creating a Windows 2019 Virtual Machine with Hyper-V

Today, I'm creating a new Windows 2019 VM using Hyper-V for my home lab. The goal is to create a new SQL Server AlwaysOn and FCI cluster for testing. So let's see how we can start just creating a VM for my domain controller (DC). Official docs are here Open

postgresql

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