SQL Server

OCI Security rules for SQL Always On

oci security list

Security rules in Oracle Cloud Infrastructure (OCI) allow you to specify inbound and outbound traffic rules for your VCN (Virtual Cloud Network). They operate at the subnet level and are used to control traffic flow between resources within the VCN, and between the VCN and the internet. Security rules consist of the following components: Security …

Automatic Memory Management for SQL Server Failover Cluster Instances


One of the challenges while using Failover Cluster Instances (FCI) is to manage the memory of the SQL server in case of failover. In general, most SQL Server configurations do not require much attention to memory management beyond the initial configuration. However, Failover Cluster Instances (FCI) architecture is very different from others. Therefore, special attention …

SQL Server Migration from 2008 R2 to 2016


Take a read about real-live experience coming from SQL Server migration project I participated in. We migrated from SQL Server 2008 R2 standalone servers into SQL Server 2016 in Failover Cluster Instances (FCI). Watch the full presentation – Polish language only! Intro The environment is a private cloud dedicated to one application using SQL Server …