ado.net (1) arangodb (2) balanced data distributor (1) big data (12) biml (11) c# (11) certification (1) cloud computing (1) csv (2) cursors (1) data engineering (6) data integration (6) data profiling (1) data quality (2) data types (4) derived column (1) dtexec (1) dynamic sql (1) excel (2) expressions (1) ezapi (2) flat file (1) flume (1) ftp (1) graph database (4) hadoop (7) hadoop 3 (2) hive (2) hive 3 (1) information technology (1) json (1) kafka (1) loops (1) manageddts (1) manticore search (1) mdx (1) melissa data (1) mongodb (2) neo4j (4) networking (1) odbc (1) olap (5) ole db (3) oracle (1) pig (2) pricing (1) profiler (1) pyspark (1) python (2) radiation data (2) raw data (1) risk management (1) schema Mapping (1) schema mapping (2) script component (1) script task (1) sp_executesql (1) sp_whoisactive (1) spark (1) sphinx search (3) sql (13) sql server (32) ssas (6) ssis (49) ssrs (2) tabular (1) tsql (2) ubuntu (1) ubuntu 16 (1) windows (4) windows 10 (3) xml (2)

 ado.net (1)

SSIS Connection Managers: OLE DB vs ODBC vs ADO.NET

 arangodb (2)

Migrating SQL Server graph databases to ArangoDB
Free data certification exams you should take!

 balanced data distributor (1)

SSIS Balanced Data Distributor Overview

 big data (12)

Nine features that made SQL Server more than a traditional DBMS
Reasons to not install Hadoop on Windows
Installing Apache Pig 0.17.0 on Windows 10
Installing Apache Hive 3.1.2 on Windows 10
Installing Hadoop 3.2.1 Single node cluster on Windows 10
ORADIEX: A Big Data driven smart framework for real-time surveillance and analysis of individual exposure to radioactive pollution
Do you really need to implement Big Data technologies in your ecosystem?
RaDEn: A Scalable and Efficient Radiation Data Engineering
Big Data Integration
Getting Started With Apache Spark, Python and PySpark
Getting Started with Apache Kafka and Apache Flume (Import data to HDFS)
Installing Hadoop 3.1.0 multi-node cluster on Ubuntu 16.04 Step by Step

 biml (11)

Building SSAS tabular models using Biml
Building SSAS OLAP cubes using Biml
Automating SSIS package creation: ManagedDTS vs. EzAPI vs. BIML vs. ETLGen
Building databases using Biml
Biml alternatives: Building SSIS packages programmatically using EzAPI
Biml alternatives: Building SSIS packages programmatically using ManagedDTS
Using external C# script files within Biml
Extending Biml with C# scripts
Converting SSIS packages to Biml scripts
Using Biml scripts to generate SSIS packages
Getting started with Biml

 c# (11)

Adding MySQL, SQLite, and Oracle support to SchemaMapper
Created a Nuget package for SchemaMapper class library
Biml alternatives: Building SSIS packages programmatically using EzAPI
Biml alternatives: Building SSIS packages programmatically using ManagedDTS
Using external C# script files within Biml
Extending Biml with C# scripts
Converting SSIS packages to Biml scripts
Using Biml scripts to generate SSIS packages
How to get GraphLayout XML from programmatically generated SSIS package?
C# - Extract objects from SQL Command
Announcing SchemaMapper a C# data integration class library

 certification (1)

Free data certification exams you should take!

 cloud computing (1)

Pricing on the Cloud

 csv (2)

SSIS Flat file could not deal with NUL (\x00) value
How to load mixed record type fixed width file with two headers into two separate files?

 cursors (1)

An overview of the SQL cursor @@FETCH_STATUS function

 data engineering (6)

ORADIEX: A Big Data driven smart framework for real-time surveillance and analysis of individual exposure to radioactive pollution
Do you really need to implement Big Data technologies in your ecosystem?
RaDEn: A Scalable and Efficient Radiation Data Engineering
An Introduction to Data quality
Big Data Integration
Getting Started with Apache Kafka and Apache Flume (Import data to HDFS)

 data integration (6)

