SQL Azure Deployments

Azure
You’ve set up your access to a SQL Azure site so you’re ready to go. Now how do you get your database up there? Well, TSQL works just fine, so you can script it all out to a file or set of files and apply them. Because you can connect with SSMS, you could use the GUI to build out your database. You can also use the Azure development platform and it’s web based GUI to create your database structures. Personally, the scripting method doesn’t seem too bad to me because you can get your code into source control that way. But, Microsoft has something additional in mind. It’s called Data-tier Applications or DAC for short (and yes, there are other things called DAC in SQL Server, what can I…
Read More

SQL Azure Cost

Azure
We’ve all heard the scary stories. A developer starts testing Azure and then suddenly gets a thousand dollar bill on their credit card. The whole idea behind Azure works of the premise that you are not paying for the infrastructure. Instead of buying servers and disks and racks and switches and routers, you just pay for access and storage. It’s a great model. That model is  especially applicable to small businesses that just can’t  afford the outlay, or to a larger company that wants to perform cheap experiments, or any number of other places where purchasing and maintaining hardware just doesn’t make sense. But what are the costs? That’s a little tricky to answer, truth be told. SQL Azure is charged a monthly fee based on the size and number…
Read More

SQL Azure

Azure
If you’ve talked to anyone from Microsoft recently you had to have heard the phrase “all in.” It’s been made very clear. Microsoft is all in on the cloud. What’s that mean? My understanding of it means they are really, seriously committed to building a viable and large presence there. Part of that presence is SQL Azure. Say the word “cloud” and watch DBAs flinch, wince or moan, sometimes all three at once. I have been one of them. I looked at the list of restrictions on a cloud database, snickered, and moved on. But you know what? They’re wrong and I was too. The cloud is absolutely coming. Microsoft is not alone in believing this. Look at the offerings from Google and Amazon and others. It really is becoming…
Read More