Wednesday, December 23, 2009

SQL Azure

Microsoft now offers a “cloud” version of SQL Server called SQL Azure. Cloud in this context means SQL Server lives out on the internet, on equipment managed by Microsoft. We access SQL Azure as a service over the internet either programmatically with Dot Net, or through the command line using SQLCMD. SQL Azure is very similar to traditional SQL Server and now supports many standard TSQL commands. This article will demonstrate the use of TSQL commands to create SQL Azure objects.

Rerunning a SSRS subscription report

Yesterday I had a situation where  a couple of SSRS reports failed due to a network upgrade. The SSRS report was not able to access the SQ...