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
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
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,262 reads
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
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
This article shows how one can use SSIS to find differences in SAP.
2022-10-31
2,125 reads
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
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
You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE toolkit!
2022-10-28
4,829 reads
Spaces are still available for next month's PASS Data Community Summit pre-conference sessions - but they’re booking up fast! Choose from 18 deep-dive full day pre-cons, featuring some of the best minds in the data industry, covering everything from technical processes to personal growth. Register now.
2022-10-28
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers