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.

The Difference Between UNION and UNION ALL

SQL Server, Uncategorized

Twice in the last six months, I have had to get involved in the resolution of an incident...
Read More

Workplace Encounters: Reclaiming Space from an Oversized Database

Database administation, Memory Optimization

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

A Simple Use Case for Indexes on Primary Keys

Database administation, Database development, Indexes, Perfomance Tuning, SQL Server • 3 Comments

Introduction Recently we encountered an interesting performance problem on one of our SQL Server databases that process transactions at a...
Read More

Simple SQL Server Functions to Solve Real-World Problems

Database development, Statements

Introduction Today’s article comes from a scenario we experienced in practice some time ago. We...
Read More

Understanding of SQL Server UPPER Function

Database development, Statements

There are many cases of SQL lowercase that we need to change for our purposes. For instance, we have keywords or strings of characters in...
Read More

SQL Server TRIM, LTRIM, and RTRIM Functions

Database development, Statements

The TRIM function of SQL Server is designed to remove leading and trailing whitespaces from a character string. A leading space is...
Read More

Basics of SQL Server Transaction Log

Database administation, Transaction Log

What is a Transaction Log? There is a requirement in relational database systems that transactions...
Read More

MIN and MAX Aggregate Functions in SQL Server

Database development, Statements

SQL Server Functions In database systems in general and in SQL Server in particular, functions are pieces of code that take zero or one...
Read More

Microsoft SQL Server Express Edition Limitations and Versions

Code Management, Tools & technologies

What is SQL Server Express? SQL Server Express Edition is a free edition of SQL Server. Microsoft provides it for educational purposes as...
Read More

Moving SQL Server Table to Different Filegroup

Database development, Tables

Introduction A table is a logical structure. When you create a table, you typically would not care...
Read More
Close