In 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. A string function is a function that takes a string value as an input regardless of the data type of the returned value. In...
[Read More]
ORADIEX: A Big Data driven smart framework for real-time surveillance and analysis of individual exposure to radioactive pollution
BDCSIntell'2019
Radiation pollution has been always a critical concern, since it can cause a huge damage to humans and for nature. To minimize the damage, governments are collecting and monitoring radiation level using advanced systems. In the past years, Big data technologies such as distributed file systems, NoSQL databases and stream...
[Read More]
An overview of the SQL Server Profiler
SQL Shack
SSIS Foreach Loop vs For Loop Container
SQL Shack
SSIS Balanced Data Distributor Overview
SQL Shack
An overview of the Data Profiling task in SSIS
SQL Shack
The 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
SQL Shack
In 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...
[Read More]
SSIS Script Component Overview
SQL Shack
SSIS 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. In this article, we will give an overview of SSIS Script component, and illustrate the benefits of using it....
[Read More]
SSIS Flat Files vs Raw Files
SQL Shack
SSIS XML Destination
SQL Shack
Until 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...
[Read More]
SSIS Data types: Change from the Advanced Editor vs Data Conversion Transformations
SQL Shack
SSIS Connection Managers: OLE DB vs ODBC vs ADO.NET
SQL Shack
SSIS Derived Columns with Multiple Expressions vs Multiple Transformations
SQL Shack
Execute SQL Task in SSIS: Output Parameters vs Result Sets
SQL Shack
Execute SQL Task in SSIS: SqlStatementSource Expressions vs Variable Source Types
SQL Shack
SSIS OLE DB Destination vs SQL Server Destination
SQL Shack
SSIS Expression Tasks vs Evaluating variables as expressions
SQL Shack
SSIS OLE DB Source: SQL Command vs Table or View
SQL Shack
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,...
[Read More]
SSIS Flat file could not deal with NUL (\x00) value
Stack Overflow
An efficient approach to process a SSAS multidimensional OLAP cube
SQL Shack
While building and deploying an SSAS OLAP cube, there are two processing orders that you can choose from when you create a process operation: Parallel (All Objects will be processed in a single transaction): Used for batch processing, all tasks run in parallel inside one transaction. Sequential (Transaction mode): One...
[Read More]
C# Script in SSIS Script Task to convert Excel Column in "Text" Format to "General"
Stack Overflow
C# - Extract objects from SQL Command
Data Developers
Do you really need to implement Big Data technologies in your ecosystem?
Towards Data Science
From many years, “Big Data” has become widespread and trendy. The Big Data technologies started to fill the gap between the traditional data technologies (RDBMS, File systems … ) and the high evolution of the data and business needs. While implementing these technologies is a must for many large-scale organization...
[Read More]