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 business grow. You can connect with Kenneth via his blog https://kennethigiri.com, LinkedIn or on Amazon.com.
  • Interests: Creative Writing, Small Business, Apologetics
  • Skills: Database Management, Data Management, Leadership, Management, Design Thinking

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)

2020-05-21

5,964 reads

Blogs

Automatically Take Missed Backups with Ola Hallengren’s Scripts

By

I blogged a few years ago about my configuration tables for Ola Hallengren’s maintenance...

SQL Server 2022 is GA!

By

The big announcement at the PASS Data Community Summit 2022 was that SQL Server...

Tell My Story of Public Speaking

By

This month the fine folks behind New Stars of Data and the DataGrillen Newcomer...

Read the latest Blogs

Forums

Backup progress

By ramana3327

We have started the full backup job that uses Veritas netbackup. The server has...

Join query with many tables

By pedroccamara

Hi guys, I hope everyone's ok I have a query in MySql (I'm using...

Mass update on Clustered Columnstore indexes

By SqlRon

Hi, we have a FACT table with 35 billion rows, partitioned on daily level....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers