While Azure's web portal is quite sophisticated and streamlined, nothing beats the efficiency of powershell. Building off of my previous posts, I'm going to provide a few powershell commands to login and create a new Azure SQL Database. The first step allows you to login to your Azure account. It gives you a neat little prompt. Once logged in, the powershell window will provide you with some information regarding your subscription. The next two commands sections provide a w
Azure provides built in high availability. In a given server region, you are provided with three local copies of the Azure SQL Database. Geo-Replication Now, if there is an outage covering the entire server region, you can use the Geo-Restore feature or the Geo-replication feature to have a copy of the database in a different region. Geo-Replication offers up a 30 second RTO and a 5 second RPO. And rightfully so, since each secondary is billed at full price. It's a business d
One of the great things about Azure is that backups are automated as part of the service. Azure for SQL touts a 12 hour RTO and a 5 minute RPO for backups that are considered "in-region". The backup schedule is as follows: Full: Weekly Differential: Hourly Transaction Log: 5 mins. Retention Period of the backups depends on the tier that you have selected. Basic: 7 Days Standard and Premium: 35 Days The backups are also Geo-Replicated, which means that in the event of an outa
If only I could upload my brain to the cloud. BaaS anyone? What is Database as a Service (DaaS)? Azure SQL Database is Microsoft's version of DaaS. DaaS is a cloud service in which the service provider manages the operating system and database software. In addition to that, they may also relieve your IT staff of certain administration tasks such as backups, high availaiblity/DR, patching etc… Pricing. The users of such a service will most likely pay according to their usage.