Import data from MongoDB to SQL Server using SSIS
Automating SSIS package creation: ManagedDTS vs. EzAPI vs. BIML vs. ETLGen
Adding MySQL, SQLite, and Oracle support to SchemaMapper
Created a Nuget package for SchemaMapper class library
Announcing SchemaMapper a C# data integration class library
Big Data Integration

 data profiling (1)

An overview of the Data Profiling task in SSIS

 data quality (2)

Melissa Data Quality free components for SSIS
An Introduction to Data quality

 data types (4)

SQL Server functions for converting a String to a Date
Yet another bunch of SQL string functions
An overview of SQL String Functions
SSIS Data types: Change from the Advanced Editor vs Data Conversion Transformations

 derived column (1)

SSIS Derived Columns with Multiple Expressions vs Multiple Transformations

 dtexec (1)

An overview of the DTExec utility in SSIS

 dynamic sql (1)

Working with parameters in the sp_executesql stored procedure

 excel (2)

SSIS Extract links from Excel cells to load into SQL
C# Script in SSIS Script Task to convert Excel Column in "Text" Format to "General"

 expressions (1)

SSIS Expression Tasks vs Evaluating variables as expressions

 ezapi (2)

Automating SSIS package creation: ManagedDTS vs. EzAPI vs. BIML vs. ETLGen
Biml alternatives: Building SSIS packages programmatically using EzAPI

 flat file (1)

SSIS Flat Files vs Raw Files

 flume (1)

Getting Started with Apache Kafka and Apache Flume (Import data to HDFS)

 ftp (1)

An overview of the SSIS FTP Task

 graph database (4)

Migrating SQL Server graph databases to ArangoDB
Export indexes and constraints from SQL Server graph databases to Neo4j
Migrating SQL Server graph databases to Neo4j
Getting started with the Neo4j graph database

 hadoop (7)

Reasons to not install Hadoop on Windows
Connecting to Apache Hive and Apache Pig using SSIS Hadoop components
SSIS Hadoop Connection Manager and related tasks
Importing and Exporting data using SSIS Hadoop components
Installing Hadoop 3.2.1 Single node cluster on Windows 10
Getting Started with Apache Kafka and Apache Flume (Import data to HDFS)
Installing Hadoop 3.1.0 multi-node cluster on Ubuntu 16.04 Step by Step

 hadoop 3 (2)

Installing Hadoop 3.2.1 Single node cluster on Windows 10
Installing Hadoop 3.1.0 multi-node cluster on Ubuntu 16.04 Step by Step

 hive (2)

Connecting to Apache Hive and Apache Pig using SSIS Hadoop components
Installing Apache Hive 3.1.2 on Windows 10

 hive 3 (1)

Installing Apache Hive 3.1.2 on Windows 10

 information technology (1)

How Information Technologies influenced Risk Management?

 json (1)

SQL Server JSON functions, a bridge between NoSQL and relational worlds

 kafka (1)

Getting Started with Apache Kafka and Apache Flume (Import data to HDFS)

 loops (1)

SSIS Foreach Loop vs For Loop Container

 manageddts (1)

Biml alternatives: Building SSIS packages programmatically using ManagedDTS
Manticore search: a continuation of the Sphinx search engine

 mdx (1)

Linking relational databases with OLAP cubes

 melissa data (1)

Melissa Data Quality free components for SSIS

 mongodb (2)

Free data certification exams you should take!
Import data from MongoDB to SQL Server using SSIS

 neo4j (4)

Export indexes and constraints from SQL Server graph databases to Neo4j
Free data certification exams you should take!
Migrating SQL Server graph databases to Neo4j
Getting started with the Neo4j graph database

 networking (1)

Ad-Hoc networks QoS and Security overview

 odbc (1)

SSIS Connection Managers: OLE DB vs ODBC vs ADO.NET

 olap (5)

Building SSAS OLAP cubes using Biml
Manipulating SSAS OLAP cubes using SSIS
Linking relational databases with OLAP cubes
An efficient approach to process a SSAS multidimensional OLAP cube
Retrieve multidimensional database objects directories

 ole db (3)

SSIS Connection Managers: OLE DB vs ODBC vs ADO.NET
SSIS OLE DB Destination vs SQL Server Destination
SSIS OLE DB Source: SQL Command vs Table or View

 oracle (1)

