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

423 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

53 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,477 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

17 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

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

898 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

5 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

11 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,786 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

T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future

Keeping MS Docs Up to Date

Patch Tuesday – Where to get more information

Forums

Change Tracking – Troubleshooting

is there a no code way to limit an ssis extract from excel to the 1st 21 rows?

Pivot but preserve all rows on Aggregate column

Question of the Day

What is the PRODUCT