Support timelines for SQL Server, .NET Framework, Visual Studio, Team Foundation Server and Windows

Microsoft maintains a database of all supported products, along with the dates when those products’ various support stages end.  Anyone can search the database for a specific product, but that can be time-consuming when data for more than one product is needed.  I have therefore been maintaining a list of important dates and relevant information about several products…


Connection-Pooling vs. Reusing one connection

I recently had a conversation about .NET connection pooling, and how this compares to reusing a single open connection.  I have always “known” that connection pooling helps, but that it isn’t as efficient as reusing the connection.  Since I couldn’t provide proof of my belief, I decided to write a test.  I decided to execute…


Running SQL Reporting Services on Vista

I recently decided to fire up SQL Server 2005 Reporting Services on my Vista laptop.  I installed SQL Server 2005 (with SP2 of course!) and made sure that I used the SQL Server User Provisioning tool to give myself full rights.  I then launched the Report Manager, and stopped dead in my tracks.  I couldn’t…

1

Microsoft SQL Server Data Services

Today at MIX, Microsoft unveiled Microsoft SQL Server™ Data Services (SSDS), a Web-facing utility-based service designed for businesses and developers that need scalable, highly available, secure and easily programmable on-demand data storage with robust database query capabilities. What SSDS offers: Virtually limitless, on-demand scalability. Customers pay only for the resources actually consumed Reduced costs.  Customers…

1

The data provider required to connect to the local data file cannot be found

I’ve been trying to get SQL Compact 3.5 working in Visual Studio 2008.  Since SQL Compact 3.5 ships with Visual Studio 2008, I thought that this wouldn’t be a problem.  All I needed to do was to create a new Windows Forms project and add a Local Database item.  Sadly, this didn’t work.  After added…

1