Cassandra Springboot Integration
In this article, you will see how to initialize a Cassandra database that is used in a Springboot application.
2022-11-04
2,507 reads
Articles
Join a community like no other at Summit
There's not long until PASS Data Community Summit takes place. There's still time to register for an in-person or online pass, and unlock access to over 300 world-class sessions. Join liked-minded attendees at the year's largest hybrid data platform conference. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE
Register now
2022-11-04
Leveraging the Script Activity within Azure Data Factory
Learn how to use the Script activity in an Azure Data Factory pipeline to deploy and populate databases using DDL, DCL, and DML statements.
2022-11-04
Assert Transformations in Azure Data Factory
This article will show how you can use Azure Data Factory to check your data quality with an assertion.
2022-11-02 (first published: 2022-10-24)
4,109 reads
Introducing the MySQL INSERT statement
In the previous article in this series, I introduced you to the SELECT statement, one of several SQL statements that fall into the category of data manipulation language (DML), a subset of statements used to query and modify data. Another DML statement is the INSERT statement, which lets you add data to MySQL tables, both permanent and temporary. This article covers the INSERT statement and the different ways you can use it to add data.
2022-11-02
Sign up to PASS Data Community Summit 2022
There's still time to register for Summit and unlock access to over 300 sessions. Join peers and industry leaders in the data community homecoming. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE.
2022-11-02
SAP S/4HANA and Microsoft Azure SQL Integration and Hard Deletion Handling
This article shows how one can use SSIS to find differences in SAP.
2022-10-31
2,077 reads
How SQL Monitor gives developers the information they need to develop faster and smarter
Leading Danish pharmaceutical company, Orifarm, has a mission to be 'Number 1 in making healthcare a better deal'. Find out why they chose SQL Monitor to give their whole IT team, developers included, the real-time metrics they need to highlight development issues and resolve them before they become problems.
2022-10-31
SQL Cheat Sheet for Basic T-SQL Commands
In this article, we cover some basic T-SQL commands that show you how to interact with a SQL Server database table.
2022-10-31
SQL Server Engineering Using Free Tools
You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE toolkit!
2022-10-28
4,742 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers