SSIS stands for SQL Server Integration Services and is a solution for building data integrations and workflow applications that integrate with SQL Server databases. As data integration processes increase in importance, organizations are looking for ways to simplify integration and manage workflows. In this article, we'll walk you through how to design a data flow that adds new HubSpot contacts to a MailChimp list using CData SSIS Components for HubSpot and MailChimp. Connecting to HubSpot and MailChimp The […]

Create, Populate, and Subset a Pandas Dataframe from a CSV File

by Additional Articles

MSSQLTips.com

In this article we demonstrate how to transfer data via a CSV file from a SQL Server database to a Pandas dataframe and then subset the dataframe in Python.

Connect to and Query Salesforce Data in QlikView

by JerodJ

SQLServerCentral

This short article shows how to connect to Salesforce data with CData and produce a chart from a query.

Where We Need Better AI Disclosure and Responsibility

by Steve Jones

SQLServerCentral

Artificial Intelligence (AI)

The way that AI is used in the world can make it better, but not always. In either case, we ought to have some accountability for the models.

Discovering What’s Changed by Flyway Migrations

by Additional Articles

Redgate

Vendors/3rd-party Products

A set of PowerShell cmdlets that will 'diff' two versions of a database and provide a high-level overview of the major database changes made by successive Flyway migrations. You can 'diff' a SQL Server database to the same one on PostgreSQL and find out which objects are the same and which are different.

Join SQL Server tables where columns include NULL values

by Additional Articles

MSSQLTips.com

JOIN

Dealing with NULL values especially when joining tables can become a challenge. Let's take a look at this issue and how this can be resolved.

Eyes Wide Open

by Steve Jones

SQLServerCentral

software development

Trying to architect a new database system so that you don't outgrow it is a challenge, but the more you think about early, the better off you will be.

Tracking Failed Job Steps

by Steve Jones

SQLServerCentral

Recently a customer was asking for a way to alert on job steps that failed, but the job succeeded. They really wanted a custom metric for SQL Monitor, which I submitted, but this post looks at the query in general, trying to determine if a job step failed. Note: Let me start by noting that […]

Diagnose and resolve latch contention on SQL Server

by Additional Articles

SQLServerCentral

This guide describes how to identify and resolve latch contention issues observed when running SQL Server applications on high concurrency systems with certain workloads.

Schedule Azure SQL DB Processes using Azure Functions

by Additional Articles

MSSQLTips.com

Azure

Learn how to schedule processes in Azure SQL Database using an Azure Function in this easy to follow step by step tutorial.

Use SQL Server Integration Services to Add HubSpot Contacts to MailChimp Lists

Create, Populate, and Subset a Pandas Dataframe from a CSV File

Connect to and Query Salesforce Data in QlikView

Where We Need Better AI Disclosure and Responsibility

Discovering What’s Changed by Flyway Migrations

Join SQL Server tables where columns include NULL values

Eyes Wide Open

Tracking Failed Job Steps

Diagnose and resolve latch contention on SQL Server

Schedule Azure SQL DB Processes using Azure Functions

Blogs

SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First

Google Moves Up Post-Quantum Cryptography Timeline

The Book of Redgate: No Politics

Forums

Dancing Robot Goes Rogue

advice as i migrate my winscp based ssis pkg to our prod server

Identities and Sequences II

Question of the Day

Identities and Sequences II