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

432 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

2 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

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...

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

2,381 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,056 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

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

5 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

16 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,744 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

Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests

Adding a Local Model to Ollama through the GUI

Connect resiliently to SQL Server

Forums

using different credentials when debugging ssis

AlwaysON health check alerts

Bat and SQL script to generate DB user permissions for all Databases in SQL server

Question of the Day

PWDCompare