Author: Esat Erkeç

Esat Erkec is an SQL Server professional that began his career as a Software Developer over 8 years ago. He is an SQL Server Microsoft Certified Solutions Expert. Most of his career has focused on SQL Server Database Administration and Development. His current interests are in database administration and Business Intelligence.

SQL Server Bulk Insert – Part 2

Constraints, Database development, Triggers

In the previous part of this article, we discussed how to import CSV files to SQL Server with the...
Read More

SQL Server Bulk Insert – Part 1

Database administration

According to Wikipedia, ”A Bulk insert is a process or method provided by a database management system to load multiple rows of data...
Read More

SQL Server CRUD Operations


In database programming, there are four fundamental operations: create, read, update, and delete – CRUD operations. They are the first...
Read More

Introduction to SQL Server Identity

Database development, Tables

In this article, we will explore the basics and details of the SQL Server IDENTITY property and the...
Read More

Essentials and usage of NOLOCK hint in SQL Server

Database administration, Security

The main idea of the SQL Server locking mechanism is that it controls the consistency of transactions. According to this principle, if a...
Read More

SQL Database Administrator Interview Tips

Database administration

Interview is the most significant step of SQL database administrator recruitment. During the interview, a technical person or interviewer...
Read More

Basics of sys.dm_exec_requests

Database administration, Performance Tuning

Performance monitoring and troubleshooting in SQL Server is a vast topic. In SQL Server 2005,...
Read More

Main Usage of sys.dm_os_wait_stats

Database administration, Database development, Troubleshooting Issues, Views

As you know, the main responsibility of the database administrator lies in the monitoring of the SQL Server performance and intervening in...
Read More

Traditional and Natively Compiled Scalar-Valued User-Defined Functions

Languages & Coding, T-SQL

In the software programming world, there are several approaches used by developers that help them with effortless software development....
Read More

Compare Execution Plans in SQL Server

Database administration, Database Optimization & Structure

Database Administrator always makes an effort to tune SQL Server query performance. The first step...
Read More