Tech Tips, Tricks & Trivia

The Stack Overflow forum's Azure section is a great place to know about real-world issues and find answers to them. As part of my learning, I plan to collect short summarized answers of questions that I find useful, for quick reference - Q.  What is the difference between the Web Edition and Business Edition of SQL Azure? The two editions are identical except for capacity. Both offer the same replication and SLA. Web Edition scales from 1GB to 5GB, whereas Business Edition scales from 10GB to 50GB in 10GB increments, plus 100GB and 150GB. Q.  How to change maximum capacity or edition of a SQL Azure database? To increase (or decrease) capacity - ALTER DATABASE Test MODIFY (EDITION='WEB', MAXSIZE=5GB) To switch to the Business Edition - ALTER DATABASE Test MODIFY (EDITION='BUSINESS', MAXSIZE=10GB) You can also change the size of the database through the Azure SQL portal. Simply choose the database and go to the scale tab and select the size you want. ...

Here is a summary of the 2h 38min duration Pluralsight SQL Azure course  - * Advantages of SQL Azure - Highly available Manageable Scalable Familiar – similar to SQL Server 2005 & 2008, but differences / limitations exist Maintained by MS IT * Some differences from standard SQL Server  - Data migration – SSIS, BCP, Scripts, SQL Azure Migration Wizard, System.Data.SqlClient.SqlBulkCopy; Restore not supported Transactions – possible in same DB instance only Collation applies only to Column & Expression level; Server, Database excluded Tables must have clustered index Supports most but not all of TSQL  * Candidate apps that can leverage SQL Azure - Require relational data model. Consider Windows Azure Table for other needs Easily partitioned data sets, 5 – 50 GB database All queries use one database. (Most Enterprise apps may need to access multiple DBs) Require high availability * Besides Memory, Time, Disk costs, Devs must also understand...