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

428 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

23 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,790 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

“We love to debate minutiae”

Advice I Like: Knots

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

Forums

Windows logins for users migrated from DomainA to DomainB

Multiple Deployment Processes

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Question of the Day

Upgrading Admin Queries