×

Azure SQL Database Serverless -Disable Auto Pause Cost?

October 26, 2020

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 […]

Azure SQL Database Serverless – Facts!!

October 20, 2020

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 […]

#SqlRun During Pass Summit 2020

October 16, 2020

We might not be together for PASS Summit this year, but we are still together for #sqlrun. Join other attendees as we walk/run/jog, from where we are each attending PASS Summit this year. If you do not have a Strava account, create one at Strava.com.  Join the “PASS SQL Run 2020” club anytime starting Monday, […]

TSQL Tuesday #132 Roundup

December 5, 2020

I want to thank all of the participants of T-SQL Tuesday #132. If I missed your post, it was not intentional. Please let me know, and I will add it here. I am proud of this community and feel lucky to be a small part of it. I admire everyone who joined the blog party […]

How to Persist Information from Lightweight Query Profiling?

September 14, 2020

Accessing runtime information of a query execution plan is vital to get a precise understanding of resource usage, execution patterns to resolve performance issues. Runtime statistics is beneficial while debugging query performance issues, such as long-running queries, and queries that run indefinitely and never finishes. Historically query completion was a prerequisite for the availability of […]



profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

Did you know? We have a #SQLServer builds site with nearly 1000 builds: indexed, searchable and powered by a regularly ...updated JSON file that is included in dbatools! http://dbatools.io/builds

I've started a little thing to provide a list of mental health resources for people. Started by having many ...conversations with folks. It's in on GitHub so people can help me add to it. It's in its baby stages. https://buff.ly/3Ar09Vw #mentalhealth #sqlfamily

My kids had their first day of school today.

As school starts up again, tell your kids about Ruby Bridges—the first... Black child at all-white public elementary school in South.

Ms. Bridges is only 67

67.

Azure SQL Database - Business Continuity During Disaster🤯with #MVP @SqlWorldWide🌍

Sept 1st @ 1pm BST!📅

You ...can RSVP below!👇 Please note that our user group is fully virtual - that means anyone and everyone can join us!😍

https://www.meetup.com/microsoftdataplatformbirmingham/events/287780538/

Load More...