database

SQLServerCentral Article

Easily Integrate with Any RESTful API Using the CData API Driver

  • Article

The evolution of APIs has opened up exciting opportunities for businesses. RESTful APIs are a consistent, straightforward way that enables businesses to work with external data and offer access to their own data. In May 2021, the number of public APIs grew beyond 24,000, with about 2,000 APIs added just since 2019.  APIs continue to be beneficial to businesses and developers, and with the CData API Driver, it […]

You rated this post out of 5. Change rating

2021-11-15

1,231 reads

SQLServerCentral Article

SQL Access to Redis Data

  • Article

Traditionally, importing key-value data stores such as Redis into BI, reporting, and ETL tools is problematic, if not impossible. With the CData Drivers, there are several different ways to building a traditional database model to easily work with Redis data in the BI, reporting, ETL, and custom applications of your choice. In this article, we discuss […]

5 (1)

You rated this post out of 5. Change rating

2021-11-12

1,667 reads

SQLServerCentral Article

Perform API Operations Using Stored Procedures in CData SSIS Components

  • Article

APIs require up-to-date and strong documentation, increased security levels, comprehensive testing, routine versioning, and high-reliability to be appropriately utilized. With the CData SSIS Data Flow components you can import and export data from various data sources. However, in some cases the type of operation you need does not fit the SSIS Source or the SSIS Destination model. The […]

You rated this post out of 5. Change rating

2021-11-08

877 reads

SQLServerCentral Article

Connect to SAP HANA Data as a Linked Server

  • Article

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

4,576 reads

Technical Article

Our Top Findings from The State of Database Monitoring Survey

  • Article

Over 2500 global database professionals answered questions on their experiences with database monitoring in our annual survey earlier this year. We’re creating four reports from the findings and in our first, The real-world challenges of growing server estates, you’ll discover both insights and trends along with advice for how to tackle the most common challenges.

You rated this post out of 5. Change rating

2021-09-13

Blogs

Can I Change a Primary Key Value? #SQLNewBlogger

By

I heard someone say recently that you can’t change a primary key value in...

SQL Server Index Primer

By

Indexes 101: What, Why, and When? “What Is an Index?” I get this question...

Secure Azure SQL Server Backups Using Managed Identities

By

I do believe most people know about the ability to backup your SQL server...

Read the latest Blogs

Forums

Internationalisation

By julian.fletcher

Quick one I hope in case I'm heading off in entirely the wrong direction!...

Size of DB on physical disk doesn't match Disk Usage by Table report

By water490

Hi everyone I am looking at the size of my db on disk (ie...

Getting the TEXTSIZE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the TEXTSIZE

Visit the forum

Question of the Day

Getting the TEXTSIZE

How can I check what value I used for TEXTSIZE? I ran this code:

SET TEXTSIZE 8096
But then deleted the code and couldn't remember. Is there a way to check this?

See possible answers