Set up a Windows Server Fail-over Clusters (As a Precursor to High Availability in Standard Edition)

Setting up High Availability in SQL server has some prerequisites. One of these is that the database servers must be members of the same Windows Server Failover Cluster. In this article I show how to succesfully set up WSFC and activate Cluster Aware Updating

Basic Always On Availability Groups in SQL Server Standard

Once Windows Server Failover Clusters have been set up, we can set up Availability Groups in SQL Server. This article will focus on setting up Basic Always-On Availability Groups in SQL Server Standard Edition.
This facilitates High Availability in SQL Server Standard, with three levels of availability and failover:
Asynchronous commit with manual or forced failover,
Synchronous commit with manual or forced failover,
Synchronous commit with automatic failover.

Read Only Replica in SQL Server Standard

SQL Server Standard Always On Availability Groups

Always On Setup

Simple script to de-identify data

An audit finding relating to production data, containing customer identifiable data, in a UAT environment, prompted this simple script, which completely scrambles data in such a way that the original value can not be reconstituted.

Importing Tricky CSV Files with PowerShell

A means of importing large csv files (where there may be commas in quote-delimited free text) into SQL Server tables using PowerShell

Dynamic SQL

To view or not to view, that is the question.

Deterministic