SQL Server

Locks in MS SQL Server are one way to ensure the integrity of data when changes are made by multiple users at the same time. MSSQL locks objects on a…

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 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…

I came across an interesting error when installing MS SQL Server 2014 on a new VM running Windows Server 2012 R2. SQL Server setup was interrupted almost at the end…