Articles

SQLServerCentral Article

Connect to SAP HANA Data as a Linked Server

The SQL Gateway enables you to configure a TDS (SQL Server) remoting service and set up a linked server for SAP HANA data.  After you have started the service, you can use the UI in SQL Server Management Studio or call stored procedures to create the linked server. You can then work with SAP HANA data just […]

You rated this post out of 5. Change rating

2021-09-29

5,086 reads

SQLServerCentral Article

Working with the Delete Activity in Azure Data Factory

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 […]

(1)

You rated this post out of 5. Change rating

2021-09-27

15,620 reads

SQLServerCentral Article

Create an RPA Flow that Connects to Oracle Data in UiPath Studio

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 […]

You rated this post out of 5. Change rating

2021-09-24

1,519 reads

Blogs

The Book of Redgate: SQL Server Central

By

It was neat to stumble on this in the book, a piece by me,...

Git forked

By

Forgive me for the title. Mentally I’m 12. When I started my current day...

Setting FK Constraints in Data Modeler

By

One of the things a customer asked recently about Redgate Data Modeler was how...

Read the latest Blogs

Forums

Microsoft Security Changes and SQL Server

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Microsoft Security Changes and SQL...

Expanding into Print

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Expanding into Print

Downtime Caused by the Postgres Transaction ID Wraparound Problem

By Chandan Shukla

Comments posted to this topic are about the item Downtime Caused by the Postgres...

Visit the forum

Question of the Day

The String Distance I

In SQL Server 2025, what is returned by this code:

SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled.

See possible answers