This article is a supplement to the previously published article, An overview of SQL String Functions . This time, we will describe another bunch of SQL string functions used in SQL Server.
Read more »
Hadi Fadlallah
Hadi Fadlallah
Hadi is a Lebanese Researcher, Data Engineer and Business Intelligence Developer.
He has been working with SQL Server for more than 10 years. Also, he's one of the top ETL and SQL Server Integration Services contributors at Stackoverflow.com
Hadi really enjoys learning new things everyday and sharing his knowledge.
View all posts by Hadi Fadlallah
He has been working with SQL Server for more than 10 years. Also, he's one of the top ETL and SQL Server Integration Services contributors at Stackoverflow.com
Hadi really enjoys learning new things everyday and sharing his knowledge.
View all posts by Hadi Fadlallah
Latest posts by Hadi Fadlallah (see all)
- Yet another bunch of SQL string functions - January 13, 2020
- Linking relational databases with OLAP cubes - January 10, 2020
- An overview of SQL String Functions - December 25, 2019
Linking relational databases with OLAP cubes
January 10, 2020One of the most asked questions is how to link an OLAP cube with a relational database, or in another way how to join the result of an MDX query with a table stored in a relational database.
Read more »An overview of SQL String Functions
December 25, 2019In this article, we will try to give a brief overview of the SQL string functions used in SQL Server and we will provide some examples.
Read more »
An overview of the SQL Server Profiler
December 9, 2019In this article, we will describe SQL Server Profiler and how it can be used. In addition, we will mention the tools that are integrated with it- plans about its deprecation, and what are the alternatives?
Read more »
SSIS Foreach Loop vs For Loop Container
December 4, 2019In this article, first, we will briefly describe foreach loops and for loops. Then, we will give an overview of SSIS Foreach Loop Container and For Loop Container. Finally, we will compare these two containers.
Read more »
SSIS Balanced Data Distributor Overview
November 22, 2019In this article, we will give a brief overview of SSIS Balanced Data Distributor (BDD). In addition, we will give some examples and illustrate alternatives.
Read more »
Overview of Data Profiling tasks in SSIS
November 21, 2019The Data Profiling task in SSIS is an important task that can be used to assess the quality of data sources. Unfortunately, this component is not widely used by many business intelligence developers.
Read more »
SQL OFFSET FETCH Feature: Loading Large Volumes of Data Using Limited Resources with SSIS
November 14, 2019In this article, we illustrate how to use the OFFSET FETCH feature as a solution for loading large volumes of data from a relational database using a machine with limited memory and preventing an out of memory exception. We describe how to load data in batches to avoid placing a large amount of data into memory.
Read more »
SSIS Flat Files vs Raw Files
October 29, 2019In this article, we will give an overview of using Flat Files and Raw Files in SSIS, then we will illustrate some of the differences between using these two types.
Read more »
SSIS Script Component Overview
October 29, 2019SSIS Script component is a prominent strength of SQL Server Integration Services since it allows developers to implement any complex logic and utilize libraries from the powerful .NET framework or third-parties.
Read more »
SSIS XML Destination
October 11, 2019Until now, Microsoft has not included the XML Destination component in SQL Server Integration Services (SSIS). Many years ago, this component was requested on the Microsoft connect website, but it was closed as “Won’t fix.” For this reason, many workarounds and third-party components were created. In this article, we’ll talk about these components and some of the popular solutions for exporting data to XML using SSIS.
Read more »
SSIS Connection Managers: OLE DB vs ODBC vs ADO.NET
October 4, 2019In this article, I will first give an overview of the OLE DB, ODBC, and ADO.NET SSIS connection managers. Then I will try to illustrate the difference between them when trying to connect to SQL Server.
Read more »
SSIS Data types: Change from the Advanced Editor vs Data Conversion Transformations
October 4, 2019In this article, I will first give an overview of SSIS data types and data types conversion methods and then I will illustrate the difference between changing the columns data types from the Source Advanced editor and using Data Conversion Transformation.
Read more »
SSIS Derived Columns with Multiple Expressions vs Multiple Transformations
September 25, 2019In this article, we will first give an overview on SSIS derived column transformation, then we will run an experiment to check if there is any difference between adding multiple expressions within one derived column transformation and adding a derived column transformation for each expression.
Read more »
Execute SQL Tasks in SSIS: Output Parameters vs Result Sets
September 17, 2019In the previous article, I gave an overview of Execute SQL Task in SSIS and we illustrated some of the differences between writing an expression to evaluate SqlStatementSource property and writing this expression within a variable and change the Execute SQL Task Source Type to variable.
Read more »
Execute a SQL Task in SSIS: SqlStatementSource Expressions vs Variable Source Types
September 9, 2019In this article, I will give an overview of Execute SQL Task in SSIS and I will try to illustrate some of the differences between writing an expression to evaluate SqlStatementSource property or writing this expression within a variable and change the Execute SQL Task Source Type to variable.
Read more »
SSIS OLE DB Destination vs SQL Server Destination
August 30, 2019In this article, I will give an overview of SSIS OLE DB Destination and SQL Server Destination and I will try to illustrate some of the difference between both destination components based on my personal experience, SSIS official documentation and some other experts experience in this domain.
Read more »
SSIS Expression Tasks vs Evaluating variables as expressions
August 27, 2019In this article, I will first give an introduction about SSIS expressions, then I will describe briefly the Expression Task and how to Evaluate a variable as expression. Then I will do a comparison between these two features to illustrate the similarities and differences between them.
Read more »
SSIS OLE DB Source: SQL Command vs Table or View
August 22, 2019Introduction
SQL Server Integration Services provides a wide variety of features that helps developers to build a robust Extract, Transform and Load process. After many years contributing to SSIS related tags on Stackoverflow.com, I can say that many developers have some misunderstanding about SSIS features (SSIS OLE DB Source, SSIS Expressions, SQL Server destination …) especially those which are very similar and have some common usability.
Read more »
An efficient approach to process a SSAS multidimensional OLAP cube
August 15, 2019Introduction
While building and deploying an SSAS OLAP cube, there are two processing orders that you can choose from when you create a process operation:
Read more »