I showed you a while ago the improved SQL Azure management portal. After having nothing in 2008, Project Houston was a great step towards a Cloud only management portal. But December 2011 they renewed the complete SQL Azure management portal. Besides a more Metro look-and-feel they added also some extreme helpful tools and utilities. When clicking on Administration in the lower left corner, you get an overview of your Database health etc. Information about the utilization of your database, connections and users. In this case the database was fairly new and unused, so the query usage is empty. On a … Continue reading SQL Azure and Query plans / Performance
What the Windows Azure platform missed, was an implementation of SQL Server Reporting Services (SSRS). That doesn’t mean reports are not able, there is no service for storing those reports. With Visual Studio 2010 are you able to create a report (RDLC) and this report can connect to a SQL Azure database. By storing the report (RDLC) on Windows Azure storage, you could change the report definition without doing a full deploy of your Windows Azure service. But now SQL Azure Reporting is coming. There already was a CTP available, but now Reporting is avail in a real Preview vorm. … Continue reading SQL Azure Reporting Preview
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!
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
In my previous post I told about Project Houston and how the current version is much cleaner. Well look at the picture and decide by yourself. Project Houston: The 2011 version: I love the new one for sure!
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
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’
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
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
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