AI content detectors (1) Stack overflow (1) ado.net (1) arangodb (2) awards (2) balanced data distributor (1) big data (14) biml (11) blogging (1) c# (13) certification (1) chatgpt (4) cloud computing (1) clr (1) context awareness (2) csv (2) cursors (1) data engineering (7) data integration (6) data management (2) data profiling (2) data quality (8) data types (5) data visualization (1) data wrangling (1) derived column (1) dtexec (1) dynamic sql (1) excel (2) expressions (1) ezapi (2) flat file (1) flume (1) free certification (1) ftp (1) google search (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 (5) monitoring (1) neo4j (4) networking (1) odbc (1) olap (5) ole db (3) oracle (1) pig (2) pricing (1) profiler (1) prompt engineering (1) pyspark (1) python (3) 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 (23) sql injection (1) sql parameters (1) sql server (62) ssas (6) ssis (69) ssrs (2) stack overflow (17) tabular (1) tds (12) technical writing (1) time series (1) tsql (3) ubuntu (1) ubuntu 16 (1) visual studio (1) windows (4) windows 10 (3) xml (3)

 AI content detectors (1)

The Struggle with AI Content Detectors

 Stack overflow (1)

Top 3 Skills for Computer Scientists in 2023

 ado.net (1)

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

 arangodb (2)

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

 awards (2)

MSSQLTips Rookie of the year winner
MSSQLTips Rookie of the year award (2022)

 balanced data distributor (1)

SSIS Balanced Data Distributor Overview

 big data (14)

Context-aware big data quality assessment: a scoping review
BIGQA: Declarative Big Data Quality Assessment
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
SSIS packages automation tools
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

 blogging (1)

Write for Tech Blog

 c# (13)

Import flat files into seperate SQL Server Tables using SSIS
Getting started with SQL Server CLR functions
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 database certification exams you should take!

 chatgpt (4)

The Struggle with AI Content Detectors
Interviewing ChatGPT: Everything you need to know about Prompt Engineering
Interviewing ChatGPT: What about Data Engineering?
Top 3 Skills for Computer Scientists in 2023

 cloud computing (1)

Pricing on the Cloud

 clr (1)

Getting started with SQL Server CLR functions

 context awareness (2)

Context-aware big data quality assessment: a scoping review
BIGQA: Declarative Big Data Quality Assessment

 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 (7)

Interviewing ChatGPT: What about Data Engineering?
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
SSIS packages automation tools
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 management (2)

Towards Data Quality: An Overview of SQL Server Data Quality Solutions
Towards Data Quality: an Introduction

 data profiling (2)

SQL Script for SQL Server Table and Column Properties
An overview of the Data Profiling task in SSIS

 data quality (8)

SQL Script for SQL Server Table and Column Properties
Data Wrangling in SQL Server for Cleaning, Transforming and Merging Data
Towards Data Quality: An Overview of SQL Server Data Quality Solutions
Towards Data Quality: an Introduction
Context-aware big data quality assessment: a scoping review
BIGQA: Declarative Big Data Quality Assessment
Melissa Data Quality free components for SSIS
An Introduction to Data quality

 data types (5)

Why is the SSIS variable not passing the milliseconds part into the query?
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

 data visualization (1)

Build Python Matplotlib Charts to Visualize Application Log Data

 data wrangling (1)

Data Wrangling in SQL Server for Cleaning, Transforming and Merging Data

 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)

SSIS packages automation tools
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)

 free certification (1)

Professional Certification Exams provided at NO COST

 ftp (1)

An overview of the SSIS FTP Task
Top 3 Skills for Computer Scientists in 2023

 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 (5)

Different methods for monitoring MongoDB databases
Migrate Data from SQL Server to MongoDB using SSIS
Is it Possible to Load data to MongoDB Using SSIS?
Free database certification exams you should take!
Import data from MongoDB to SQL Server using SSIS

 monitoring (1)

Different methods for monitoring MongoDB databases

 neo4j (4)

Export indexes and constraints from SQL Server graph databases to Neo4j
Free database 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

 prompt engineering (1)

Interviewing ChatGPT: Everything you need to know about Prompt Engineering

 pyspark (1)

Getting Started With Apache Spark, Python and PySpark

 python (3)

Build Python Matplotlib Charts to Visualize Application Log Data
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 (23)

An overview of SQL Server monitoring tools
SQL Script for SQL Server Table and Column Properties
Data Wrangling in SQL Server for Cleaning, Transforming and Merging Data
Implicit Conversion Concerns for SQL Server Performance
Searching between two date values in SQL Server
Working with Date and Time Data Types in SQL Server
Learn SQL: Insert multiple rows commands
How to use the SQL WHERE Clause with Examples
Learn SQL standard deviation function
An overview of the SQL GROUP BY clause
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 injection (1)

Using parameterized queries to avoid SQL injection

 sql parameters (1)

