SQL Server

When installing a new SQL Server instance (or updating/removing it), you may find that the installation process freezes when reaching the Install_SQLSupport_CPU64_Action step: Install_sql_common_core_Cpu64_Action : Write_NativeImage_64. : Generating native images

If you are using untrusted/public networks to connect clients/apps to your Microsoft SQL Server database, it is recommended to use traffic encryption. Let’s see how to configure and enable mandatory…

In this article, we will take a look at how to reset SA (system administrator) password in Microsoft SQL Server 2019/2017/2014/2012 . This guide will help you restore access to…

If you have installed an evaluation (trial) Microsoft SQL Server edition, note that this MSSQL instance will work only for 180 days. Then you must either stop using this instance…

In this article, we’ll walk you through a step-by-step guide on how to install and configure Always On Availability Groups on SQL Server running on Windows Server 2019, discuss failover…

In this article, we will show how to repair the TempDB Database on the Microsoft SQL Server using Single User or Minimal Configuration mode. This guide should help you to…

In this article, we will show you how to check the current TCP port on which a named or default MS SQL Server instance is listening (waiting for connection on),…

In this article we will describe step-by-step Microsoft SQL Server 2019 installation and tell about all options, components, relevant recommendations and best practices. MS SQL Server is a leading relational…

In this article we will discuss all effective ways to connect to a Microsoft SQL Server and run SQL queries from PowerShell. There are many ways how you can work…

In this article we will discuss existing Microsoft SQL Server licensing schemes and learn how to license SQL Server in a virtualization and container environment (the article is relevant for…