Ahh Microsoft Excel, the key tool of every financial analyst across the world. Where would we be without you? What application would receive all of the notoriety for analysts mistakenly leaving in sensitive data in a hidden column? How would an analyst store tons of data that is a pain to mine? As part of our conversion of some of our legacy Excel "systems" ......

---

Been awhile since I had posted anything and what better way to restart this blog than with some Timeout Issues. Now this list is designed for SSRS 2005, but you can put a few of these tips to use in 2008. Consider these steps in the below order. 1) Set the HttpRuntime ExecutionTimeout value to a greater value (ie 3 hours) on the Report Server How do ......

---

In the SSRS Reporting Environment, you may never encounter this error and you live a happy and easy life. We all know an SSRS report can easily ping your server to 100% CPU if you decide to export a 120 page report, to PDF, with charts, etc. etc. You may get a complaint that performance suffers in another application while running the reports and you ......

---

In my experience with SSRS, I have noticed that there are two types of report developers: 1) SQL Developer that naturally flowed into SSRS, uses Stored Procedures for database development and has a very solid background for development. 2) Developers from other categories that somehow fell into SSRS. I come from the second school but I have an endless ......

---