Tag: Windows

Resolving an Availability Group Sync Issue – HADR_AR_CRITICAL_SECTION_ENTRY

We recently ran into an interesting issue on a three-node SQL Server Availability Group (AG) cluster. There was a cluster failure that impacted the availability group for a few minutes during which the replicas changed to resolving state. Once the…

Read More >

Solving an uncommon Oracle error code – ORA-01041

So, here is the thing. We have a customer running a 11.2 Single Instance Oracle database on Windows. I know the version is a bit old and Windows may not be the most common choice to run an Oracle database,…

Read More >

Installing SQL Server 2008 R2 on Windows 2012 cluster

Despite being an older version, some applications may require you to install a SQL Server 2008 R2 clustered instance on a Windows 2012 environment. You will quickly find out that there are a number of compatibility issues that can make…

Read More >

RDP Issue – CredSSP encryption Oracle remediation

Introduction We have recently had some issues accessing a few client servers and found it is related to a Windows security update that was released earlier in May 2018. The problem is when you try to RDP to a server…

Read More >

Windows containers: installing SQL server

This blog post is a quick introduction to Containers in the Windows world, and a walk-through on installing SQL Server in a Windows Container. Introduction As many of you have heard, Microsoft is jumping into containers with native support for…

Read More >

Pillars of PowerShell: Windows OS

Introduction This is the fifth blog post continuing the series on the Pillars of PowerShell. The previous post in the series are: Interacting Commanding Debugging Profiling The Windows Operating System (OS) is something a DBA should know and be familiar with…

Read More >

High system time on Windows running in a VM

Recently I’ve seen an issue with CPU usage on a server running Windows 2003 Server in a VMware. This is a small Virtual Machine with just 2 cores allocated (which are possibly mapped to “threads” on a host level but…

Read More >

Fixing Windows RAC listener to listen on IP address of Hostname

Recently, there was an issue after a node was added to an existing Windows RAC cluster. After everything was set up, the local listener was not listening to the IP address (192.168.0.37) corresponding to the node’s hostname. Oracle version was…

Read More >

How to configure an Azure Point-to-Site VPN – Part 2

This blog post is the second in a series of three which will demonstrate how to configure a Point-to-Site VPN step-by-step. In my first blog post, I demonstrated how to configure a virtual network and a dynamic routing gateway. Today’s…

Read More >

How to Configure an Azure Point-to-Site VPN – Part 1

This blog post is the first in a series of three which will demonstrate how to configure a Point-to-Site VPN step-by-step. Today’s post will teach you how to configure a virtual network and a dynamic routing gateway, and the following…

Read More >
Page 1 of 212