Kenneth Igiri

Kenneth Igiri is an Enterprise Architect with almost two decades of 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 his day job, Kenneth teaches at Youth Church, writes faith-based fiction and works as a Strategy Coach. You can connect with Kenneth via his blog https://kennethigiri.com, LinkedIn or YouTube (@kenigiri).

Interests: Strategy, Small Business, Creative Writing
Skills: Database Management, Data Management, Leadership, Management, Design Thinking

Website: https://kennethigiri.com

All authors

The Real World: Implementing Data Compression in SQL Server 2008 R2

by Kenneth Igiri

SQLServerCentral.com

Compression

Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.67 (3)

You rated this post out of 5. Change rating

2018-10-19 (first published: 2016-01-18)

4,247 reads

Discuss

Configuring Backups Using Veritas Netbackup with AGs

by Kenneth Igiri

SQLServerCentral.com

Backup

A short description of our experience with Veritas Netbackup on MS SQL Server AG Groups. This article does not give a full description of the procedure for configuring netbackup but highlights a few pitfalls which we think some people will find very useful.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2017-07-18

4,637 reads

Discuss

Workplace Encounters: Using Volume Mount Points in SQL FCIs

by Kenneth Igiri

SQLServerCentral.com

disks

How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.5 (4)

You rated this post out of 5. Change rating

2017-06-26

960 reads

Discuss

Installing SQL Server vNext on an AWS EC2 RHEL Instance

by Kenneth Igiri

SQLServerCentral.com

Installation

The steps required to create an Amazon Web Services EC2 instance and install the latest SQL Server version on the EC2.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.75 (4)

You rated this post out of 5. Change rating

2017-03-16

796 reads

Discuss

Five Useful SQL Server Management Practices

by Kenneth Igiri

SQLServerCentral.com

Security

This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.89 (19)

You rated this post out of 5. Change rating

2017-01-18

3,676 reads

Discuss

SQL Server 2016: The New @OneResultSet Parameter in SP_SpaceUsed

by Kenneth Igiri

SQLServerCentral.com

space management

EXEC SP_SPACEUSED can return only one result set if you want it to. This is possible using a new parameter in SQL Server 2016. If are familiar with the inbuilt stored procedure sp_spaceused, I am sure you will find this new parameter quite useful.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.38 (8)

You rated this post out of 5. Change rating

2016-11-30

2,230 reads

Discuss

The Real World: Rebuilding Index - 1 Instance, 106 Databases

by Kenneth Igiri

SQLServerCentral.com

Indexing

The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.