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 […]
The post Easily Integrate with Any RESTful API Using the CData API Driver appeared first on SQLServerCentral.
DBAs at work #1: The IT services provider DBA
Our series of ‘DBAs at work’ blog posts feature conversations with IT leaders and experts about the challenges of managing and monitoring their server estates. Episode 1 features Dennis Heitmann, Database Administrator at Atruvia, which provides IT services for banking clients in Germany.
The post DBAs at work #1: The IT services provider DBA appeared first on SQLServerCentral.
The post DBAs at work #1: The IT services provider DBA appeared first on SQLServerCentral.
SQL Access to Redis Data
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 […]
The post SQL Access to Redis Data appeared first on SQLServerCentral.
The post SQL Access to Redis Data appeared first on SQLServerCentral.
Performance of querying blob storage with SQL
It’s possible to query blob storage using SQL, but what about performance? In this article, Dennes Torres compares several query methods to see which one performs the best.
The post Performance of querying blob storage with SQL appeared first on SQLServerCentral.
The post Performance of querying blob storage with SQL appeared first on SQLServerCentral.
A brief history of SSIS evolution
Learn about the history and different versions of Integration Services (SSIS) in SQL Server.
The post A brief history of SSIS evolution appeared first on SQLServerCentral.
The post A brief history of SSIS evolution appeared first on SQLServerCentral.
Managing Database Documentation during Flyway-based Development
Learn how to create and maintain a 'data dictionary' for your databases, in JSON format, which you can then use to add and update the table descriptions, whenever you build a new version using Flyway.
The post Managing Database Documentation during Flyway-based Development appeared first on SQLServerCentral.
The post Managing Database Documentation during Flyway-based Development appeared first on SQLServerCentral.
Handling an unknown number of parameters in SQL Server
In this article we compare performance differences when splitting comma separated strings using TVPs, TVFs, openjson, string_split and more.
The post Handling an unknown number of parameters in SQL Server appeared first on SQLServerCentral.
The post Handling an unknown number of parameters in SQL Server appeared first on SQLServerCentral.
Azure Data Studio vs SSMS – Who is the winner?
Introduction I have to admit that I love SSMS. It is a great tool, and I felt furious when a colleague mentioned that Azure Data Studio will replace SSMS in the long run. In this new article, we will talk about the main differences between Azure Data Studio and SSMS. We will see if my […]
The post Azure Data Studio vs SSMS - Who is the winner? appeared first on SQLServerCentral.
The post Azure Data Studio vs SSMS - Who is the winner? appeared first on SQLServerCentral.
