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: )

5,808 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,469 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

6,771 reads

Blogs

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Azure SQL MI License free?

By

A common setup when leveraging the cloud is to use the cloud for Disaster...

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Read the latest Blogs

Forums

Windows auth. is much slower than SQL server auth.

By ArnolddG

Moving around in SSMS when logged on to the SQL server (2019)  with Windows...

SQL query i need each Friday count back 6 days and select each ticker record

By angang

I have a stock market table that includes 70 tickers per day: ticker date,...

If anyone used tools like Gee-Pee-Tee for writing T-SQL (MS SQL server)?

By VAI

If anyone used artificial intel like Gee-Pee-Tee for writing T-SQL (MS SQL server) code...

Visit the forum

Question of the Day

Query Execution Modes

What are the two distinct processing modes that the SQL Server Database Engine can use to process T-SQL statements?

See possible answers