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.
From Compass '99 to Data Community Summit 2022
Steve looks back at Summits past and his excitement for this year.
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.
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.
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.
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.
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.
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.
Friendship and Your Career
PASS Data Community Summit is coming up like an out of control freight train. Another couple of weeks and it'll be here. I'm excited about it every year and I really hope to see you there. Please, consider this a personal invite to say hi if you see me around. I'm bringing all this up […]
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Everything is the right question away
Comments posted to this topic are about the item Everything is the right question...
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers