This step-by-step technical article will explore how to perform data profiling on a database using SQL code. We will use a combination of SQL queries to gather various metrics and statistics about the data, such as column data types, null values, data length, and more. Ultimately, all SQL code portions...
[Read More]
Data Wrangling in SQL Server for Cleaning, Transforming and Merging Data
MSSQLTips.com
Implicit Conversion Concerns for SQL Server Performance
MSSQLTips.com
Towards Data Quality: An Overview of SQL Server Data Quality Solutions
Tech Blog
Towards Data Quality: an Introduction
Tech Blog
This article emphasizes the significance of data quality in data-driven strategies and highlights the consequences of implementing data warehousing scenarios that need more attention to data quality. It introduces the concept of data quality management and discusses the ISO/IEC 25012 standard’s fifteen data quality characteristics. The article explains the different...
[Read More]
Different methods for monitoring MongoDB databases
SQL Shack
Context-aware big data quality assessment: a scoping review
ACM Journal of Data and Information Quality
The term data quality refers to measuring the fitness of data regarding the intended usage. Poor data quality leads to inadequate, inconsistent, and erroneous decisions that could escalate the computational cost, cause a decline in profits, and cause customer churn. Thus, data quality is crucial for researchers and industry practitioners....
[Read More]
BIGQA: Declarative Big Data Quality Assessment
ACM Journal of Data and Information Quality
In the big data domain, data quality assessment operations are often complex and must be implementable in a distributed and timely manner. This paper tries to generalize the quality assessment operations by providing a new ISO-based declarative data quality assessment framework (BIGQA). BIGQA is a flexible solution that supports data...
[Read More]
The Struggle with AI Content Detectors
Tech Blog
Searching between two date values in SQL Server
MSSQLTips.com
When working with databases, it is common to encounter scenarios where you must search for data within a specific date range. Fortunately, Microsoft SQL Server provides several methods for performing these types of searches with T-SQL. This SQL tutorial illustrates some of the most common techniques for searching between two...
[Read More]
Interviewing ChatGPT: Everything you need to know about Prompt Engineering
Tech Blog
Interviewing ChatGPT: What about Data Engineering?
Tech Blog
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
Tech Blog
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...
[Read More]
Working with Date and Time Data Types in SQL Server
MSSQLTips.com
Learn SQL: Insert multiple rows commands
SQL Shack
How to use the SQL WHERE Clause with Examples
MSSQLTips.com
MSSQLTips Rookie of the year winner
MSSQLTips.com
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...
[Read More]
Getting started with SSIS External Configuration File
MSSQLTips.com
SSIS Interview Questions and Answers for Developers and DBAs
MSSQLTips.com
Write for Tech Blog
Tech Blog
Fixing Cannot Convert Between Unicode and Non-Unicode String Data Types in SSIS
MSSQLTips.com
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.
[Read More]
Migrate Data from SQL Server to MongoDB using SSIS
MSSQLTips.com
This article gives an overview of the approaches to migrating SQL Server data to a MongoDB database.
[Read More]
Learn SQL standard deviation function
SQL Shack
MSSQLTips Rookie of the year award (2022)
MSSQLTips.com
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...
[Read More]