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
Migrating SQL Server graph databases to ArangoDB
SQL Shack
An overview of the VS_NEEDSNEWMETADATA SSIS exception
SQL Shack
Different approaches to execute Python in SQL Server
SQL Shack
Top free T-SQL training videos
SQL Shack
Working with parameters in the sp_executesql stored procedure
SQL Shack
Export indexes and constraints from SQL Server graph databases to Neo4j
SQL Shack
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
Microsoft SQL Server Gurus you should follow
Tech Blog
Building SSAS OLAP cubes using Biml
SQL Shack
Migrating SQL Server graph databases to Neo4j
SQL Shack
Getting started with the Neo4j graph database
SQL Shack
Import data from MongoDB to SQL Server using SSIS
SQL Shack
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
Building databases using Biml
SQL Shack
Manticore search: a continuation of the Sphinx search engine
SQL Shack
In this article, we will be talking about Manticore Search, which is an open-source search engine first released in 2017 as a fork of the Sphinx search engine. We will try to describe this search engine briefly, mention some of its differences from the Sphinx search engine, and we will...
[Read More]
Building full-text indexes using the Sphinx search engine
SQL Shack
Getting started with Sphinx search engine
SQL Shack
In this article, we will be talking about the Sphinx search engine and how to use it to install it on the Windows operating system. This is the first article in the “Sphinx Search Engine” series, where we will explain how to install and use this search engine to create...
[Read More]