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

322 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

266 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

311 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

6 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

Local LLM Models at SQL Saturday Boston 2025

3 things you must do to start data quality management right

Set Theory vs. Batch Mode in SQL Server

Forums

Changing the Recovery Time

Getting More Time from AI

When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server

Question of the Day

Changing the Recovery Time