Introduction We can use the delete activity in Azure Data Factory to delete files from both on-premises and cloud storage. In this article, we will discuss the delete activity with the various options available for the file deletion. I will show the following operations with the Delete Activity: Delete files from a folder. Delete contents […]
The post Working with the Delete Activity in Azure Data Factory appeared first on SQLServerCentral.

The very definition of open-source software means that developers can change the code, which means that exclusive, paid, licensing is not a part of the deal. In short, open-source is free. Free of licensing anyway. So, why might you choose to pay for an open-source software like Flyway? Grant Fritchey explores.
The post Why pay for open-source software? appeared first on SQLServerCentral.

LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to other techniques
The post How LAG compares to other techniques appeared first on SQLServerCentral.

If your company uses legacy technology systems, you can use the UiPath RPA platform to extend your process automation capabilities to these systems and eliminate repetitive, error-prone tasks of manually updating them. By using UiPath Studio, you can build an RPA program just like drawing a diagram.  With the CData ODBC Driver for Oracle, users can embed Oracle data in the workflow.  Let’s […]
The post Create an RPA Flow that Connects to Oracle Data in UiPath Studio appeared first on SQLServerCentral.

In the second part of this PostgreSQL date time series, we examine a number of commonly used functions for getting current dates and times and converting strings to dates and times.
The post PostgreSQL Date And Time Part 2 appeared first on SQLServerCentral.

IDC’s recent Global DataSphere Forecast, 2021-2025 predicts that global data creation and replication will experience a compound annual growth rate of 23% over the forecast period. But what’s causing the growth? Where will all of that extra data be stored? And how should we, as data professionals, prepare for it? Read this blog to explore these important questions.
The post What's the real story behind the explosive growth of data? appeared first on SQLServerCentral.

In this tip we will look at using a Streaming Dataset in Power BI to visualize real time data using the streaming service Azure Stream Analytics job.
The post Real-Time Streaming using Power BI Streaming Dataset appeared first on SQLServerCentral.

The wide ecosystem of Python modules enables you get to work fast and effectively integrate your systems. You can use the CData Python Connector for MongoDB and the SQLAlchemy toolkit to build MongoDB-connected Python applications and scripts.  This article details how to use SQLAlchemy to connect to MongoDB data to query, update, delete, and insert MongoDB data.  Connecting to MongoDB Data  Connecting to MongoDB data is similar to connecting to any other relational database. Create a […]
The post Use SQLAlchemy ORMs to Access MongoDB Data in Python appeared first on SQLServerCentral.