Esat Erkec

Author
Recent Posts

Esat Erkec is a SQL Server professional who began his career 8+ years ago as a Software Developer. He is a SQL Server Microsoft Certified Solutions Expert.

Most of his career has been focused on SQL Server Database Administration and Development. His current interests are in database administration and Business Intelligence. You can find him on LinkedIn.

View all posts by Esat Erkec

SQL Performance Tuning tips for newbies

April 15, 2024 by Esat Erkec

The purpose of this article is to give newbies some basic advice about SQL performance tuning that helps to improve their query tuning skills in SQL Server.

SQL Unit Testing reference guide for beginners

August 11, 2023 by Esat Erkec

In this article, we are going to learn the basics of SQL unit testing and how to write a SQL unit test through the tSQLt framework.

SQL Cheat Sheet for Newbies

February 21, 2023 by Esat Erkec

In this SQL cheat sheet, we’ll look at sample SQL queries that can help you learn basic T-SQL queries as quickly as possible.

SQL Practice: Common Questions and Answers for the final round interviews

January 26, 2023 by Esat Erkec

In this article, we are going to make a SQL practice exercise that will help to prepare for the final round of technical interviews of the SQL jobs.

5 Best Practices for writing SQL queries

December 30, 2022 by Esat Erkec

In this article, we are going to learn some best practices that help to write more efficient SQL queries.

Introduction

Queries are used to communicate with the databases and perform the database operations. Such as, we use the queries to update data on a database or retrieve data from the database. Because of these functions of queries, they are used extensively by people who also interact with databases. In addition to performing accurate database operations, a query also needs to be performance, fast and readable. At least knowing some practices when we write a query will help fulfill these criteria and improve the writing of more efficient queries.

Five beneficial Azure Data Studio Extensions for SQL developers

July 19, 2022 by Esat Erkec

This article will mention five helpful Azure Data Studio extensions that may help to improve the SQL developers’ productivity.

How to build custom widgets on Azure Data Studio

July 7, 2022 by Esat Erkec

In this article, we will learn how to build a customized widget in Azure Data Studio that helps to monitor the performance metrics.

How to obtain SQL Execution Plans using different methods

June 30, 2022 by Esat Erkec

In this article, we will learn various methods of how to get an SQL execution plan of a query.

How to overcome parameter sniffing problems in ad-hoc queries

June 17, 2022 by Esat Erkec

The purpose of this article is to provide insights into how parameter sniffing occurs for an ad-hoc query and how it affects their performance.

Unrevealed tips of SQL Server Statistics

June 13, 2022 by Esat Erkec

In this article, we will explore some internal working principles of SQL Server statistics.

SQL Server statistics from a different perspective

June 10, 2022 by Esat Erkec

The goal of this article is to throw light on the less-known points about SQL Server statistics.

7 Common T-SQL Query mistakes

June 1, 2022 by Esat Erkec

SQL (Structured Query Language) is an ANSI/ISO standard programming language that is designed to program relational databases and T-SQL (Transact-SQL) is an extended implementation of the SQL for Microsoft SQL Server databases. T-SQL is highly used by database persons when they want to program or manage the SQL Server databases. However, the beginners may do some mistakes without realizing when they write queries with SQL. In the next section of this article, we will glance at the common mistakes that may be made by newbies.

How to become a SQL Server Developer

May 20, 2022 by Esat Erkec

In this article, we will talk about what SQL Server developers do and which main skills are required to get a job as a SQL developer.

How to write readable T-SQL queries

May 18, 2022 by Esat Erkec

This article intends to give some beneficial suggestions that help to write a more readable T-SQL query.

Microsoft SQL Server Trace Flags and usage details

April 13, 2022 by Esat Erkec

In this article, we will explore Microsoft SQL Server trace flags with all aspects, and we will learn also how to use them.

5 reasons to consider on your Query Performance degradation

April 7, 2022 by Esat Erkec

This article gives fundamental insights into which 5 reasons can cause to drop off the query performances in SQL Server.

SQL Server Database Parameterization option and its Query Performance effects

February 18, 2022 by Esat Erkec

The goal of this article is to give details about the database query parameterization feature and explain its effects on query performance.

SQL Server Trivial Execution Plans

February 3, 2022 by Esat Erkec

In this article, we will go through the details of the trivial execution plans and we will also tackle some examples about the trivial plans to explore effects on query performance.

Behind the scenes of the SQL Delete Statement

January 31, 2022 by Esat Erkec

In this article, we will explore the details of what happens behind the scenes when a SQL delete statement is executed.

Monitoring SQL Server TempDB with Dynamic Management Views

December 29, 2021 by Esat Erkec

In this article, we will learn how we can detect which operations cause to fill up SQL Server tempdb through the dynamic management views.

SQL Update statement Performance Tips

December 7, 2021 by Esat Erkec

The SQL update statement is used to modify an existing record or records in a table and it is commonly widely used in databases applications. In this article, we will examine the update statement in terms of the performance perspective.

SQL Server Trace Flags and how they impact the SQL Server Query Optimizer behavior

December 2, 2021 by Esat Erkec

In this article, we will learn some query hints and trace flags that impact the query performance and also influence the SQL Server query optimizer’s default execution plan generation algorithm.