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

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-06-17

323 reads

Two new authentication options in SSMS 2016

by Igor Micev

Si vis pacem, para sql

Until SSMS 2014 there were the two standard authentication options for connecting to a SQL Server instance: Windows Authentication and...

2016-06-14

4,734 reads

The CHECK constraints unlike behaviours

by Igor Micev

Si vis pacem, para sql

The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create...

2016-06-13

267 reads

The CHECK constraints unlike behaviours

by Igor Micev

Si vis pacem, para sql

The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create...

2016-06-13

312 reads

The CHECK constraints unlike behaviours

by Igor Micev

Si vis pacem, para sql

The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...

2016-06-13

9 reads

The CHECK constraints unlike behaviours

by Igor Micev

Si vis pacem, para sql

The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...

2016-06-13

2 reads

The COUNT function in T-SQL

by Igor Micev

Si vis pacem, para sql

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...

2016-06-11

630 reads

The COUNT function in T-SQL

by Igor Micev

Si vis pacem, para sql

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...

2016-06-11

393 reads

The COUNT function in T-SQL

by Igor Micev

Si vis pacem, para sql

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not...

2016-06-11

3 reads

The COUNT function in T-SQL

by Igor Micev

Si vis pacem, para sql

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not...

2016-06-11

7 reads

All authors

Igor Micev

Connect to SQL Azure database from SSMS

Two new authentication options in SSMS 2016

The CHECK constraints unlike behaviours

The CHECK constraints unlike behaviours

The CHECK constraints unlike behaviours

The CHECK constraints unlike behaviours

The COUNT function in T-SQL

The COUNT function in T-SQL

The COUNT function in T-SQL

The COUNT function in T-SQL

Blogs

Query Intelligence in SQL Server 2025: What Developers Need to Know

Finding and Killing Blockers with Redgate AI Tech

Back at Small Data SF in 2025

Forums

Distributed Availability Group Issue / Misunderstanding.

Large posts full of code not allowed anymore?

Data > Hype

Question of the Day

Slipstream parameters