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

105 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

6 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

17 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

16 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

84 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

150 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

10 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

241 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,931 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

15 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

Measuring RAG Solutions: Are We Retrieving the Right Information?

Advice I Like: Lots of Ideas

Building a DBA Agent for Your SQL Server Estate with MCP

Forums

Looking for New Blood

Server-Level Row Counts for Tables and Views

Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't

Question of the Day

Hyperscale Replicas I