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,309 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

425 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

57 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,480 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

20 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

22 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

900 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

8 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

12 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,788 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

Learn Better: Pause to Review More

Azure SQL Managed Instance Next-Gen: Bring on the IOPS

SQL, MDX, DAX – the languages of data

Forums

Two foreign keys to the same table. Can't cascade deletes.

Connecting Power BI to SSAS and effective user not working

High Availability setup - has anyone seen this method?

Question of the Day

Encoding URLs