×

Monitoring

Azure SQL Database backup history

May 4, 2022

There is a new DMV currently in preview which returns information about backups of Azure SQL databases except for the Hyperscale tier. Microsoft official documentation is here. If you run the example query as-is from the above documentation some of the columns do not make sense. Instead, use this query where I am joining with […]

Azure Data Factory Monitoring Choice?

May 19, 2021

If you are using Azure Data Factory, you can export platform logs and metrics to a log analytics workspace. Sending logs and metrics to a Log Analytics workspace allows you to analyze them with other monitoring data collected by Azure Monitor using powerful log queries and leveraging other Azure Monitor features such as alerts and visualizations. […]

Auto-failover Groups – GracePeriodWithDataLossHours

March 31, 2021

The auto-failover groups feature for the Azure SQL database can be configured with an automatic failover policy. Azure triggers failover after the failure is detected and the grace period has expired. Grace period is determined by a setting called ‘GracePeriodWithDataLossHours’ that cannot be set under one hour. Why is it not allowed to set a […]

North Boston Azure Cloud User Group

January 28, 2021

View Event: Monitor Azure Resources with 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 to the cloud, we […]

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...