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

Microsoft Certified Trainer!

by Igor Micev

Si vis pacem, para sql

For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of...

2017-05-28

435 reads

Microsoft Certified Trainer!

by Igor Micev

Si vis pacem, para sql

For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus...

2017-05-28

6 reads

Microsoft Certified Trainer!

by Igor Micev

Si vis pacem, para sql

For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus...

2017-05-28

6 reads

Multiple usage of functions to ensure “value” is not null? – NO

by Igor Micev

Si vis pacem, para sql

In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three...

2017-05-10 (first published: 2017-04-29)

2,390 reads

Some stuff with Date and Time in SQL Server

by Igor Micev

Si vis pacem, para sql

I’m writing this post because I want to put some more stuff around dates and times in one place. I...

2017-05-09

1,062 reads

Some stuff with Date and Time in SQL Server

by Igor Micev

Si vis pacem, para sql

I’m writing this post because I want to put some more stuff around dates and times in one place. I additionally teach SQL Server classes and often come up...

2017-05-09

7 reads

Some stuff with Date and Time in SQL Server

by Igor Micev

Si vis pacem, para sql

I’m writing this post because I want to put some more stuff around dates and times in one place. I additionally teach SQL Server classes and often come up...

2017-05-09

6 reads

Multiple usage of functions to ensure “value” is not null? – NO

by Igor Micev

Si vis pacem, para sql

In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three functions for a variable to ensure it never accepts...

2017-04-29

21 reads

Multiple usage of functions to ensure “value” is not null? – NO

by Igor Micev

Si vis pacem, para sql

In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three functions for a variable to ensure it never accepts...

2017-04-29

4 reads

Mixed page allocation

by Igor Micev

Si vis pacem, para sql

MIXED_PAGE_ALLOCATION is a new option introduced with SQL Server 2016. It controls whether the database can create initial pages using...

2017-04-08

5,801 reads

All authors

Igor Micev

Microsoft Certified Trainer!

Microsoft Certified Trainer!

Microsoft Certified Trainer!

Multiple usage of functions to ensure “value” is not null? – NO

Some stuff with Date and Time in SQL Server

Some stuff with Date and Time in SQL Server

Some stuff with Date and Time in SQL Server

Multiple usage of functions to ensure “value” is not null? – NO

Multiple usage of functions to ensure “value” is not null? – NO

Mixed page allocation

Blogs

Programmatically Retrieving MLV Lineage and Refresh Times

SWAG Saves the Day

Upgrading SQL Server Containers on the Laptop

Forums

BCA Finance WTC Mangga Dua Telpon/WA:08218168291

Kantor BCA Finance pusat Telpon/WA:08218168291

BCA KCP Benhil Telpon/WA:08137887595

Question of the Day

Increase Deadlock Detection