Azure Synapse SQL Pool Backup

November 2, 2021

Definition Data warehouse snapshot A data warehouse snapshot creates a restore point you can leverage to recover or copy your data warehouse to a previous state. Since a dedicated SQL pool is a distributed system, a data warehouse snapshot consists of many files that are located in Azure storage. Snapshots capture incremental changes from the data stored […]

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

Vocabulary Matters In Technical Writing

March 19, 2021

A list of items that people often get wrong. If you have a suggestion, let me know, and I will add them to this page.

Azure SQL Database – dedicated administrator connection (DAC)

March 10, 2021

As per Microsoft documentation, Diagnostic Connection for Database Administrators is available for the Azure SQL database. If you are not familiar with DAC, read this official documentation from Microsoft. By default, the connection is only allowed from a client running on the server. Network connections are not permitted unless they are configured by using 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

SqlPackage Import - How to chose vCore purchase model?

... https://dba.stackexchange.com/questions/306335/sqlpackage-import-how-to-chose-vcore-purchase-model

Have you checked out the schedule for @DataMinutes ?
There are 50 sessions to choose from https://buff.ly/3q81R9h

... Which sessions are you looking forward to?

#Azure #DataAnalytics #Data #Machinelearning #AI #MVPBuzz

@DataMozart will be talking about: "It's just a SQL - Crash course on Synapse Serverless for T-SQL ninjas! "
... Registration details:

Wednesday, January 26, 2022
Noon PST
2000 GMT
#azuresynapse #sqlpool #Serverless #tsql #MVPBuzz

I am speaking at the upcoming @DataMinutes on 2022-01-21. #DataMinutes is a fast-paced lightning talk event with 50 ... sessions to choose from

Check out the schedule https://datagrillen.com/dataminutes/ and sign up for the event here https://www.meetup.com/datagrillen/events/281518971/

See you there!

If you're attending #SQLBits2022 in person and & willing to help make the event even more epic by joining our band ... of orange shirted volunteers we'd love to hear from you. To sign up pls use this form https://forms.office.com/r/J6sGsPJTxG of if you want to know more email helpers@sqlbits.com

Load More...