This article presents a way that finds a perfect match in any bipartite graph or shows why one cannot exist.
The post How To Find A Perfect Match appeared first on SQLServerCentral.
Plotting in Python for Financial Time Series Data for Exponential Moving Averages
Learn how to plot a financial time series using SQL Server data and Python to reveal the value of exponential moving averages and make decisions about time series values.
The post Plotting in Python for Financial Time Series Data for Exponential Moving Averages appeared first on SQLServerCentral.
The post Plotting in Python for Financial Time Series Data for Exponential Moving Averages appeared first on SQLServerCentral.
Sharing knowledge in communities of practice
Communities of practice bring people together to share ideas and learn from each other about a common interest. In this article, Robert Sheldon explains and gives some advice on starting them.
The post Sharing knowledge in communities of practice appeared first on SQLServerCentral.
The post Sharing knowledge in communities of practice appeared first on SQLServerCentral.
Register Now For PASS Data Community Summit 2021
Registration is now open for our free and online data platform conference. Join 1000s of your data peers at PASS Data Community Summit and get access to up to 5 days of training, sessions, networking activities, and events. This year's program has been carefully designed to help you achieve your goals, wherever you are in your data career.
The post Register Now For PASS Data Community Summit 2021 appeared first on SQLServerCentral.
The post Register Now For PASS Data Community Summit 2021 appeared first on SQLServerCentral.
Create, Populate, and Subset a Pandas Dataframe from a CSV File
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.
The post Create, Populate, and Subset a Pandas Dataframe from a CSV File appeared first on SQLServerCentral.
The post Create, Populate, and Subset a Pandas Dataframe from a CSV File appeared first on SQLServerCentral.
Connect to and Query Salesforce Data in QlikView
This short article shows how to connect to Salesforce data with CData and produce a chart from a query.
The post Connect to and Query Salesforce Data in QlikView appeared first on SQLServerCentral.
The post Connect to and Query Salesforce Data in QlikView appeared first on SQLServerCentral.
Discovering What’s Changed by Flyway Migrations
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.
The post Discovering What’s Changed by Flyway Migrations appeared first on SQLServerCentral.
The post Discovering What’s Changed by Flyway Migrations appeared first on SQLServerCentral.
Join SQL Server tables where columns include NULL values
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.
The post Join SQL Server tables where columns include NULL values appeared first on SQLServerCentral.
The post Join SQL Server tables where columns include NULL values appeared first on SQLServerCentral.