Calculating the Harmonic Mean in Power BI
Learn how you can add a harmonic mean calculation in Power BI.
2026-06-16 (first published: 2026-06-15)
850 reads
Learn how you can add a harmonic mean calculation in Power BI.
2026-06-16 (first published: 2026-06-15)
850 reads
SQL Server 2005 has added many new T-SQL commands, one of which is the OUTPUT command. Longtime SQL Server author Dinesh Asanka brings us a short look at how you can use this command.
2019-08-21 (first published: 2007-07-09)
16,355 reads
We can get data in all sorts of formats in the real world. In this new article from Dinesh Asanka, learn how to use scripting to import data from individual Excel cells.
2010-04-28
16,627 reads
Integration Services has a lot of features to enable to you perform ETL operations on data moving into SQL Server. Longtime author Dinesh Asanka brings us an article on
2009-01-14
12,231 reads
Longtime author Dinesh Asanka brings us a short tutorial on importing your data from Excel 2007 into a database using Integration Services.
2008-10-24
15,841 reads
Longtime SQL Server author Dinesh Asanka brings us a new article on backing up an Analysis Services database.
2008-07-17
15,567 reads
This review of RedGate's new SQL Multi Script tool that aids you in deploying a script across multiple databases.
2008-03-20
3,563 reads
This is an entry level look at how temp tables work in SQL along with some tips about how to use them effectively.
2007-10-02 (first published: 2004-02-11)
82,280 reads
Longtime author Dinesh Asanka takes a look at one of the new tools on the market, SQL Refactor from Red Gate.
2007-03-27
3,544 reads
SQL Server 2005 has brought about many paradigm changes, including substantial changes to the SQL Server Agent subsystem. Dinesh Asanka takes a new look at roles and counters in 2005.
2006-05-03
22,505 reads
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
By way of background, a while back I did video called “My New Favourite...
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item How We Handled a Vendor...
Comments posted to this topic are about the item Cognitive Coverage
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers