Even though we just hosted SQL Saturday #17 in Baton Rouge recently, we are already planning for next year. If you are interested in speaking or attending, go ahead and register for SQL Saturday #28 in Baton Rouge on August 14, 2010. We have several enhancements planning for this year based on feedback and our experiences. I look forward to assisting in the planning and look forward to seeing you there! http://www.sqlsaturday.com/... ......
While http://en.wikipedia.org/wik... outlines some limitations of SQL Server Express, there are some specifics that are missing for Reporting Services. One such example is what I discovered today while at a client that uses DB2 for its RDBMS. SSRS that comes with the Express Edition only supports creating reports against the local SQL Server data source. Be aware of this when considering SQL Server Express in your system design. http://www.microsoft.com/te... ......
My co-worker Steve wrote this cool VS.NET add-in that adds SQL intellisense. I've used it at work and it seems to work pretty well. One bug that I'm aware of is the list of columns for a table doesn't display properly for an update statement. All in all a great tool. Check it out.
This hasn't been tested in VS.NET 2000 or 2005 so beware.
SqlAssist