View Event: Need to Monitor Any Azure Resource? Must Learn Kusto Query Language Kusto is a service for storing and running interactive analytics over Big Data. Kusto was designed from scratch to be a “big data” repository for Azure and easy to query using Kusto Query Language (KQL). As we make progress in our migration […]
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 […]
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, […]
View Event: New features in Management Studio — Performance Troubleshooting made easier! SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools, which enabled rapid enhancement to the Execution Plan. Do you know that now you can see how many pages are spilled to disk for […]
