Igor Micev

Integration specialist, Developer & Programmer, Database administrator, and Architect with 15+ years of
expertise. Experienced in software development, database analysis & design, performance tuning, upgrades &
migrations, high availability solutions implementation, and design, backup and recovery strategies, and system
capacity planning.

All authors

SCOPE_IDENTITY() or @@IDENTITY

by Igor Micev

Si vis pacem, para sql

I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation...

2017-01-27

276 reads

SCOPE_IDENTITY() or @@IDENTITY

by Igor Micev

Si vis pacem, para sql

I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from @@IDENTITY can sometimes not be the desired. This...

2017-01-27

5 reads

SCOPE_IDENTITY() or @@IDENTITY

by Igor Micev

Si vis pacem, para sql

I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from @@IDENTITY can sometimes not be the desired. This...

2017-01-27

4 reads

My first Microsoft MVP Award!

by Igor Micev

Si vis pacem, para sql

Exactly 10 years ago I started my career as a Software developer in a Bank, which for me meant directing...

2017-01-10

178 reads

My first Microsoft MVP Award!

by Igor Micev

Si vis pacem, para sql

Exactly 10 years ago I started my career as a Software developer in a Bank, which for me meant directing my career in the fields of data analysis, processing...

2017-01-10

6 reads

My first Microsoft MVP Award!

by Igor Micev

Si vis pacem, para sql

Exactly 10 years ago I started my career as a Software developer in a Bank, which for me meant directing my career in the fields of data analysis, processing...

2017-01-10

5 reads

Indexes optimize for the system databases

by Igor Micev

Si vis pacem, para sql

Maintenance of the system databases in SQL Server regarding the indexes is important too. The system tables also have indexes...

2016-12-23

1,372 reads

Indexes optimize for the system databases

by Igor Micev

Si vis pacem, para sql

Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and...

2016-12-23

274 reads

Indexes optimize for the system databases

by Igor Micev

Si vis pacem, para sql

Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and their maintenance is of asset on the busy environments....

2016-12-23

5 reads

Indexes optimize for the system databases

by Igor Micev

Si vis pacem, para sql

Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and their maintenance is of asset on the busy environments....

2016-12-23

3 reads

All authors

Igor Micev

SCOPE_IDENTITY() or @@IDENTITY

SCOPE_IDENTITY() or @@IDENTITY

SCOPE_IDENTITY() or @@IDENTITY

My first Microsoft MVP Award!

My first Microsoft MVP Award!

My first Microsoft MVP Award!

Indexes optimize for the system databases

Indexes optimize for the system databases

Indexes optimize for the system databases

Indexes optimize for the system databases

Blogs

Rolling Back a Broken Release

A bespoke reporting solution doesn’t have to cost the earth

Presenting with Visual Studio Code

Forums

Lots of FKs

Real-time On-prem SQL Server Data in Excel – Over the Internet

Can You Let Go of Determinism

Question of the Day

Lots of FKs