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

Useful T-SQL queries and scripts to work in SQL Server

by Igor Micev

Si vis pacem, para sql

This post is about some queries and scripts that I use in my daily work on SQL Server. Some of...

2018-12-26 (first published: 2018-12-05)

7,321 reads

Useful T-SQL queries and scripts to work in SQL Server

by Igor Micev

Si vis pacem, para sql

This post is about some queries and scripts that I use in my daily work on SQL Server. Some of them are self-explanatory, i.e. the name of the query/script...

2018-12-05

429 reads

Useful T-SQL queries and scripts to work in SQL Server

by Igor Micev

Si vis pacem, para sql

This post is about some queries and scripts that I use in my daily work on SQL Server. Some of them are self-explanatory, i.e. the name of the query/script...

2018-12-05

58 reads

How to Write a Better T-SQL Code

by Igor Micev

Si vis pacem, para sql

Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are...

2018-11-28 (first published: 2018-11-16)

4,481 reads

How to Write a Better T-SQL Code

by Igor Micev

Si vis pacem, para sql

Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are aimed for the beginner-level T-SQL developers. Always Use a...

2018-11-17

21 reads

How to Write a Better T-SQL Code

by Igor Micev

Si vis pacem, para sql

Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are aimed for the beginner-level T-SQL developers. Always Use a...

2018-11-17

24 reads

Some New Cool Features in SSMS

by Igor Micev

Si vis pacem, para sql

SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases...

2017-12-28

901 reads

Some New Cool Features in SSMS

by Igor Micev

Si vis pacem, para sql

SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases and onward. Vulnerability Assessment (active from SSMS 17.4) Right...

2017-12-28

9 reads

Some New Cool Features in SSMS

by Igor Micev

Si vis pacem, para sql

SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases and onward. Vulnerability Assessment (active from SSMS 17.4) Right...

2017-12-28

14 reads

Using Time Zones in SQL Server

by Igor Micev

Si vis pacem, para sql

The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be...

2017-08-31 (first published: 2017-08-18)

3,792 reads

All authors

Igor Micev

Useful T-SQL queries and scripts to work in SQL Server

Useful T-SQL queries and scripts to work in SQL Server

Useful T-SQL queries and scripts to work in SQL Server

How to Write a Better T-SQL Code

How to Write a Better T-SQL Code

How to Write a Better T-SQL Code

Some New Cool Features in SSMS

Some New Cool Features in SSMS

Some New Cool Features in SSMS

Using Time Zones in SQL Server

Blogs

On Speaking Well

Monday Monitor Tips: Oracle Custom Metrics

Walking Through a Planned Failover: SQL Server Always On Availability Groups on Kubernetes

Forums

Troubleshooting WQL in custom PBM conditions?

Analysis of Locking Issues on Secondary Replicas in AlwaysOn Availability Groups

The Vector Data Type

Question of the Day

The Vector Data Type