Work & Wisdom

This page contains references to training materials, articles I have written and problems I have helped solve.

MVA Trainings

Technical Articles

Switching Out Table Partitions: A Walkthrough

AlwaysOn Availability Groups: Quorum

Database Normalization: A Primer

Parameter Sniffing Primer

T-SQL Datetime Datatype

Using Trace Flag 3226 to Suppress T-Log Backup Logging

Concatenation in Transact-SQL

In-depth Exploration of Row Level Security

Dealing with NULLs in SQL Server

Query Store Showing the Impact of Inserts on Indexes

Navigating SQL Server Error Logs

Resolved Incidents

Untrusted Domain

ORACLE: Virtual Circuit Waits

Reporting Services: Unable to Establish Connection

RMAN-05500 and RMAN-05502

MSDTC Throwing Errors: Internal Error and HR=0x80000171

Veritas: Connection Requested by Invalid Server

Path Error When Installing SQL Server 2016 on Command Line

Persistent Database Mail Queue

ORA-00313 Open Failed for Logfile Group in Physical Standby

VCLRUNTIME140.dll Missing When Launching SSMS

Unable to Start SQL Server 2016 Polybase Engine

WFCS and SQL 2016 FCI – SCSI-3 Persistent Reservation and FIPS

Error 0x80070643 Installing SSMS, SSDT

Rolling Back an AlwaysOn AG Configuration

Upgrade Error – SQL 2016 Installer Unable to Open Registry Key

HAIP Offline After Oracle Upgrade

AlwaysOn AG Automatic Failover Not Working

ORA-12545 – Peculiar Case – Host or Object Does Not Exist

Unable to Reorganize Index – ALLOW_PAGE_LOCKS Disabled

SQL Server Setup Disappears When Installing Setup Support Files

Identifying Objects Using Page IDs

Installing SQL Server in Silent Mode