SSIS, query Oracle table using ID's from SQL Server?

 pig (2)

Connecting to Apache Hive and Apache Pig using SSIS Hadoop components
Installing Apache Pig 0.17.0 on Windows 10

 pricing (1)

Pricing on the Cloud

 profiler (1)

An overview of the SQL Server Profiler

 pyspark (1)

Getting Started With Apache Spark, Python and PySpark

 python (2)

Different approaches to execute Python in SQL Server
Getting Started With Apache Spark, Python and PySpark

 radiation data (2)

ORADIEX: A Big Data driven smart framework for real-time surveillance and analysis of individual exposure to radioactive pollution
RaDEn: A Scalable and Efficient Radiation Data Engineering

 raw data (1)

SSIS Flat Files vs Raw Files

 risk management (1)

How Information Technologies influenced Risk Management?

 schema Mapping (1)

Announcing SchemaMapper a C# data integration class library

 schema mapping (2)

Adding MySQL, SQLite, and Oracle support to SchemaMapper
Created a Nuget package for SchemaMapper class library

 script component (1)

SSIS Script Component Overview

 script task (1)

SSIS Script Task error: Exception has been thrown by the target of an invocation

 sp_executesql (1)

Working with parameters in the sp_executesql stored procedure

 sp_whoisactive (1)

Monitoring activities using sp_WhoIsActive in SQL Server

 spark (1)

Getting Started With Apache Spark, Python and PySpark
Manticore search: a continuation of the Sphinx search engine
Building full-text indexes using the Sphinx search engine
Getting started with Sphinx search engine

 sql (13)

Popular free SQL online compilers
SSIS: Execute T-SQL Statement Task vs Execute SQL Task
SQL Server functions for converting a String to a Date
A SQL join on multiple tables: overview and implementation
An overview of the SQL cursor @@FETCH_STATUS function
Yet another bunch of SQL string functions
An overview of SQL String Functions
An overview of the SQL Server Profiler
SQL OFFSET FETCH Feature: Loading Large Volumes of Data Using Limited Resources with SSIS
Execute SQL Task in SSIS: Output Parameters vs Result Sets
Execute SQL Task in SSIS: SqlStatementSource Expressions vs Variable Source Types
SSIS OLE DB Source: SQL Command vs Table or View
C# - Extract objects from SQL Command

 sql server (32)

SSIS, query Oracle table using ID's from SQL Server?
How to write subqueries in SQL?
An overview of the SQL Server ISNUMERIC function
Migrating SQL Server graph databases to ArangoDB
Different approaches to execute Python in SQL Server
Working with parameters in the sp_executesql stored procedure
Export indexes and constraints from SQL Server graph databases to Neo4j
Microsoft SQL Server Gurus you should follow
Migrating SQL Server graph databases to Neo4j
Import data from MongoDB to SQL Server using SSIS
Automating SSIS package creation: ManagedDTS vs. EzAPI vs. BIML vs. ETLGen
Nine features that made SQL Server more than a traditional DBMS
Building databases using Biml
Building full-text indexes using the Sphinx search engine
Getting started with Sphinx search engine
SQL Server JSON functions, a bridge between NoSQL and relational worlds
Biml alternatives: Building SSIS packages programmatically using EzAPI
Biml alternatives: Building SSIS packages programmatically using ManagedDTS
Monitoring activities using sp_WhoIsActive in SQL Server
SSIS: Execute T-SQL Statement Task vs Execute SQL Task
SQL Server functions for converting a String to a Date
A SQL join on multiple tables: overview and implementation
An overview of the SQL cursor @@FETCH_STATUS function
Yet another bunch of SQL string functions
Linking relational databases with OLAP cubes
An overview of SQL String Functions
An overview of the SQL Server Profiler
An overview of the Data Profiling task in SSIS
SQL OFFSET FETCH Feature: Loading Large Volumes of Data Using Limited Resources with SSIS
Execute SQL Task in SSIS: Output Parameters vs Result Sets
SSIS OLE DB Destination vs SQL Server Destination
Fast load error output doesn't redirect entire batch

 ssas (6)

