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 Server Reporting Service: how to handle common end-user requirements with Report Builder

March 26, 2018 by Esat Erkec

In this article, we will discuss the SQL Server Reporting Service Report Builder and look at how to handle common client, end user requests using Report Builder. Report Builder is a very powerful tool to create a report for the SQL Server Reporting Service.

Advantages of the Report Builder is that it:

exists as a Stand-alone installation
can use different data from a lot of data sources
can easily deploy reports to SQL Server Reporting Service
supports full capabilities of SQL Server Reporting Service
provides a productive report-authoring environment

How to create advanced analytics using Power BI and R scripts

February 27, 2018 by Esat Erkec

In this article, we will discover how to find the associations and hidden patterns in a dataset. The tool we will use for this is Power BI and not use any statistical functions or calculation.

Explanation

Power BI is one of the most powerful business intelligence solutions in the market. A cloud-based, user-friendly interface and basic development abilities provide this solution to be more convenient for people to use.

As you may know, Microsoft now supports R script in SQL Server and Power BI. R script support opens magical gates of statistics world to Power BI. Custom Visual offers very useful and interesting visual components for Power BI. In this store, many useful visualizations have been created by Microsoft or the community itself. Some of these visuals use R script infrastructure and this feature allows us to create advanced visual analytic in Power BI. Only a Power BI account is enough to connect and download theses visuals. We will use these visuals in our examples.

How to develop a K-Means model on Azure Machine Learning Studio

January 30, 2018 by Esat Erkec

In this article, we will discuss the k-means algorithm and how can we develop a k-means model on Azure Machine Learning Studio.

Machine learning is an area of artificial intelligence that helps us develop relationships between data and predict the future. There are many secrets that are hidden in the data. To discover these secrets, we need Machine Learning algorithms. Machine learning plays the key role in leveraging existing data to exploit business opportunities.

How to integrate SQL Server and Azure Machine Learning

January 11, 2018 by Esat Erkec

Good, clean and reliable data is important for every company, because well-analyzed data will open new possibilities to success. When we look at successful companies, we see that they’ve analyzed customers, sales, and finance data very well. At this point, a game changer enters: machine learning.

Machine learning

Machine learning is a type of artificial intelligence which analyzes data in order to predict future and discover hidden patterns. The output helps us make decisions. Machine learning is widely used in finance, healthcare and marketing.

How to use sargable expressions in T-SQL queries; performance advantages and examples

December 22, 2017 by Esat Erkec

The challenge

One of the main tasks of a SQL Server database administrator is performance tuning. Sometimes, though, coders or developers don’t always prioritize database performance or query optimization. Here is a typical scenario

Imagine that developers create a new table and then insert some records in a test environment and test their queries to retrieve data from it
The query executed successfully and does not exhibit any symptoms of performance problems
The developer team release this table and query into production
One day you take a telephone from your colleague and he says my report is very slow
Bingo! In production, this table contains a lot of records and this is resulting in performance bottlenecks when querying it

How to implement a graph database in SQL Server 2017

December 19, 2017 by Esat Erkec

Introduction

Graph database

A graph database is a type of database whose concept is based on nodes and edges.

Graph databases are based on graph theory (a graph is a diagram of points and lines connected to the points). Nodes represent data or entity and edges represent connections between nodes. Edges own properties that can be related to nodes. This capability allows us to show more complex and deep interactions between our data. Now, to explain this interaction we will show it in a simple diagram

How to use parallel insert in SQL Server 2016 to improve query performance

December 8, 2017 by Esat Erkec

Introduction

In the first part of this article, we will discuss about parallelism in the SQL Server Engine. Parallel processing is, simply put, dividing a big task into multiple processors. This model is meant to reduce processing time.

SQL Server can execute queries in parallel
SQL Server creates a path for every query. This path is execution plan
The SQL Server query optimizer creates execution plans
SQL Server query optimizer decides the most efficient way for create execution plan

Execution plans are the equivalent to highways and traffic signs of T-SQL queries. They tell us how a query is executed.

R script word-cloud in SQL Server Report Builder

November 28, 2017 by Esat Erkec

What is R

R is a very popular data programing language. R is especially used in data analysis, statistics calculations, predictions, data mining and machine learning. R is used by data scientist, economist, genetic scientists, and statisticians. R has very wide usage in real life. Healthcare, finance, marketing, and manufacturing are some of them.