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

Too many Foreign Keys

by Igor Micev

Si vis pacem, para sql

I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some...

2016-03-10

99 reads

Too many Foreign Keys

by Igor Micev

Si vis pacem, para sql

I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some couple of foreign keys and up to 20, 30 and similar....

2016-03-10

4 reads

Too many Foreign Keys

by Igor Micev

Si vis pacem, para sql

I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some couple of foreign keys and up to 20, 30 and similar....

2016-03-10

14 reads

SQL Server ports

by Igor Micev

Si vis pacem, para sql

When you configure a SQL Server instance on a server, you have to consider the following ports: SQL Server default instance port – 1433 Dedicated Admin Connection and SQL...

2016-03-05

9 reads

SQL Server ports

by Igor Micev

Si vis pacem, para sql

When you configure a SQL Server instance on a server, you have to consider the following ports:
SQL Server default instance...

2016-03-05

71 reads

SQL Server ports

by Igor Micev

Si vis pacem, para sql

When you configure a SQL Server instance on a server, you have to consider the following ports:SQLServer default instance port...

2016-03-05

145 reads

SQL Server ports

by Igor Micev

Si vis pacem, para sql

When you configure a SQL Server instance on a server, you have to consider the following ports: SQL Server default instance port – 1433 Dedicated Admin Connection and SQL...

2016-03-05

4 reads

Rebuild of the System databases on Stand-alone and Failover Clustered SQL Server

by Igor Micev

Si vis pacem, para sql

The rebuild of the master database (or system databases) on a stand-alone and Failover Clustered (FC) SQL server instance is...

2016-03-02

227 reads

Rebuilding the system databases

by Igor Micev

Si vis pacem, para sql

The rebuild of the master database (or system databases) on a stand-alone and Failover Clustered (FC) SQL server instance is...

2016-03-02

1,914 reads

Rebuilding the system databases

by Igor Micev

Si vis pacem, para sql

The rebuild of the master database (or system databases) on a stand-alone and Failover Clustered (FC) SQL server instance is the same – https://msdn.microsoft.com/en-us/library/dd207003.aspx. When you install a SQL...

2016-03-02

2 reads

All authors

Igor Micev

Too many Foreign Keys

Too many Foreign Keys

Too many Foreign Keys

SQL Server ports

SQL Server ports

SQL Server ports

SQL Server ports

Rebuild of the System databases on Stand-alone and Failover Clustered SQL Server

Rebuilding the system databases

Rebuilding the system databases

Blogs

Claude Code Helps Analyze Test Data Manager Log Files

PowerPoint to HTML with Claude AI

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

Forums

Huge frustration - Database watcher with two elastic pools

SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance

Is it uncommon for Dev's to have a data model of the source data

Question of the Day

Creating JSON I