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

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

From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO

Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests

Adding a Local Model to Ollama through the GUI

Forums

Parameter sniffing issue with different minutes as opposed to using midnight

Some query values change when query is run but not others. Why?

using different credentials when debugging ssis

Question of the Day

PWDCompare