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

327 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,742 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

275 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

318 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

12 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

4 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

635 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

395 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

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

11 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

Why I stopped using MCP for AI coding stuff

AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning

AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention

Forums

Dynamic Unpivot

Writing as an Art and a Job

String Similarity II

Question of the Day

String Similarity II