Featured blog posts

Using Kerberos configuration manager to resolve Microsoft SQL server SPN issues

Using Kerberos configuration manager to resolve Microsoft SQL server SPN issues

Feb 20, 2018 12:00:00 AM 3 min read
Cosmos DB indexing fundamentals – SQL on the edge episode 15

Cosmos DB indexing fundamentals – SQL on the edge episode 15

Feb 7, 2018 12:00:00 AM 3 min read
Improve Oracle performance with ASM filter driver

Improve Oracle performance with ASM filter driver

Jan 25, 2018 12:00:00 AM 15 min read
How to display database statistics for all objects used in a SQL statement

How to display database statistics for all objects used in a SQL statement

Jan 17, 2018 12:00:00 AM 3 min read
Oracle 12.2 ASM filter driver installation

Oracle 12.2 ASM filter driver installation

Dec 29, 2017 12:00:00 AM 8 min read
How to analyze SQL server stack dumps

How to analyze SQL server stack dumps

Aug 22, 2017 12:00:00 AM 9 min read
Multi Tb migration using mydumper

Multi Tb migration using mydumper

May 12, 2017 12:00:00 AM 4 min read
Investigating IO performance on Amazon EC2

Investigating IO performance on Amazon EC2

Dec 30, 2016 12:00:00 AM 7 min read
SQL server security review using PowerShell

SQL server security review using PowerShell

Jul 26, 2016 11:14:00 AM 20 min read
InnoDB flushing and Linux I/O

InnoDB flushing and Linux I/O

May 5, 2016 12:00:00 AM 2 min read
Data encryption at rest in Oracle MySQL 5.7

Data encryption at rest in Oracle MySQL 5.7

Apr 20, 2016 12:00:00 AM 5 min read
Migrate a SQL Server environment with complex replication without reinitializing or rebuilding replication

Migrate a SQL Server environment with complex replication without reinitializing or rebuilding replication

Apr 4, 2016 12:00:00 AM 2 min read
In depth: MySQL 5.6+ DDL

In depth: MySQL 5.6+ DDL

Mar 29, 2016 12:00:00 AM 8 min read
Amazon database migration service - first try

Amazon database migration service - first try

Mar 28, 2016 12:00:00 AM 6 min read
Centralized authentication with Red Hat directory server for Linux systems

Centralized authentication with Red Hat directory server for Linux systems

Mar 10, 2016 12:00:00 AM 12 min read
How to build a multi-domain cluster with AlwaysOn availability groups - SQL Server 2016

How to build a multi-domain cluster with AlwaysOn availability groups - SQL Server 2016

Feb 17, 2016 12:00:00 AM 4 min read
Locks, blocks and deadlocks - what's the difference?

Locks, blocks and deadlocks - what's the difference?

Dec 4, 2015 12:00:00 AM 3 min read
Implementing Fuzzy search in SQL server

Implementing Fuzzy search in SQL server

Nov 10, 2015 12:00:00 AM 5 min read
Online resizing of ASM disks

Online resizing of ASM disks

Nov 4, 2015 12:00:00 AM 3 min read
Import/export multiple SSIS packages

Import/export multiple SSIS packages

Sep 30, 2015 12:00:00 AM 1 min read
Windows containers: installing SQL server

Windows containers: installing SQL server

Sep 21, 2015 12:00:00 AM 8 min read
Part 1: Oracle cloud database backup service

Part 1: Oracle cloud database backup service

Sep 9, 2015 12:00:00 AM 18 min read
Migration of Oracle Database to Amazon RDS using Golden Gate

Migration of Oracle Database to Amazon RDS using Golden Gate

Aug 28, 2015 12:00:00 AM 2 min read
Making existing SQLPLUS Scripts 12c and Container DB (PDB) compatible

Making existing SQLPLUS Scripts 12c and Container DB (PDB) compatible

May 26, 2015 12:00:00 AM 7 min read
List of SQL Server Databases in an Availability Group

List of SQL Server Databases in an Availability Group

May 23, 2014 12:00:00 AM 2 min read
Merge Replication Identity Range Management - An Identity Disorder? Part 2

Merge Replication Identity Range Management - An Identity Disorder? Part 2

Feb 4, 2014 12:00:00 AM 5 min read
Do You Know If Your Database Is Slow?

Do You Know If Your Database Is Slow?

Jun 25, 2013 12:00:00 AM 8 min read
Locks, Latches, Mutexes, and CPU Usage

Locks, Latches, Mutexes, and CPU Usage

Jun 13, 2012 12:00:00 AM 16 min read
Troubleshooting SSPI handshake error

Troubleshooting SSPI handshake error

Dec 5, 2011 12:00:00 AM 2 min read
Linux Patching and Oracle: Detect RPM conflicts before they happen

Linux Patching and Oracle: Detect RPM conflicts before they happen

Nov 15, 2011 12:00:00 AM 9 min read