Where does data fit into the digital transformation story? Discover how and why it deserves a place in this fascinating piece from Pramod Sadalage, principal consultant at Thought Works
2022-12-30
In this article, we walk through the steps and examples of how to use Secure File Transfer Protocol (SFTP) when working in Azure.
2022-12-30
This article dives into all the math required to convert historical times between time zones.
2022-12-28
This article demonstrates how we can use a Flyway placeholder as a simple on/off switch for each task, during Flyway migrations.
2022-12-28
As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should read the data. SQL Server has huge list of collations […]
2022-12-26 (first published: 2020-08-03)
25,433 reads
This article looks at how to calculate MACD indicators using a set of T-SQL code and data stored in a SQL Server database.
2022-12-26
The examples so far in this series have all used repeatable read isolation to acquire shared locks on qualifying rows and hold them to the end of the transaction. This was convenient for the demos but repeatable read isolation isn’t common in everyday use.
2022-12-26
Building on his last article, Frank shows how to add parameters to your stored procedure calls from PoSh.
2022-12-23 (first published: 2020-08-20)
30,118 reads
For those new to Flyway Desktop, this article takes a strategic overview of the components of a Flyway Desktop project, how to set up a project for team-based development work, and how we can use the tool in conjunction with a version control system and CI servers to manage a database development and release process.
2022-12-23
In this tutorial, learn about Python priority queues and heaps, how do they relate, and how to use the heapq module in Python.
2022-12-23
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