×

Azure SQL

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

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

Replace Trace Flag with ‘USE HINT’

January 23, 2021

Introduced in SQL Server 2016 (13.x) SP1 and Azure SQL Database is the USE HINT option. At the time of writing this article, there are 23 of those. You can see an up to date list by running Dynamic Management View sys.dm_exec_valid_use_hints. With the introduction of this feature, we can replace some of the trace […]

Executive Summary – Always On Availability Group

December 20, 2020

The ‘Always On Availability Group’ feature is a high-availability and disaster-recovery solution. Since the launch with SQL Server 2012, data professionals have adopted this solution widely. Before implementing ‘Always On Availability Group’, data professionals need to make decisions about availability and failover mode. These decisions will involve discussion with business owners of the applications that […]

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



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

#sqlhelp
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:
https://www.meetup.com/dbavug/events/277522059/

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