All of This Has Happened Before (T-SQL Tuesday #48)

This month’s host for T-SQL Tuesday is the SQLChicken, Jorge Segarra (B|T). He has asked us to write about our take on this whole Cloud thing.

I’ve been lucky enough to have some time to play with Windows Azure over the last couple months and I have some opinions on the platform. Overall I think my opinion on the idea of The Cloud is about the same as when I started. To begin with I wish they hadn’t called it The Cloud – or maybe that it hadn’t stuck as a part of the technical conversation. I think the name conjures up this romantic image for business users of a technology solution that exists out there – somewhere over the rainbow.

Continue reading

Create an Azure Database using Powershell

In my presentation on Windows Azure SQL Database and SSIS I show how to create a database using the Azure Portal and using T-SQL from SQL Server Management Studio. Using the portal us about as simple as it gets so I’m not going to go through the steps here. To use T-SQL you have to be connected to the master database and then you can quickly create a new database with the CREATE DATABASE command.

CREATE DATABASE <database_name>
       (EDITION = 'Web', MAXSIZE=1GB)

The edition can be either Web or Business and the only difference I am aware of is the maximum database size. The Web edition can only be up to 5GB and a Business edition has a max size of 150GB.

Continue reading

It’s Scary in the Cloud

darkcloudAs I mentioned in my last post I have been learning as much as I can about Windows Azure SQL Database (SQL Database or WASD to those who work with it).  I did a lot of research and some demo projects for my presentation on WASD at SQL Saturday #237 in Charlotte, but I know there is more for me to learn. In fact one of the challenges with WASD is that it can change as quickly as DBA’s and developers can learn. I’ve had a lot of conversations about Azure over the last few weeks. These have ranged from in-depth case studies using WASD for a SaaS product offering to people who have never looked at Azure. To help me and maybe others have a baseline for learning about Windows Azure SQL Database I wanted to ask some experts a few questions. The first person that comes to mind for me from the DBA perspective on Azure is the Scary DBA, Grant Fritchey (B|T). Grant is a Product Evangelist for Red Gate Software and his blogging and presenting have had an Azure focus lately. I traded some emails with Grant and he agreed to answer my five cloudy questions. Continue reading