SQL Azure enhancements (December 2011)

There are a few enhancements made to the Windows Azure Management portal as I told you in my previous blogpost Billing is one of them. But there are also enhancements made to SQL Azure. Now you can choose for 100 Gb or 150 Gb as max sizes. And if 150 Gb is not enough. With Federation there is no limit anymore. By making different feds you are able to go beyond the 150 Gb database limit! More info on that later! And then the clean and nice interface in Silverlight 5 How cool is that!  

SQL Azure Databases

When I do sessions on Windows Azure, then SQL Azure is always part of that. Most of the time remarks about the maximum sizes of SQL Azure database come from the audience. Quick summary. There are 2 SQL Azure editions available: Web and Business. I have not found any differences between the two, but perhaps this will come in the future. The Web edition comes in sizes of 1 Gb and 5 Gb. The Business edition starts at 10 Gb and ends with 50 Gb, in steps of 10 Gb. In December the maximum will be 150 Gb (here). The … Continue reading SQL Azure Databases

SQL Azure DACPAC – import and export data

If you keep an eye on the Windows Azure blog then you saw the  announcement of service release of SQL Azure. With this update there are also changes made to the SQL Azure part on the Windows Azure portal. Before we had Houston (on my Dutch blog I had months ago an item on that one). Houston was the web tooling to manage the database objects on a SQL Azure instance. And it was pretty neat! Other competitors also came with Web sites from which you can manage a SQL Azure instance. This new release is a clean-up of the … Continue reading SQL Azure DACPAC – import and export data

SQL Azure development with tooling ‘Juneau’

At this moment when you develop for SQL Azure you miss some of the cool tools. The tools you are familiar with while developing for SQL Server 2008 R2. In the SQL Server Management Studio when connected to SQL Server 2008 R2 and you want to create a table, there is that UI thingie. But when connected to SQL Azure with SQL Server Management Studio you only get some guidance on the syntax for the create table statement. But I am not a great SQL developer at least I need more help then the guidance you are getting . I … Continue reading SQL Azure development with tooling ‘Juneau’

SQL Azure versions

Few months ago on the Windows Azure blog there was the announcement about the SQL Azure July service release. http://blogs.msdn.com/b/windowsazure/archive/2011/07/13/announcing-sql-azure-july-2011-service-release.aspx In this blog post they warned, the live version van SQL Azure would be update in de coming weeks. In order to keep using SSMS (Sql Server Management Studio) you had to get current on a few SQL Server 2008 R2 updates. So after these update you could work with the tools and SQL Azure as you used to be. Such a update takes a while that all the nodes in the Windows Azure datacenters are ready. I was able … Continue reading SQL Azure versions

SQL Azure Custom Logging to Windows Azure Table storage

At a Windows Azure customer of ours they keep track of changes on the tables in the SQL Azure database. This is done by a trigger, the trigger inserts the change in a table. I can not think of another solution without losing data or changes. But the downside of this, the logging space in SQL Azure costs a lot of money. This logging is only used for an analyses of a problem and the read frequency is rather low. And btw the data is not relational. So the space for this logging data in the SQL Azure database is … Continue reading SQL Azure Custom Logging to Windows Azure Table storage

Window Azure Co-admin and SQL Azure

At different customer sites I am not the administrator of the Windows Azure subscription. But I am one of the co-admin(‘s). My strategy is to make a live id on the e-mail address I have with that customer. So when I leave the assignment I can give back my co-admin account. The customer is sure, I do not  change the Windows Azure settings. Of course they trust me, but better save than sorry. The only disadvantage was, as a co-admin you were not able to manage a SQL Azure database. You weren’t able to create Databases, change firewall rules etc. … Continue reading Window Azure Co-admin and SQL Azure