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

Database cloning – CLONEDATABASE

by Igor Micev

Si vis pacem, para sql

Database cloning is a new feature supported in SQL Server. Only SQL Server 2014 SP2 and SQL Server 2016 SP1...

2017-02-27

708 reads

Database cloning – CLONEDATABASE

by Igor Micev

Si vis pacem, para sql

Database cloning is a new feature supported in SQL Server. Only SQL Server 2014 SP2 and SQL Server 2016 SP1 support cloning. The command syntax is very simple [crayon-5e81b52ed8fb5359335187/]...

2017-02-27

26 reads

Database cloning – CLONEDATABASE

by Igor Micev

Si vis pacem, para sql

Database cloning is a new feature supported in SQL Server. Only SQL Server 2014 SP2 and SQL Server 2016 SP1 support cloning. The command syntax is very simple [crayon-5e96566157e7c824875345/]...

2017-02-27

6 reads

Resolution of Database Consistency Error in SQL Server

by Igor Micev

Si vis pacem, para sql

There are so many facilities and amenities in SQL Server along with built-in methods, which assist users in some bad...

2017-02-16

1,938 reads

Mixed page allocation

by Igor Micev

SQLServerCentral

database options

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2017-02-13

1,071 reads

Discuss

SCOPE_IDENTITY() or @@IDENTITY

by Igor Micev

Si vis pacem, para sql

I've seen a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from...

2017-02-01 (first published: 2017-01-27)

3,226 reads

SQL and the other technologies

by Igor Micev

Si vis pacem, para sql

I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow. Charted data looks like in...

2017-02-01

13 reads

SQL and the other technologies

by Igor Micev

Si vis pacem, para sql

I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow. Charted data looks like in...

2017-02-01

5 reads