Author: Kenneth Igiri

Kenneth Igiri is an Enterprise Architect with eProcess International S.A., Ecobank Group's Shared Services Centre. Kenneth has over fifteen years' experience in Information Technology with nine of those years focused on SQL Server and Oracle databases. His interests include Database Performance, HADR, Cloud Computing, Data Architecture and Enterprise Architecture. Asides from work, Kenneth teaches at Children's Church, writes faith-based fiction and helps small businesses grow. You can connect with Kenneth via his blog https://kennethigiri.com, LinkedIn, or on Amazon.com.

How to Configure Database Mail in SQL Server

Database administration, Database Optimization & Structure

INTRODUCTION Notifications are usual in most modern systems. SQL Server implemented means of...
Read More

Configuring AlwaysOn Availability Groups on SQL Server

Availability Groups, Database administration

INTRODUCTION This document describes the steps and additional information necessary to configure AlwaysOn Availability Groups for HA and DR...
Read More

Restoring the SQL Server Master Database

Database administration, Database Optimization & Structure

INTRODUCTION The master database contains records of the structure/configuration for both the current instance and all other databases....
Read More

SQL Server System Databases – Basic Concepts

Database administration, Database Optimization & Structure

Introduction The SQL Server design implies a one-to-many mapping between the database engine...
Read More

Workplace Encounters: Reclaiming Space from an Oversized Database

Database administration, Memory Optimization

INTRODUCTION This document records steps, scripts, and ideology behind the maintenance performed on a production database between 22nd...
Read More

Using SQL Server 2016 Upgrade Advisor

Tools & technologies, Utilities & Extensions

INTRODUCTION SQL Server is designed to allow multiple databases on a single instance. With this model it is possible to have databases...
Read More

How To Migrate SQL Server Jobs From One SQL Server Instance To Another

Database administration, Database Optimization & Structure

Introduction In a previous article, we highlighted that the msdb database stores practically all...
Read More

SQL Server Lock Escalation

Database administration, Work with data

Introduction Relational databases follow the ACID properties in how they implement transactions – Atomicity, Consistency, Isolation, and...
Read More

Creating Maintenance Plans in SQL Server

Database administration, Database Optimization & Structure

Maintenance plans in SQL Server give us an easy way to organize, configure, and schedule tasks that ensure that the database engine and the...
Read More

Basics of Working with JSON in SQL Server

JSON, Languages & Coding

JSON – A Brief Background JSON is an acronym for JavaScript Object Notation, that became popular...
Read More
Close