A quick way to do it, to get it from sys.partitions, since directly hitting all tables in db with COUNT(*) can be quite time consuming.
SELECT OBJECT_SCHEMA_NAME(p.object_id) [Schema]
, OBJECT_NAME(p.object_id) AS [Table]
, p.partition_number
, p.rows AS [Row Count]
FROM sys.partitions p
WHERE OBJECT_SCHEMA_NAME(p.object_id) <> 'sys'
AND p.rows > 10