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 my two-year working as a trainer at the Seavus...

2017-05-28

2 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,376 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,045 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

2 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

4 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

11 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

1 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,677 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 a mixed extent for the first eight pages of...

2017-04-08

25 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 a mixed extent for the first eight pages of...

2017-04-08

3 reads

All authors

Igor Micev

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

Mixed page allocation

Mixed page allocation

Blogs

SQL Data Type Conversions: Your Key to Clean Data & Sharp Queries

T-SQL Tuesday #186–Agent Jobs

T-SQL Tuesday #186 - Agent Job History Visualization

Forums

How to ask questions and find effective support on SQL Server Central?

Execution Plan Operators

Just To Talk – Your Safe Space for Online Therapy

Question of the Day

Execution Plan Operators