Azure

Backup TO DISK, TAPE and now URL - Backup On-Premises SQL Server Databases to Azure Storage

There has been a lot of discussion over the years about whether or not it’s a good idea to introduce new functionality in service packs (for SQL Server, the OS, and others). The concern is that it can invalidate testing, invalidate documentation, books, courseware, etc. However, it can also introduce much-needed features without having to wait for another version of the product. It’s been even-less likely that new functionality would be introduced in a cumulative update (or CU), which are basically a set of rolled-up hotfixes.

2013-01-27

Working with Aliases for Windows Azure SQL Databases in SQL Server Management Studio

One of the issues that is often raised with Windows Azure SQL Database is that you don’t get to pick the name of your server, so you end up with a bizarre name such as: yy2l95dk1k.database.windows.net. I can understand why the team did this. Apparently when they first set it up, they allowed you to pick your own server name, so everyone started registering Coke, Pepsi, etc. Not wanting to have yet another place for people to argue about name ownership, they quickly removed that ability.

2013-01-21

Windows Azure SQL Database, GETDATE, SYSDATETIME, SYSUTCDATETIME and Rounding

When I’ve been putting data into Windows Azure SQL Database (WASD) in the past, I’d normally been providing the dates from my own system. This week, I had the first time where I wanted to put a column default that provided a date in WASD. It suddenly dawned on me that I wasn’t sure what timezone the date would be from. As I was using the Southeast Asia data centre (in Singapore), I was presuming the value would be based on Singapore’s timezone.

2013-01-20

New Azure Mobile Services Samples

Hi Folks, I have to say that I’m really impressed by the rate at which the Windows Azure Mobile Services team is rolling out updates and samples. In particular, it’s good to see a new sample for using Geolocation, given how common a requirement that is in mobile apps today. It’s worth checking out the following: · New Code Samples page on WindowsAzure.com · Updated WindowsAzure.com Tutorials and Resources page that includes new tutorials and related videos from the new Windows Azure Mobile Services channel 9 series

2013-01-11

How full is my Windows Azure SQL Database?

While the level of compatibility of Windows Azure SQL Databases is high, there are a number of things that need to be dealt with differently, compared with how they are done with on-premises SQL Server. An example of this, today I needed to know how full one of my databases was. I wanted to know how much space I had used but also to know what the limit was. My first attempt was the usual system views such as:

2013-01-03

Nice set of updates to Azure over the last few days - Data Sync now in the HTML Portal - Updates to the CLI

Scott Guthrie posted about the Azure-related changes that have happened over the last few days. Of particular interest to me was that Data Sync was now in the new HTML portal, and that the Azure store now works in a bunch more countries. Generally I like the newer HTML portal but I’m still finding that it applies different validation rules to SQL passwords than Windows Azure SQL Database itself does. That’s a pain as I still have to use the older portal.

2012-12-27

Windows Azure SQL Reporting - Great to see a dramatic price decrease for lower volume users

I was really excited about Windows Azure SQL Reporting being released. That lasted until I saw the pricing. If I just deployed a server and didn’t use it, the price was 89c per hour for up to 300 reports per hour. What many people didn’t understand is that the price applied whether or not you used the reporting server. That meant that the minimum price for deploying a server was 89c x 24 hours x 365 days = $7796.

2012-12-21

Azure Conference announced - Free, Online, and Soon

ScottGu announced the Azure Conference today at BUILD. Have to say that I’m looking forward to it. If you want a bunch of Azure content, online and free, you can register for more info here: http://www.windowsazureconf.net/

2012-11-01

SQL Down Under Show 51 - Guest Conor Cunningham - Now online

Late last night I got to record an interview with Conor Cunningham. Most people that know Conor have come across him as the product team wizard that knows so much about query processing and optimization in SQL Server. Conor is currently spending quite a lot of time working on Windows Azure SQL Database, which we used to know as SQL Azure. I’m still trying to think of a good way to say “WASD”.

2012-08-22

SQL Azure DB size limit increased to 150GB

Nice to see the increase in maximum database size on SQL Azure kicked up to 150GB. In most enterprises I go into, there are a few databases that wouldn’t fit but now the vast majority of databases would fit in SQL Azure. Also included in the November release are federations and an updated management portal. More info here: http://msdn.microsoft.com/en-us/library/windowsazure/ff602419.aspx

2011-12-13