This is part 4 of the Azure SQL Database series. In this session I cover the business continuity within the context of Azure SQL Databases. I start off with what business continuity is how it is important for an organization. I discuss how the terms RTO, RPO and Retention are important to understand and establish business continuity plans. In this session I go over first the Database Export method of backing up the data. I explain how this should not be your first choice for database backup in Azure SQL. I further divulge into the Automated point-in-time restore backups and discuss the details of it. Finally, I discuss what Active geo-replication of database is and how that’s the premium choice of ultimate Disaster Recovery and High Availability of Databases in Azure SQL Database.
This is part 3 of the Azure SQL Database series. In this session I cover the Azure SQL Database security related concepts. This is a very demo heavy session. I start off with what Azure SQL server-level security is; I cover concepts such as firewall rules and logins with master database roles. Then next I move onto explaining what database-level security is and how users are created for each databases by mapping them to logins. Clear explanations are given on why logins and users are both required in Azure SQL. I also demonstrate each concept in details.
This is part 2 of the Azure SQL Database series. In this sequel of Azure SQL, the session is jam packed with hand-on demo of creating Azure SQL server and database and exploring all the features and properties. I then demo how to use SQL Server Management studio to connect to the Azure SQL server and browse Azure databases and as create databases to SQL Azure. The latter half of this session dives into creating an On-premise SQL and a database and finally migrating that on premise database to SQL Azure through a wizard in the SQL Management Studio.
Often every cloud services provider, including Microsoft Azure, have the ultimate sales pitch of being highly scalable and elastic; unlimited resources come to mind. In every sense this happens to be true but with certain technological limitations. It is of course hard to say if such limitations are in place due to the actual limitations of the underlying technology or if they are set to make the provider’s manageability manageable. But these limitations are real and therefore it is advisable to be aware of such limitations in a production environment.
So if you are wondering what type of limits your subscription has then you can quick run the following PowerShell cmdlet to get some interesting information.
An example of an output of the above cmdlet from my subscription is below:
While the above cmdlet provides some exposure to the limits you have on your Subscription, Azure website has a very detailed article in its documentation regarding Azure Subscriptions and Service Limits, Quotas and Constraints that will give you a full picture of all limits your subscription may have.
Microsoft kept up to it’s promises as per it’s SLA and reimbursed everyone for the storage service interruption on November 18th, 2014. I got the email today. I am wondering if everyone got reimbursed today or its rolling region to region.
WOW! I was very excited to read the announcement of G-series VMs in Azure available for people using East US 2 region. This is my home region! The best part is that the prices for the East US 2 region is comparatively cheaper than West US region for the same G-series. Makes me wonder why.
Prices of G-series in East US 2 (Canadian Dollars)
Prices of G-series in West US (Canadian Dollars)
Looking at these prices above, the East US 2 region is about 6 cents cheaper than its counterpart in West US.
Things to remember about G-series VMs in Azure in case you are going to spin one up this weekend for testing:
- G-series VMs cannot be in the same Cloud Service as A-series, D-Series or DS-Series VMs.
- You cannot re-size an existing VM to a G-series from any other series. This means your existing VMs will have to be recreated if you want to bump up its’ performance to G-series.
As the top tier G5 can run about $10 an hour, do not forget to de-allocate these VMs after you are done testing with them!