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

1 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,374 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,042 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

1 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

3 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

9 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,609 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

24 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

A New Word: Amoransia

The Data API Builder Start and Add Extensions in VS Code

Using OneLake for Excel Files in Microsoft Fabric

Forums

DbDefence - how does work this tool?

Technical Pain Behaviors

trying to call powershell from TSQL statement

Question of the Day

Counting Bits