I have created a sample query for you
declare @tbl table(id int, date datetime, iduser int)
insert into @tbl
select 1, '2013-02-25', 1
union all
select 2, '2013-02-08', 1
union all
select 3, '2013-03-02', 1
union all
select 4, '2013-03-04', 1
select DATENAME(MONTH, [date]), count(DATENAME(MONTH, [date])) from @tbl group by DATENAME(MONTH, [date])