The idea behind starting this blog was to help people who are interested in data engineering as a career. The reason this blog is named Azure Data Engineering is because my experience is mostly with Microsoft Technologies.

This article list out few tips on “Preparing for SQL DBA Interview” If you are reading this article which means you must be a Database Administrator/professional or getting ready for entering into DBA world. In today’s corporate world attending...

In this article, I am going to discuss Rank and Dense_Rank Function in SQL Server with Examples. Please read our previous article where we discussed Row_Number Function in SQL Server with Examples. As part of this article, we are going to discuss the...

Problem I have heard a lot about JSON data format for exchanging data between applications. Please present a quick overview of what is JSON as an introduction to a set of examples showing how I can open JSON data in SQL Server with T-SQL. Solution J...

In this article, we will explore the Bulk Copy Program tool that is also known as the SQL Server BCP tool. BCP allows us to export data into particular flat-file formats from SQL Server, and it also enables us to transfer data between different SQL S...

SQL Server is one of the world’s leading data platforms. It is being broadly used hosting millions of databases. These databases store data. This data are each organization’s most valuable asset. It is with this data that organizations run their...

In the article for SQL Server Always On Availability Groups, we are going to explore lease timeouts and health checks. SQL Server Always On Availability Groups provides resilience for high availability and disaster recovery solution in a multi-node a...

This article explores the usage of TempDB and different ways to shrink the TempDB database in SQL Server.Each instance of Microsoft SQL Server has a system database TempDB. It is a backbone for the SQL Server instance. Let’s review the TempDB datab...

In this article, we will discuss how to read the SQL Server execution plan (query plan) with all aspects through an example, so we will gain some practical experience that helps to solve query performance issues. Interpreting query plans correctly is...

Sometimes, all a DBA needs, to help with day-to-day work, is a checklist of best-practices and dos and don'ts. It provides a handy reminder. Brad has come up with a new update to his famous checklist

SQL Server DBA Scripts All in One - Useful MS-SQL ( DBA ) Database Administration Scripts : Performance Tuning Scripts - We can learn that all databases CPU resources usage with script, Also You can find TOP CPU queries in SQL Server database with a...

How to Rebuild a Database with a Corrupted or Deleted SQL Server Transaction Log File : In this article, we will see how to rebuild a SQL Server database that has a corrupted or deleted SQL Server Transaction Log file. Issue definition : When the SQL...

Using DBCC PAGE to Examine SQL Server Table and Index Data : Problem : I've read a lot of articles that talk about database pages and how they're used to store table data and index data. Is there some way I can actually look at this information? Sol...

Go through these top SQL interview questions to learn SQL programming, thoroughly. SQL is one of the most widely used languages. Almost all biggest names in the tech industry such as Uber, Netflix, Airbnb, etc. use SQL. The reason for the popularity...

Eight Different Ways to Clear the SQL Server Plan Cache : Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you usually get some sort of a scary warning about how you should not use it on a prod...