Storing database connection strings for Azure cloud services (including encypting the connection strings)

As my Surface didn’t arrive on launch day, I had nothing better to do on a Friday night so here’s a blog post on Azure configuration settings. Prior to Azure, web.config was the place ASP.NET devs would store settings.  However, as you should consider web.config read-only in Azure, you should use the Azure .cscfg instead IF…

2

Azure ASP.NET to SQL Hello World! on the Introductory offer

“Inspired” by a pub discussion with a mate last night, I finally got around to doing a “hello world” ASP.NET->SQL sample on Azure today.  Unfortunately, I couldn’t leave it up as I don’t want it to start accruing charges.  However, I included a screen capture of it running below!  I set it up under the…

0

SQL updates failing on WSS Developer VM

I noticed SQL updates (KB960089 but also SQL SP3) were failing to apply on the WSS Developer VM. After many hours of frustration, I located this great blog post that helped me to overcome the issue:  http://blogs.msdn.com/sqlserverfaq/archive/2009/01/30/part-1-sql-server-2005-patch-fails-to-install-with-an-error-unable-to-install-windows-installer-msp-file.aspx In my case, the missing .msi’s were from SQL Developer edition.  The missing .msp’s were from SQL SP2…

1