This article compares the SSIS OLE DB Destination SQL command with the “Table or View” data access mode
Data Access Modes in SSIS OLE DB Destination: SQL Command vs. Table or View
SQL Shack
SSIS Merge Join vs. Merge Transformation
SQL Shack
SSIS Merge Join and Merge transformations are two similar components used to combine two input data sources into one output. This article explains both transformations and illustrates when and how to use each one of them.
SSIS Pivot transformation vs. Unpivot transformation
SQL Shack
This article explains the SSIS pivot transformation and how it differs from the unpivot transformation.
SSIS, query Oracle table using ID's from SQL Server?
Stack Overflow
How to filter data in Oracle based on a SQL Server query result?
Popular free SQL online compilers
SQL Shack
This article will mention some of the most popular free SQL online compilers that help developers debug and test their SQL code without installing an SQL instance locally or buying one on the cloud.
How to write subqueries in SQL?
SQL Shack
This article briefly explains how to write a subquery in SQL by providing examples.
SSIS Lookup transformation vs. Fuzzy Lookup transformation
SQL Shack
This article will explain how to use the SSIS lookup transformation and how it differs from the fuzzy lookup. This is a continuation of the SSIS features face-to-face series that we published previously on this website.
An overview of the SQL Server ISNUMERIC function
SQL Shack
This article gives an overview of the SQL Server ISNUMERIC built-in system function. It explains how to use this function, illustrates its limitations, and provides some alternatives.
Migrating SQL Server graph databases to ArangoDB
SQL Shack
This article will explain ArangoDB, how to install it on Windows, and how to migrate a SQL Server graph database to this NoSQL database management system.
An overview of the VS_NEEDSNEWMETADATA SSIS exception
SQL Shack
In this article, we will briefly explain the VS_NEEDSNEWMETADATA SSIS exception, one of the most popular exceptions that an ETL developer may face while using SSIS. Then, we will run an experiment that reproduces this error. Then, we will show how we can fix it.
Different approaches to execute Python in SQL Server
SQL Shack
This article briefly explains how to execute scripts written in Python in SQL Server and how Machine Learning services facilitate this process.
Top free T-SQL training videos
SQL Shack
This article mentions some of the top free T-SQL training videos available on the internet.
Working with parameters in the sp_executesql stored procedure
SQL Shack
This article explains how to use the sp_executesql system stored procedure to run static and dynamic SQL queries and how to pass input and output parameters while using it.
Export indexes and constraints from SQL Server graph databases to Neo4j
SQL Shack
This article is an extension of the previsouly published article “Migrating SQL Server graph databases to Neo4j”, where we will explain how to export the supported indexes and constraints from SQL Server to the Neo4j graph database.
Free database certification exams you should take!
Tech Blog
Professional certification recognizes your knowledge and experience and enhances your professional credibility. Many students and developers cannot get certified since they cannot pay the certifications exams fees. After a little research on the internet, I found several database certification exams available for free by leading database providers in the market....
[Read More]
Building SSAS tabular models using Biml
SQL Shack
This article will explain how to use the Business Intelligence Markup Language to create an SSAS tabular model.
Microsoft SQL Server Gurus you should follow
Tech Blog
This post mentions some SQL Server experts you need to know during your SQL Server journey. Those experts are Microsoft Most Valuable Professionals that highly contributed to SQL Server the community.
Building SSAS OLAP cubes using Biml
SQL Shack
In this article, we will explain how to use the Business Intelligence Markup Language (Biml) to build SSAS OLAP cubes, noting that this article is the ninth article in the Learn Biml series.
Migrating SQL Server graph databases to Neo4j
SQL Shack
This article provides a step-by-step guide for migrating SQL Server graph databases to Neo4j using C#.
Getting started with the Neo4j graph database
SQL Shack
In this article, we will talk briefly about graph databases and what Neo4j is. Then we will give a step-by-step guide on how to install and get started with Neo4j on Windows operating system.
Import data from MongoDB to SQL Server using SSIS
SQL Shack
In this article, we will explain how to install MongoDB on the Windows operating system, how to install and configure the ODBC driver and connector that allows us to import data from MongoDB to SQL Server using SSIS.
SSIS packages automation tools
Tech Blog
Even after the rise of Big Data technologies, Microsoft SQL Server Integration Services still one of the most popular data integration tools. Mainly, SSIS developers use Visual Studio to develop their data integration packages. One of the main challenges that face the SSIS developers is that they design tens of...
[Read More]
Adding MySQL, SQLite, and Oracle support to SchemaMapper
Tech Blog
As in the first release (1.0.0), SchemaMapper was developed to merge data from different file types (flat file, Excel, Access …) into one SQL table. SchemaMapper 1.1.0 was released after being improved to support reading from relational databases and writing data into more data formats. Also, SchemaMapper 1.1.0 is now...
[Read More]
Nine features that made SQL Server more than a traditional DBMS
Tech Blog
This article will briefly mention nine features added starting SQL Server 2008 that make SQL Server more than a traditional database management system.
Building databases using Biml
SQL Shack
In this article, we will explain how to build databases using BIML. We will be covering handling databases objects such as schemas, tables, columns, indexes, and other objects.