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

436 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

8 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

10 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,068 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

12 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

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

29 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

5 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,817 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

Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations

Rambling about Data on Wheels – origins, branding, expansion

Think Twice Before Enabling Fabric’s Inbound Network Protection

Forums

AI Observability Challenges in FinOps as a DBA

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

SQL Agent Job Automated Change Capture Process

Question of the Day

Finding a Database Master Key