Ahmad Yaseen

Author
Recent Posts

Ahmad Yaseen is a Microsoft Big Data engineer with deep knowledge and experience in SQL BI, SQL Server Database Administration and Development fields.

He is a Microsoft Certified Solution Expert in Data Management and Analytics, Microsoft Certified Solution Associate in SQL Database Administration and Development, Azure Developer Associate and Microsoft Certified Trainer.

Also, he is contributing with his SQL tips in many blogs.

View all posts by Ahmad Yaseen

Migrating SQL workloads to Microsoft Azure: Planning the jump

July 27, 2020 by Ahmad Yaseen

In this article, we will discuss several points that should be considered when planning to migrate the on-premises SQL workload to Microsoft Azure cloud services. This article is the first step in a series of articles that discuss how to perform the SQL and No-SQL workload migration smoothly to the cloud.

SQL Server Connectivity Interview Questions & Answers for SQL Server Database Administrators

June 29, 2020 by Ahmad Yaseen

In this article, we will discuss a number of questions that you may be asked while being interviewed for a SQL Server Database Administrator (DBA) position. These questions will concentrate on the SQL Server connectivity concept, components, configurations, and troubleshooting.

Migrating your data into Azure Cosmos DB

June 26, 2020 by Ahmad Yaseen

In the previous article, Start your journey with Azure Cosmos DB, we provided you with the backpack that helps you to start your journey with Azure Cosmos DB and filled it with detailed information about the Cosmos DB usage benefits, how to create your first Cosmos DB account, create a new database, container, and items and finally how to query the data stored in that container.

It is time to specify your Microsoft Certifications path

June 24, 2020 by Ahmad Yaseen

In this article, we will discuss all Microsoft Certifications paths in a way that helps you to drive on the correct road, to meet the requirements of the current job career growth or the job that you plan for.

Digging deeper into Azure Data Studio: Extensions and Azure SQL DB Development

June 24, 2020 by Ahmad Yaseen

In the previous articles listed below, we went through the Azure Data Studio tool, starting from the installation procedure, showing the purpose of each component, how to organize your connections, and develop the different types of SQL Server database objects using the interactive query editor in that data studio.

Digging deeper into Azure Data Studio: More code and less GUI

June 23, 2020 by Ahmad Yaseen

In the previous two articles, Starting your journey with Azure Data Studio and Developing your SQL Server database using Azure Data Studio, we introduced the Azure Data Studio tool by describing the main components of that data studio and showed how we can take advantages from it in developing and organizing the database related projects.

Developing your SQL Server database using Azure Data Studio

June 22, 2020 by Ahmad Yaseen

In the previous article, Starting your journey with Azure Data Studio, we put the first stone that helps you to be familiar with the Azure Data Studio and start using it to interact with your database objects.

Starting your journey with Azure Data Studio

June 19, 2020 by Ahmad Yaseen

In this article, we will introduce the Azure Data Studio in a way that makes it easy for you to start using it. Enjoy the reading!

SQL Server Senior Database Administrator Interview Questions and Answers

May 5, 2020 by Ahmad Yaseen

In this article, we will discuss a number of questions that you may be asked when applying to a senior SQL Server database administrator position.

SQL Server Junior Database Administrator Scenario-Related Interview Questions and Answers

May 5, 2020 by Ahmad Yaseen

In this article, we will discuss a number of questions that you may be asked when applying to a junior SQL Server database administrator (DBA) position.

Microsoft Azure Administrator scenario-related Interview Questions and Answers

May 4, 2020 by Ahmad Yaseen

In this article, we will discuss several scenario-related interview questions that you may be asked when applying to an Azure Administrator position.

Start your journey with Azure Cosmos DB

April 6, 2020 by Ahmad Yaseen

In this article, we will discuss why we need to use Azure Cosmos DB and how to configure it to store and query our data.

Working with SQL Server ROWCOUNT

March 30, 2020 by Ahmad Yaseen

In this article, we will discuss the SQL Server @@ROWCOUNT and ROWCOUNT system objects by going through practical examples that cover most of these system objects usage.

INSERT INTO T-SQL Statement in SQL Server

March 27, 2020 by Ahmad Yaseen

In this article, we will go deeply through the INSERT INTO statement by showing the different syntax formats and usage scenarios for that statement.

SQL Server MAX() aggregate function

March 19, 2020 by Ahmad Yaseen

SQL Server provides us with several aggregate functions that can be used to perform different types of calculations on a set of values, and return a single value that summarized the input data set. These SQL Server aggregate functions include AVG(), COUNT(), SUM(), MIN() and MAX().

SQL Server Replication Interview Questions & Answers

March 2, 2020 by Ahmad Yaseen

In this article, we will discuss a number of interview questions that cover the SQL Server Replication concept, components, types, and troubleshooting scenarios.

SQL Server Always On Availability Groups Interview Questions & Answers

February 28, 2020 by Ahmad Yaseen

In this article, we will discuss a number of interview questions that you could be asked about the SQL Server Always On Availability Groups feature when attending an interview for the SQL Server database administrator role.

Top five considerations for SQL Server index design

January 13, 2020 by Ahmad Yaseen

In this article, we will discuss the most important points that we should consider when designing an optimal SQL index. Before going through the index design procedure, let us revise the SQL Server index concept.

How to detect and prevent unexpected growth of the TempDB database

January 13, 2020 by Ahmad Yaseen

In this article, we will discuss the best practices that should be followed in order to keep the TempDB database in a healthy state and prevent any unexpected growth of the database, in addition to the procedure that can be followed to detect this unexpected growth once occurred.

SQL Server Transaction Log Interview Questions

October 3, 2019 by Ahmad Yaseen

In this article, we will discuss some important SQL Server Transaction Log interview questions that you may be asked during a SQL Server administrator or developer technical job interview.

SQL Server Auditing Interview Questions

October 3, 2019 by Ahmad Yaseen

In this article, we will discuss a number of common and important SQL Server Audit questions that you may be asked during the SQL Server database administrator interview. I advise you to check them out and get ready for the interview.

SQL Server Execution Plan Interview Questions

September 20, 2019 by Ahmad Yaseen

In this article, we will discuss a few very common questions that you may be asked during a SQL Server administrator or developer technical job interview.

SQL Server Auditing Best Practices

May 23, 2019 by Ahmad Yaseen

In this article on SQL Server Auditing Best practices, we will show the best practices that should be followed to have a successful auditing strategy that complies the company audit policies and requirements.

How to Rebuild a Database with a Corrupted or Deleted SQL Server Transaction Log File

May 15, 2019 by Ahmad Yaseen

This is the last article, but not the least one, in the SQL Server Transaction Log series. In this series of articles (see the TOC below), we described the Transaction Log concept from four different aspects.

Perform a SQL Server Audit using ApexSQL Audit

May 15, 2019 by Ahmad Yaseen

This is the last article, but not least, in the SQL Server Audit series. In this series (see TOC at the bottom), we explained deeply the concept of the SQL Server Audit, why it becomes mandatory for each company to have a SQL Server Audit solution to track and log the different types of events at both the SQL Server instance and database levels. We also went through and compare the different methods that can be used to audit the SQL Server instances and databases.