×

Meta Data

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

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

T-SQL Tuesday #130: Automate Trace Flag Consistency

September 8, 2020

I thank Elizabeth Noble (blog|twitter) for hosting T-SQL Tuesday #123. The topic for this month is Automate Your Stress Away. I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some of the #TSQL Tuesday’s and participated in a few. Thank you, Steve Jones (blog|twitter), for coordinating this program. If you […]

UnmatchedIndexes – Bug in SSMS

January 21, 2020

Filtered Index in SQL Server and Parameterized Query does not work well with each other. This incompatibility is a well-known issue among Data Professionals. If you do a Google search for ‘SQL Server unmatched index‘ you find many articles written by well-known bloggers in the SQL Server community. I am quoting a summary of the […]



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