This Week I Learned - Week #48 2019

This Week I Learned -

SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single Azure SQL Database server and share a set number of resources at a set price. Elastic pools in Azure SQL Database enable SaaS developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database.

* In the General Purpose tier, you are charged for Premium blob storage that you provision. In the Business Critical tier, you are charged for local SSD storage that you provision for your database or elastic pool. In the hyperscale tier, you are charged for storage for your database based on actual usage.

In the serverless compute tier of Azure SQL Database, compute resources scale dynamically up or down based on the workload’s requirements and are billed on a per-second basis, pausing during periods of inactivity. In the provisioned compute tier, a customer purchases a certain amount of compute resources and is billed for them on an hourly basis.

* Striping and then partitioning across the stripe provides a pool of resources to be shared by the databases.  This has advantages and disadvantages.  The advantage is the flexibility that the number of partitions doesn’t have to match the number or size of disks, and that the databases can burst to use more throughput than they would get from a single disk. The disadvantage is that the databases are more likely to interfere with each other (they all share the machine limits, but they can’t exceed their disk limits) and that it’s harder to do things like move a database to another machine (if the database was sitting on a single disk, the disk could be dismounted from one system and mounted on another, that can’t be done with a partition on a stripe set). Azure disks can be striped in any RAID pattern you want: 0, 1, 5, or 10; however, given the triple redundancy at the disk level, we generally just recommend RAID 0 (which is roughly equivalent to RAID 01 or RAID 10).  If that’s insufficient redundancy, then it’s probably time to look at ways to replicate the entire VM to eliminate single points of failure there as well - MSDN Forums, November 2017

* Disk striping is low resiliency. The failure of any physical drive in the striped disk results in the loss of the data. In Azure, if you are not using Premium Storage (dev/test scenarios), the recommendation is to add the maximum number of data disks supported by your VM size and use Disk Striping - MSDN Forums, April 2016

Azure NetApp Files can support any POSIX-compliant workload that requires shared file storage. It  is a fully managed cloud service with full Azure portal integration and access via REST API, CLI or PowerShell. Importantly, it is sold and supported by Microsoft and is not a marketplace offering.

Location Sharing may not work if you're in a country/region where you can’t share your location.

* Sand is one of the most in-demand natural resources on the planet. It is the most essential ingredient in concrete, detergent, silicon chips, but its supply is finite. Sand acts as a barrier against heavy metals in the earth's crust.

* HDFC Bank has 4.5 crore customers

* 15% of the world’s population experience some form of disability

* New Delhi has the highest levels of air pollution

* In 1921, K B Hedgewar (who founded Rashtriya Swayamsevak Sangh (RSS) in April 1926) was arrested on the charge of sedition for participating in the non-cooperation movement. He decided to plead his own case and levelled charges against the British govenment which the judge found 'even more seditious than his original speech!' - RSS : Icons of the Indian Right
* The Voluntary Provident Fund (VPF)  has the same lock-in period as the Employees Provident Fund (EPF) -- on resignation or within 2 months of unemployment. Partial withdrawal is allowed, but the withdrawal amount is tax-free only if the account is at least 5 years old - Mint

* Nearly 92,700 employees of BSNL and MTNL have opted for voluntary retirement. In case of BSNL, over 78,300 employees opted for voluntary retirement which is over half of the company's total manpower. In case of BSNL, employee cost was around 75 per cent of the total revenue that company earned and 87 per cent at MTNL.

Comments

Popular posts from this blog

Maven Crash Course - Learn Power Query, Power Pivot & DAX in 15 Minutes

"Data Prep & Exploratory Data Analysis" course by Maven Analytics

Oracle Cloud Infrastructure 2024 Generative AI Professional Course & Certification Exam (1Z0-1127-24)