Interviewing ChatGPT: What about Data Engineering?
Posted on March 29, 2023
Interviewing ChatGPT is an article series where we delve into various technical domains by conversing with ChatGPT. With its knowledge base and natural language processing capabilities, ChatGPT can provide insights and answers to various technical questions. In this article, we will be asking several questions about data engineering.
Top 3 Skills for Computer Scientists in 2023
Posted on March 26, 2023
In this article, we will focus on three essential skills that every computer scientist should have in 2023 but are often overlooked: efficient Google searching, effective use of Stack Overflow for asking and answering questions, and having the ability to ask good questions to intelligent virtual assistants like ChatGPT By...
Working with Date and Time Data Types in SQL Server
Posted on March 15, 2023
This tutorial explains different data types that can be used to store date time values and illustrates when to use each one in scripts, stored procedures and more.
Learn SQL: Insert multiple rows commands
Posted on March 6, 2023
This article explains the different approaches used to insert multiple rows into SQL Server tables.
How to use the SQL WHERE Clause with Examples
Posted on March 1, 2023
This tutorial, illustrates the different use cases and options available when using the WHERE clause and demonstrates them using the AdventureWorks2017 database.
MSSQLTips Rookie of the year winner
Posted on February 10, 2023
I am very thankful for being awarded the MSSQLTips.com Rookie of the year. I am pleased that this award was based on the SSIS Bad Habits article series I published in 2022. A special thanks to Jeremy Kadlec, who encouraged me to complete this article series before the end of...
Why is SQL Server doing an Index Scan instead of Index Seek?
Posted on February 9, 2023
This article explains how implicit conversion affects SQL query performance and causes the query optimizer to perform an index scan instead of index seek while searching for a specific value.
Getting started with SSIS External Configuration File
Posted on February 6, 2023
This article illustrates how to use a Microsoft SQL Server Integration Services (SSIS) external configuration file to enable the properties of package objects to be dynamically updated at run time.
SSIS Interview Questions and Answers for Developers and DBAs
Posted on February 3, 2023
This article provides more than 50 questions that can be used within an SSIS job interview.
Write for Tech Blog
Posted on January 29, 2023
Tech Blog is a Medium publication that tends to publish technical articles, ideas, and tutorials. If you are interested in sharing your knowledge with us, please read the article writing guidelines and submission rules before submitting your first article.
Fixing Cannot Convert Between Unicode and Non-Unicode String Data Types in SSIS
Posted on January 20, 2023
In this article, we will reproduce the “Cannot convert between Unicode and non-Unicode string data types” exception and explain several solutions to this issue.
Migrate Data from SQL Server to MongoDB using SSIS
Posted on January 17, 2023
This article gives an overview of the approaches to migrating SQL Server data to a MongoDB database.
Learn SQL standard deviation function
Posted on January 17, 2023
This article will show the SQL standard deviation function with several examples.
MSSQLTips Rookie of the year award (2022)
Posted on January 5, 2023
Dear Audience, 2022 was my first year as a contributing author for MSSQLTips.com. I have written an article series (6 articles) named “SSIS Bad Habits” where I explained several bad practices that decrease the SSIS packages performance. I am gload to annouce that I was recognized as a contender for...
An overview of the SQL GROUP BY clause
Posted on December 28, 2022
This article briefly explains the SQL group by clause, when it should be used, and what we should consider when using it.
SSIS Bad Habits: Decreasing SSIS Package Performance
Posted on December 1, 2022
This tip will explain some mistakes SSIS developers usually make when designing ETL and how they should be avoided.
Using parameterized queries to avoid SQL injection
Posted on November 18, 2022
This article explains what the SQL injection attack is, why it could be hazardous, and how to defend our SQL database from this attack using parameterized queries and some third-party tools.
SSIS Bad Habits: Inefficient Data Staging Strategies - Part 2
Posted on August 4, 2022
This article explains when databases are not suitable for data staging and what formats SSIS developers should use to stage their data when ETL jobs are developed using SQL Server Integration Services.
xp_cmdshell and sp_xp_cmdshell_proxy_account stored procedures in SQL Server
Posted on June 22, 2022
This article explains the xp_cmdshell and sp_xp_cmdshell_proxy_account system stored procedures in SQL Server and how developers can use them to execute Windows commands.
SSIS Bad Habits: Slow lookup transformations
Posted on June 7, 2022
This tutorial explains how lookups may highly decrease SSIS package performance and when they should only be used in Business Intelligence projects.
SSIS Bad Habits: Wrong OLE DB components configuration
Posted on May 4, 2022
This tutorial will explain some of the mistakes that SSIS developers usually make when configuring the OLE DB component while designing SSIS packages and how they should avoid them.
SSIS Bad Habits: Inefficient Data Staging Strategies
Posted on April 19, 2022
This article explains data staging and staging methods in SSIS, and how to choose the appropriate approach while designing your data pipeline.
SSIS Bad Habits: Using Sort and Merge Join Components
Posted on April 5, 2022
This tutorial explains the main cause of the performance problem faced while merging different data sources in SQL Server Integration Services and provides a few alternatives.
SSIS Extension for Visual Studio 2022
Posted on February 15, 2022
Is SSIS extension available for Visual Studio 2022?
An overview of DIFFERENCE and SOUNDEX SQL functions
Posted on January 18, 2022
This article gives an overview of DIFFERENCE and SOUNDEX SQL Server built-in system functions. It explains how to use those functions and how do they work.