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

SQLServerCentral Article

Dealing with Transaction Log Growth

Introduction Relational databases are designed to track changes introduced to a database by data modification language (DML) commands. The fundamental reason for this construct is to ensure that changes are durable and that they can be rolled back reliably. The typical DML command used in SQL are INSERT, UPDATE and DELETE. When INSERT introduces new […]

4.8 (5)

You rated this post out of 5. Change rating

2022-06-13 (first published: )

6,136 reads

SQLServerCentral Article

Database Snapshot Use Case: Service Migration

In this article, we show how we used Database Snapshots as a rollbackup plan for a database migration from one data centre to another. Database Snapshots proved to be the best route since we sould not afford the time a backup/restore approach would take.

5 (1)

You rated this post out of 5. Change rating

2020-08-28 (first published: )

2,494 reads

SQLServerCentral Article

The IDENTITY Column Property

There are a number of ways to generate key values in SQL Server tables including the IDENTITY column property, the NEWID() function and more recently, SEQUENCES. The IDENTITY column property is the earliest of these methods. It was introduced very early in the history of SQL Server and it is arguably the simplest approach. Though old, IDENTITY is still maintained in modern versions of SQL Server and is still relevant for simple use cases.

5 (7)

You rated this post out of 5. Change rating

2020-05-21

7,214 reads

Blogs

The Annual SQL Saturday in Baton Rouge

By

I’ve been to quite a few of the SQL Saturday Baton Rouge events. There...

25 Years of Redgate

By

I’m in Austin today, ready for the Redgate Software 25th Birthday celebration. The company...

Read the latest Blogs

Forums

Synapse Analytics History I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Synapse Analytics History I

A Programmer's Attitude

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Programmer's Attitude

Notebook Jobs in Azure Data Studio

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Notebook Jobs in Azure Data...

Visit the forum

Question of the Day

Synapse Analytics History I

Before Synapse Analytics was a service in Azure, what was the name of the analytic data warehouse platform in the Azure cloud?

See possible answers