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

What does an Index mean to a Query

by Igor Micev

Si vis pacem, para sql

This post is about the importance of a right index to a query. The following simple query was considered.

SELECT
[GroupBy1].[A1] AS...

2016-11-11

259 reads

What does an Index mean to a Query

by Igor Micev

Si vis pacem, para sql

This post is about the importance of a right index to a query. The following simple query was considered. [crayon-5e81b52eda1f0195410103/] Even simple, this query was causing troubles on our production...

2016-11-11

4 reads

What does an Index mean to a Query

by Igor Micev

Si vis pacem, para sql

This post is about the importance of a right index to a query. The following simple query was considered. [crayon-5e96566159ca8644006533/] Even simple, this query was causing troubles on our production...

2016-11-11

9 reads

Connect to SQL Azure database from SSMS

by Igor Micev

Si vis pacem, para sql

In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have...

2016-10-11

274 reads

Connect to SQL Azure database from SSMS

by Igor Micev

Si vis pacem, para sql

In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you...

2016-10-11

14 reads

Connect to SQL Azure database from SSMS

by Igor Micev

Si vis pacem, para sql

In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you...

2016-10-11

2 reads

Changing SQL Server name

by Igor Micev

Si vis pacem, para sql

This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that:...

2016-10-02

711 reads

Changing SQL Server name

by Igor Micev

Si vis pacem, para sql

This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that:...

2016-10-02

285 reads

Changing SQL Server name

by Igor Micev

Si vis pacem, para sql

This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that: You simply forgot to change the name of your...

2016-10-02

6 reads

Changing SQL Server name

by Igor Micev

Si vis pacem, para sql

This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that: You simply forgot to change the name of your...

2016-10-02

32 reads

All authors

Igor Micev

What does an Index mean to a Query

What does an Index mean to a Query

What does an Index mean to a Query

Connect to SQL Azure database from SSMS

Connect to SQL Azure database from SSMS

Connect to SQL Azure database from SSMS

Changing SQL Server name

Changing SQL Server name

Changing SQL Server name

Changing SQL Server name

Blogs

Ramblings about data communities and your contributions, no excuses

SQL Server Journey till 2025 (brief)

Building Power BI Reports: Desktop vs Fabric

Forums

Multi-State Payroll Tax Issues 2026

Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)

Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE

Question of the Day

String Similarity I