Building SSAS tabular models using Biml
Building SSAS OLAP cubes using Biml
Manipulating SSAS OLAP cubes using SSIS
Linking relational databases with OLAP cubes
An efficient approach to process a SSAS multidimensional OLAP cube
Retrieve multidimensional database objects directories

 ssis (49)

SSIS Pivot transformation vs. Unpivot transformation
SSIS, query Oracle table using ID's from SQL Server?
SSIS Lookup transformation vs. Fuzzy Lookup transformation
An overview of the VS_NEEDSNEWMETADATA SSIS exception
Import data from MongoDB to SQL Server using SSIS
Automating SSIS package creation: ManagedDTS vs. EzAPI vs. BIML vs. ETLGen
Building databases using Biml
Melissa Data Quality free components for SSIS
Connecting to Apache Hive and Apache Pig using SSIS Hadoop components
SSIS Hadoop Connection Manager and related tasks
Importing and Exporting data using SSIS Hadoop components
An overview of the DTExec utility in SSIS
Biml alternatives: Building SSIS packages programmatically using EzAPI
Biml alternatives: Building SSIS packages programmatically using ManagedDTS
An overview of the SSIS FTP Task
Using external C# script files within Biml
Extending Biml with C# scripts
Converting SSIS packages to Biml scripts
Using Biml scripts to generate SSIS packages
SSIS: Execute T-SQL Statement Task vs Execute SQL Task
How to get GraphLayout XML from programmatically generated SSIS package?
Getting started with Biml
Manipulating SSAS OLAP cubes using SSIS
SSIS Extract links from Excel cells to load into SQL
SSIS Foreach Loop vs For Loop Container
SSIS Balanced Data Distributor Overview
An overview of the Data Profiling task in SSIS
SQL OFFSET FETCH Feature: Loading Large Volumes of Data Using Limited Resources with SSIS
SSIS Script Component Overview
SSIS Flat Files vs Raw Files
SSIS XML Destination
SSIS Data types: Change from the Advanced Editor vs Data Conversion Transformations
SSIS Connection Managers: OLE DB vs ODBC vs ADO.NET
SSIS Derived Columns with Multiple Expressions vs Multiple Transformations
Execute SQL Task in SSIS: Output Parameters vs Result Sets
Execute SQL Task in SSIS: SqlStatementSource Expressions vs Variable Source Types
SSIS OLE DB Destination vs SQL Server Destination
SSIS Expression Tasks vs Evaluating variables as expressions
SSIS OLE DB Source: SQL Command vs Table or View
SSIS Flat file could not deal with NUL (\x00) value
An efficient approach to process a SSAS multidimensional OLAP cube
C# Script in SSIS Script Task to convert Excel Column in "Text" Format to "General"
Fast load error output doesn't redirect entire batch
SSIS Script Task error: Exception has been thrown by the target of an invocation
How to load mixed record type fixed width file with two headers into two separate files?
How to Map Input and Output Columns dynamically in SSIS?
Date calculation with parameter in SSIS is not giving the correct result
How to check column structure in ssis?
Automate Version number Retrieval from .Dtsx files

 ssrs (2)

Report dates not working correctly if date format is not mm/dd/yyyy
How can I fix the number of groups in each page of SSRS

 tabular (1)

Building SSAS tabular models using Biml

 tsql (2)

Popular free SQL online compilers
Top free T-SQL training videos

 ubuntu (1)

Installing Hadoop 3.1.0 multi-node cluster on Ubuntu 16.04 Step by Step

 ubuntu 16 (1)

Installing Hadoop 3.1.0 multi-node cluster on Ubuntu 16.04 Step by Step

 windows (4)

Reasons to not install Hadoop on Windows
Installing Apache Pig 0.17.0 on Windows 10
Installing Apache Hive 3.1.2 on Windows 10
Installing Hadoop 3.2.1 Single node cluster on Windows 10

 windows 10 (3)

Installing Apache Pig 0.17.0 on Windows 10
Installing Apache Hive 3.1.2 on Windows 10
Installing Hadoop 3.2.1 Single node cluster on Windows 10

 xml (2)

How to get GraphLayout XML from programmatically generated SSIS package?
SSIS XML Destination