In this blog post, I discussed some facts about Azure SQL Database Serverless. If someone wants to avoid those limitations and disable ‘Auto-pause,’ how costly is it? Suppose a serverless database is not paused and configured with 4 max vCores and 0.5 min vCores corresponding to 2.1 GB min memory. Then the minimum compute bill […]
Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview Few […]
On March 16th, I posted (Twitter|LinkedIn) about achieving my first ever Azure Certification. AZ-900 Azure Fundamentals. I understand it is basics, and that is why it is called fundamentals. I had a few people asked me how I prepared as they want to do the same. Here are a few resources I used to prepare: […]
With the announcement of Powershell support in Azure Functions, it has become easier for data professionals to use functions to manage cloud resources such as Azure SQL Database, Managed Instances. A common challenge when using functions is how to manage the credentials in function code for authenticating databases. Keeping the credentials secure is an important […]
As per the Microsoft documentation, I should be able to set up Azure Monitor Action Group with voice mail. I can easily do that from the portal. I wanted to do the same with PowerShell. The following code works as expected while setting up email and SMS. When I add the code for the voicemail, […]
I'm expecting a lot of my followers to follow this diagram and end up at Database Reliability Engineering.
So I suppose... I owe @BrentO a thank you for effectively writing that part of this blog post for me!
https://octopus.com/blog/devops-reading-list
#sqlhelp
#AzureSupport
Anyone know how to get to these section in portal. I know how to configure this using PowerShell ... .
I am not seeing this while creating new database.
https://docs.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview?tabs=single-database#configure-backup-storage-redundancy-by-using-the-azure-portal
Are you a Data Professional?
Do you have a Dream to become a Public Speaker but struggle with self-doubt?
Then this ... article is for you!
@NewStarsOfData
https://dbanuggets.com/2020/11/21/take-that-first-step-in-faith-rest-will-pave-its-path-to-your-speaking-journey/
#sqlsatmontreal organizers thank you for work and opportunity.
Flawless execution.
Thanks to all speakers, sponsors, ... volunteers and attendees.
#sqlpass
Listening to @Hugo_Kornelis talking about 'debug without debuggers'
#sqlsatmontreal
