SSRS 2005 Error: The Declare cursor SQL construct or statement is not supported

Few days back I downloaded a SSRS 2005 file from one of our internal report server and started modifying it....

T-SQL Tuesday - Using APPLY to find out which queries are running on which CPU...

When I saw that Matt Velic's is hosting T-SQL Tuesday, and he has invited the SQL commmunity to participate, I was very...

T-SQL Tuesday #17 – APPLY Knowledge

We have another opportunity to write as a part of TSQL Tuesday today.  This month Matt Velic (Blog | Twitter).  Matt has proposed a challenge that was derived from...

T-SQL Tuesday #17 – APPLY Knowledge

We have another opportunity to write as a part of TSQL Tuesday today.  This month Matt Velic (Blog | Twitter).  Matt...

T-SQL Tuesday #17 – APPLY Knowledge

It’s that time of the month again… again.  Time for T-SQL Tuesday!  This month’s event is being hosted by Matt...

#SqlBits and SSIS custom components

If you are in anyway interested in SQL Server and live in the UK,  you cant of failed to of...

A SQL Server Hardware Nugget A Day – Day 11

For Day 11, I want to talk about the new processor numbering system for Xeon processors that Intel introduced on...

April PASSMN Meeting (April 19)

Every career, whether on purpose or accident, is a journey from one job or project to another.  To achieve great...

April Version of SQL Server 2008 Diagnostic Queries

I have added two new queries to this month’s version, to try to collect some more hardware information about the...

Cloud computing – not without risk?

Interesting quote from Sharepoint Best Practices Conference :” 17% of IT Pros think benefits of cloud computing outweigh the risks”!!

That’s not...