Using parameterized queries to avoid SQL injection

 sql server (62)

An overview of SQL Server monitoring tools
SQL Script for SQL Server Table and Column Properties
Data Wrangling in SQL Server for Cleaning, Transforming and Merging Data
Implicit Conversion Concerns for SQL Server Performance
Towards Data Quality: An Overview of SQL Server Data Quality Solutions
Searching between two date values in SQL Server
Working with Date and Time Data Types in SQL Server
Learn SQL: Insert multiple rows commands
How to use the SQL WHERE Clause with Examples
Getting started with SSIS External Configuration File
SSIS Interview Questions and Answers for Developers and DBAs
Fixing Cannot Convert Between Unicode and Non-Unicode String Data Types in SSIS
Migrate Data from SQL Server to MongoDB using SSIS
Learn SQL standard deviation function
An overview of the SQL GROUP BY clause
SSIS Bad Habits: Decreasing SSIS Package Performance
Using parameterized queries to avoid SQL injection
SSIS Bad Habits: Inefficient Data Staging Strategies - Part 2
xp_cmdshell and sp_xp_cmdshell_proxy_account stored procedures in SQL Server
SSIS Bad Habits: Slow lookup transformations
SSIS Bad Habits: Wrong OLE DB components configuration
SSIS Bad Habits: Inefficient Data Staging Strategies
SSIS Bad Habits: Using Sort and Merge Join Components
SSIS Extension for Visual Studio 2022
An overview of DIFFERENCE and SOUNDEX SQL functions
Import flat files into seperate SQL Server Tables using SSIS
Getting started with SQL Server CLR functions
Why is the SSIS variable not passing the milliseconds part into the query?
How to using STRING_SPLIT within an SSIS OLE DB Source SQL Command when the database compatibility level is set to is set to SQL Server 2008?
Is it Possible to Load data to MongoDB Using SSIS?
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
SSIS packages automation tools
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 (69)

Getting started with SSIS External Configuration File
SSIS Interview Questions and Answers for Developers and DBAs
Fixing Cannot Convert Between Unicode and Non-Unicode String Data Types in SSIS
Migrate Data from SQL Server to MongoDB using SSIS
SSIS Bad Habits: Decreasing SSIS Package Performance
SSIS Bad Habits: Inefficient Data Staging Strategies - Part 2
SSIS Bad Habits: Slow lookup transformations
SSIS Bad Habits: Wrong OLE DB components configuration
SSIS Bad Habits: Inefficient Data Staging Strategies
SSIS Bad Habits: Using Sort and Merge Join Components
SSIS Extension for Visual Studio 2022
Import flat files into seperate SQL Server Tables using SSIS
Why is the SSIS variable not passing the milliseconds part into the query?
How to using STRING_SPLIT within an SSIS OLE DB Source SQL Command when the database compatibility level is set to is set to SQL Server 2008?
SSIS Term Extraction vs. Term Lookup
SSIS Script task vs. Script Component
Is it Possible to Load data to MongoDB Using SSIS?
SSIS XML Source vs. XML task
Data Access Modes in SSIS OLE DB Destination: SQL Command vs. Table or View
SSIS Merge Join vs. Merge Transformation
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
SSIS packages automation tools
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

 stack overflow (17)

SSIS Extension for Visual Studio 2022
Import flat files into seperate SQL Server Tables using SSIS
Why is the SSIS variable not passing the milliseconds part into the query?
How to using STRING_SPLIT within an SSIS OLE DB Source SQL Command when the database compatibility level is set to is set to SQL Server 2008?
Is it Possible to Load data to MongoDB Using SSIS?
SSIS, query Oracle table using ID's from SQL Server?
SSIS Extract links from Excel cells to load into SQL
SSIS Flat file could not deal with NUL (\x00) value
C# Script in SSIS Script Task to convert Excel Column in "Text" Format to "General"
Fast load error output doesn't redirect entire batch
Report dates not working correctly if date format is not mm/dd/yyyy
Retrieve multidimensional database objects directories
How to Map Input and Output Columns dynamically in SSIS?
How can I fix the number of groups in each page of SSRS
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

 tabular (1)

Building SSAS tabular models using Biml

 tds (12)

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
Do you really need to implement Big Data technologies in your ecosystem?
Fast load error output doesn't redirect entire batch
An Introduction to Data quality
Big Data Integration
Pricing on the Cloud
Getting Started With Apache Spark, Python and PySpark
How Information Technologies influenced Risk Management?
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

 technical writing (1)

Write for Tech Blog

 time series (1)

Build Python Matplotlib Charts to Visualize Application Log Data

 tsql (3)

An overview of DIFFERENCE and SOUNDEX SQL functions
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

 visual studio (1)

SSIS Extension for Visual Studio 2022

 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 (3)

SSIS XML Source vs. XML task
How to get GraphLayout XML from programmatically generated SSIS package?
SSIS XML Destination