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

454 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

69 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,490 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

33 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

48 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

911 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

15 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

19 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,801 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

Monday Monitor Tips: Configuring Access to the MCP Server

The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection

10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives

Forums

A Challenge of Our Knowledge

The memory toll of VARCHAR(MAX) in SQL Server

Transaction Log Truncation

Question of the Day

Transaction Log Truncation