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.

T-SQL Datetime Data Type

Database administration, Work with data

Introduction Data types are attributes that specify the kind of data that objects such as columns,...
Read More

Using Trace Flag 3226 to Suppress Log Backup Logging

Database administration, Transaction Log

Introduction Every backup operation in SQL Server is written to the SQL Server Error log. This includes Transaction Log Backups even when...
Read More

Concatenation in Transact-SQL

Languages & Coding, Statements, T-SQL

Introduction Assuming you maintain a table containing customer data, and your boss asks you to send him the current list of customers and...
Read More

In-depth Exploration of Row Level Security

Database administration, Security

Introduction Organizations are becoming more and more concerned about how to reduce the cost of...
Read More

Dealing with NULLs in SQL Server

Database administration, Work with data

What is NULL? NULL or the NULL marker is the way we represent an unknown value in SQL, by SQL I am referring to the standard Structured...
Read More

Query Store: Showing the Impact of Indexes on Inserts

Database development, Indexes

Introduction It is common knowledge in database circles that indexes improve query performance either by satisfying the required result set...
Read More

Navigating SQL Server Error Logs

Database administration, Troubleshooting Issues

Introduction One of the key skills you need as a database administrator or an IT person is...
Read More

Monitoring Backups Across Instances

Database administration, Database Optimization & Structure

Introduction In the last two or three months, I have been asked twice for a solution native to SQL Server that consolidates a backup report...
Read More

How to Move Datafiles in SQL Server – Part 1

Database administration, Work with data

Introduction There are a number of situations which would warrant the movement of database files or transaction log files from one volume...
Read More

Fixing Data Loss Using Log Shipping with Delayed Recovery

Database administration, Transaction Log, Troubleshooting Issues

Introduction Transaction Log Shipping is a very well-known technology used in SQL Server to...
Read More
Close