I've recently moved house from Massachusetts to Oklahoma. Long story. Anyway, sitting in my new office looking out at the trees, some of the leaves are starting to change. Ah, Fall. Lovely Autumn colors... WAIT! Actually, something else is going on. Only a few trees are changing color. Word is, we've been a little dry […]
Data can enhance the experience our client's have with software.
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 […]
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.
This short article shows how to connect to Salesforce data with CData and produce a chart from a query.
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.
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.
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.
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.
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 […]
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major...
The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first...
Hi All, I have plan to upgrade SSIS and SSRS from SQL Server 2016,...
Comments posted to this topic are about the item Do You Want a Microsoft...
Comments posted to this topic are about the item The Density Vector
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers